Lead Data engineer ETL + Cloud

Actively Reviewing the Applications

CG-VAK Software & Exports Ltd.

4–8 years

Posted 2 days ago • Apply by June 11, 2026

Job Description

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: etl,cloud,operations,analytics,data engineering,data