Home
Jobs
CloudIngest
Data Engineer (Pharmaceutical industry)

Data Engineer (Pharmaceutical industry)

On site

Indianapolis, United states

$ 48 /hour

Freelance

16-02-2026

Share this job:

Score my CV

Skills

Data Governance Monitoring Azure Data Factory Architecture power bi Azure AWS Analytics

Job Specifications

Job Title: Data Engineer

Location: Indianapolis, IN (Hybrid - 3 days a week from office)

Duration: 6-12 month contract with multiple extensions

Role Overview:

The Data Engineer will be responsible for designing, building, and maintaining data pipelines that extract data from source systems, transform it through the medallion architecture layers, and prepare it for consumption by the analytics layer. This role will work closely with the Power BI Developer to ensure data is properly structured, documented, and accessible for reporting and analytics.

Key Responsibilities:

Phase 1 Deliverables

Following EDB standard, design and establish AWS S3 bucket structure for data lake (Bronze/Silver/Gold zones) with Red CCI security controls
Build new data pipelines to extract data from the selected SaaS-based HSE systems
Enhance/extend data pipelines using the dataset from AWS EDB Asset related data products and digital solutions
MES selection to be finalized by the end of Jan 2027 - Build data ingestion pipeline for selected MES via REST API (Lambda-based extraction). If a different MES is chosen, change course accordingly
Data pipeline to SaaS based HSE tools to integrate data into the data warehouse
Implement CDC pipeline for LabVantage LIMS using AWS DMS from Oracle database (or Azure Data Factory)
Develop Bronze-to-Silver transformations using AWS Glue or Azure Data Factory depending on data domains
Configure AWS Glue Data Catalog with appropriate metadata and Red CCI classification tags

Phase 2 Deliverables

Connect to EDB marketplace for enterprise reference data
Build Silver-to-Gold transformations creating batch-centric data products
Implement data quality checks and monitoring dashboards
Develop orchestration workflows using AWS Step Functions
Support Power BI Developer in validating OneLake shortcut connectivity to Gold zone
Document data lineage, schema definitions, and pipeline architecture

Ongoing Responsibilities

Monitor pipeline health, troubleshoot failures, and optimize performance
Collaborate with Power BI Developer on data model requirements and data quality issues
Support data governance and security compliance reviews
Respond to ad-hoc data requests from engineers
Coordinate with enterprise EDB team on data sharing agreements and standards

About the Company

CloudIngest is a full-service tech software firm. Our expert technical team maintains strong core competencies in Big Data, Business Intelligence & Analytics, Cloud Services, Digital Transformations, Mobility Solutions, Natural Language Processing, APIs, Software Development & Integration, Staffing and Staff Augmentation, as well as Kubernetes, DevOps - Ansible and Terraform and Site Reliability Engineers, Azure HDInsights, DataFactory, ADLS Gen2, Azure Analytics Services, HDP ( Hortonworks Data Platform) , HDF ( NiFi) and S... Know more