Job Description:
• Design, write, and optimize SQL queries powering dairy predictive algorithms and customer-facing platform analytics
• Support deployment and lifecycle management of dairy analytics and predictive algorithms
• Prepare, validate, and transform input data and review algorithm outputs for internal consistency
• Perform data mapping and modeling to translate business and scientific requirements into data and analytic specifications
• Perform data quality checks for completeness, consistency, and production suitability
• Prepare documentation and technical specifications covering data structures, query logic, data flows, and processes
• Maintain project logs and manage pending requests and reprioritization with department-level and business leadership
• Collaborate with R&D and data science teams to support innovation in dairy algorithms and models
• Work with internal and external business stakeholders to review requirements, validate outputs, and ensure platform data accuracy
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
• All applicants must possess or obtain authorization to work in the US for Zoetis
• Individuals requiring sponsorship must disclose this fact
Benefits:
• Short-term incentive compensation
• Long-term incentives
• Healthcare and insurance benefits beginning on day one
• 401K plan with a match and profit-sharing contribution from Zoetis
• 4 weeks of vacation