FP&A Automation & Insights Analyst

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

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.

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

Merck • Ryde

On-site
AUD 86,000 - 100,000
Health insurance
Finance Automation & Reporting Analyst - AI-Driven Dashboards
Finance Automation & Reporting Analyst - AI-Driven Dashboards

3339 Intervet Australia Pty Ltd • Sydney

Hybrid
AUD 120,000 - 150,000
FP&A Analyst, ANZ – Hybrid & Data-Driven Growth
FP&A Analyst, ANZ – Hybrid & Data-Driven Growth

Pernod Ricard Winemakers - Headquarters (inactive) • Sydney

Hybrid
AUD 90,000 - 130,000
Product allowance
Hybrid and flexible working
Summer hours
+5
FP&A Analyst – ANZ FMCG, Hybrid & Insights
FP&A Analyst – ANZ FMCG, Hybrid & Insights

Pernod Ricard SA • Sydney

Hybrid
AUD 90,000 - 120,000
Product allowance
Hybrid and flexible working
Summer hours
+5
Hybrid FP&A Analyst - Budgeting, Forecasting & Analytics
Hybrid FP&A Analyst - Budgeting, Forecasting & Analytics

Talent Web Recruitment • Sydney

Hybrid
AUD 117,000 - 143,000
Hybrid working
Competitive salary
Financial Analyst - Reporting & Automation
Financial Analyst - Reporting & Automation

3339 Intervet Australia Pty Ltd • Sydney

Hybrid
AUD 120,000 - 150,000
FP&A Analyst — Strategic Budgeting, Forecasting & Insights (Hybrid)
FP&A Analyst — Strategic Budgeting, Forecasting & Insights (Hybrid)

Groupe Clarins • Sydney

Hybrid
AUD 110,000 - 165,000
Remote work up to 2 days per week
Development opportunities
Competitive compensation & benefits
Finance Data Analyst – Power BI & Automation
Finance Data Analyst – Power BI & Automation

Vectec Pty Ltd • Sydney

On-site
AUD 90,000 - 130,000
FP&A Analyst (Contract) — Excel, Power BI, Intercompany
FP&A Analyst (Contract) — Excel, Power BI, Intercompany

Naked Ambition • Sydney

On-site
AUD 167,000 - 357,000
Finance Transformation & Automation Analyst
Finance Transformation & Automation Analyst

ISS World • Sydney

On-site
AUD 110,000 - 140,000
Top locations