Design, develop, and maintain enterprise ETL pipelines and scalable data processing using ADF, Informatica, Python, Spark/Databricks, and relational systems. Support Medicaid analytics, data validation, cloud migrations, production operations, and CI/CD practices.
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.
Why You’ll Love Working 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.
What You’ll Do
- 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.
- Write and optimize SQL and stored procedures across relational platforms such as Snowflake, Oracle, and SQL Server.
- Follow data engineering best practices for performance, reliability, reusability, and security.
- Support Medicaid analytics and federal reporting initiatives (e.g., T-MSIS, PERM, MARS, Quality of Care).
- Develop robust data validation, reconciliation, and audit-traceable data pipelines.
- Collaborate with analysts, QA, and reporting teams to ensure data quality, accuracy, and timeliness.
- Participate in cloud migration and modernization initiatives within Azure-based architectures.
- Support production operations, incident resolution, and root cause analysis.
- Participate in code reviews, source control, and CI/CD processes using Azure DevOps and GitHub.
Requirements
- 5+ years of data engineering experience with a focus on enterprise data warehousing.
- 5+ years of hands-on ETL development using Informatica PowerCenter, Teradata, Azure Data Factory, or similar tools.
- 5+ years of Python development for data engineering and automation.
- 5+ years of Teradata experience, including Teradata loader utilities.
- 3+ years of experience with Spark-based processing frameworks (Databricks or equivalent).
- Solid SQL expertise and experience with relational databases (such as Snowflake, Oracle, SQL Server).
- 3+ years of experience with Snowflake using SnowSQL and Snowpark (Python).
- Experience with source control and DevOps practices (Azure DevOps, GitHub, CI/CD).
- Proven solid analytical, problem-solving, and troubleshooting skills.
- Periodic travel may be required based on project or customer needs.
Preferred Qualifications
- Bachelor’s degree or higher in Computer Science, Engineering, Analytics, or a related field.
- Azure certifications related to data engineering or analytics.
- 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 (PowerShell, Bash) for automation and orchestration.
- Experience designing or consuming APIs (REST) within data platforms.
- Familiarity with data quality frameworks, reconciliation, and audit support.
Come Build With Us
At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment—apply today!
Similar Jobs
Machine Learning • Payments • Security • Software • Financial Services
Leads a team providing advanced Tier 4/L3 support for enterprise applications. Responsibilities include resolving complex production issues, performing root-cause analysis, guiding software development and architecture, mentoring engineers, improving reliability and observability, designing automation, managing incidents, and partnering with development, infrastructure, security, and cloud teams across Microsoft and Azure environments.
Top Skills:
.NetAPIsCi/CdCloud-Native ApplicationsDatabasesDistributed SystemsIisAzureMonitoring ToolsObservability ToolsWindows Server
Fintech • Information Technology • Payments • Sharing Economy • Financial Services • Cryptocurrency
Supports go-to-market launches for FedNow product features by coordinating Product, Marketing, Sales, and Operations. Develops customer-focused messaging, launch plans, educational resources, webinars, training, and industry presentations. Tracks deadlines, researches customer personas and competitors, improves business-development processes, and ensures internal stakeholder readiness and consistent customer communications.
Top Skills:
Check ServicesFedachFedcashFedlineFednowFedwireNational Settlement Service
.png){kind=logo}
AdTech • eCommerce • Information Technology • Software • Travel • Generative AI
Lead the architecture and delivery of Salesforce Marketing Cloud and Data Cloud solutions for partner marketing. Design data models, knowledge graphs, identity resolution, batch and streaming pipelines, APIs, zero-copy integrations, and AI-enabled workflows. Establish orchestration, monitoring, CI/CD, governance, and reliability standards while mentoring engineers and partnering with marketing, data science, and Salesforce stakeholders.
Top Skills:
Amazon BedrockAmazon DynamodbAmazon Ec2Amazon NeptuneAmazon RedshiftAmazon S3Amazon SqsAmpscriptApache AirflowApache KafkaSparkAutomation StudioAWSAws AppflowAws GlueAws LambdaCi/CdContact BuilderContent BuilderCypherData DesignerData ExtensionsData Lake ObjectsData Model ObjectsDbtGenerative AiGitGremlinJavaJourney BuilderLlmsMarketoMessage GearsNeo4JPythonRagRest ApisSalesforce Data 360Salesforce Data CloudSalesforce Marketing CloudScalaSoapSparqlSQLSsjsVector StoresZero Copy
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
