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)
Full time
Legal statement as below
This job advert indicates the general nature and level of work expected. It is not designed to cover or contain a comprehensive listing of activities or responsibilities required of the incumbent. Incumbent may be asked to perform other duties as required. Additional position specific requirements/responsibilities are contained in approved training curricula.
Visa status re must be eligible to work and live in Ireland as below
Colleague must be legally eligible to live and work in Ireland.
Summary of our Benefits
In addition, to being part the world leading animal health company focused on the needs of those who raise and care for animals we offer a range of benefits such as competitivesalary, bonus, 25.5 days holiday per annum plus public holidays, a defined contributory pension plan, private medical insurance for you and your family and empowered flexible working, to name a few. Please note that the benefits outlined are subject to change based on organization decision.