Description

You will design and manage end-to-end ETL pipelines using AWS Glue following Lakehouse and Medallion (Bronze/Silver/Gold) architecture.

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 (Sales, CRM, HCP/HCO, Address, 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.
• Expertise in ETL processes.
• Proficiency with AWS services, particularly AWS Glue.
• Experience designing and managing data architectures.
• Strong knowledge of Snowflake for analytical warehousing.
• Understanding of Data Governance principles.
• Experience modeling commercial life sciences data.

Key Skills

Education

Any Gradute