Consultant, Data Engineer, Snowflake Data Engineer

What you'll do

• Design enterprise-scale data warehousing and cloud integration strategies using Snowflake.
• Build scalable ELT pipelines utilizing Snowpipe, Streams, Tasks, and Snowpark.
• Implement data modeling frameworks such as Dimensional or Data Vault using dbt.
• Optimize query performance and manage warehouse compute costs through clustering and caching.
• Integrate orchestration tools like Apache Airflow or Prefect to manage complex dependency graphs.
• Develop automated testing programs and scripts to validate data quality and completeness.
• Create and maintain scalable data pipelines for both streaming and batch requirements.
• Establish standards for data ingestion, transformation, and continuous performance tuning.

What we're looking for

• Must have strong experience in data engineering specifically focused on Snowflake architecture and implementation.
• Must possess advanced skills in SQL, Python (including PySpark or Snowpark), and dbt.
• Must have deep knowledge of Snowflake features including RBAC, zero-copy cloning, time travel, and performance tuning.
• Must have hands-on experience with major cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Must have 6 to experience with data quality rules, management standards, and software development on large projects.
• Must have 1 to experience developing compelling stories and distinctive visualizations.
• Undergraduate degree in a related field such as computer science, math, or statistics is preferred.
• Graduate studies in a related field are a plus.