Financial Analyst - Reporting & Automation

Merck

Ryde

On-site

AUD 86,000 - 100,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance

Job summary

Merck in Sydney, Macquarie Park, is seeking a Financial Analyst to lead reporting, automation and analytics across Australia and New Zealand. You will build Power BI dashboards, standardised KPI scorecards and automation workflows to streamline close cycles, forecast packs and variance analysis.

The role partners with finance and commercial teams to translate complex data into actionable insights, drive efficiency, and support strategic decision-making.

Qualifications

  • Bachelor's degree in Finance, Accounting, Data Analytics or related field.
  • CPA, CA, CIMA or equivalent is a plus.
  • Prior solid FP&A, financial reporting, business analytics or finance transformation experience.
  • 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.

Responsibilities

  • 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 Power BI dashboards.
  • Develop standardised KPI scorecards covering sales, gross-to-net, OPEX and margin analysis.
  • Ensure data refreshes and data integrity across models.
  • Deliver analytics and reporting to support planning, performance and decision-making.
  • AI and Technology Integration – use AI tools to draft commentary, analyse variances and summarise trends.

Skills

Power BI
DAX
Power Query
SQL
VBA
SAP
AI in finance
Analytical thinking
Stakeholder comms

Education

Bachelor's degree in Finance/Accounting/Data Analytics

Tools

Power Automate
SQL
VBA
SAP

Job description

Financial Analyst - Reporting & Automation
External

Merck - New South Wales - Macquarie Park, Australia

Budgeting Business Analysis Compliance Data Analysis Financial Analysis Forecasting

Responsibilities
  • 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
  • Additional location(s) Compensation Information:
  • NZL - Wellington - Upper Hutt (Whakatiki), AUS - Queensland - Murarrie
  • Required Skills:
  • Preferred Skills:

Health insurance

Additional Information

Job DescriptionFinancial Analyst - Reporting & AutomationPermanent, full-time role with competitive remuneration and benefitsLocation: Macquarie Park, Sydney, NSWCareer growth: Develop your skills in financial reporting, automation and analytics across a complex ANZ businessProfessional development: Gain hands-on experience modernising finance processes, dashboarding and AI-enabled reportingAs 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.

Your Match

How well this role fits your profile.

Confirmed H-1B sponsor. The Department of Labor record shows filings under MERCK SHARP & DOHME CORP. .

Filings 467

Approved 80.3%

Avg wage $92K

From public Department of Labor LCA disclosures. Sponsorship history is a signal about the employer, not a commitment on this role.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Financial Analyst - Reporting & Automation
Financial Analyst - Reporting & Automation

3339 Intervet Australia Pty Ltd • Sydney

Hybrid
AUD 120,000 - 150,000
Financial Accountant ANZ
Financial Accountant ANZ

MSD • Sydney

Hybrid
AUD 110,000 - 140,000
Accountant ANZ
Accountant ANZ

1003 Merck Sharp & Dohme (Australia) Pty Ltd • Sydney

Hybrid
AUD 70,000 - 100,000
Accountant ANZ
Accountant ANZ

MSD KK • New South Wales

Hybrid
AUD 90,000 - 120,000
Hybrid work arrangements
Accountant ANZ
Accountant ANZ

MSD Australia & New Zealand • Sydney

Hybrid
AUD 90,000 - 130,000
Financial Accountant ANZ
Financial Accountant ANZ

MSD KK • Sydney

Hybrid
AUD 90,000 - 130,000
Permanent role
Hybrid work arrangement
Career growth
+2
Financial Accountant
Financial Accountant

AH UK Animal Health (PVT) • Sydney

Hybrid
AUD 90,000 - 120,000
Discounts on animal health products
Perkbox/Boost access
Additional leave benefits
+6
Sales Enablement Data & Automation Specialist
Sales Enablement Data & Automation Specialist

MSD • Sydney

Hybrid
AUD 110,000 - 150,000
Flexible work arrangements
FP&A Automation & Insights Analyst
FP&A Automation & Insights Analyst

Merck • Ryde

On-site
AUD 86,000 - 100,000
Health insurance
Senior Commercial Analyst
Senior Commercial Analyst

Reo Group • Sydney

Hybrid
AUD 160,000 - 170,000
Hybrid working
Wellbeing benefits
Career development
Top locations