
Senior ETL, Python Developer
DATAMAXIS, Inc
contract
Posted on:
Location Type: Remote
Location: Illinois • United States
Visit company websiteExplore more
Job Level
About the role
- 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 (e.g., T-MSIS, PERM, MARS, Quality of Care)
- Develop robust data validation, reconciliation, and audit-traceable data pipelines
- Write and optimize SQL and stored procedures across relational platforms such asSnowflake, Oracle, and SQL Server
- Participate in cloud migration and modernization initiatives within Azure-based architectures
- Collaborate with analysts, QA, and reporting teams to ensure data quality, accuracy, and timeliness
- Follow data engineering best practices for performance, reliability, reusability, and security
- 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, Azure Data Factory, or similar 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 experience with relational databases (such as Teradata,Snowflake, Oracle, SQL Server)
- Experience with source control and DevOps practices (Azure DevOps, GitHub, CI/CD)
- Bachelor’s degree or higher in Computer Science, Engineering, Analytics, or a related field
- Strong analytical, problem-solving, and troubleshooting skills
- Experience supporting State Medicaid EDW or MMIS analytics environments (preferred)
- Healthcare or public-sector analytics experience (Medicaid / Medicare preferred) (preferred)
- Data modeling experience in enterprise data warehouse environments (preferred)
- Scripting experience (PowerShell, Bash) for automation and orchestration (preferred)
- Experience designing or consuming APIs (REST) within data platforms (preferred)
- Familiarity with data quality frameworks, reconciliation, and audit support (preferred)
- Azure certifications related to data engineering or analytics (preferred)
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETL developmentPythonSQLSparkData validationData reconciliationData pipelinesData modelingScriptingAPI design
Soft Skills
analytical skillsproblem-solvingtroubleshootingcollaborationcommunication
Certifications
Azure certifications