ETL / Python Developer

CSpring • Springfield, IL

19h

About The Position

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.

The work matters beyond the warehouse. The pipelines you build support Medicaid programs and federal reporting that affect millions of people. At CSpring, that connection between craft and mission is something the whole team takes seriously.
You'll be surrounded by people who care. The culture here is warm, collaborative, and grounded — people ask good questions, share what they know, and hold each other to a high standard.
You'll work across a modern stack. This role spans Azure Data Factory, Databricks, Snowflake, Informatica, and Python-based frameworks — and you'll have the autonomy to build things the right way, not just the fast way.
Your work is visible and your voice is heard. You'll work alongside architects, analysts, and program leads who want your input, not just your output.

Requirements

• 5+ years of data engineering experience with a focus on enterprise data warehousing
• 5+ years of hands-on ETL development using Informatica PowerCenter, Azure Data Factory, or comparable tools
• 5+ years of Python development for data engineering and automation
• 3+ years of experience with Spark-based processing frameworks (Databricks or equivalent)
• Strong SQL expertise and hands-on experience with relational databases including Snowflake, Oracle, or SQL Server
• Experience with source control and DevOps practices (Azure DevOps, GitHub, CI/CD pipelines)
• Bachelor's degree or higher in Computer Science, Engineering, Analytics, or a related field

Nice To Haves

• Experience supporting State Medicaid EDW or MMIS analytics environments
• Healthcare or public-sector analytics experience (Medicaid / Medicare preferred)
• Data modeling experience in enterprise data warehouse environments
• Scripting experience with PowerShell or Bash for automation and orchestration
• Experience designing or consuming REST APIs within data platforms
• Familiarity with data quality frameworks, reconciliation, and audit support
• Azure certifications in data engineering or analytics

Responsibilities

• 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
• Follow data engineering best practices for performance, reliability, reusability, and security — not just functionality
• Support production operations, incident resolution, and root-cause analysis when issues arise
• Participate in code reviews, source control, and CI/CD processes using Azure DevOps and GitHub

Benefits

• The work matters beyond the warehouse. The pipelines you build support Medicaid programs and federal reporting that affect millions of people.
• The culture here is warm, collaborative, and grounded — people ask good questions, share what they know, and hold each other to a high standard.
• You'll work across a modern stack. This role spans Azure Data Factory, Databricks, Snowflake, Informatica, and Python-based frameworks — and you'll have the autonomy to build things the right way, not just the fast way.
• Your work is visible and your voice is heard. You'll work alongside architects, analysts, and program leads who want your input, not just your output.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior