FP&A Analyst - Reporting, Automation & AI Dashboards

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

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