Senior Data Modeller: Enterprise Modeling & Governance

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

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.