Data Modeler – Mercer
We are seeking a talented individual to join our technology team at Mercer. This role will be based in Melbourne or Sydney and is a hybrid role that requires working in the office at least three days a week.
Mercer is a global consulting firm that provides a wide range of services to organisations, including health and benefits consulting, retirement and investment solutions, workforce and career development, and mergers and acquisitions (M& A) advisory. The technology team serves the Mercer business across services. With strong foundations in place, we're focused on growing capability, lifting capacity, and creating a future‐ready ecosystem. We don't settle for good enough — we ask what better looks like, every day.
The Data Modeler reports to the Head of Data and Analytics and will design the structures, relationships and constraints for implementation on a modern data platform, focusing on source‐to‐target transformation design and governance to support business needs.
Responsibilities
Work within the current data team and develop a deep understanding of current data structures across the Mercer Data Estate
Collaborate with stakeholders to translate business needs into effective target‐state data models, defining transition state models as required
Define and implement Data Modelling and Governance best practices and support scalability, performance, and data integrity
Qualifications
5–7 years of experience in data modelling and data/delta lake design, preferably within the Superannuation industry
Strong knowledge of data and AI governance and best practices and hands‐on implementation experience
Proficiency with multiple data modelling tools and techniques
Preferred Technology Exposure
AWS
Databricks
SQL Server
CRM
Desired Additional Skills
Experience in the financial services industry, predominantly
Familiarity with cloud data platforms and technologies such as AWS, Databricks and Lakehouse Architecture
Strong communication skills to liaise between technical and business teams
Benefits
We support your professional development through opportunities for growth, engaging work, and supportive leadership
We foster a vibrant and inclusive culture where you can collaborate with talented colleagues to create impactful solutions for our clients and communities
Our scale provides a range of career opportunities, along with competitive 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.
Marsh Mc Lennan (NYSE: MMC) is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90 000 colleagues, Marsh Mc Lennan helps build the confidence to thrive through the power of perspective.
Marsh Mc Lennan 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.
Marsh Mc Lennan 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 Mc Lennan 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.
R_327887 #J-18808-Ljbffr
