Business Intelligence Analyst

Company:

Mercer

Description:

We are seeking a talented individual to join our Workforce Management / Reporting team at Mercer. This role will be based in Adelaide, Melbourne or Sydney. This is a hybrid role that has a requirement of working at least three days a week in the office.

The BI Analyst will act as a Reporting Analyst for workforce operations, supporting daily and weekly reporting requirements including SLA, throughput, and regulatory reporting. You will work closely with operational teams across the business to deliver accurate and insightful reporting solutions.

We will count on you to:

• Develop, maintain, and enhance business intelligence solutions to aid analytics and business decision-making
• Run existing reporting on a regular basis ensuring timely and accurate delivery
• Define reporting requirements, data scope, and key operational metrics in collaboration with stakeholders
• Have a good understanding of operational metrics and best practice
• Assist in creating and automating reports and dashboards by extracting, validating, and consolidating data from multiple sources, performing trend and variance analyses, and presenting concise, actionable insights to stakeholders
• Ensure accurate coordination and standardisation of data inputs across business units
• Maintain clear documentation for data sources, transformations, and reporting logic
• Manage multiple priorities with a strong delivery focus while working independently and under direction

What you need to have:

• Experience in Qlik (preferred) or Power BI, including data modelling, dashboards, and visualisations
• Advanced Excel skills, including Power Query to manipulate and analyse complex datasets
• Strong SQL experience for data extraction and transformation
• Proficient PowerPoint skills for leadership and board-level reporting
• Experience with Power Automate to streamline data refreshes, reporting workflows, and approvals

What makes you stand out:

• High attention to detail and a strong delivery mindset with a collaborative and proactive approach to problem-solving
• Experience in an operational environment with exposure to workforce management
• Familiarity with EDW, Databricks or large-scale data platforms, plus a genuine interest in automating processes
• Experience in operations, data or business analysis within the superannuation or broader financial services industries
• Willingness to continuously improve, learn, and adapt to new technologies and tools in the data management space

Why join our team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders
• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities
• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being

Applications can be considered from candidates who have the appropriate approval to work in Australia. Successful applicants will be required to complete a criminal & bankruptcy check prior to commencement of employment.

Mercer is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information about Mercer, visit mercer.com, or follow us on LinkedIn and X.

Marsh is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. Applications will only be considered from candidates who have the appropriate approval to work in Australia. Successful applicants will be required to complete a Criminal & Bankruptcy check prior to commencing of employment.

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.