MDM Data Quality & Cleansing Specialist

Role: MDM Data Quality & Cleansing Specialist

Location: Wayne PA (Hybrid)

Position Summary

The MDM Data Quality & Cleansing Specialist 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.

Responsibilities

Qualifications

Required

• Minimum of 2 years 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.

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.

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.

Competencies

• Analytical thinking and problem solving
• Accuracy and attention to detail
• Data stewardship mindset
• Collaboration and communication
• Organizational and time‑management skills
• Ability to work with confidential information responsibly