Senior Data Engineer - Snowflake - Contract

About the role

Propel is looking for a Snowflake Data Engineer to help build and maintain its cloud data warehouse and pipelines. This hands-on role involves owning moderately complex data engineering tasks, working with senior engineers on architecture decisions, and partnering with analysts and data scientists to deliver reliable, well-modeled data.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines feeding into Snowflake.
• Develop and optimize Snowflake data models, including star and snowflake schemas and staging and curated layers.
• Write efficient SQL and use Snowflake features such as Streams, Tasks, and Snowpipe for automation.
• Manage data ingestion from APIs, files, and databases using tools such as Fivetran, Airbyte, or custom scripts.
• Implement transformation logic using dbt or similar frameworks.
• Monitor and optimize warehouse performance, query efficiency, and credit and cost usage.
• Implement data quality checks and basic monitoring and alerting for pipeline health.
• Support role-based access control, data governance, and security within Snowflake.
• Participate in code reviews, follow CI/CD practices, and maintain version control via Git.
• Troubleshoot pipeline failures and data quality issues, escalating complex problems as needed.
• Document pipelines, data models, and processes for team and stakeholder reference.
• Collaborate with analysts and data scientists to understand data requirements and deliver fit-for-purpose datasets.

Requirements

• 5 to 7 years of experience in data engineering, including at least 2 to 3 years working directly with Snowflake.
• Strong SQL skills and experience with relational or cloud data warehouses.
• Understanding of dimensional data modeling and ETL/ELT design principles.
• Experience with at least one ELT or transformation tool; dbt is preferred.
• Familiarity with a cloud platform (AWS, Azure, or GCP) that Snowflake runs on.
• Experience with Git-based version control and basic CI/CD workflows.
• Working knowledge of Python or another...

Datos clave

• The role involves building and maintaining a Snowflake cloud data warehouse and pipelines.
• The requirements include strong SQL skills and experience working directly with Snowflake.