Data Engineer - Healthcare Domain

Orcapod Consulting Services; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Orcapod Consulting Services is seeking a Data Engineer to design, develop, and maintain scalable data pipelines in the healthcare domain. The role emphasizes Python, Apache Airflow, and Amazon Redshift to deliver robust data warehouse solutions.

You will work with stakeholders to translate data requirements, ensure data quality and governance, and optimize performance across enterprise platforms. Experience in Healthcare or Life Sciences is preferred.

Qualifications

• Experience designing scalable data pipelines with Python and Airflow.
• Strong SQL and data modeling skills for data warehouses.
• Experience with healthcare/pharma data domains is preferred.
• Experience with AWS data services and Redshift.
• Ability to collaborate with stakeholders and ensure data quality.

Responsibilities

• Design and develop scalable data pipelines using Python and Airflow.
• Build and optimize data warehouses in Amazon Redshift.
• Develop ETL/ELT processes for large-scale data processing.
• Collaborate with analytics and reporting teams to deliver data solutions.
• Ensure data governance and data quality across platforms.
• Integrate data from multiple sources into enterprise platforms.
• Performance tune data pipelines.

Skills

Python

Apache Airflow

Amazon Redshift

Advanced SQL

ETL/ELT Pipeline Development

Data Warehousing Concepts

AWS Cloud Services

Data Modeling

Data Integration

Tools

AWS Glue

AWS Lambda

Amazon S3

PySpark

Snowflake

Job description

Data Engineer - Healthcare Domain

We are looking for a passionate Data Engineer with strong experience in Python, Apache Airflow, and Amazon Redshift to design, develop, and maintain scalable data pipelines and data warehouse solutions. The ideal candidate should have prior experience working in the Healthcare, Pharma, Life Sciences, or Clinical Data domain.

Mandatory Skills

• Python (Strong hands-on experience)
• Apache Airflow
• Amazon Redshift
• Advanced SQL
• ETL/ELT Pipeline Development
• Data Warehousing Concepts
• AWS Cloud Services
• Data Modeling
• Data Integration

Domain Requirements

Candidates must have experience in at least one of the following:

• Healthcare
• Pharmaceutical

Responsibilities

• Design and develop scalable data pipelines using Python and Airflow.
• Build and optimize data warehouses in Amazon Redshift.
• Develop ETL/ELT processes for large-scale data processing.
• Work with business stakeholders to understand data requirements.
• Ensure data quality, governance, and integrity across platforms.
• Integrate data from multiple sources into enterprise data platforms.
• Perform performance tuning and optimization of data pipelines.
• Collaborate with analytics and reporting teams to deliver data solutions.

Preferred Skills

• AWS Glue
• AWS Lambda
• Amazon S3
• PySpark
• Snowflake