Deputy Manager- IT

Piramal Pharma Limited; Mumbai; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

SnowPro Core Certification

AWS Certified Data Engineer Associate

AWS Certified Solutions Architect

Job summary

Piramal Pharma Limited is seeking a Deputy Manager- IT with hands-on expertise in AWS and Snowflake to design, build, and support scalable data pipelines and cloud-based data warehousing solutions.

The role involves extracting data from diverse sources, ensuring data quality, and aligning with business analysts and data scientists to meet reporting needs. Excellent collaboration and problem-solving skills are essential.

Qualifications

• Experience designing scalable data pipelines in cloud environments.
• Hands-on with Snowflake data warehousing and AWS services.
• Strong data modeling and quality assurance experience.

Responsibilities

• Design, develop, and maintain data pipelines using Snowflake and AWS services.
• Build and optimize ETL/ELT data ingestion frameworks from various sources.
• Develop data models, tables, views, and transformations in Snowflake.

Skills

Data integration

Snowflake

AWS

ETL/ELT

Data modeling

Tools

Snowflake

AWS

ETL tools

Job description

Deputy Manager- IT

We are looking for a skilled Data Engineer with hands‑on experience in AWS and Snowflake to design, develop, and support scalable data pipelines and cloud‑based data warehousing solutions. The ideal candidate should have experience working with structured and semi‑structured data, ETL/ELT processes, cloud services, and data integration frameworks.

Key Responsibilities

• Design, develop, and maintain data pipelines using Snowflake and AWS services.
• Build and optimize ETL/ELT data ingestion frameworks from various source systems.
• Develop data models, tables, views, and transformations within Snowflake.
• Perform data loading, transformation, and data quality validation activities.
• Integrate data from enterprise applications, databases, APIs, and cloud storage platforms.
• Monitor, troubleshoot, and optimize pipeline performance and Snowflake workloads.
• Implement data security, governance, and access controls in Snowflake.
• Work closely with business analysts, data scientists, and reporting teams to understand data requirements.
• Support production deployments, incident resolution, and performance tuning activities.
• Ensure adherence to coding standards, documentation, and best practices.

Key Competencies

• Strong analytical and problem‑solving skills.
• Ability to work independently and in a collaborative environment.
• Excellent communication and stakeholder management skills.
• Attention to detail and commitment to data quality.
• Ability to handle multiple priorities in a fast‑paced environment.

Nice‑to‑Have Certifications

• SnowPro Core Certification
• AWS Certified Data Engineer Associate
• AWS Certified Solutions Architect Associate