Note: The job is a remote job and is open to candidates in USA. AAIS (American Association of Insurance Services) is a national not-for-profit advisory organization serving the property and casualty insurance industry. They are seeking a Master Data Management (MDM) Data Engineer to support their MDM platform and data governance frameworks, focusing on the full lifecycle of master data management.
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
- Clearly communicate technical concepts, data quality findings, and governance recommendations to non-technical stakeholders and leadership
- Perform additional duties as assigned or requested
Skills
- 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
- 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
- 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
- 10% annual bonus
- Up to 5% travel for annual company gatherings or team sessions
Company Overview
Company H1B Sponsorship