Data Product Engineer

emergiTEL is hiring a Data Product Engineer for our client in the technology services industry. This role can be either contract or perm.
Compensation: $72 - $90/hour OR Perm $120-$130k/annum
Location: Montreal, QC or Toronto, ON

Job Description (English)

Role Description

Design and deliver the data model, continuous data lineage framework, reconciliation approach, and audit trail infrastructure for governed data platform engagements at regulated financial institutions. Own the semantic and physical models that downstream reporting and reconciliation build against, design and build the lineage framework itself, and set the reconciliation and auditability standard the delivery team builds against.

You Will

- Design and document data models for confirmed sources and outputs, including source-to-target mappings, transformation requirements, and treatment approaches for data gaps identified during discovery.

- Lead data model migration work, including mapping existing source structures to target models, defining transformation and enrichment logic, documenting migration approaches, and validating reconciliation to source systems.

- Define the semantic model that the reporting layer builds upon in collaboration with data engineering stakeholders.

- Design and build a continuous data lineage framework that captures, stores, refreshes, and presents lineage as a core platform capability.

- Integrate lineage generation into the deployment lifecycle to ensure lineage is refreshed with every solution change.

- Define and implement reconciliation approaches across source, transformed, and target datasets, including exception management.

- Implement audit trail infrastructure capturing actor, timestamp, previous state, new state, and reason code for material data changes.

- Author test specifications for data models, lineage, and reconciliation components and integrate automated data quality checks into deployment pipelines.

- Apply enterprise data governance standards for sensitive data, privacy, and access controls as defined by the client.

- Participate as an embedded member of an integrated delivery team, including standups, sprint planning, and stakeholder reviews.

Who You Are

- Experienced leading large-scale data migration engagements with proven reconciliation outcomes at go-live.

- Skilled in designing semantic and physical data models for governed data platforms.

- Experienced building continuous data lineage frameworks rather than administering lineage products.

- Proven background implementing reconciliation controls and audit traceability within regulated environments.

- Deep expertise with AWS data platforms, including Aurora PostgreSQL, S3, Glue, Athena, Iceberg, Lambda, and orchestration services.

- Committed to quality engineering through testing, validation, and automated quality controls.

- Experienced in regulated financial services environments.

- Able to communicate effectively with technical, business, and governance stakeholders.

- Comfortable working as an embedded member of a client delivery team.

Nice to Have

- Agentic lineage experience, including the use of LLM agents for lineage extraction, transformation analysis, and lineage maintenance.

- Broader agent-based system experience in data platform environments.

- DataOps expertise, including deployment pipelines, data contracts, expectations frameworks, and data quality tooling.

- Experience with graph databases such as Neo4j or Amazon Neptune and graph-based lineage exploration tools.

- Experience supporting Canadian banking data platforms operating under OSFI or similar regulatory requirements.

- Financial services reconciliation experience, including general ledger or revenue reconciliation.

Description du poste (Franais)

Description du rle

Concevoir et livrer le modle de donnes, le cadre de lignage des donnes en continu, lapproche de rapprochement ainsi que linfrastructure de piste daudit pour des plateformes de donnes gouvernes au sein dinstitutions financires rglementes. Assurer la responsabilit des modles smantiques et physiques utiliss par les couches de production de rapports et de rapprochement, concevoir le cadre de lignage et dfinir les normes dauditabilit pour lquipe de livraison.

Responsabilits

- Concevoir et documenter les modles de donnes pour les sources et les sorties confirmes, y compris les mappings source-cible, les exigences de transformation et le traitement des carts de donnes.

- Diriger les travaux de migration des modles de donnes en mappant les structures existantes vers les modles cibles et en validant les rsultats de rapprochement.

- Dfinir le modle smantique utilis par les solutions de production de rapports.

- Concevoir et dvelopper un cadre de lignage des donnes continu qui capture, stocke, met jour et prsente le lignage comme capacit essentielle.

- Intgrer la gnration du lignage au cycle de dploiement afin dassurer une mise jour chaque changement.

- Dfinir et mettre en uvre lapproche de rapprochement entre les jeux de donnes sources, transforms et cibles.

- Mettre en place une infrastructure de piste daudit enregistrant lacteur, lhorodatage, ltat prcdent, le nouvel tat et le code de justification.

- Rdiger les spcifications de tests et intgrer des contrles automatiss de qualit des donnes dans les pipelines de dploiement.

- Appliquer les normes de gouvernance des donnes du client concernant les donnes sensibles, la confidentialit et la gestion des accs.

- Participer activement aux crmonies Agile et aux activits de livraison au sein de lquipe intgre du client.

Profil recherch

- Exprience dmontre dans des projets de migration de donnes grande chelle avec validation de rapprochement.

- Expertise dans la conception de modles de donnes smantiques et physiques pour des plateformes gouvernes.

- Exprience dans la cration de cadres de lignage continus plutt que dans ladministration doutils de lignage.

- Solide exprience en auditabilit et en contrles de rapprochement dans des environnements rglements.

- Expertise approfondie des plateformes AWS incluant Aurora PostgreSQL, S3, Glue, Athena, Iceberg, Lambda et les outils dorchestration.

- Fort engagement envers la qualit logicielle, les tests automatiss et les contrles de qualit des donnes.

- Exprience dans le secteur des services financiers rglements.

- Capacit communiquer avec des intervenants techniques, daffaires et de gouvernance.

- Aisance travailler comme membre intgr dune quipe client.

Atouts

- Exprience en lignage agentique utilisant des agents LLM.

- Exprience avec des systmes bass sur des agents dans un contexte de donnes ou de plateforme de donnes.

- Connaissances en DataOps, contrats de donnes et outils de qualit des donnes.

- Exprience avec Neo4j, Amazon Neptune ou dautres bases de donnes graphiques.

- Exprience sur des plateformes de donnes bancaires canadiennes soumises aux exigences de lOSFI ou dorganismes comparables.

- Exprience en rapprochement financier, notamment pour le grand livre ou les revenus.

---

Vacancy Status / Statut du poste

This is an active position currently open for hiring. / Ce poste est activement ouvert au recrutement.

Use of Artificial Intelligence / Utilisation de l'intelligence artificielle

emergiTEL uses artificial intelligence to help identify and source candidates for this role. All assessment and selection decisions are made by our recruiters, a human is always involved, and no applicant is evaluated or rejected by automated means alone. / emergiTEL a recours l'intelligence artificielle pour aider identifier et trouver des candidats pour ce poste. Toutes les dcisions relatives l'valuation et la slection sont prises par nos recruteurs ; une intervention humaine est systmatiquement assure, et aucun candidat n'est valu ou rejet uniquement par des moyens automatiss.