Data Engineering (ETL + Cloud)-Pharma

Role & Responsibilities

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
  
  

Skills: data,etl,data engineering,leadership