Description :

Key Responsibilities :

- Lead ETL development, operations, and production support

- Design and manage cloud-based data platforms (AWS / Azure / GCP)

- Build and optimize data warehouse solutions using Snowflake / Redshift

- Implement dimensional models including SCD Type 1/2/3

- Develop and orchestrate pipelines using SSIS, Matillion, SnapLogic, PySpark

- Ensure data quality, performance, scalability, and reliability

- Support downstream analytics and reporting (Tableau / Power BI)

- Lead small-to-medium teams, perform code reviews, and mentor engineers.

- Work closely with business and analytics stakeholders

- Drive root-cause analysis and problem resolution for data issues

Ideal Candidate :

- Must have 7+ years of experience in Data Engineering / ETL with at least 3+ years in pharma/life sciences domain

- Must have strong expertise in ETL tools (SSIS / Matillion / SnapLogic) and pipeline development

- Must have hands-on experience with cloud platforms (AWS / Azure / GCP)

- Must have experience working with data warehouses (Snowflake / Redshift)

- Must have strong knowledge of data warehousing concepts and dimensional modeling (SCD Type 1/2/3)

- Must have hands-on experience with PySpark for large-scale data processing

- Must have experience ensuring data quality, scalability, and performance of data pipelines

- Must have atleast 2+ years of experience leading teams, mentoring engineers, and owning end-to-end delivery

- Must have experience working with business or analytics stakeholders and solving data problems

- Health/pharma/life sciences companies or consulting/service firms with strong pharma analytics exposure

- Mandatory (Note 1) : Hybrid, WFH flexibility 6 days a month