Data Analyst, Dairy Predictive Solutions

Zoetis; Michigan; On-site; USD 80,000 - 120,000; Full time

Benefits offered by this job

Health benefits from day one

401K plan with match

4 weeks vacation

Job summary

Zoetis seeks a data analytics engineer to design and optimize SQL queries powering predictive dairy algorithms and customer analytics. You will partner with business leaders, data scientists, and implementation specialists to translate objectives into scalable data solutions and ensure data integrity across platforms.

You will manage data transformations, document data structures, and support lifecycle management of analytics.

Qualifications

• Bachelor's degree in Animal Science, Computer Science, Information Science, Data Science, Information Systems, or related field.
• 3+ years with relational SQL databases, including query writing, optimization and tuning.
• 2+ years in animal agriculture data ecosystems or dairy experience.
• Ability to manage multiple projects concurrently and communicate with stakeholders.

Responsibilities

• Design, write, and optimize SQL queries powering dairy predictive analytics.
• Support deployment and lifecycle management of dairy analytics and algorithms.
• Perform data mapping and modeling to translate requirements into specifications.
• Conduct quality checks for data completeness and production readiness.
• Prepare technical documentation detailing data structures and processes.
• Manage pending requests and reprioritize with leadership as needs evolve.
• Collaborate with R&D and data science to enable rapid iteration on models.

Skills

Advanced SQL

Data quality

Documentation

Cross-functional collaboration

Time management

Data mapping

Requirements gathering

Data transformation

Communication skills

Education

Bachelor's degree in Animal Science or CS or Data Science

Tools

Databricks

Data lakes/data warehouses

Python

Microsoft Excel

Job description

Position Summary

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 $80,000-120,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.

About Zoetis

Zoetis, our purpose is to nurture the 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.

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.

Global Job Applicant Privacy Notice