Manager Data Engineering
Zoetis Hyderabad, Telangana, India
Pharmaceutical Manufacturing · 10,001+ employees
About the role
The Manager of Data Engineering will design and develop data pipelines using Azure Data Factory and Databricks while overseeing ETL/ELT processes. They are also responsible for leading and mentoring the team, managing technical projects, and collaborating with cross-functional departments.
What they look for
Requirements
Candidates must have a bachelor's or master's degree in computer science or applications with 8-10+ years of experience in data engineering. Proficiency in Azure Data Factory, Databricks, Python, and database management is required, along with at least one year of experience in a lead role.
Full 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
Regular
Colleague
Any unsolicited resumes sent to Zoetis from a third party, such as an Agency recruiter, including unsolicited resumes sent to a Zoetis mailing address, fax machine or email address, directly to Zoetis employees, or to Zoetis resume database will be considered Zoetis property. Zoetis will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
Zoetis will consider any candidate for whom an Agency has submitted an unsolicited resume to have been referred by the Agency free of any charges or fees. This includes any Agency that is an approved/engaged vendor but does not have the appropriate approvals to be engaged on a search.
Notice: Zoetis Recruiters will contact candidates via email from an address ending in @zoetis.com and may also initially connect with candidates through LinkedIn, including LinkedIn InMail. Zoetis does not use Gmail, Outlook, Yahoo, or other web-based/generic email domains to communicate about job opportunities, interviews, or offers of employment. If you receive a recruitment-related email message claiming to be from Zoetis that does not come from @zoetis.com, please treat it as suspicious. For your security, do not reply, click links, open attachments, share personal or financial information, or send money in response to unexpected or questionable recruitment communications.