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

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)