Sr. Data Engineer to deliver ELT data migration from legacy SQL to Snowflake using DBT for a Payments Client

S.i. Systems London, England Posted Mar 17, 2026

Contract
Hybrid
Senior

Job description

Sr. Data Engineer to deliver ELT data migration from legacy SQL to Snowflake using DBT for a Payments Client

Duration: 6-month contract to start

Location: Etobicoke, Hybrid 3x/week on-site. 

Our Payments Client is seeking a Sr. Data Engineer to deliver ELT data migration from legacy SQL to Snowflake using DBT. The client is modernizing their data platform, moving away from Talend and legacy ETL tooling toward a modern ELT approach built entirely on DBT and Snowflake. This is a hands-on, command-line-driven, config-based environment — the ideal candidate embraces modern data engineering practices and can hit the ground running in a fast-paced team.

Responsibilities

  • Build and maintain data ingestion pipelines using the client's proprietary ingestion tooling
  • Develop, test, and maintain data transformation models in DBT across the client's data product portfolio
  • Support the migration of historical data loads from legacy SQL analytical systems into Snowflake
  • Manage source control workflows using Git across all data assets and configuration files
  • Contribute to hitting key project milestones around database ingestion — an identified gap in current team velocity
  • Work directly with business users and delivery leads to gather and refine requirements using Excel templates and convert them into actionable user stories
  • Collaborate with the broader data team to adopt and reinforce modern ELT practices, helping shift the team away from legacy ETL approaches
  • Must Haves

  • 5+ years as a Data Engineer with strong ELT methodology experience
  • Hands-on DBT experience building data transformation models and data products/assets
  • Snowflake data platform experience
  • Git for version control and source code management
  • Comfortable working in a command-line-driven, config-based environment (editing JSON config files, no frontend/UI tooling)
  • Data ingestion and transformation pipeline experience
  • Ability to work at a fast pace with a startup mentality; comfortable with ambiguity and rapid iteration
  • Nice to Haves

  • Software development background or familiarity with SDLC concepts
  • Requirements management experience — gathering user stories directly from business users (JIRA, Excel templates)
  • Banking, insurance, or payments domain experience
  • Experience with data migration projects (legacy analytical systems to cloud platforms)


  • Report this job
    Report this job

    Help us keep Jobs247 accurate, safe, and useful for job seekers.

    Usually takes less than 20 seconds
    We review reports to remove misleading, expired, or duplicate listings faster.
    Career guide

    Learn more about this role

    Explore the matching JobPedia guide for deeper duties, skills, salary context, and career paths.

    JobPedia role guide

    What does a Data Engineer actually do?

    Explore the real work behind the title, from day-to-day responsibilities to how the role works in practice for Data Engineer.

    Keep exploring similar roles

    Search for more Sr. Data Engineer to deliver ELT data migration from legacy SQL to Snowflake using DBT for a Payments Client jobs from S.i. Systems in London, England.