Apply on Kit Job: kitjob.ca/job/2g9kl1

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 contemporary ELT approach built entirely on DBT and Snowflake. This is a hands-on, command-line-driven, config-based environment - the ideal candidate embraces up-to-date 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 solid 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)

Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.

Apply

Apply on Kit Job: kitjob.ca/job/2g9kl1

📌 Sr Data Engineer To Deliver Elt Data Migration From Legacy Sql To Snowflake Using Dbt For A Payments Client Toronto (Canada)
🏢 S.i. Systems
📍 Canada