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 |