Business Intelligence Coordinator

Role Summary

The Business Intelligence Coordinator is an entry level position in the Commercial Operations department, delivering the analytical backbone that underpin Zoetis’ commercial strategy. Reporting to the Commercial Operations Manager and partnering closely with the commercial team, this role combines hands-on analytics with commercial acumen and cross-functional collaboration.
The Business Intelligence Coordinator is responsible for dashboard building and maintenance including data import, transformation, and cleansing. The role will also require the responsible person to be able to use calculated tables, slicers and tooltips to showcase trend, variance and root cause analysis. It will require knowledge of SQL for query optimization and model optimization. Also, to develop and maintain pricing guidance for a broad portfolio of products beyond core brands, establishing benchmarks for in-market pricing.

Role Responsibilities

• Develop and maintain Power BI dashboards for sales, rebates and trends seen at the 3PL and wholesalers, providing key insights in regards to sales trends, seasonality and safety stocks to the commercial team.

• Develop and maintain pricing guidance for a broad portfolio of products beyond core brands, establishing benchmarks for in-market pricing

• Build and refine models, analytics, and Power BI dashboards that support annual planning, sales analysis, and commercial decision-making.

• Support revenue management analysis and scenario modelling to recommend commercial optimization with measurable financial impact.

• Translate analytical findings into actionable business recommendations through clear and concise presentations to internal stakeholders.

• Develop calculated tables, slicers and tooltips to showcase trend, variance and root cause analysis and use of SQL for query optimization and model optimization

Candidate Requirements

Education & Experience

• Bachelor’s degree in Data Analytics, or a related discipline
• Minimum 3 years of experience in commercial analytics, or data analytics roles
• International exposure and experience supporting cross-functional commercial teams
• Expertise in Microsoft Excel and Power BI; SQL, Azure and Python/R are a plus
• Knowledge of commercial relationships, wholesaler reporting, and rebate framework
• Experience in regulated industries such as animal health, pharma, or diagnostics preferred

Technical Skill Requirements

• Strong analytical capability with the ability to translate data into strategic insights
• Demonstrated ability to guide commercial decisions through structured frameworks and modelling
• High attention to detail, with capability to manage compliance monitoring and exception approvals
• Clear communicator with strong storytelling skills to present findings to non-technical audiences
• Proactive and accountable, with strong prioritization and time management skills
• Experience with ERP systems (e.g. SAP S4 Hana/Vistex)

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.