Data Engineer - ETL Python Developer (36024)

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

Job summary

Clover Consulting is seeking a Data Engineer - ETL/Python Developer for a 12+ month contract, with remote work from anywhere in the U.S. and occasional travel to Illinois.

You will design and maintain enterprise ETL pipelines, build data solutions using Python, Spark, and Databricks, and ensure data quality across Snowflake, Oracle, and SQL Server. The role requires strong SQL skills, experience with Azure DevOps and CI/CD, and 5+ years in data warehousing.

Qualifications

• 5+ years of data engineering experience with enterprise data warehousing.
• 5+ years 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 Spark-based processing (Databricks or equivalent).
• Solid SQL expertise with Snowflake, Oracle, SQL Server, or similar relational DBs.
• 3+ years with Snowflake using SnowSQL and Snowpark (Python).
• Experience with source control and DevOps (Azure DevOps, GitHub, CI/CD).
• Strong analytical, problem-solving, and troubleshooting skills.
• Periodic travel may be required.

Responsibilities

• Design, develop, and maintain enterprise ETL pipelines using ADF, Informatica, and Python-based frameworks.
• Build and optimize data processing Solutions with Python, Spark, and Databricks.
• Write and optimize SQL across Snowflake, Oracle, and SQL Server.
• Support data quality, governance, and auditability; collaborate with analysts and QA.

Skills

Data engineering

ETL development

Python development

Analytical skills

Problem solving

Travel flexibility

Education

Bachelor's degree or higher in Computer Science / Engineering / Analytics

Tools

Azure Data Factory

Informatica PowerCenter

Teradata loader utilities

Databricks

Snowflake

SnowSQL

Snowpark (Python)

Azure DevOps

GitHub

CI/CD tooling

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.

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.