Data Engineer - ETL/ELT Pipelines & API Integrations

Oorwin AI; Indianapolis (IN); On-site; USD 100,000 - 150,000; Part time

Job summary

Oorwin AI in Indianapolis, IN is hiring a Data Engineer with ETL/ELT pipelines and API integrations on a contractual basis. The role focuses on building data pipelines, API integrations, and AI infrastructure for a governed, Azure-based platform that ingests structured and unstructured data from multiple sources.

The engineer will implement data quality, lineage, and audit trails to support regulatory reporting, analytics, and AI-driven insights in a compliant environment.

Qualifications

• 8+ years of hands-on Data Engineering experience delivering production ETL/ELT pipelines and API integrations.
• Expert-level Python and/or PySpark for data ingestion, transformation, orchestration, testing, and CI/CD.
• Experience with Microsoft Azure Fabric (Lakehouse, Data Factory, Fabric Pipelines, Delta Lake) delivering end-to-end production solutions.
• Hands-on AWS experience, including S3, Glue (or equivalent), and RDS/Aurora.
• Strong SQL and PostgreSQL experience, including normalized schema design, query optimization, indexing, and performance tuning.
• Experience with data modeling, medallion architecture, and Lakehouse design patterns.
• Experience implementing data lineage, quality controls, schema validation, error handling, and monitoring in regulated environments.
• Knowledge of GxP, GMP, GCP within pharmaceutical, biotechnology, or medical device environments
• SCM, WMS, PLM, MM, QA, any validated applications within FDA Regulated systems

Responsibilities

• Design, build, and maintain production ETL/ELT pipelines integrating laboratory and operational systems into Azure Fabric Lakehouse and PostgreSQL.
• Develop and optimize bronze/silver/gold medallion architecture with schema mapping and data modeling.
• Build scalable API integrations and cross-cloud data pipelines across Azure and AWS.
• Implement automated data quality controls, normalization, schema validation, data lineage, and audit trails for compliance.
• Monitor, troubleshoot, and optimize pipeline performance and reliability in production.
• Collaborate with business, engineering, and IT to create a governed digital thread for analytics and regulatory reporting.

Skills

Python/PySpark

ETL/ELT pipelines

API integrations

SQL/PostgreSQL

Azure Fabric

Azure Data Factory

AWS S3/Glue

Data modeling

Data lineage/QA

GxP/GMP

Tools

Azure Fabric Lakehouse

Azure services

PostgreSQL tuning

Job description

Oorwin AI in Indianapolis, IN is hiring a Data Engineer with ETL/ELT pipelines and API integrations on a contractual basis. The role focuses on building data pipelines, API integrations, and AI infrastructure for a governed, Azure-based platform that ingests structured and unstructured data from multiple sources.

The engineer will implement data quality, lineage, and audit trails to support regulatory reporting, analytics, and AI-driven insights in a compliant environment.