Data Engineer - ETL Python Developer (36024)

Myticas Consulting Inc.; Illinois; Remote; USD 77,000 - 91,000; Full time

Job summary

Clover Consulting has a direct client in Springfield, IL seeking a Data Engineer - ETL/Python Developer for a 12+ months contract. Remote work with occasional travel to Illinois possible.

The role focuses on designing ETL pipelines, Python-based processing, and SQL across Snowflake, Oracle, and SQL Server, with cloud migration and DevOps collaboration.

Qualifications

• 5+ years enterprise data warehousing and data engineering experience.
• 5+ years ETL development with PowerCenter, Teradata, ADF or similar.
• 5+ years Python development for data engineering and automation.
• 3+ years Spark-based processing with Databricks or equivalent.
• Solid SQL expertise with Snowflake, Oracle, SQL Server.
• Experience with Snowflake SnowSQL/Snowpark (Python) a plus.
• Experience with source control and CI/CD pipelines.

Responsibilities

• Design, build, and maintain enterprise ETL pipelines (ADF, PowerCenter, Python).
• Develop scalable data processing using Python, Spark, Databricks.
• Write and optimize SQL across Snowflake, Oracle, SQL Server.
• Support Medicaid analytics, federal reporting and data quality.
• Contribute to cloud migration and production operations, CI/CD.

Skills

Data engineering

ETL development

Python

SQL

Analytical problem-solving

Cloud data platforms

Education

Bachelor’s degree in CS/Engineering/Analytics

Tools

Azure Data Factory

Informatica PowerCenter

Teradata

Snowflake

Spark/Databricks

Python frameworks

CI/CD tools (Azure DevOps, GitHub)

Job description

Clover Consulting has a direct client in Springfield, IL in need of an Data Engineer - ETL/Python Developer for a 12+ months contract. Job details are below. Thank you!

Role:

Data Engineer - ETL/Python Developer

Location:

Remote - occasional travel to Illinois possible

Term:

12+ months contract, extensions possible

Rate:

$56 W2 - $66 C2C

Primary Responsibilities

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

Analytics, Reporting & Data Quality

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

Modernization, Operations & Collaboration

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

Required Qualifications

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

Location & Work Model

• Work Arrangement: Remote from anywhere within the U.S.
• Travel: Periodic travel may be required based on project or customer needs.