Remote Data Engineer - ETL/Python Developer

Myticas Consulting Inc.; Springfield (IL); Remote; USD 77.000 - 91.000; Teilzeit

Zusammenfassung

Clover Consulting is seeking a Data Engineer - ETL/Python Developer for a 12+ month contract. This remote role may involve occasional travel to Illinois.

The candidate will design and maintain enterprise ETL pipelines, leverage ADF, Informatica, Python, Spark, and Snowflake to support Medicaid analytics and federal reporting. Responsibilities include building scalable data processing, writing SQL across multiple relational platforms, and ensuring data quality and security while collaborating

Qualifikationen

• 5+ years of data engineering focused on enterprise data warehousing.
• 5+ years of ETL development with Informatica PowerCenter, Teradata, Azure Data Factory, or similar.
• 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 frameworks (Databricks or equivalent).
• 3+ years of Snowflake using SnowSQL and Snowpark (Python).

Aufgaben

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

Kenntnisse

Data engineering

ETL development

Python programming

SQL proficiency

Analytical problem-solving

Team collaboration

Ausbildung

Bachelor's degree in CS/Engineering/Analytics

Tools

Azure Data Factory

Informatica PowerCenter

Spark / Databricks

Snowflake

Teradata

Azure DevOps

GitHub

CI/CD

Jobbeschreibung

Clover Consulting is seeking a Data Engineer - ETL/Python Developer for a 12+ month contract. This remote role may involve occasional travel to Illinois.

The candidate will design and maintain enterprise ETL pipelines, leverage ADF, Informatica, Python, Spark, and Snowflake to support Medicaid analytics and federal reporting. Responsibilities include building scalable data processing, writing SQL across multiple relational platforms, and ensuring data quality and security while collaborating