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

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 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)

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

Apply

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

📌 Sr. Data Engineer to deliver ELT data migration from legacy SQL to Snowflake using DBT for a Payments Client (Toronto)
🏢 S.i. Systems
📍 Toronto