Job ID: JOB_ID_8484
About the Role:
We are looking for a Senior Data Engineer with extensive experience in ETL, Python, and cloud-based data solutions. This role is critical for designing, developing, and maintaining enterprise ETL pipelines, building scalable data processing solutions, and supporting healthcare analytics initiatives. You will work with state-of-the-art technologies and collaborate with cross-functional teams to ensure data quality and accuracy.
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.
- 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 as Snowflake, 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.
Required Qualifications:
- Minimum 15+ years of overall experience required.
- 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).
- Bachelors degree or higher in Computer Science, Engineering, Analytics, or a related field.
- Strong analytical, problem-solving, and troubleshooting skills.
Preferred Qualifications:
- 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 (Power, Bash) for automation and orchestration.
- Experience designing or consuming APIs (REST) within data platforms.
- Familiarity with data quality frameworks, reconciliation, and audit support.
- Azure certifications related to data engineering or analytics.
Special Requirements
Remote, State Health care Experience Must
Compensation & Location
Salary: $130,000 – $180,000 per year (Estimated)
Location: Springfield, IL
Recruiter / Company – Contact Information
Recruiter / Employer: Datamaxis
Email: diyan@turhire.com
Recruiter Notice:
To remove this job posting, please send an email from
diyan@turhire.com with the subject:
DELETE_JOB_ID_8484