Duration:
12 months + (Strong potential for extension)
Job
Description:
We are
looking for a Sr.
Data Engineer with at least 7+ years of experience. This resource must have
Teradata, Python, Spark, Snowflake, SQL.
*This
resource must have strong Medicaid experience specifically direct State
Medicaid experience either working directly for a State Health department or
through a direct integrator such as Optum, Deloitte, Accenture, KPMG, Gainwell,
PCG, Cognizant, Conduent, BCBS, etc.
**We are not looking for someone who only has
healthcare Provider side Medicaid experience.
Top Desired Skills:
• 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).
• Experience supporting State Medicaid EDW or MMIS analytics environments.
Senior Data Engineer (ETL / Python)
Job Summary:
This Senior Data Engineer role focuses on designing,
developing, and maintaining scalable data ingestion and transformation
pipelines that power an Enterprise Data Warehouse and analytics program for
Medicaid and federal reporting. You will work extensively with ETL tools,
Python, and modern cloud technologies to support large, complex healthcare
datasets in a regulated, audit-sensitive environment. The position is highly
delivery-focused and requires close collaboration with architects, analysts,
QA, project managers, subject matter experts, developers, and BI/reporting
teams across both legacy and cloud-based platforms.
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 to
support high-volume healthcare data workloads.
Write and optimize SQL
queries and stored procedures across relational platforms such as
Teradata, Oracle, and SQL Server.
Apply data engineering
best practices to ensure performance, reliability, reusability, and
security of data pipelines and solutions.
Support Medicaid
analytics and federal reporting initiatives, including T-MSIS, PERM, MARS,
and Quality of Care reporting.
Develop robust data
validation, reconciliation, and audit-traceable data pipelines to meet
regulatory and compliance requirements.
Collaborate closely with
analysts, QA, and reporting/BI teams to ensure data quality, accuracy, and
timeliness for downstream analytics and reporting.
Participate in cloud
migration and modernization initiatives within Azure-based architectures,
including transitioning legacy workloads to modern platforms.
Support production
operations by monitoring pipelines, resolving incidents, and performing
root cause analysis for data and system issues.
Participate in code
reviews and contribute to maintaining high-quality, well-documented code
across data engineering solutions.
Use source control and
CI/CD processes with Azure DevOps and GitHub to manage deployments and
promote automation in the delivery lifecycle.
Coordinate with
architecture, BI, QA, and business teams to align data engineering solutions
with enterprise standards and project objectives.
Contribute to continuous
improvement of data quality frameworks, reconciliation processes, and
audit support across the data platform.
Essential Skills:
7+ years of data
engineering experience with a focus on enterprise data warehousing.
5+ years of hands-on ETL
development using tools such as Informatica PowerCenter, Teradata, Azure
Data Factory, or similar platforms.
5+ years of Python
development experience focused on data engineering, automation, and
orchestration.
5+ years of Teradata
experience, including use of Teradata loader utilities for large-scale
data ingestion.
3+ years of experience
with Spark-based processing frameworks, such as Databricks or equivalent
technologies.
Strong SQL expertise and
experience working with relational databases including Teradata, Oracle,
and SQL Server.
3+ years of experience
with Snowflake using SnowSQL and Snowpark (Python) for data engineering
and analytics workloads.
Experience supporting
State Medicaid Enterprise Data Warehouse (EDW) or MMIS analytics
environments.
Experience designing or
consuming REST APIs within data platforms for integration and data
exchange.
Scripting experience
with PowerShell and Bash for automation and orchestration of data
workflows.
Familiarity with data
quality frameworks, reconciliation processes, and audit support in
regulated environments.
Experience with source
control and DevOps practices using Azure DevOps, GitHub, and CI/CD
pipelines.
Additional Skills and Qualifications
Azure certifications
related to data engineering or analytics.
Healthcare or public
sector analytics experience, with Medicaid or Medicare strongly preferred.
Data modeling experience
in enterprise data warehouse environments, including support for complex
healthcare data structures.
Experience with MMIS,
T-MSIS, MARS, PERM, and healthcare analytics reporting domains.
Background in quality of
care reporting and related healthcare performance metrics.
Experience with
Snowflake-based data platforms and modern cloud data architectures.
Exposure to
enterprise-scale modernization initiatives involving both modern cloud and
legacy data platforms.
Ability to operate
effectively in regulated, audit-sensitive environments with a strong focus
on compliance and data governance.
Strong collaboration
skills and experience working within cross-functional delivery teams,
including architecture, BI, QA, and business stakeholders.
Work Environment
This role is 100% remote, supporting enterprise healthcare
analytics delivery teams focused on Medicaid and federal reporting initiatives.
You will work across modern cloud and legacy data platforms, including
Azure-based architectures, Teradata, Snowflake, Databricks, and a range of ETL
and automation tools. The environment emphasizes collaboration across
architecture, BI, QA, and business teams, with frequent interaction through
virtual meetings and shared DevOps tooling such as Azure DevOps and GitHub.
Periodic travel may be required based on project needs, and you will operate
within a structured, regulated setting that prioritizes data quality,
auditability, and reliable production operations.
Thanks,
Information
Locations Position Open to RemoteIndustry Information TechnologyStatus OpenJob Age 17 Day'sCreated Date 10/21/2026No.of Positions 1Duration 12 months +Zip Code
