Data Product Engineer

Job summary

Design and deliver governed data models, migration mappings, custom lineage frameworks, reconciliation controls, and audit trail infrastructure for regulated financial services environments. Build and integrate AWS data solutions, automate data quality and testing in CI/CD pipelines, and collaborate with technical and business stakeholders.

Job details

Job Description: Data Product Engineer Locations: Toronto, ON / Montreal, QC, Canada Technology Stack: AWS, Aurora PostgreSQL, S3, Glue, Athena, Iceberg, Lambda, Step Functions / MWAA Job Summary We are seeking an experienced Data Product Engineer to design and deliver governed data models, continuous data lineage frameworks, reconciliation controls, and audit trail infrastructure for regulated financial services environments. The ideal candidate will have hands-on experience in large-scale data migration, semantic and physical data modeling, custom data lineage framework development, AWS data platforms, and audit traceability. Key Responsibilities Design and document data models, source-to-target mappings, and transformation logic. Lead data migration activities and validate migrated data through reconciliation. Design and build custom data lineage frameworks, integrating automated lineage refreshes into the deployment lifecycle. Implement reconciliation checks, exception handling, and automated data quality validation. Develop audit trail infrastructure capturing actor, timestamp, previous state, new state, and reason code. Build and integrate data solutions using AWS Aurora PostgreSQL, S3, Glue, Athena, Iceberg, Lambda, and orchestration tools. Develop test specifications and integrate quality checks into CI/CD pipelines. Apply enterprise data governance, privacy, security, and access-control standards. Collaborate with data engineers, analysts, business stakeholders, and client technical teams in an Agile delivery environment. Required Qualifications Proven experience in large-scale data migration and source-to-target reconciliation. Strong expertise in semantic, logical, and physical data modeling. Hands-on experience building custom data lineage frameworks, beyond third-party tool administration. Experience implementing audit trails and data reconciliation in regulated environments. Strong AWS data engineering expertise, including Aurora PostgreSQL, S3, Glue, Athena, Lambda, and orchestration services. Experience with Apache Iceberg or comparable table formats. Strong SQL, data quality, testing, and CI/CD integration skills. Previous experience in financial services or other regulated industries. Excellent communication and stakeholder collaboration skills. Core Skills: Data Modeling | Data Migration | Custom Data Lineage | Data Reconciliation | Audit Trail | AWS | Data Quality | Financial Services

What you’ll do

Design and deliver governed data models, migration mappings, custom lineage frameworks, reconciliation controls, and audit trail infrastructure for regulated financial services environments. Build and integrate AWS data solutions, automate data quality and testing in CI/CD pipelines, and collaborate with technical and business stakeholders.

Requirements

Requires proven experience with large-scale data migration, source-to-target reconciliation, semantic and physical data modeling, and custom data lineage and audit trail development. Candidates should have strong AWS data engineering, SQL, data quality, testing, and CI/CD skills, experience with Apache Iceberg or a comparable format, and a background in financial services or another regulated industry.

Listed skills

• SQL · Preferred
• CI/CD · Preferred
• Amazon Web Services · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Modeling
• Data Migration
• Custom Data Lineage
• Data Reconciliation
• Audit Trails
• AWS
• Data Quality
• Financial Services
• SQL
• CI/CD
• Aurora PostgreSQL
• Amazon S3
• AWS Glue
• Amazon Athena
• Apache Iceberg
• AWS Lambda

Job areas

• Data & Analytics
• Technology
• Software
• Finance & Accounting