Automation-Focused Financial Analyst | PowerBI & AI

Merck; Sydney; On-site; AUD 90,000 - 130,000; Full time

Job summary

Merck in Sydney, Australia, is seeking a Financial Analyst - Reporting & Automation to advance finance reporting, automate processes and deliver high‑impact insights for ANZ markets.

You will partner with finance and commercial teams to build dynamic PowerBI dashboards, streamline month‑end close and implement AI‑driven workflows to improve speed and accuracy.

The role offers growth in analytics, dashboarding and AI-enabled reporting with travel up to a week per month.

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 PowerBI 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

• Reporting, automation and process improvement across AU and NZ.
• 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 PowerBI 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.

Skills

Analytical thinking

Stakeholder management

Planning & prioritisation

Communication skills

Financial acumen

Education

Bachelor's degree in Finance/Accounting/Data Analytics

Tools

PowerBI

Power Automate

SQL

VBA

SAP

Job description

Merck in Sydney, Australia, is seeking a Financial Analyst - Reporting & Automation to advance finance reporting, automate processes and deliver high‑impact insights for ANZ markets.

You will partner with finance and commercial teams to build dynamic PowerBI dashboards, streamline month‑end close and implement AI‑driven workflows to improve speed and accuracy.

The role offers growth in analytics, dashboarding and AI-enabled reporting with travel up to a week per month.