Lead Data Modeller

Recruitment Hive; Canberra; Presencial; AUD 120.000 - 180.000; Jornada completa

Descripción de la vacante

The Recruitment Hive Pty Ltd is recruiting for a Commonwealth Government organisation in Canberra for a Lead Data Modeller. You will lead enterprise semantic models, governance, and KPI design to empower strategic decision making across government programs.

Collaborate with data architects to translate business requirements into dimensional and semantic models, develop Snowflake-based data warehouse designs, perform complex SQL transformations, and deliver BI-ready presentation layers.

Formación

• Lead enterprise data modelling activities in large, complex environments.
• Translate business requirements into logical, physical and semantic models.
• Work with Snowflake, SQL transformations and validation against business metrics.
• Proficient in ER modelling and data governance standards.

Responsabilidades

• Lead the design and governance of enterprise semantic models, datasets, KPIs, and metrics.
• Collaborate with stakeholders and data architects to capture requirements and model accordingly.
• Design and develop enterprise dimensional models using star schema principles.
• Develop analytical data models in the data warehouse with presentation layers and SQL transforms.
• Maintain reusable semantic models in BI tools to support enterprise reporting.

Conocimientos

Enterprise data modelling

Stakeholder engagement

Snowflake

SQL transformations

Power BI

ER modelling

Herramientas

ERWIN

Descripción del empleo

Our client, a Commonwealth Government organisation whose focus is to provide support to Australian's living with disability, require the services of Lead Data Modeller.

Duties of the Lead Data Modeller:

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
• Engage with business stakeholders and data architects to understand business requirements and translate them into logical, dimensional and semantic data model.
• Design and develop enterprise grade dimensional models using start schema principles, including fact tables, dimensions, relationships, hierarchies and appropriate data granularity.
• Develop and optimise analytical data models within data warehouse, including presentation layer tables, views and SQL transformations to support semantic model requirements.
• Design, develop and maintain reusable and scalable semantic models in BI tools to support enterprise reporting and analytics.

Skills and Experience

• Extensive experience leading enterprise data modelling activities within large and complex data environments, with a strong understanding of enterprise data modelling principles, naming conventions, metadata management, model documentation and governance standards.
• Proven ability to analyse complex business requirements, identify business entities, relationships, measures, KPIs and dimensions, and translate these into logical, physical and semantic data models.
• Strong hands-on experience designing and developing analytical data models in Snowflake, including presentation layer design, complex SQL transformations, query optimisation, and validation of semantic models against business requirements to ensure accuracy and consistency of business metrics.
• Demonstrated proficiency in data modelling tools and techniques, including ER modelling, dimensional modelling, data normalisation, and the use of ERWIN or equivalent modelling tools.
• Extensive experience architecting and developing scalable semantic data models that support self-service reporting, analytics and business intelligence solutions, including Power BI and similar platforms.

Job ID 680667 | LH-08399

We Value Diversity

The Recruitment Hive is a proud Equal Opportunity Employer. We recognise the value of diverse perspectives and experience and are committed to an inclusive workplace where everyone feels valued and respected for who they are. We encourage people with disability, indigenous, veterans and people of all backgrounds and abilities to express their interest in this role.

Be careful - Don’t provide your bank or credit card details when applying for jobs. Don't transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad .