Manager Data Engineering

Zoetis; Hyderabad; On-site; INR 1,400,000 - 2,100,000; Full time

Job summary

Zoetis India Capability Center (ZICC) in Hyderabad seeks a seasoned Data Engineer to design and develop robust data solutions using Azure Data Factory and Data Bricks. You will lead ETL/ELT pipelines, integrate diverse data sources, and optimize data processing for performance and cost-efficiency.

You will mentor a team, collaborate with security and infrastructure teams, and contribute to transformative, analytics-driven initiatives across Zoetis global ERP platforms.

Responsibilities

• Design and build data solutions using Azure Data Factory and Data Bricks.
• Develop and maintain ETL/ELT pipelines and data transformations.
• Mentor and lead team members, ensuring high-quality deliverables.
• Collaborate with cross-functional teams including security and infrastructure.

Job description

Zoetis, Inc. is the world's largest producer of medicine and vaccinations for pets and livestock. The Zoetis Tech & Digital (ZTD) Global ERP organization is as a key building block of ZTD comprising of enterprise applications and systems platforms. Join us at Zoetis India Capability Center (ZICC) in Hyderabad, where innovation meets excellence. As part of the world's leading animal healthcare company, ZICC is at the forefront of driving transformative advancements and applying technology to solve the most complex problems. Our mission is to ensure sustainable growth and maintain a competitive edge for Zoetis globally by leveraging the exceptional talent in India. At ZICC, you'll be part of a dynamic team that partners with colleagues worldwide, embodying the true spirit of One Zoetis. Together, we ensure seamless integration and collaboration, fostering an environment where your contributions can make a real impact. Be a part of our journey to pioneer innovation and drive the future of animal healthcare.

Responsibilities

• Techno Functional Management: Manage and oversee technical and functional aspects of projects.
• Hands on experience in Azure Data Factory & Data Bricks.
• Provide hands-on experience in Python and back-end programming languages.
• Utilize knowledge in data visualization tools and libraries.
• Knowledge in Graph-DB is a plus.
• People Management: Lead and mentor team members, fostering a collaborative and productive work environment.
• Azure Data Factory & Data Bricks: Design and develop data pipelines, workflows, and data transformation processes.
• Integrate various data sources to ensure seamless data flow between systems.
• Optimize data processing and storage for performance and cost-efficiency.
• Databases (SQL, PostgreSQL, Azure Databases): Design, implement, and maintain database systems, including PostgreSQL and Azure databases.
• Monitor and optimize database performance.
• Implement robust backup and recovery strategies.
• ETL/ELT Concepts: Extract data from various sources.
• Transform data to meet business requirements.
• Load data into target systems efficiently.
• DevOps and Agile Methodologies: Implement and manage continuous integration and continuous deployment (CI/CD) pipelines.
• Use Git for version control and collaboration.
• Apply Agile methodologies for project management and delivery.
• Cross-Team Collaboration: Work closely with infrastructure teams to ensure seamless integration and deployment.
• Collaborate with security teams to implement and maintain security controls.
• Engage with business partners to understand requirements and deliver solutions in a timely and cost-effective manner.
• Problem-Solving and Attention to Detail: Demonstrate excellent problem-solving abilities and attention to detail.
• Identify and resolve issues promptly within SLA guidelines, providing ongoing support to business users.
• Experience with data analysis, data modelling, data profiling and architecting data analytic solutions.
• Leadership and Team Support: Lead and support the team to maintain high-quality standards in deliverables.
• Collaborate with cross-functional teams to support seamless project delivery.

Position Responsibilities

• Design and develop data solutions using Azure Data Factory & Data Bricks - 40%
• Oversee ETL/ELT processes along with manage and maintaining ETL/ELT pipelines. Extract data from various sources. Transform data to meet business requirements. Load data into target systems efficiently - 20%
• Techno Functional Management and People Management - 20%
• Cross-Team collaboration, Dev-ops & Agile methodologies - 10%
• Global Manufacturing Supply process understanding like production planning, quality, inventory, and supply chain. MES (execution system) understanding, and SAP-ERP landscape - 10%

Organizational Relationships

Interacting with business stakeholders to gather integration requirements, understand business processes, and ensure that integration solutions align with organizational goals and objectives. Participate in project planning activities, risk assessment, and scheduling for DDA projects. Interacting with external vendors or partners who provide software or services that need to be integrated with DDA systems. Work with implementation partners who may be responsible for deploying, configuring, or maintaining integrated solutions within Zoetis IT landscape. Coordinate with developers and other members of the team to implement integration solutions, share knowledge, and address technical challenges.

Education and Experience

Education: Bachelors/master’s degree in computer science/applications. Experience: 8-10+ years of overall experience in Data Engineering/Science with 6+ years’ experience in Data Engineering/Science, and almost 1+ years in Lead Role. Hands-on experience in Azure Data Factory and Data Bricks. Expertise in Python, Databases Management, ETL/ELT Concepts. Strong analytical skills, excellent communication abilities, and a proactive approach to problem-solving. Experience with data analysis, data modelling, data profiling and architecting data analytic solutions. DevOps and Agile Methodologies CI/CD Pipelines: Implement and manage continuous integration and continuous deployment pipelines. Version Control: Use Git for version control and collaboration. Agile Practices: Apply Agile methodologies for project management and delivery.

Technical Skills Requirements

Azure Data Factory, Data Bricks, ETL/ELT, DB Management, Python, SQL, Viz. Tools, CI/CD pipelines

Physical Position Requirements

Regular working hours are from 11 PM to 8:00 PM IST. Sometimes, more overlap with the EST Time zone is required during production go-live. Full time

At Zoetis, our purpose is to nurture our world and humankind by advancing care for animals. As a Fortune 500 company and the world leader in animal health, we discover, develop, manufacture and commercialize vaccines, medicines, diagnostics and other technologies for companion animals and livestock. We know our people drive our success. Our award-winning culture, built around our Core Beliefs, focuses on our colleagues’ careers, connection and support. We offer competitive healthcare and retirement savings benefits, along with an array of benefits, policies and programs to support employee well-being in every sense, from health and financial wellness to family and lifestyle resources.