Master Data Management (MDM) Data Engineer

AAIS (American Association of Insurance Services); United States; On-site; USD 117,000 - 143,000; Full time

Job summary

AAIS is seeking a seasoned MDM Data Engineer to own the full lifecycle of master data, from ingestion to survivorship and delivery. You will architect MDM solutions, implement data quality rules, and collaborate with data stewards and engineering teams to enable enterprise data governance across party, policy, and reference data domains.

The role emphasizes hands-on MDM expertise, strong data modeling, SQL, Python, and cloud experience (AWS).

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Management, or related discipline.
• 5+ years of data engineering, with at least 3 years on MDM platform development and data governance.
• Experience owning MDM implementations end-to-end including data model design and integration delivery.
• Proficiency in SQL and Python; experience with data quality tooling and profiling methodologies.

Responsibilities

• Build and maintain the MDM platform with entity resolution, match/merge rules, survivorship, and golden records.
• Define and enforce data models for party, policy, and reference data domains.
• Architect MDM hub configurations (registry, consolidation, co-existence).
• Develop data integration pipelines feeding MDM from diverse sources (batch and near real-time).
• Collaborate with stakeholders, maintain data governance policies, and ensure data quality and lineage.

Skills

MDM platforms

SQL

Python

Data governance

Data modeling

Cloud experience (AWS)

ETL/ELT

Communication

Education

Bachelor’s or Master’s in CS/IS/Data Management

Tools

Informatica MDM

Reltio

Semarchy

AWS Glue

Job description

About AAIS
Since 1936, American Association of Insurance Services (“AAIS”) has served the property and casualty insurance industry as the only national not-for-profit advisory organization governed by its member companies. We are committed to evolving with changes in the insurance industry, adding value to our members, regulators, and the industry with responsive products and insights.

Description
About AAIS
Since 1936, American Association of Insurance Services (“AAIS”) has served the property and casualty insurance industry as the only national not-for-profit advisory organization governed by its member companies. We are committed to evolving with changes in the insurance industry, adding value to our members, regulators, and the industry with responsive products and insights.

Purpose
The MDM Data Engineer supports AAIS’s Master Data Management platform, data governance frameworks, and supporting data integration infrastructure. This role is the operational and technical backbone of our MDM practice, owning the full lifecycle of master data — from ingestion and standardization through survivorship, stewardship, and delivery.

The ideal candidate brings deep, hands-on MDM expertise paired with strong data engineering fundamentals. They thrive in a collaborative, cross-functional environment and are comfortable translating complex data governance concepts into practical, scalable solutions.

Responsibilities
Master Data Architecture & Development

• 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.

Data Governance & Stewardship
Data Governance & Stewardship

• 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.

Data Quality & Profiling
Data Quality & Profiling

• 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.

ETL/ELT & Integration Engineering
ETL/ELT & Integration Engineering

• 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.

Broader Data Engineering Responsibilities
Broader Data Engineering Responsibilities

• 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.
• Clearly communicate technical concepts, data quality findings, and governance recommendations to non-technical stakeholders and leadership.
• Perform additional duties as assigned or requested.

Knowledge, Skills, And Abilities
Knowledge, Skills, And Abilities

• Deep, hands-on expertise in MDM platforms and patterns (e.g., Informatica MDM, Reltio, Semarchy, or equivalent) — including match/merge configuration, survivorship rules, and workflow design.
• Strong data modeling skills with experience in both MDM-specific models and traditional warehouse patterns (Kimball, Inmon, Data Vault).
• Proficiency in SQL and experience working with large structured and semi-structured datasets.
• Experience designing and implementing data governance frameworks, including stewardship workflows, data quality rules, and lineage tracking.
• Hands-on experience with cloud data platforms, preferably AWS (Glue, Athena, S3, RDS).
• Familiarity with ETL/ELT tooling such as AWS Glue.
• Ability to operate independently as a developer while collaborating effectively across technical and business teams.
• Excellent written and oral communication skills; ability to articulate data governance and MDM concepts to non-technical audiences.
• Strong critical thinking and problem-solving skills with the ability to manage multiple priorities and meet deadlines.

Requirements
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.
• Up to 5% travel for annual company gatherings or team sessions.

Minimum starting base of $130,000, with upward flexibility based on skills and experience + 10% annual bonus.
Salary Description

Min $130k base; see full pay details in job post.