Title: Sr. Snowflake EDW Administrator

Location: Remote (Must be based on US – Dallas TX preferred)

Duration: 12 Months (Long Term Extension Highly Likely)

Description:

Our client is a large multi-national industry market leader with a large-scale complex data foundation supporting an array or application solutions including Salesforce & SAP. The Snowflake Cloud Data platform serves a central component of the client’s current and ongoing data management strategy. The team currently needs an experienced Snowflake Database Administrator to assist with performance tuning and enhancing/expanding the platform to meet current requirements.

Specific Role:

·    Perform duties as a Senior Snowflake Admin with additional Development skills who has the hands-on skills and can perform requested tasks quickly

·    Apply Automations utilizing Snowflake information exchange schema

·    Develop Python scripts to automate snowflake administration tasks beyond standard admin screens and apply in production

·    Develop data pipelines and related orchestration

·    Programmatically downsize Snowflake clusters as needed

·    Support integration of Snowflake with AWS, Kafka, Salesforce and user access systems

·    Implement oauth access scenarios for supported clients

·    Migrate large legacy data sources to Snowflake

Qualifications:

·    A minimum of 7 + years of DBA experience to include at least 3 year of experience working with the Snowflake Elastic Cloud EDW platform

·    Working knowledge/experience with Snowflake administration in a production environment

·    Proven experience work with Snowflake Administration and Development tools – SnowSQL, Snowflake Connector for Python, Data loading with Snowpipe & Web Interface, and Security and Data Access tools – oAuth Service

·    Strong foundational experience working Data Modeling and Provisioning Concepts

·    Additional proven prior experience as an Oracle DBA and/or Netezza BI Appliance Architecture highly desired