CSpring

Data Engineer

• Design and develop reusable, parameter-driven ingestion and transformation pipelines
• Build and maintain medallion architecture solutions
• Develop performant ELT workflows
• Create and optimize PySpark notebooks and distributed processing jobs
• Design dimensional data models
• Implement data vault patterns
• Optimize distributed SQL workloads
• Implement CI/CD processes
• Build monitoring, logging, and auditing solutions
• Lead or contribute to cloud modernization initiatives

Enterprise Data Warehouse ETL/Data Engineer

Pharmacist

• Review and process prescription prior authorization and appeal requests
• Organize and manage documents, verify profiles, and ensure accuracy for patient/member records
• Use decision trees and protocols to evaluate requests and provide approvals or rationales for denials
• Communicate decisions and updates to patients and providers, ensuring they feel supported
• Forward complex cases for additional review and follow up as needed
• Provide compassionate, timely support while staying organized and detail focused

Pharmacy Technician

Manager

• Serve as the primary regional point of contact for MIH agencies in your assigned region (North or South Indiana)
• Support onboarding, implementation, and expansion of MIH programs and initiatives
• Assist agencies with operational guidance, program development, and best practices
• Coordinate regional stakeholders, including healthcare and community partners
• Identify and escalate operational challenges, compliance concerns, and resource needs
• Support data reporting compliance in coordination with the MIH Data & Analytics Lead
• Provide regional updates, insights, and recommendations to the Section Chief
• Perform other duties and special projects as assigned by the Section Chief to advance MIH program goals and statewide initiatives

Mobile Integrated Health Manager

Program Manager

• Lead and support the rollout of Meds to Beds programs in rural hospitals across Indiana
• Build strong partnerships with hospital leaders and stakeholders to drive adoption and solve implementation challenges
• Monitor hospital work plans, grant deliverables, and contract requirements
• Develop relationships with vendors and external partners, including pharmacies, PBMs, PSAOs, couriers, and medical records providers
• Provide on-site technical assistance and serve as a liaison between hospitals, support partners, and IDOH leadership
• Work directly with hospital CEOs, pharmacy leaders, and organizations such as the Indiana Pharmacy Association
• Share best practices and successful program models across hospitals and health systems
• Develop reporting processes and help hospital staff track program outcomes
• Measure and report progress on key performance objectives and provide updates to IDOH leadership

Pharmacy Program Manager

Backend Engineer

• Be the hands-on technical lead for dashboard, reporting, and data engineering work within a large-scale Medicaid EDW and analytics program.
• Design, develop, and maintain enterprise-level dashboards and reports using Tableau and Python-based frameworks, ensuring they're performant, reusable, and built to last.
• Build and optimize scalable data processing pipelines using Python, supporting both ongoing analytics needs and federal reporting requirements.
• Write and tune SQL and stored procedures across relational platforms — primarily Teradata — with a focus on accuracy and efficiency at enterprise scale.
• Support Medicaid analytics and federal reporting initiatives including T-MSIS, PERM, MARS, and Quality of Care programs, working closely with SMEs and compliance teams.
• Participate in cloud migration and modernization work within Azure-based architectures, contributing to the shift from legacy systems toward modern platforms.
• Collaborate with analysts, QA teams, and BI reporting leads to validate data quality, resolve discrepancies, and ensure timely delivery of reporting deliverables.
• Support production operations — including incident response and root-cause analysis — and contribute to a stable, reliable analytics environment.
• Participate in code reviews, maintain source control hygiene, and work within CI/CD processes using Azure DevOps and GitHub.

Tableau, Python Developer

• You'll design and maintain the data infrastructure that powers enterprise analytics and federal reporting for some of the nation's most critical public health programs.
• Design, develop, and maintain enterprise ETL pipelines using Azure Data Factory (ADF), Informatica PowerCenter, and Python-based frameworks.
• Build and optimize scalable data processing solutions using Python, Spark, and Databricks.
• Support Medicaid analytics and federal reporting initiatives including T-MSIS, PERM, MARS, and Quality of Care programs.
• Develop robust data validation, reconciliation, and audit-traceable pipelines that hold up under regulatory scrutiny.
• Write and optimize SQL and stored procedures across relational platforms including Snowflake, Oracle, and SQL Server.
• Participate in cloud migration and modernization initiatives within Azure-based architectures, bridging legacy and modern platforms.
• Collaborate closely with analysts, QA engineers, and BI reporting teams to make sure data is accurate, timely, and trustworthy at every stage.
• Participate in code reviews, source control, and CI/CD processes using Azure DevOps and GitHub.

ETL Developer, Python

QA Engineer

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

QA Analyst, ETL Tester

Accountant

• As an Accountant on Indiana's Rural Health Transformation Program (RHTP), you'll be responsible for a variety of important and complex accounting functions.
• Understanding and applying federal grant accounting principles.
• Ensuring compliance with federal financial reporting requirements.
• Communicating with program managers about the status of federal funds.
• Assisting in developing and documenting procedures for Finance department.
• Prepare monthly appropriation reports for State funds, Department funds and Federal projects.
• Review monthly appropriation reports for accuracy and allowable expenses.
• Process journal entries for indirect costs, expense transfers and corrections.
• Reporting and reconciliation procedures for risk management, program support, and federal grant requirements.
• Ensure accurate chart fields for requisitions and purchase orders are entered.
• Fiscal Approval for requisitions and purchase orders for assigned State funds, Federal Funds, and departments.
• Reconcile and request purchase orders or purchase order lines associated with assigned Federal funds.
• Meet with Program Directors and Program Managers no less than quarterly or more frequently at the program areas request and/or need to review and validate assigned Federal funds.
• Engage in periodic, comprehensive reviews of financial data.

Analyst

• The Grant Analyst will lead oversight activities related to operational processes, financial stewardship, and data integrity for funded subrecipients of the Rural Health Transformation Program (RHTP) at the Indiana Department of Health (IDOH).
• This role is responsible for developing and implementing risk-based monitoring systems, conducting programmatic and fiscal compliance reviews, and strengthening subrecipient capacity to meet state and federal grant requirements.
• Working within the broader RHTP governance framework, you will ensure that each region's strategy is data-driven, compliant, and aligned with Indiana's long-term vision for rural health transformation.
• You will work closely with multiple state and contracted staff, internal agency partners, and external local, state, and national partners.
• Develop and implement risk-based subrecipient monitoring processes in accordance with state and federal grant requirements.
• Conduct desk reviews, on-site, and virtual monitoring of subrecipients to assess compliance with programmatic, fiscal, and reporting requirements.
• Identify compliance risks and develop corrective action plans in collaboration with subrecipients to promote grant stewardship and partnerships.
• Track corrective actions, follow-up actions, and resolution of findings to ensure timely remediation and sustain subrecipient compliance.
• Contribute to the development and continuous improvement of formal subrecipient monitoring tools, templates, and procedures.
• Analyze finance documentation including invoices, expenditure reports, ledgers, and supporting documentation to verify allowable expenses and anticipate barriers to fiscal stewardship.
• Act as a knowledgeable resource for finance and administration to Division Directors.
• Utilize PeopleSoft Financials to monitor and report sub-award spending throughout the fiscal year.
• Maintain and make accessible financial files.
• Analyze data submitted by subrecipients for accuracy, completeness, and alignment with program performance measures and reporting requirements.
• Maintain detailed monitoring records, reports, and audit trails to demonstrate grant administration activities, best practices, and audit readiness.
• Support internal staff and subrecipients in the preparation of state and federal audits by compiling documentation, responding to audit inquiries, and assisting with audit resolution activities.
• Provide technical assistance and guidance to subrecipients to strengthen grant management practices, documentation methods, and reporting processes.
• Coordinate with internal program, finance, and data staff to manage queries, barriers, or tasks related to subrecipient grant monitoring.

Grant Analyst

Operations

• You will support a high-impact Medicaid initiative for the State of Indiana, playing a key role in keeping the project running effectively.
• This role is ideal for someone early in their career who wants to build a strong foundation in project operations, financial tracking, and team coordination.
• You’ll work alongside experienced consultants and client stakeholders, gaining exposure to large-scale data and analytics work in the public sector.
• We’re looking for someone who is proactive, accountable, and eager to learn—someone who doesn’t just complete tasks but helps drive the work forward.
• Provide Jira administration and ongoing maintenance to support project execution
• Create, manage, and close out tasks to ensure work is tracked and delivered efficiently
• Monitor project budgets and proactively flag risks, trends, or inconsistencies
• Support invoice analysis and financial tracking activities
• Ensure accurate and timely time entry by coordinating with team members
• Follow up and communicate with consultants and stakeholders to keep workstreams on track
• Support overall project coordination and operational effectiveness
• Identify opportunities to improve processes and increase efficiency