Data Modeler - Construction

Mirvac; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

Mirvac is seeking a Data Modeler to design and maintain scalable data models for analytics, reporting, self-service BI, and AI-driven insights across the organisation.

You will work with Data Engineers and business stakeholders to ensure data assets are reliable and aligned with data strategy, employing Kimball and other modelling methods.

Qualifications

• Construction industry experience is essential.
• 5+ years in Database Design, Integration & Dimensional Modelling.
• 5+ years of Power BI experience, EDW (Snowflake or MS Fabric) & ETL tools.

Responsibilities

• Design and maintain conceptual, logical, and physical data models aligned with enterprise standards.
• Develop dimensional models including fact and dimension tables.
• Build enterprise semantic layers for consistent reporting and analytics.
• Develop Power BI datasets, measures, DAX calculations, and row-level security.
• Collaborate with stakeholders to define metrics and reporting definitions.
• Support data governance, data quality, and metadata management initiatives.
• Contribute to cloud data warehousing and AI-enabled analytics initiatives.

Skills

Power BI

SQL

Data modelling

Agile delivery

Stakeholder engagement

Education

Bachelor's degree in IT / CS / Engineering

Tools

Snowflake

Azure Synapse

SQL Server

Matillion / ADF

MS Fabric

Job description

More than 50 years ago a foundation was laid, with a vision for the future. To re-imagine the environments where Australians would live, work and grow. In this time,Mirvac has evolved from a small joint venture to a thriving ASX-listed property group, leading in sustainability, innovation, safety, and placemaking.

At Mirvac, we know thatit’sour people, their passion andexpertiseand the exceptional experiences we create for our audience, that defines us.

The opportunity

The purpose of the Data Modeler role is to design and maintain scalable, trusted, and business-aligned enterprise data models that support analytics, reporting, self-service BI, and AI-driven insights across Mirvac.

This position works under the guidance of Senior Data Modelers and Data Engineers, who provide architectural direction, complex design support, and technical oversight where required. The role is expected to operate independently on well-defined modelling tasks while escalating complex design or platform challenges to senior team members.

Working closely with Data Engineers, Senior Modelers, and business stakeholders, the Data Modeler ensures enterprise data assets are reliable, accessible, and aligned with organisational data strategy.

Key responsibilities include:

Data Modelling & Architecture

• Design and maintain conceptual, logical, and physical data models aligned with enterprise architecture standards.
• Develop dimensional models including fact and dimension tables using Kimball and/or other enterprise modelling methodologies.
• Ensure data models are scalable, performant, reusable, and aligned with business requirements.
• Work closely with Data Engineers and Modelers to support ingestion, transformation, and integration of data into enterprise platforms.
• Maintain metadata, data lineage, business definitions, and modelling documentation.
• Support data governance, data quality, and master data management initiatives.

Semantic Layer Development

• Design, develop, and optimise enterprise semantic layers to support consistent reporting and analytics.
• Build reusable business measures, KPIs, calculations, hierarchies, and business-friendly data structures.
• Ensure semantic models are performant, scalable, and aligned with business terminology.
• Collaborate with stakeholders to define and standardise enterprise metrics and reporting definitions.
• Support semantic layer optimisation for AI and Copilot-enabled analytics capabilities

Power BI Modelling & Reporting Support

• Develop and optimise Power BI datasets and reporting structures.
• Create and maintain relationships, measures, DAX calculations, aggregations, and row-level security.
• Work with business users to support self-service analytics capabilities.
• Optimise Power BI model performance, refresh strategies, and usability.
• Support governance and best practices for enterprise Power BI implementations

Stakeholder Engagement

• Collaborate with business stakeholders to gather and refine data and reporting requirements.
• Translate business concepts into scalable analytical data structures.
• Provide technical guidance and support to analysts and reporting teams.
• Participate in workshops, solution design sessions, and project delivery activities.

Continuous Improvement

• Contribute to enterprise data standards, frameworks, and best practices.
• Identify opportunities to improve data modelling, semantic layer design, and reporting performance.
• Support modern data platform initiatives including cloud data warehousing and AI-enabled analytics

About you

We are seeking a Data Modeler with proven experience in the Construction industry, bringing a strong understanding of construction project, operational and commercial data, and the ability to translate complex business requirements into scalable data solutions.

You will have:

• Prior experience in Construction is essential
• 5+ years of Database Design, Integration & Dimensional Modelling
• 5+ years of experience in PowerBI (essential), EDW (Snowflake or MS Fabric) & ETL tool (Matillion, ADF or similar cloud tools)
• Bachelor’s degree in information technology, Computer or Data Science, Engineering, or related discipline.
• Relevant industry certifications in Data Analytics, Power BI, Cloud Platforms, or Data Management are desirable
• Proven experience in enterprise data modelling and analytics environments.
• Strong experience designing dimensional data models for reporting and analytics.
• Hands-on experience with semantic layer development and enterprise BI modelling.
• Strong Power BI experience including dataset modelling, DAX, performance optimisation, and security.
• Experience working with cloud data platforms such as Snowflake, Azure Synapse, SQL Server, or similar technologies.
• Strong SQL development and data analysis skills.
• Experience working in Agile delivery environments.
• Strong stakeholder engagement and communication skills.
• Ability to simplify complex data concepts for business users.
• Strong analytical and problem-solving capability.