We are looking for a Manager/Lead Data Engineering & ETL Operations to drive enterprise-scale data integration and analytics solutions. The role requires strong hands-on expertise in ETL, cloud platforms, and data warehousing, along with the ability to lead teams, manage delivery, and solve complex data problems.

This is a hands-on leadership role, ideal for professionals transitioning from Senior Engineer to Manager.

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 :

- Strong Data Engineering (ETL + Cloud) Leadership Profile

Mandatory (Experience) : Must have 7+ years of experience in Data Engineering / ETL with at least 3+ years in pharma/life sciences domain

Mandatory (Skill 1) : Must have strong expertise in ETL tools (SSIS / Matillion / SnapLogic) and pipeline development

Mandatory (Skill 2) : Must have hands-on experience with cloud platforms (AWS / Azure / GCP)

Mandatory (Skill 3) : Must have experience working with data warehouses (Snowflake / Redshift)

Mandatory (Skill 4) : Must have strong knowledge of data warehousing concepts and dimensional modeling (SCD Type 1/2/3)

Mandatory (Skill 5) : Must have hands-on experience with PySpark for large-scale data processing

Mandatory (Skill 6) : Must have experience ensuring data quality, scalability, and performance of data pipelines

Mandatory (Leadership) : Must have atleast 2+ years of experience leading teams, mentoring engineers, and owning end-to-end delivery

Mandatory (Stakeholder Mgmt) : Must have experience working with business or analytics stakeholders and solving data problems

Mandatory (Company) : Health/pharma/life sciences companies or consulting/service firms (Accenture, Deloitte, etc.) with strong pharma analytics exposure

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

Mandatory (Note 2) : CTC is inclusive of 10% variable

Mandatory (Note 3) : This has an equal mix of IC and leadership responsibilities

Preferred (Tools) : Experience with Tableau / Power BI and production support / data operations