MDM Data Quality & Cleansing Specialist

MDM Data Quality & Cleansing Specialist Location: Wayne, PA (Hybrid 2 days/week) Duration: 6+ months plus extension or Possibility of Conversion MoI: Video Core Responsibilities: Perform data cleansing and standardization (deduplication, formatting, validation) Support account/data creation and maintenance Investigate and resolve data quality issues and fallout Apply and help refine data quality rules and checks Identify data anomalies and contribute to root cause analysis Work across multiple datasets to ensure accuracy and consistency Must-Have Qualifications: Strong attention to detail (critical for success in this role) Proven experience working with data quality, data operations, or data cleansing Ability to identify inconsistencies/anomalies in data Comfortable working independently and solving problems with minimal oversight Role overview: 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: 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. 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. 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 InterSources