Senior Executive - IT

Piramal Critical Care, Inc.Mumbai, MaharashtraOn-siteFull-timeSenior, 5–8 yearsListed 4 hours ago

Apply now

About this role

Be the First to Apply

Division
Piramal Critical Care
Piramal Critical Care (PCC), a business unit of Piramal Pharma, is the fourth-largest producer of inhaled anesthetics and a global player in hospital generics. We are motivated by our vision of commitment to delivering critical care solutions for patients and healthcare providers across the globe while achieving sustainable and profitable growth for all the stakeholders.

PCC maintains a wide presence across the US, Europe, and more than 100 countries across the globe. Its rich product portfolio includes Inhalation Anesthetics such as Sevoflurane, Isoflurane and Halothane as well as Intrathecal Baclofen therapy, for spasticity management.

PCC has a strong manufacturing and process development experience with wholly-owned, state-of-the-art manufacturing facilities in the United States and India, inspected periodically by the US FDA and the UK MHRA and other regulators. The strategic locations of our facilities help us supply high-quality products around the world, timely at optimal costs.

For more details, please visit https://www.piramalcriticalcare.com/global/

Job Title
Senior Executive - IT
Job Description
We are looking for a hands-on AWS & Snowflake Data Engineer to develop, maintain and support data pipelines integrating multiple enterprise business applications into our Enterprise Data Platform (EDP). The role involves cloud data migration, data integration, reporting support, data quality, production troubleshooting and continuous improvement of enterprise data processes.
We are looking for someone with strong logical thinking, practical problem-solving abilities, a proactive mindset and the willingness to take ownership, challenge existing approaches and contribute beyond assigned responsibilities.
Key Responsibilities

- Develop and maintain data ingestion and transformation pipelines using AWS, Snowflake, Python and SQL

- Integrate data from enterprise business applications and platforms, including SAP S/4HANA and MDM

- Build and manage data integration workflows using AWS S3, Glue, Lambda and AppFlow

- Use Apache Airflow for pipeline orchestration, scheduling and monitoring

- Support migration of data pipelines and datasets from Azure Data Lake to the AWS-based Enterprise Data Platform

- Perform data validation, source-to-target reconciliation and data quality checks

- Support Qlik Sense and Power BI reporting by investigating backend data issues, refresh failures, missing records and data discrepancies

- Work with the BI/reporting team to troubleshoot SQL queries, data models, transformations and reporting datasets

- Monitor production pipelines, troubleshoot failures, perform root-cause analysis and support incident resolution

- Optimize SQL queries, Python scripts and data processing jobs

- Support deployments across Development, QA, UAT and Production environments

- Maintain technical documentation, data flow diagrams and operational runbooks

Key Competencies

- Technical: Strong SQL and Python; AWS (S3, Glue, Lambda, AppFlow); Snowflake; Apache Airflow; Git/GitHub and deployment processes

- Cloud & Security: Basic understanding of AWS IAM, Secrets Manager, networking and cloud security practices

- Digital & AI Skills:

- Basic knowledge of AI, Machine Learning and Generative AI concepts, including LLMs, prompt engineering and RAG

- Hands-on use of AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, Claude) for coding, debugging and documentation

- Interest in AI-driven automation of data pipelines, data quality checks and operational monitoring

- Data literacy and a digital-first approach to process improvement

- Analytical & Problem-Solving: Strong logical reasoning; able to break complex problems into practical solutions; skilled at root-cause analysis

- Ownership & Initiative: Works independently, drives issues to resolution, challenges existing processes and suggests improvements

- Business Understanding: Turns business requirements into effective technical solutions

- Communication & Collaboration: Good communication, teamwork and stakeholder management skills

- Learning Agility: Curious about new technologies and willing to go the extra mile.

Essential Qualification

- B.E./B.Tech/MCA/B.Sc (IT/Computer Science) or an equivalent degree in a related field

- AWS or Snowflake certification preferred

Relevant Experience

- 2–4 years in Data Engineering or Cloud Data Engineering

- Hands-on with AWS services: S3, Glue, Lambda and AppFlow

- Working knowledge of Snowflake: data loading, stages, warehouses and SQL transformations

- Experience with Apache Airflow, DAGs and ETL/ELT pipelines

- Exposure to Azure Data Lake, cloud migration and enterprise applications (SAP, ERP, MDM) preferred

- Experience supporting Qlik Sense or Power BI reporting layers is an advantage

AI Skills:

- Basic knowledge of AI, Machine Learning and Generative AI concepts, including LLMs, prompt engineering and RAG

- Hands-on use of AI-assisted development tools (e.g., GitHub Copilot, ChatGPT, Claude) for coding, debugging and documentation

- Interest in AI-driven automation of data pipelines, data quality checks and operational monitoring