Senior Data Modeller
Clerk Grade: 9/10
Annual Salary Range: $129,464 - $142,665 plus superannuation
Employment Type: Ongoing, Full-time
Location: Darlinghurst - Hybrid Working
About the Role
The role is to support the IRO by providing analysis, technical support and reporting services to facilitate its smooth running in alignment with the overall business and strategic requirements of the Office of the Independent Review Officer.
We are seeking a motivated and resilient person to join our team, someone to lead the design and implementation of conceptual, logical, and physical data models across IRO’s analytics platform (Databricks / Snowflake / Power BI). Convert complex operational systems - particularly Resolve (EAV) - into governed, scalable, high‑performance analytical datasets that support BAU reporting, dashboards, and future analytics needs.
The Senior Data Modeller plays a critical role in supporting the Independent Review Office (IRO) by designing and implementing high‑quality conceptual, logical and physical data models that underpin reliable insights, statutory reporting and continuous improvement across the organisation.
Working within the Systems & Support team, the role leads the modelling, structuring and governance of data across IRO’s cloud analytics environment (Databricks, Snowflake, Power BI). You will translate complex operational systems - including Resolve’s EAV structures - into trusted, scalable and analytics‑ready data assets that directly support IRO’s statutory functions: resolving complaints, administering ILARS, and informing inquiries into NSW workers’ compensation and motor accident schemes.
This role is ideal for someone who is technically strong, collaborative, and motivated to shape IRO’s enterprise data foundations. You will ensure that curated datasets, metadata, quality rules and lineage are robust, well‑documented and fit for purpose, enabling the organisation to deliver accurate insights, optimise service delivery and improve outcomes for injured people.
Key Accountabilities
-
Lead the creation, optimisation and maintenance of conceptual, logical and physical data models to meet IRO’s business, statutory and analytics requirements.
-
Establish and maintain data modelling standards, including naming conventions, patterns, keys, and conformed dimensions.
-
Lead the transformation of Resolve EAV structures into normalised, analytics‑ready models.
-
Define and document data mappings from Resolve, ILARS Payments (SAP), Genesys, and GA into curated models, including lineage and business glossaries.
-
Identify and resolve data lineage and data quality issues across upstream and curated layers.
-
Specify reconciliation and data quality rules, embedding these into data pipelines.
-
Partner with governance and security to ensure domain models support RBAC and privacy‑by‑design controls.
-
Optimise models for dashboard performance and self‑service analytics; support analysts in best‑practice usage.
Essential Experience
- Proven ability to design and deliver enterprise‑grade data models in cloud data warehouses (preferably Snowflake) and Databricks/Delta‑based pipelines.
-
Demonstrated senior‑level expertise converting complex operational systems - specifically EAV or schema‑light platforms (e.g., Resolve - into normalised, high‑performance analytical models suitable for enterprise reporting and analytics.
-
Significant experience embedding data quality, reconciliation rules, and modelling standards into data pipelines and delivering models that support security, RBAC and privacy‑by‑design.
-
Experience designing curated layers, semantic datasets, and materialised views with strong metadata, governance, and lineage practices.
-
Strong Power BI experience, including optimising datasets for reporting and analytical workloads.
-
Experience providing technical leadership in data modelling, including reviewing others’ models, setting modelling standards, and mentoring analysts or data engineers..
What we need from you:
To start your journey towards joining our team please click on the link below and attach your resume (max 5 pages) and cover letter (max 2 pages).
A talent pool may be created from this recruitment process to fill future ongoing and temporary opportunities.
Applicants invited for interview will be required to complete additional assessments
The Organisation
The IRO is an independent statutory office established under the Personal Injury Commission Act 2020. Samantha Taylor PSM is the Independent Review Officer. The Officer is supported by an expert team.
The statutory functions of the IRO include to:
-
find solutions for persons injured at work or in motor vehicle accidents with complaints about their insurers;
-
manage and administer the Independent Legal Assistance and Review Service (ILARS)
-
conduct inquiries into matters arising in connection with the operation of the Personal Injury Commission Act 2020 and the workers’ compensation and motor vehicle accident legislation.
For more information about the IRO
Salary Grade 9/10, with the base salary for this role starting at $129464 base plus superannuation
For enquiries relating to recruitment please contact Meg Rapley via
[email protected].
Visit the Capability Application Tool to prepare for the recruitment process by accessing practice application and interview questions based on the focus capabilities listed in the role description.
Closing Date: Thursday 18 June 2026 at 9:59am
Careers at Department of Customer Service
A career at the Department of Customer Service (DCS) gives you the opportunity to help improve government services and be part of reform that benefits people across NSW. We are focused on delivering excellent customer service, digital transformation, and regulatory reform. Come join us and influence the future of our great state.
Belong in our diverse and inclusive workplace
The strength of our workforce lies in its diversity and embracing difference, while the key to our success is leveraging the contributions of employees with different backgrounds and perspectives.
You can view our full diversity and inclusion statement here.
We want you to bring your best self to this application process. If you have any support or access needs that may require adjustments to allow you to fully participate in this selection process (including an alternate format of the application form) please contact
[email protected] or 02 9494 8351.
For more information, please visit
Information on some of the different types of disabilities
Information on adjustments available for the recruitment process
