Snowflake Data Engineer

Propel London Ltd.; Kentucky; On-site; USD 110,000 - 160,000; Full time

Job summary

Propel London Ltd. is seeking a Snowflake Data Engineer to build and maintain our cloud data warehouse and pipelines.

You will own moderately complex data engineering tasks, collaborate with senior engineers on data architecture, and work with analysts and data scientists to deliver well-modeled data. Responsibilities include designing ELT pipelines, optimizing Snowflake models, writing SQL, and using Fivetran or Airbyte.

Qualifications

• 5-7 years of experience in data engineering with 2-3 years direct Snowflake work
• Strong SQL skills and experience with relational/cloud data warehouses
• Understanding of dimensional data modeling and ETL/ELT design principles
• Experience with at least one ELT/transformation tool (dbt preferred)
• Cloud platform familiarity (AWS, Azure, or GCP)
• Git-based version control and basic CI/CD workflows
• Python or another scripting language for automation
• Good communication and teamwork abilities

Responsibilities

• Design, build, and maintain ETL/ELT pipelines feeding into Snowflake
• Develop and optimize Snowflake data models (star/snowflake, staging/curated layers)
• Write efficient SQL and use Snowflake features (Streams, Tasks, Snowpipe) for automation
• Manage data ingestion from various sources using tools like Fivetran, Airbyte, or custom scripts
• Implement transformation logic using dbt or similar frameworks
• Monitor and optimize warehouse performance, query efficiency, and costs
• Implement data quality checks and basic monitoring/alerting
• Support RBAC, data governance and security within Snowflake
• Participate in code reviews, CI/CD practices, and Git version control
• Troubleshoot pipeline failures and data quality issues
• Document pipelines and data models for reference
• Collaborate with analysts and data scientists to deliver fit-for-purpose datasets

Skills

Strong SQL skills

Snowflake experience

Python or scripting

Git-version control

Team collaboration

Education

Post secondary diploma in Computer Science or Engineering

Tools

dbt

Fivetran

Airbyte

Git

Job description

Snowflake Data Engineer

About the Role

We're looking for a Snowflake Data Engineer with solid hands-on experience to help build and maintain our cloud data warehouse and pipelines. You'll take ownership of moderately complex data engineering tasks, work closely with senior engineers on data architecture decisions, and partner with analysts and data scientists to deliver reliable, well-modeled data.

Key Responsibilities

• Design, build, and maintain ETL/ELT pipelines feeding into Snowflake
• Develop and optimize Snowflake data models (star/snowflake schemas, staging/curated layers)
• Write efficient SQL and use Snowflake features such as Streams, Tasks, and Snowpipe for automation
• Manage data ingestion from various sources (APIs, files, databases) using tools like Fivetran, Airbyte, or custom scripts
• Implement transformation logic using dbt (data build tool) or similar frameworks
• Monitor and optimize warehouse performance, query efficiency, and credit/cost usage
• Implement data quality checks and basic monitoring/alerting for pipeline health
• Support role-based access control (RBAC), 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

Required Qualifications

• 5-7 years of experience in data engineering, with at least 2-3 years working directly with Snowflake
• Strong SQL skills and experience with relational/cloud data warehouses
• Understanding of dimensional data modeling and ETL/ELT design principles
• Experience with at least one ELT/transformation tool (dbt 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 scripting language for automation
• Good communication skills and ability to work within a team, taking direction from senior engineers when needed

Preferred Qualifications

• SnowPro Core Certification
• Experience with Snowflake-native features: Streams, Tasks, Snowpipe, Time Travel, Zero-Copy Cloning
• Familiarity with orchestration tools (Airflow, Dagster, or Snowflake Tasks)
• Exposure to data ingestion tools (Fivetran, Airbyte, Matillion)
• Basic understanding of streaming data concepts
• Post secondary diploma in Computer Science, Engineering, or related field (or equivalent practical experience)

Snowflake Data Engineer

About the Role

We're looking for a Snowflake Data Engineer with solid hands-on experience to help build and maintain our cloud data warehouse and pipelines. You'll take ownership of moderately complex data engineering tasks, work closely with senior engineers on data architecture decisions, and partner with analysts and data scientists to deliver reliable, well-modeled data.

Key Responsibilities

• Design, build, and maintain ETL/ELT pipelines feeding into Snowflake
• Develop and optimize Snowflake data models (star/snowflake schemas, staging/curated layers)
• Write efficient SQL and use Snowflake features such as Streams, Tasks, and Snowpipe for automation
• Manage data ingestion from various sources (APIs, files, databases) using tools like Fivetran, Airbyte, or custom scripts
• Implement transformation logic using dbt (data build tool) or similar frameworks
• Monitor and optimize warehouse performance, query efficiency, and credit/cost usage
• Implement data quality checks and basic monitoring/alerting for pipeline health
• Support role-based access control (RBAC), 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

Required Qualifications

• 5-7 years of experience in data engineering, with at least 2-3 years working directly with Snowflake
• Strong SQL skills and experience with relational/cloud data warehouses
• Understanding of dimensional data modeling and ETL/ELT design principles
• Experience with at least one ELT/transformation tool (dbt 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 scripting language for automation
• Good communication skills and ability to work within a team, taking direction from senior engineers when needed

Preferred Qualifications

• SnowPro Core Certification
• Experience with Snowflake-native features: Streams, Tasks, Snowpipe, Time Travel, Zero-Copy Cloning
• Familiarity with orchestration tools (Airflow, Dagster, or Snowflake Tasks)
• Exposure to data ingestion tools (Fivetran, Airbyte, Matillion)
• Basic understanding of streaming data concepts
• Post secondary diploma in Computer Science, Engineering, or related field (or equivalent practical experience)