Senior Snowflake Data Engineer — Cloud Data Warehouse

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

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.