Data Engineering Team Lead

Job Description

Our Company is where we transform vision into reality. It's where ideas become technologies, and cutting-edge technologies become solutions for animal care and management.

We support farmers by providing real-time actionable information to help them manage their herds. It provides pet owners with smart devices and data that give them a better understanding of their pets’ activity and health needs, enriching relationships. It helps conservationists safeguard natural environments and wildlife.

Leveraging decades of Technological Research & Development experience across many markets, technologies and species, along with development environments and Quality Assurance procedures, we're always inventing new ways to look after the health and well-being of animals. Our decades of experience keep us ahead of the curve by leveraging advanced Technological Solutions from enhancing the precious bond between people and their pets, to advancing animal healthcare and wildlife preservation.

As a Data Engineering Team Lead, you will play a critical role in designing, implementing, and maintaining our enterprise data infrastructure. You’ll lead a data engineering team and ensure the successful delivery of high-quality data solutions.

Responsibilities

Team Management

• Lead and mentor a team of data engineers.
• Assign tasks, set priorities, and ensure timely project delivery.
• Foster a collaborative and innovative work environment.
• Work with many stakeholders, provide support, and help achieve business goals by providing great data solutions.
  
  

Work closely with our data platform architect to keep pushing our data platform to great performance, scale, quality, and industry standards.

Data Infrastructure Development

• Design, develop, and maintain a scalable and reliable data infrastructure using Snowflake as the core data platform.
• Collaborate with stakeholders to identify and understand business requirements and translate them into technical specifications for data engineering projects.
• Ensure data quality, integrity, and security by implementing best practices and standards.
  
  

ETL Development

• Develop, test, deploy, and schedule complex ETL/ELT solutions.
• Integrate multiple data assets across the organization using ETL tools such as Matillion (and Azure Data Factory, if applicable).
• You are expected to do hands-on work as part of your day-to-day work
  
  

Requirements

• Bachelor’s degree in computer science, Information Systems, or a related field.
• Proven experience of 3 years in data engineering, with a focus on building and managing data infrastructure and analytics systems.
• At least 3 years experience leading a software team or data engineering team.
• SQL Proficiency
• Demonstrate a high level of proficiency with SQL for data extraction, manipulation, and analysis.
• Develop and optimize SQL queries and scripts for both ad hoc and recurring data requests.
• Implement data modeling, schema design, and indexing strategies to enhance query performance.
• Strong expertise in Snowflake as a data warehouse and data integration platform.
• Strong leadership and team management skills, with the ability to motivate and guide team members.
• Excellent problem-solving skills and the ability to effectively communicate complex concepts to both technical and non-technical stakeholders.
• Excellent communication skills and great ability to interact with many interfaces.
  

Advantage

• Working experience with Azure Data Factory and Matillion
• Knowledge of cloud-based data solutions and best practices.
• Development of ETL processes using Phyton
• Understand self-service BI tools such as Superset.
• Experience with Power BI
  
  

MDAHTL

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully

Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Employee Status

Regular

Relocation

VISA Sponsorship

Travel Requirements

Flexible Work Arrangements

Hybrid

Shift

Valid Driving License

Hazardous Material(s)

Job Posting End Date

06/25/2025

• A job posting is effective until 11 59 59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.
  
  

Job Posting End Date 06/25/2025

A job posting is effective until 11 59 59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Requisition ID R298619