Description

You will design and manage end-to-end ETL pipelines using AWS Glue following Lakehouse and Medallion architecture.

This role is hybrid.

Responsibilities

• Build and maintain a Data Lake on AWS, integrating data from various sources with Snowflake as the analytical warehouse.
• Lead data modeling and transformations for commercial life sciences datasets including Sales, CRM, HCP/HCO, Address, and Affiliation.
• Define integration architecture and data mappings with Reltio MDM, including mastering rules and ID propagation.
• Drive data standardization, enrichment, and quality controls to support trusted analytics.
• Design curated Gold-layer datasets and KPIs to power dashboards and business reporting.

Required Skills

• 15+ years of professional experience in data engineering.
• Expertise in ETL processes and data architecture design.
• Proficiency with AWS services, particularly AWS Glue.
• Strong knowledge of Snowflake for analytical warehousing.
• Understanding of Data Governance principles.
• Experience modeling commercial life sciences data.

Preferred Skills

• Experience with Lakehouse and Medallion (Bronze/Silver/Gold) architecture patterns.
• Familiarity with Reltio MDM integration.

Key Skills

Education

Any Gradute