Validate and test ETL pipelines and EDW extracts for a state Medicaid environment. Review requirements, design and execute test cases (manual and automated), write complex SQL, develop Python-based validation scripts, document defects in JIRA/ALM/Azure DevOps, integrate automation into CI/CD, and collaborate with developers and stakeholders to ensure data quality and compliance with healthcare standards.
Description
At CSpring, we believe in the power of people and data to drive real-world impact. We’re a purpose-driven consulting firm that helps organizations solve complex problems, gain insights, and achieve measurable results. Our clients span the public and private sectors, and our work — from data strategy and engineering to workforce transformation — improves lives across Indiana and beyond. We’re seeking talented professionals who are collaborative, curious, and committed to making a difference.
Why You’ll Love Working Here
- Work that carries real weight. You'll be validating data pipelines that support a state Medicaid system — your attention to detail has a direct downstream effect on how healthcare information reaches the people who need it.
- A team that takes quality seriously. CSpring has a culture of rigor and care. We don't ship sloppy work, and we hire people who feel the same way — you'll be surrounded by colleagues who hold the same standard.
- Room to grow your craft. You'll work across a modern, meaningful stack — Informatica PowerCenter, Teradata, Azure DevOps, and Python automation — with the latitude to improve and automate the processes you own.
- Collaboration without silos. Our teams work in tight Agile cycles with real communication between QA engineers, ETL developers, and business stakeholders.
- Purpose-driven clients. Our government and healthcare clients are doing work that matters to their communities. When you support their data infrastructure, you're part of that mission too.
What You’ll Do
You'll own the quality of data as it moves through ETL pipelines in a state Medicaid environment — from reviewing requirements all the way through defect resolution, regression testing, and automation.
- Review Change Requests (CRs) and participate in requirement analysis for new EDW extracts and transformations.
- Participate in data modeling and requirement gathering sessions to ensure testing stays aligned with business needs.
- Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses (EDW); verify source-to-target data mapping and transformation logic for Medicaid datasets.
- Validate data quality, standardization rules, and loading accuracy across full-load and incremental-load cycles.
- Write complex SQL queries — multi-table JOINs, aggregations, row counts, null checks, duplicate checks, and referential integrity validation — to validate ETL outputs against business rules.
- Design test plans, test cases, and test scenarios for ETL processes; execute both manual and automated tests.
- Identify, document, and track discrepancies using JIRA, HP ALM, or Azure DevOps Test Plans; collaborate with ETL developers to resolve defects and perform regression testing.
- Develop automated database validation scripts using Python, SQLAlchemy, and Pandas; create shell scripts for ETL monitoring and log analysis.
- Integrate test automation into CI/CD pipelines in Azure DevOps.
- Document test results and provide detailed, actionable feedback to stakeholders.
Requirements
- 5+ years of experience in software testing and quality assurance
- 5+ years of experience testing backend, database, EDW, or ETL systems
- 4+ years of strong SQL experience and hands-on work with at least one RDBMS (Teradata, SQL Server, Oracle, or similar)
- 4+ years of experience in UI, smoke, end-to-end, and integration testing
- 4+ years of experience in test design and working with at least one test management tool (Azure DevOps, JIRA, HP ALM)
- Strong understanding of EDW and ETL concepts, including Star/Snowflake schema and Slowly Changing Dimensions (SCD1/SCD2)
- Direct experience in a Medicaid, healthcare, or government data environment, including familiarity with HIPAA and healthcare data standards (837/835 claims, ICD-9/10, CPT, HL7)
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Mathematics, or a related field
Preferred Qualifications
- Hands-on experience with Informatica PowerCenter
- Knowledge of Medicaid reporting, encounter data, and data mart validation
- Familiarity with Medicaid Enterprise Systems (MES) or a state Medicaid agency (e.g., Illinois HFS)
- Python test automation and GitHub for code management
- Experience integrating automated tests into CI/CD pipelines
At CSpring, we unlock the potential of people and data. If you’re ready to lead meaningful work, collaborate with passionate teams, and grow your career in a people-first consulting environment — apply today!
Similar Jobs
.png){kind=avatar}
Fintech • Machine Learning • Software • Financial Services
Provides in-house corporate legal support for an international proprietary trading organization. Responsibilities include advising on corporate law, entity structures, intracompany transactions, tax matters, and organizational actions; drafting and negotiating agreements; preparing legal memoranda; and supporting contracts, regulatory safeguards, and cross-functional business objectives.
Fintech • Machine Learning • Software • Financial Services
Chief of Staff serving as a strategic and operational partner to trading leadership. Coordinates cross-functional initiatives, manages milestones and stakeholders, supports budgeting, vendor oversight, staffing, strategic planning, communications, and process improvement. Performs daily PnL reconciliation checks and escalates discrepancies. The role requires strong analytical, financial, organizational, communication, and stakeholder-management skills, with an in-office presence in Chicago four days per week.
Cloud • Fintech • Software • Financial Services
Provide frontline support for YCharts' SaaS platform via email, chat, and phone. Troubleshoot product/data/technical issues, escalate as needed, monitor usage and customer health, share customer insights with product and engineering, create educational resources, and support process improvements to drive engagement and retention.
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
