Business Data Analyst

MSD

2-Year Fixed-Term Contract, full-time, with competitive remuneration and benefits
Location: Wellington - Upper Hutt, New Zealand (onsite requirement, mixed with flexible WFH days)
Career growth: Expand your expertise in a growing, successful industry
Professional development: Gain valuable experience in a dynamic, evolving role

We are looking for a Business Data Analyst who can interpret data, build clear dashboards, and support commercial decision making.

This role is hands on with Excel and Power BI, works closely with Finance and Business Units, and focuses on insight, reporting, and process improvement rather than building complex data pipelines or platforms.

What You Will Do

Responsibilities include, however not limited to

Reporting, Dashboards Insights

Build and maintain Power BI dashboards for business reviews and operational reporting
Analyse data from CRM, SAP/ERP and finance systems to produce clear, actionable insights
Support leadership and BU teams with ad-hoc analysis and interpretation, not just data extracts
Ensure reports are accurate, consistent, and aligned to a single source of truth

Business Commercial Support

Manage SAP pricing and rebates, including accruals, reconciliations, and margin protection with
Finance
Lead contract operations, enabling key terms in SAP and tracking renewals and compliance
Maintain SAP customer master data governance, approvals, and data quality
Design and maintain Excel-based templates for targets, incentives, and allocations
Align targets and reporting with Finance and Business Unit leaders
Support Sales Incentive Plan (SIP) reporting, tracking, and budget alignment
Maintain accurate customer and commercial master data across systems

Process Improvement Automation

Identify manual, repetitive reporting or data tasks and improve them using available tools
Improve how teams use CRM, SAP and reporting tools (practical optimisation, not system design)
Help standardise processes, templates, SOPs and training materials

Data Quality Governance

Support ongoing data quality, accuracy, and documentation
Work with IT, Finance and global teams to resolve data issues and inconsistencies
Ensure reporting is audit-ready and well understood by business users

What You Must Have

Qualifications Experience

Bachelor’s degree in Business, Economics, Information Systems, or a related field
Equivalent practical experience in business or commercial analytics is welcome

Essential

Strong hands-on experience with Power BI (building dashboards, measures, visuals)
Advanced Excel skills (formulas, pivot tables, templates, data analysis)
Experience working as a Business Analyst / Commercial Analyst / Reporting Analyst
Ability to interpret data and explain insights clearly to non-technical stakeholders
Strong attention to detail and comfort working with operational and financial data
Confident working across Finance, Sales, Operations and IT teams

What You Can Expect

Work autonomously whilst being supported,encouraged and being part of a trusted Global Leading Animal Health organisation
Exposure toupskill and develop in your role
Flexibility andopening doors to other opportunities and skillsets
Joining acollaborative team oflikeminded individuals

We are proud to be a company that embraces the value of bringing talented and committed people together. The fastest way to breakthrough innovation is when ideas come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively. We are an equal opportunity employer, committed to fostering an inclusive workplace.

Required Skills

Business Data Analytics, Business Intelligence (BI), Business Reviews, Commercial Analytics, Customer Service Communication, Data Analysis, Data Quality, Data Quality Assessments, Microsoft Power Business Intelligence (BI), Process Standardization, Sales Data Management, SAP CRM, Technical Knowledge, Technical Support

Preferred Skills

Current Employees applyHERE

Current Contingent Workers applyHERE

Search Firm Representatives Please Read Carefully

Merck Co., Inc., Rahway, NJ, USA, also known as Merck Sharp Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Employee Status

Temporary (Fixed Term)

Relocation

No relocation

VISA Sponsorship

Travel Requirements

No Travel Required

Flexible Work Arrangements

Hybrid

Shift

Not Indicated

Valid Driving License

Hazardous Material(s)

N/A

Job Posting End Date

08/8/2026*A job posting is effective until 11:59:59PM on the dayBEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the dayBEFORE the job posting end date.

Requisition ID: R406996