MDM Data Quality Analyst (36020)

Myticas Consulting Inc.; Illinois; Remote; USD 72,000 - 85,000; Full time

Job summary

Clover Consulting is seeking a skilled MDM Data Quality Analyst for a 12+ month contract. The role focuses on data quality analysis, profiling, testing, requirements gathering, and data governance across State programs.

You will work under the MDM Technical Lead, performing SQL analysis, data validation, UAT support, and collaboration with stakeholders to ensure reliable MDM operations and a unified client view. Remote with occasional travel to Illinois.

Qualifications

• 5+ years of data analysis, data quality, MDM, governance, and data management.
• Experience with Informatica MDM.
• Experience gathering and documenting business and technical requirements.
• SQL experience with large MDM and relational DBMS.
• Bachelor’s degree in CS, Data Analytics, Information Systems, Engineering, or equivalent.

Responsibilities

• Develop and maintain complex SQL queries to support MDM solutions.
• Support SQL analysis, data validation, and data analysis reporting for MDM.
• Collaborate with project teams supporting database objects (tables, procedures, views).
• Perform script execution, maintenance, and modification of programs to meet specs.
• Participate in unit, integration, and system testing.
• Perform data profiling and quality review and analysis.
• Improve the delivery and management of health and human services programs via data analytics.
• Gather business requirements and prepare analyses to evaluate effectiveness and efficiency for projects.
• Participate in discussions to document alternative technical solutions.
• Perform data quality assessments and document findings and remediation.
• Analyze data anomalies, matching issues, and client/member quality concerns.
• Support data governance and data stewardship activities.
• Assist users during UAT and production validation.

Skills

SQL Queries

Data quality

MDM

Data governance

Business analysis

QA testing

Requirements

Relational DBMS

Informatica MDM

Data profiling

Python

Healthcare data

Data reconciliation

Education

Bachelor’s degree in CS/IS/Engineering

Tools

Informatica MDM

Job description

Clover Consulting has a direct client in Springfield, IL in need of an MDM Data Quality Analyst for a 12+ months contract. Job details are below. Thank you!

Role

MDM Data Quality Analyst

Location

Remote - occasional travel to Illinois possible

Term

12+ months contract, extensions possible

Rate

$52 W2 - $62 C2C

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.

MDM Services Summary

• Partner with the MDM Statewide initiative supporting and combining different agency data sources.
• Integrate State agency data to create a holistic view of the clients that the State serves and to administer all State agency programs more effectively and efficiently.
• Provide advanced analytics, data quality analysis, business/data analysis, and MDM data specialists in support of the Illinois Health and Human Services Incubator (HHSi2) project.
• Partner with the State to develop custom dashboards using data as part of the HHSi2 project.
• Provide technical expertise using Informatica MDM and related integration tools to support MDM data processing, data quality, and downstream system(s) needs.
• Support data quality strategy while allowing for data quality analysis and other data governance activities.
• Maintain data quality by using timely and consistent processes and evaluating data quality with the State.
• Leverage established data governance practices and work with State staff and other vendors/partners to improve and validate data consistency and integrity.
• Provide a structure to support business and data analysis using industry standard practices.
• Data analysis to support policy development and program evaluation.
• Identify opportunities/use-cases that help translate data analysis into cost savings and improved outcomes in programs and service areas.

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.
• Perform 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.

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.

Location & Work Model

• Work Arrangement: 100% telecommute
• Resource must be within the continental U.S. in alignment with project requirements. Central U.S. / Illinois / Midwest location is preferred.
• Occasional travel may be required for client or project needs.