MDM Data Quality Analyst

RCR Technology Group; United States; Remote; USD 85,000 - 125,000; Full time

Job summary

RCR Technology Corporation seeks an experienced MDM Data Quality Analyst to support data quality assessments, profiling, and governance for HHSi2 initiatives. The role focuses on SQL analysis, testing, validation, and ensuring a unified view across state programs.

The candidate will work under the MDM Technical Lead, performing data quality reviews, requirements gathering, UAT support, and data governance activities to ensure reliable MDM operations.

Qualifications

• 5+ years of experience in data analysis, data quality, MDM, and data governance.
• Experience with MDM platforms such as Informatica MDM.
• Experience gathering and documenting business and technical requirements.
• Experience in data profiling, validation, testing, reconciliation, and data quality analysis.
• Experience supporting QA, UAT, or system testing activities.
• SQL experience with large MDM and relational DBMS.

Responsibilities

• Develop and maintain complex SQL queries to support MDM solutions.
• Support SQL analysis, data validation, and data analysis reporting for MDM.
• Collaborate with teams supporting DB objects (tables, procedures, views) for MDM.
• Run scripts, maintain and modify programs to meet specifications.
• Participate in unit, integration, and system testing.
• Perform data profiling and quality review and analysis.
• Improve data governance and data stewardship activities.
• Gather business requirements and prepare analyses for projects and change requests.
• Document and suggest alternative technical solutions or requirements.
• Analyze data anomalies and matching issues affecting client records.
• Assist users during UAT and production validation.

Skills

MDM

SQL

Data analysis

Data governance

QA/UAT

SDLC

Education

Bachelor's degree in CS or related

Tools

Informatica MDM

Job description

For over twenty-seven years RCR Technology Corporation has delivered the highest quality services to our clients with an expansive portfolio of industry-relevant services, and deep technical capabilities around data management and application development.

We are seeking an experienced MDM Data Quality Analyst to support Master Data Management services for the Health and Human Services Innovation Incubator (HHSi2) project. This role will focus on data quality analysis, data profiling, business and technical requirements, testing, validation, and data governance activities supporting a unified cross-agency client/member view across State programs.

The selected candidate will work under the guidance of the MDM Technical Lead to perform data analysis, data quality assessments, testing, requirements gathering, user acceptance testing (UAT) support, SQL analysis, and validation activities to ensure reliable and accurate MDM operations.

Key Responsibilities

• Developing and maintaining complex SQL queries to support MDM solutions.
• Supporting SQL analysis, data validation, and data analysis reporting activities for MDM solutions.
• Collaborate with project teams supporting database objects such as tables, stored procedures, and views for MDM.
• Performing script execution, maintaining, developing, and modifying existing programs to meet system and design specifications.
• Participating in unit, integration, and system testing
• Performing data profiling and quality review and analysis
• Improving the delivery and management of health and human services programs by utilizing data analytics and quality reviews
• Gathering business requirements and preparing analyses based on information from internal and external sources to evaluate and demonstrate effectiveness and efficiency supporting projects and change requests.
• Participating in project discussions to document and recommend alternative technical solutions or requirements.
• P erform data quality assessments and document findings, recommendations, and remediation opportunities.
• Analyze data anomalies, matching issues, and client/member record quality concerns.
• Support data governance and data stewardship activities.
• Assist users during User Acceptance Testing (UAT) and production validation.

Requirements

Required Qualifications

• 5+ years of experience in data analysis, data quality, MDM, business analysis, data governance, and data management.
• Experience working with MDM platforms such as Informatica MDM.
• Experience gathering and documenting business and technical requirements.
• Experience in performing data profiling, data validation, testing, reconciliation, and data quality analysis.
• Experience supporting QA, UAT, or system testing activities.
• SQL experience, with large MDM and large relational DBMS.
• Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts.
• Strong analytical, problem-solving, and data validation skills.
• Experience supporting MDM operations, issue resolution, testing activities, and SDLC delivery.
• Bachelor’s degree in computer science, Data Analytics, Information Systems, Engineering, or equivalent experience.

Preferred Qualifications

• Experience working in other MDM tools including Cloud-native MDM solutions.
• Experience working in State Government, public sector, or regulated environments.
• Experience with Agile/Scrum Sprint development and iterative/incremental delivery.
• Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data.
• Exposure to Python scripting for automation, testing, data validation, or profiling activities.
• Exposure to interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR.
• Exposure to cloud data platforms or modernization initiatives such as Azure, ADF, Databricks, Snowflake, Data Lake, or comparable technologies is a plus.
• Experience with on-prem-to-cloud migration, MDM modernization, or EDW / ETL modernization initiatives.
• Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality is a plus.
• Ability to operate in a telecommute environment and matrix organization with minimal direction.