MDM Data Quality Analyst

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Design and sustain intricate SQL queries that facilitate MDM solutions.

• Provide support for SQL analysis, data validation, and reporting on data analysis.

• Collaborate on the creation of database objects such as tables, stored procedures, and views.

• Execute scripts while maintaining, developing, and modifying existing programs.

• Engage in unit, integration, and system testing activities.

• Conduct data profiling along with quality reviews and analysis.

• Evaluate data quality while documenting findings, recommendations, and opportunities for remediation.

• Investigate data anomalies, matching issues, and concerns regarding client/member record quality.

• Collect business requirements and prepare analyses utilizing both internal and external sources.

• Take part in project discussions and suggest alternative technical solutions or requirements.

• Support data governance and stewardship initiatives.

• Assist users during User Acceptance Testing (UAT) and production validation.

• Enhance the delivery and management of health and human services programs through data analytics and quality reviews.

• Work under the supervision of the MDM Technical Lead.

⛳️ Requirements

• Minimum of 5 years of experience in data analysis, data quality, MDM, business analysis, data governance, and data management.

• Familiarity with MDM platforms such as Informatica MDM.

• Proven experience in gathering and documenting business and technical requirements.

• Proficiency in data profiling, data validation, testing, reconciliation, and data quality analysis.

• Experience in supporting Quality Assurance (QA), User Acceptance Testing (UAT), or system testing activities.

• SQL experience with large MDM and relational database management systems (DBMS).

• Understanding of data quality, matching, unique client/member identifiers, standardization, reconciliation, and data governance principles.

• Strong analytical, problem-solving, and data validation capabilities.

• Experience in supporting MDM operations, resolving issues, testing activities, and delivering within the Software Development Life Cycle (SDLC).

• Bachelor’s degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience.

• Preferred: experience with additional MDM tools and cloud-native MDM solutions.

• Preferred: experience in state government, public sector, or regulated environments.

• Preferred: familiarity with Agile/Scrum sprint development and iterative/incremental delivery methodologies.

• Preferred: exposure to healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data.

• Preferred: basic knowledge of Python scripting.

• Preferred: understanding of interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR.

• Preferred: experience with cloud data platforms like Azure, ADF, Databricks, Snowflake, or Data Lake.

• Preferred: experience in on-premise to cloud migration, MDM modernization, or EDW/ETL modernization.

• Preferred: exposure to automation, AI/ML, GenAI, or LLM-assisted engineering.

• Capability to function effectively in a telecommute environment and matrix organization with minimal guidance.

🏝️ Benefits

• Engaging projects that enhance systems benefiting real individuals.

• A people-first culture that emphasizes support, autonomy, and community.

• Strategic and hands-on work opportunities.

• Collaborative partnerships with clients.

• Fully remote work availability across the continental United States.