MDM Data Engineer at AAIS overseeing master data management and governance. Developing platforms and pipelines while collaborating across teams to ensure data integrity and quality.
Responsibilities
Build and maintain the MDM platform, including entity resolution, match/merge rules, survivorship logic, and golden record management.
Develop and enforce data models that support party, policy, and reference data domains across the enterprise.
Architect MDM hub configurations (registry, consolidation, or co-existence models) appropriate to AAIS’s operational context.
Build and maintain MDM integration layers connecting source systems, the data lake/warehouse, and downstream consumers.
Define and implement data governance policies, standards, and workflows in collaboration with Data Stewards and the Director of Data Solutions.
Develop data quality rules, profiling routines, and exception-handling workflows to ensure master data integrity across all jurisdictions.
Maintain business glossaries, data dictionaries, and lineage documentation for all master data domains.
Partner with business stakeholders to define data ownership, stewardship responsibilities, and escalation paths for data quality issues.
Analyze and profile source data to assess quality, completeness, atomicity, and referential integrity prior to MDM onboarding.
Implement automated data quality monitoring and alerting to proactively surface master data anomalies and support data quality KPI tracking.
Establish and track data quality KPIs and SLAs for key master data domains.
Design and develop data integration pipelines that feed the MDM platform from disparate source systems in batch and near-real-time.
Build and maintain ETL/ELT workflows using cloud-native tooling (AWS Glue, Step Functions) and integration platforms.
Ensure referential integrity and consistent application of master data identifiers across the data ecosystem.
Support the broader Data Lake/Warehouse environment, contributing to data modeling, analytics engineering, and BI delivery as needed.
Collaborate with the Data Engineering team to ensure MDM outputs are properly integrated into reporting, analytics, and statistical data collection workflows.
Contribute to Agile sprint planning, technical documentation, and peer code review processes.
Requirements
Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Management, or a related discipline.
5+ years of data engineering experience, with a minimum of 3 years focused specifically on MDM platform development and data governance.
Demonstrated experience owning MDM implementations end-to-end, including data model design, match/merge tuning, and integration delivery.
Experience with data quality tooling and profiling methodologies.
Proficiency in SQL & Python.
Experience in property and casualty insurance or other regulated industries a plus.
Bonus: Experience working with statistical data, Actuarial models, or licensed statistical agent environments.
Benefits
Up to 5% travel for annual company gatherings or team sessions
Data engineering advisor developing scalable data platforms and pipelines for Desjardins. Designing, integrating, and improving data systems aligned with business needs.
Senior Data Engineer owning NimbleRx’s compliant healthcare data platform. Building scalable pipelines, warehouse models, and AI tooling for pharmacy and patient engagement operations.
Administrateur principal de plateformes de données chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Conception, exploitation et gouvernance de plateformes de données infonuagiques.
Senior Data Platform Administrator shaping and operating EDC’s secure enterprise data platforms. Supporting Canadian businesses through Export Development Canada’s trade - finance solutions.
Staff full - stack engineer architecting GitLab’s data products, integrations, and knowledge graph. Building APIs, marketplace data access, and AI - powered developer intelligence.
Data Governance Architect shaping governance strategies and cloud data architectures for Lovelytics’ enterprise data and AI consulting clients. Leading technical delivery, presales, migrations, and governance implementations on Databricks.
Senior Data Engineer owning Databricks lakes, pipelines, and AI data infrastructure. Building Quandri’s AI operating system for insurance agencies and brokerages.
Senior Data Engineer architecting Azure and Databricks data platforms for TTEC Digital’s client experience solutions. Building governed pipelines, APIs, MCP integrations, and agentic AI data services.
Senior Data Engineer building Palantir Foundry data solutions for Unit8, a Swiss AI and data analytics consultancy. Supporting client delivery and establishing its Canadian market presence.
Staff Software Engineer building AWS data infrastructure and integrations for Solink’s cloud video - security platform. Driving scalability, architecture, and engineering mentorship.