Senior Data Engineer + Snowflake + DBT

Senior Data Engineer - Snowflake + DBT
100% Remote
Contract Opportunity
A minimum of 12 years of expereince required
Independent Consultants Only

Key Responsibilities:

• Design and implement scalable Snowflake data warehouse solutions to meet complex analytics and reporting objectives, ensuring high availability and performance
• Develop, optimize, and maintain ETL pipelines using SQL, Python, and DataStream, achieving efficient data ingestion and transformation with measurable throughput targets
• Configure and manage Snowflake features such as Time Travel, Fail Safe, Snowpipe, and SnowSQL to ensure robust data management, recovery, and automation
• Collaborate with cross-functional teams to gather data requirements and deliver reliable, high-performance data solutions aligned with business goals
• Develop and maintain stored procedures using PLSQL and T-SQL to automate business logic and streamline data processing workflows
• Monitor data platform performance, proactively troubleshoot issues, and implement improvements to optimize query efficiency and resource utilization
• Enforce data integrity, security, and compliance standards across all Snowflake environments and data pipelines
• Document technical designs, data flows, and operational procedures to support ongoing maintenance and facilitate knowledge sharing

Required Skills:

•  Expertise in Snowflake data warehouse architecture, administration, and feature configuration
•  Advanced SQL skills for complex query development and optimization
•  Hands-on experience developing ETL pipelines with Python and DataStream
•  Proficiency in Snowpipe for continuous data loading and automation
•  Experience using SnowSQL for command-line operations
•  Strong skills in developing stored procedures with PLSQL and T-SQL
•  Ability to configure and utilize Time Travel and Fail Safe features in Snowflake

Preferred Skills:

•  Experience with cloud data platforms (AWS, Azure, Google Cloud)
•  Familiarity with data governance and security best practices
•  Knowledge of data modeling techniques for analytical workloads
•  Exposure to CI/CD pipelines for data engineering projects
•  Experience with performance tuning and query optimization in Snowflake

Desired Qualifications:

•  Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline
•  Snowflake SnowPro Core Certification
•  Certification in data engineering or cloud platforms, such as Google Cloud Professional Data Engineer or Microsoft Azure Data Engineer Associate