Job Description

Role Overview
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
Requirements
Must-Have
Strong hands-on experience in ETL & Data Engineering
Expertise in:
Snowflake / Redshift
SSIS, Matillion, SnapLogic
PySpark
Solid understanding of Data Warehousing & SCD dimensions
Experience with AWS / Azure / GCP
Strong problem-solving and analytical skills
Team leadership and delivery ownership experience
Good-to-Have
Pharma / Life Sciences domain exposure
Tableau and/or Power BI experience
Experience with production support & data ops

Skills Required