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.
Responsible for writing, tuning, and managing SQL queries and data transformations that underpin dairy predictive algorithms and customer-facing analytics.
Must work with business stakeholders (internal and external).
Holds responsibility for ensuring data quality and compliance with established protocols for product implementation.
Requires strong capabilities in desktop manipulation of large, and sometimes complex, datasets.
Design, write, and optimize SQL queries that power dairy predictive algorithms and customer-facing platform analytics.
Support the deployment and lifecycle management of dairy analytics and predictive algorithms.
Perform data mapping and modeling exercises to translate business and scientific requirements.
Perform quality checks on available data to ensure completeness, internal consistency.
Collaborate with R&D and data science teams to support scientific innovation.
Requirements
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.
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.
Tech Stack
Python
SQL
Benefits
healthcare and insurance benefits beginning on day one
401K plan with a match and profit-sharing contribution from Zoetis