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 chance 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.

📌 Financial Analyst - Reporting & Automation (New South Wales)
🏢 Msd
📍 New South Wales