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