Job Description

Supports the development, optimization, and maintenance of data queries and analytics pipelines that power the Predictive Dairy Solutions platform. Works within cross-functional teams consisting of business leaders, data scientists, dairy industry experts, and technology implementation specialists to understand commercial and scientific objectives and translate them into efficient, performant data solutions. Responsible for writing, tuning, and managing SQL queries and data transformations that underpin dairy predictive algorithms and customer-facing analytics. Must be able to work with business stakeholders (internal and external) to review and refine data requirements, validate outputs, and ensure the accuracy and consistency of information flowing through the platform.

Holds responsibility for ensuring data quality and compliance with established protocols for product implementation, actively identifying and resolving data integrity issues. Requires strong capabilities in desktop manipulation of large, and sometimes complex, datasets. Expertise in database querying, query optimization, data mapping, and lifecycle management will be critical. Must be able to work effectively in a dynamic work environment managing and prioritizing multiple concurrent projects. The successful candidate balances the need for collaboration with independent effort to ensure timely delivery of business needs.

Position Responsibilities

• Design, write, and optimize SQL queries that power dairy predictive algorithms and customer-facing platform analytics, ensuring peak performance and efficiency.
• Support the deployment and lifecycle management of dairy analytics and predictive algorithms by preparing, validating, and transforming input data and reviewing algorithm outputs for internal consistency.
• Perform data mapping and modeling exercises to translate business and scientific requirements into accurate data and analytic specifications for technical development teams.
• Perform quality checks on available data to ensure completeness, internal consistency, and suitability for use in production models and customer-facing outputs.
• Prepare documentation and technical specifications describing data structures, query logic, data flows, and process details for business and technical stakeholders.
• Maintain accurate logs of pending and completed projects to support accurate prioritization of effort. Actively manage pending requests and reprioritization in consultation with department-level and business leadership as business needs evolve globally.
• Collaborate with R&D and data science teams to support scientific innovation by ensuring the data infrastructure enables rapid iteration on dairy algorithms and models.

Qualifications

• Bachelor's degree in Animal Science, Computer Science, Information Science, Data Science, Information Systems, or related field.
• 3+ years of experience with relational SQL databases, including query writing, optimization, and performance tuning (required).
• 2+ years of animal agriculture (especially dairy) experience or demonstrated familiarity with animal agriculture data ecosystems.
• Business or data analyst experience covering requirements gathering through to solution delivery is preferred.
• Ability to provide data analysis for multiple projects concurrently.
• Excellent data organizational skills required.
• Strong communication skills are essential.
• Ability to work across time zones in support of global business units and development teams.

Technical Skills

• Advanced SQL proficiency required, including experience with query optimization and performance tuning.
• Microsoft Excel or related experience is required.
• Experience with dairy software platforms including DC305, Bovisync, PCDart, or DHIPlus and understanding of underlying data elements is preferred.
• Experience with systems such as Databricks, data lakes, or data warehouses is preferred.
• Experience with Python or other scripting languages is preferred.
• Experience with AI-supported technical implementation is preferred.
• Familiarity with data visualization tools is a plus.

What We're Looking For

• Organized and dependable with a high level of accountability.
• Works effectively and collaboratively in a team environment; comfortable making constructive contributions in settings with diverse personalities and technical levels, united by their belief in our technology and industry solutions.
• Uses initiative and takes ownership in proactively working to ensure complete and high-quality deliverables.
• Comfortable in a rapidly changing environment.
• Self-motivated and able to work independently to progress assigned and emergent tasks to completion with minimal oversight.
• Demonstrated commitment to achieving objectives in a manner that is supportive of Zoetis values.

The US base salary range for this full-time position is $115,000 - $170,000. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the base pay target range for new hire salaries for the position. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.

This position is also eligible for short-term incentive compensation

This position is also eligible for long-term incentives

In addition to compensation, Zoetis offers a comprehensive benefits package that supports the physical, emotional and financial wellbeing of our colleagues and their families including healthcare and insurance benefits beginning on day one, a 401K plan with a match and profit-sharing contribution from Zoetis, and 4 weeks of vacation.

Visit zoetisbenefits.com to learn more.

Full timeRegularColleague

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.

Zoetis is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status or any other protected classification. Disabled individuals are given an equal opportunity to use our online application system. We offer reasonable accommodations as an alternative if requested by an individual with a disability. Please contact Zoetis Colleague Services at zoetiscolleagueservices@zoetis.com to request an accommodation. Zoetis also complies with all applicable national, state and local laws governing nondiscrimination in employment as well as employment eligibility verification requirements of the Immigration and Nationality Act. All applicants must possess or obtain authorization to work in the US for Zoetis. Zoetis retains sole and exclusive discretion to pursue sponsorship for the acquisition or maintenance of nonimmigrant status and employment eligibility, considering factors such as availability of qualified US workers. Individuals requiring sponsorship must disclose this fact. Please note that Zoetis seeks information related to job applications from candidates for jobs in the U.S. solely via the following: (1) our company website at www.Zoetis.com/careers site, or (2) via email to/from addresses using only the Zoetis domain of “@zoetis.com”. In addition, Zoetis does not use Google Hangout for any recruitment related activities. Any solicitation or request for information related to job applications with Zoetis via any other means and/or utilizing email addresses with any other domain should be disregarded. In addition, Zoetis will never ask candidates to make any type of personal financial investment related to gaining employment with Zoetis.