Lead Data Modeller

Aurec; Canberra; On-site; AUD 150,000 - 190,000; Full time

Job summary

Aurec is seeking a Senior Enterprise Data Architect to lead data modelling, governance and architecture across high-impact federal programs in Canberra. You will partner with architects, data engineers and executives to build a scalable analytics platform delivering nationwide outcomes.

You will drive semantic models, star schemas and metadata governance while translating complex business logic into robust data structures for enterprise reporting.

Qualifications

• Proven track record delivering enterprise data models in large-scale environments.
• Strong ability to translate business logic into robust data models.
• Experience with governance frameworks and metadata management.
• Senior/lead level engagement with stakeholders and executives.
• Background in regulated environments or government programs is advantageous.

Responsibilities

• Lead architecture, design, and governance of enterprise semantic models and KPI datasets.
• Collaborate with business leaders to convert complex logic into scalable data models.
• Design scalable star schema solutions with fact and dimension tables.
• Engineer SQL and presentation layer objects in cloud data platforms for performance.
• Create reusable semantic layers in BI tools enabling accurate self-service reporting.
• Align with data engineering to resolve data source requirements and optimize queries.

Skills

Snowflake

Advanced SQL

Dimensional Modelling

Star Schema

Power BI

Data Governance

Metadata Management

Stakeholder Facilitation

Enterprise Data Modelling

Communication with Execs

Tools

Erwin

AWS

Databricks

Redshift

MS Fabric

Job description

An opportunity to take a strategic lead in shaping enterprise data modelling, governance, and architecture across high-impact initiatives within a major Federal Government environment.
You could collaborate closely with architects, data engineers, and executive stakeholders to build a modern, high-performance data analytics platform delivering critical outcomes nationwide.

Role & Responsibilities

• Drive the architecture, design, and governance of enterprise semantic models, certified datasets, key metrics, and enterprise KPIs.

• Partner with business leaders and technical architects to convert intricate business logic into robust logical, physical, dimensional, and semantic data models.

• Design scalable, enterprise-grade star schema solutions, encompassing fact and dimension tables, relationships, hierarchies, and appropriate data granularity.

• Engineer presentation layer tables, views, and complex SQL transformations within cloud data platforms to maximise performance and analytics consumption.

• Build reusable semantic layers within enterprise BI tools, eliminating metric duplication and enabling accurate self-service reporting across the organisation.

• Align with data engineering teams to define source data requirements, resolve integration challenges, and tune database query performance and filter propagation.

Skills & Experience Required

• Deep proficiency with Snowflake, advanced SQL, enterprise data modelling tools (e.g., Erwin), dimensional modelling/star schema techniques, and modern BI tools such as Power BI.

• Exposure to AWS, Databricks, MS Fabric, or Redshift is highly regarded.

• Demonstrated senior/lead track record delivering enterprise data models within complex, large-scale data environments, with robust knowledge of metadata management, data governance frameworks, and normalisation standards.

• Exceptional stakeholder facilitation and communication skills, with a proven ability to lead technical workshops and translate sophisticated architectural concepts for non-technical stakeholders.

• Experience supporting large-scale transformation programs in Australian Government or regulated environments is strongly advantageous.

Eligibility & Clearance Requirements

• Location avaliable: CBR, NSW, QLD or VIC

• Security Clearance: Candidates must hold a current NV1 security clearance to apply.