MDM Data Quality Analyst

Description

At CSpring, we believe in the power of data to drive decisions and real-world impact. We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.

We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy. Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here.

• Purposeful Projects – Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight.
• People-First Culture – We’re as committed to your growth as we are to delivering high-impact solutions. You’ll find support, autonomy, and community here.
• Strategic, Hands-On Work – From data architecture and documentation to client workshops and solution delivery, you’ll influence every step of the process.
• Collaborative Trust – Our clients rely on us to listen carefully, deliver consistently, and guide wisely. We partner with integrity, curiosity, and heart.

CSpring partners with government and healthcare organizations to solve complex problems through data, technology, and people. This role supports the Health and Human Services Innovation Incubator (HHSi2), a statewide Master Data Management initiative in Illinois building one trustworthy view of the residents the State serves across every agency that touches them. When the same person exists as four separate records, eligibility stalls and programs double-count — the analysis you do here is what makes cross-agency data reliable enough to act on.

• The records you reconcile feed eligibility and service decisions across multiple State agencies. A duplicate client record here isn't a dashboard blemish — it's someone waiting longer than they should for benefits they qualify for.
• Statewide MDM is genuinely hard. You'll work across agency data that was never designed to be joined, on an Informatica MDM platform serving cross-agency programs — the kind of matching and survivorship problem you can't get real practice on with a tidy dataset.
• CSpring teams are small enough that you'll own a finding end to end. You'll profile it, document the remediation recommendation, and be the person who walks the client through it rather than handing it up a chain.
• HHSi2 spans data governance, interoperability, cloud modernization, and analytics. Whether you want to go deeper into MDM architecture or wider into stewardship and governance, both directions exist on this program.
• Fully remote across the continental U.S., with a team that's warm and grounded and doesn't treat "remote" as a reason to be hard to reach.

Working under the guidance of the MDM Technical Lead, you'll perform the data analysis, quality assessment, testing, and validation work that keeps MDM operations accurate and dependable:

• Develop and maintain complex SQL queries to support MDM solutions, and support SQL analysis, data validation, and data analysis reporting activities.
• Collaborate with project teams supporting database objects such as tables, stored procedures, and views for MDM.
• Perform script execution, and maintain, develop, and modify existing programs to meet system and design specifications.
• Participate in unit, integration, and system testing.
• Perform data profiling and quality review and analysis.
• Perform data quality assessments and document findings, recommendations, and remediation opportunities.
• Analyze data anomalies, matching issues, and client/member record quality concerns.
• Gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate effectiveness and efficiency supporting projects and change requests.
• Participate in project discussions to document and recommend alternative technical solutions or…