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 requires 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.
Responsibilities
* 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
Requirements
* 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
Desirable
* 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
Benefits
* Professional development opportunities, interesting work and supportive leaders
* Vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities
* Career opportunities, benefits and rewards to enhance your well‐being
Equal Opportunity & Legal Disclosure
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.
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.
#J-18808-Ljbffr