MDM Data Quality & Cleansing Consultant

The MDM Data Quality & Cleansing Consultant is responsible for supporting enterprise Master Data Management (MDM) initiatives by performing remediation of post-match-merge fallout records and executing data cleansing activities across designated data domains. This position plays a critical role in ensuring the accuracy, consistency, and completeness of master data in accordance with established data governance policies, data quality standards, and operational procedures., MDM Fallout Management

• Review and research fallout records generated from MDM match-merge processes.
• Perform timely and accurate remediation of data exceptions in accordance with predefined business rules and governance standards.
• Validate survivorship outcomes and ensure that entity resolution results align with data stewardship expectations.
• Conduct root-cause analysis to determine factors contributing to recurring data exceptions.

Data Cleansing and Data Quality Support

• Execute data cleansing tasks including standardization, deduplication, formatting corrections, and attribute validation.
• Verify data completeness and accuracy using approved tools, templates, and quality checks.
• Perform bulk updates or corrections as authorized, following established protocols and change-control requirements.
• Assist in monitoring data quality dashboards, reports, and exception queues.

Data Stewardship Collaboration

• Collaborate with Data Governance, Data Stewards, business partners, and MDM Operations teams to resolve data issues requiring business input.
• Document remediation decisions and maintain required audit trails in accordance with compliance and governance standards.
• Support stewardship processes by escalating complex or policy-related issues as appropriate.

• Minimum of 1+ year of experience in Master Data Management, Data Governance, Data Quality, or a related data operations role.
• Proficiency with Microsoft Excel (e.g., lookup functions, pivot tables, filtering, data cleaning techniques).
• Experience working with one or more MDM applications (e.g., Informatica or similar).
• Strong analytical and problem-solving skills with a high degree of attention to detail.
• Ability to interpret and apply business rules, matching logic, and survivorship frameworks.
• Demonstrated ability to work independently while managing multiple tasks and deadlines.

Preferred

• Experience with match-merge or entity resolution workflows.
• Basic proficiency in SQL or other data manipulation/query tools.
• Familiarity with data governance frameworks, data quality rules, and metadata management principles.
• Prior experience working with party (customer, partner) master data.