Company:

Mercer

Description:

People & Risk Process, Data and Reporting Analyst

Location: Sydney or Melbourne (hybrid) | Employment type: Full time, 12 months contract.

The People & Risk Process, Data and Reporting Analyst partners with process owners across the organisation to design repeatable, efficient processes and controls that extract, transform, validate and report on people and risk data. You’ll deliver reconciled datasets, maintain data lineage and quality controls, and support stakeholders to turn HR and risk information (e.g. risk surveys, performance, reward, KRIs) into timely, accurate reporting and insights.

What can you expect?

• A cross‑functional role working closely with HR, Risk, Reward, Finance, Technology and Data teams.
• A mix of process design, hands‑on data work (validation, reconciliation) and stakeholder engagement.
• Responsibility for end‑to‑end data pipelines, documentation and controls that ensure privacy and compliance.
• Project ownership for recurring initiatives such as the annual risk culture survey.

What is in it for you?

• High visibility: your outputs will inform risk and people decisions across the business.
• Opportunity to build repeatable data processes and strengthen governance across multiple systems.
• Development in HR analytics, risk reporting and data governance within a collaborative environment.
• Hybrid working and the chance to influence how people and risk data are used organisation‑wide.

We will count on you to:

• Design, document and maintain end‑to‑end processes for extracting, transforming and loading HR and risk data into reporting/analytics environments.
• Standardise data definitions, mappings and business rules across surveys, goals, performance and reward datasets.
• Extract, join and reconcile data from multiple sources (HRIS, risk systems, survey tools, performance/reward platforms) to produce reliable datasets for dashboards and analysis.
• Develop and run data quality checks (completeness, accuracy, timeliness, consistency) and investigate/resolve issues with source owners.
• Maintain auditable evidence of data lineage, transformations and key controls in line with governance and privacy requirements.
• Identify and deliver automation opportunities to improve efficiency and control (feeds, templates, validations).
• Project manage delivery of the annual risk culture survey and contribute to testing/design of system/integration changes.
• Communicate data issues, risks and remediation plans clearly to technical and non‑technical stakeholders.

What you need to have:

• Experience in a data, reporting, business analyst or risk/HR analytics role (typically 2–5+ years).
• Practical exposure to HR data (headcount, performance, reward) and/or risk/control data (risk registers, survey results, KRIs); preferable experience in the intersection of both HR and risk data
• Experience building and operating repeatable data processes and controls across multiple source systems.
• Strong technical skills in data manipulation (Excel, SQL and/or BI tools such as Power BI/Tableau).
• Understanding of data privacy, confidentiality and appropriate use of sensitive employee and risk data.
• Clear written and verbal communication, attention to detail, and ability to manage multiple datasets and stakeholders concurrently.

What makes you stand out:

• Proven track record delivering reconciled, auditable HR and risk datasets and maintaining data lineage documentation.
• Hands‑on experience automating validation processes and improving data pipeline efficiency.
• Comfortable translating business questions into data requirements and reporting specifications.
• Able to explain technical data issues in plain language and influence remediation with source system owners and business stakeholders.
• Experience in managing and coordinating the delivery of risk culture or engagement surveys

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.