Financial Analyst - Reporting & Automation

MSD Australia & New Zealand; Sydney; On-site; AUD 90,000 - 140,000; Full time

Job summary

MSD Australia & New Zealand is seeking a Financial Analyst - Reporting & Automation to support the Animal Health markets with financial insights, analytics and dashboarding. This role focuses on improving reporting efficiency, automating processes and delivering high-impact insights to support commercial decision-making.

Based in Macquarie Park, Sydney, you will partner with finance and commercial teams across Australia and New Zealand to build dynamic dashboards, standard KPI scorecards and

Qualifications

• Bachelor’s degree in Finance, Accounting, Data Analytics or a related field.
• CPA, CA, CIMA or equivalent qualification is a plus.
• Prior solid experience in FP&A, financial reporting, business analytics or finance transformation.
• Advanced Power BI skills, including DAX and Power Query.
• Experience with Power Automate, SQL, VBA and SAP.
• Practical experience using enterprise AI tools for finance workflows and analysis.
• Strong analytical skills and ability to think beyond the numbers.
• Excellent planning, organisation and prioritisation skills.
• Strong stakeholder influence and communication skills.
• Ability to build effective relationships and work across senior stakeholders.
• Experience in pharmaceutical or Animal Health industry preferred but not essential.

Responsibilities

• Identify repetitive reporting tasks across AU and NZ and automate extraction, transformation and distribution
• Streamline month-end close, forecast packages and variance analysis
• Reduce reporting preparation cycle times and improve efficiency
• Modernise FP&A reporting processes using available technologies and AI-driven workflows
• Design, build and maintain interactive Power BI dashboards for commercial leaders
• Develop standardised KPI scorecards covering sales, gross-to-net, OPEX and margin analysis
• Ensure seamless data refreshes and strong data integrity across models
• Deliver insightful analytics and reporting that support planning, performance evaluation and decision-making
• Use generative AI tools and structured prompt engineering to draft commentary, analyse variances and summarise trends
• Implement automation tools to connect disparate financial data sources
• Support the introduction of modern finance technologies to improve reporting quality and speed
• Partner with commercial and cross-functional stakeholders across Australia and New Zealand to understand reporting requirements
• Translate complex financial data into clear, actionable recommendations
• Build strong relationships with stakeholders, including senior management, to meet deadlines and financial requirements
• Support any other tasks, projects or activities required by the Finance Lead

Skills

Analytical skills

Communication skills

Planning & organisation

Stakeholder management

Relationship building

Education

Bachelor's degree

Tools

Power BI (Advanced)

DAX

Power Query

Power Automate

SQL

VBA

SAP

AI tools

Job description

• Permanent, full-time role with competitive remuneration and benefits
• Career growth Develop your skills in financial reporting, automation and analytics across a complex ANZ business
• Professional development Gain hands-on experience modernising finance processes, dashboarding and AI-enabled reporting

Job Description

Financial Analyst - Reporting & Automation

• Permanent, full-time role with competitive remuneration and benefits
• Location Macquarie Park, Sydney, NSW
• Career growth Develop your skills in financial reporting, automation and analytics across a complex ANZ business
• Professional development Gain hands-on experience modernising finance processes, dashboarding and AI-enabled reporting

As a Financial Analyst - Reporting & Automation, you will play a key role in supporting the Animal Health Australia and New Zealand markets through financial insights, analytics and dashboarding. This role focuses on improving reporting efficiency, automating processes and delivering high-impact insights to support commercial decision-making.

Working as a valued business partner, you will collaborate with finance and commercial teams across ANZ to identify reporting needs, build dynamic dashboards and streamline recurring reporting cycles through modern tools and AI-enabled workflows.

What You Will Do

Responsibilities include, however not limited to

Reporting, Automation and Process Improvement

• Identify repetitive reporting tasks across AU and NZ and automate extraction, transformation and distribution
• Streamline month-end close, forecast packages and variance analysis
• Reduce reporting preparation cycle times and improve efficiency
• Modernise FP&A reporting processes using available technologies and AI-driven workflows

Dashboarding and Analytics

• Design, build and maintain interactive Power BI dashboards for commercial leaders
• Develop standardised KPI scorecards covering sales, gross-to-net, OPEX and margin analysis
• Ensure seamless data refreshes and strong data integrity across models
• Deliver insightful analytics and reporting that support planning, performance evaluation and decision-making

AI and Technology Integration

• Use generative AI tools and structured prompt engineering to draft commentary, analyse variances and summarise trends
• Implement automation tools to connect disparate financial data sources
• Support the introduction of modern finance technologies to improve reporting quality and speed

Commercial Business Partnering

• Partner with commercial and cross-functional stakeholders across Australia and New Zealand to understand reporting requirements
• Translate complex financial data into clear, actionable recommendations
• Build strong relationships with stakeholders, including senior management, to meet deadlines and financial requirements
• Support any other tasks, projects or activities required by the Finance Lead

What You Must Have

• Bachelor’s degree in Finance, Accounting, Data Analytics or a related field
• CPA, CA, CIMA or equivalent qualification is a plus
• Prior solid experience in FP&A, financial reporting, business analytics or finance transformation
• Advanced Power BI skills, including DAX and Power Query
• Experience with Power Automate, SQL, VBA and SAP
• Practical experience using enterprise AI tools for finance workflows and analysis
• Strong analytical skills and ability to think beyond the numbers
• Excellent planning, organisation and prioritisation skills
• Strong stakeholder influence and communication skills
• Ability to build effective relationships and work across senior stakeholders
• Experience in pharmaceutical or Animal Health industry preferred but not essential

What You Can Expect

• Work autonomously whilst being supported, encouraged and being part of a trusted Global Leading Animal Health organisation
• The opportunity to help modernise finance reporting across a major regional business
• A collaborative team environment with strong business partnering exposure
• Support to grow your technical, analytical and commercial skillset
• The chance to work with modern tools, automation and AI-driven finance processes
• Location is Macquarie Park (Sydney). Since role supports 2 markets, travel up to a week per month could be required

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.

Additional location(s) Compensation Information

NZL - Wellington - Upper Hutt (Whakatiki), AUS - Queensland - Murarrie

Required Skills

Budgeting, Business Analysis, Competency Management, Critical Thinking, Dashboard Reporting, Data Analysis, Data Integrity, Detail-Oriented, Ethical Standards, Financial Acumen, Financial Analysis, Financial Forecasting, Generally Accepted Accounting Principles (GAAP), Policy Compliance, Preparation of Financial Reports, Process Improvements, Profit and Loss (P&L) Analysis, Situational Leadership, Standards Compliance, Trend Analysis

Preferred Skills

Current Employees apply HERE

Current Contingent Workers apply HERE

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

Regular

Relocation

No relocation

VISA Sponsorship

No

Travel Requirements

25%

Flexible Work Arrangements

Hybrid

Shift

Not Indicated

Valid Driving License

No

Hazardous Material(s)

N/A

Job Posting End Date

11/14/2026

• A job posting is effective until 11 59 59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Requisition ID

R421901