CSpring

QA Engineer

• Design, automate, and execute test cases for Enterprise Data Warehouse (EDW) ETL processes in a State Government Medicaid environment
• Ensure the accuracy, integrity, and reliability of data throughout ETL processes
• Design and execute test strategies validating functional and non-functional data pipeline requirements
• Use Informatica PowerCenter and Teradata RDBMS for ETL and core data store validation
• Work within Azure DevOps and Agile sprint cycles to ensure data quality, identify defects, and automate repeatable testing
• Review Change Requests and participate in requirements analysis for new EDW extracts and transformations
• Participate in data modeling and requirements gathering sessions
• Perform backend testing comparing source systems with target Medicaid Enterprise Data Warehouses
• Verify source-to-target data mappings and transformation logic for Medicaid datasets
• Validate data quality, standardization rules, and loading accuracy
• Write complex SQL queries with multi-table JOINs and aggregations
• Conduct row counts, null checks, duplicate checks, and referential integrity validation
• Design test plans, test cases, and test scenarios for ETL processes
• Document test results and provide detailed stakeholder feedback
• Execute manual and automated tests for full-load and incremental-load cycles
• 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, SQL Alchemy, and Pandas
• Create shell scripts for ETL monitoring and log analysis
• Integrate automation into Azure DevOps CI/CD pipelines

QA Analyst / ETL Tester

Customer Support

• Support the Medicaid Customer Service Team
• Deliver advanced inbound customer service to Indiana Medicaid members and providers
• Address inquiries about pharmacy coverage, claims, and medication pricing
• Help members and providers navigate their healthcare and pharmacy-related needs
• Work overtime as needed

Healthcare Customer Service Agent

General

• Serve as an operational link between IDOH and regional partners
• Support organizations receiving Rural Health Transformation Program funding with grant and contract requirements
• Monitor state and federal compliance, allowable expenditures, budgets, documentation, milestones, deliverables, and timelines
• Maintain audit-ready grant documentation and support consistent use of approved templates, tools, reporting systems, and grants-management practices
• Identify performance risks, compliance concerns, budget issues, and implementation barriers, escalating issues to IDOH when appropriate
• Collaborate with statewide Technical Assistance Providers—IHA, IPHCA, and IRHA—to support regional coalitions
• Participate in regional consortium meetings, workgroups, and planning sessions
• Convene Regional Committee meetings
• Coordinate regional data collection, performance tracking, outcome measurement, and reporting aligned with CMS Rural Health Transformation Program requirements
• Help partners understand CMS documentation, metric, narrative, and reporting expectations
• Support corrective action planning when progress falls behind expectations
• Serve as day-to-day liaison among IDOH, regional coalitions, healthcare providers, community organizations, and other partners
• Help partners interpret state guidance, solve implementation challenges, share effective practices, and use consistent statewide tools and evaluation approaches

QA Analyst / ETL Tester

Healthcare Customer Service Agent

Grant Coordinator