Senior Data Modeller

Intelligen Pty Ltd; Sydney; On-site; AUD 150,000 - 190,000; Full time

Benefits offered by this job

Grow With Purpose

Structured development pathways

Weekly knowledge sharing

360° feedback

Job summary

Intelligen Pty Ltd is seeking a Senior Data Modeler to shape enterprise data models within Databricks. You will profile source data, design Silver and Gold-layer models, and own modelling decisions across grain, keys, relationships and business rules to ensure quality and scalable solutions.

The role requires strong SQL skills, experience with Kimball/Data Vault, and the ability to translate complex requirements into concrete modelling outputs.

Qualifications

• 4-5 years’ enterprise data modelling experience across conceptual, logical and physical models.
• Recent production Databricks experience, including designing and physically implementing Silver and Gold-layer tables.
• Advanced SQL for transformation, profiling, validation and performance tuning.
• Practical experience applying Kimball and/or Data Vault approaches.
• Strong understanding of data integration, data quality, data warehousing and lakehouse architecture.
• Strong stakeholder management and ability to work independently in a fast-paced environment.

Responsibilities

• Develop conceptual, logical and physical data models across enterprise data products.
• Work directly in Databricks to profile data and design Silver and Gold-layer models.
• Define grain, keys, relationships, facts, dimensions, business rules and data-quality controls.
• Write and optimize SQL to physically build, validate and tune tables.
• Apply Kimball and/or Data Vault approaches while maintaining consistent modelling standards and documentation.
• Work with Data Engineers to ensure models are implemented correctly and are scalable, reusable and production-ready.

Skills

Data modelling

SQL

Databricks

Stakeholder management

Analytical thinking

Tools

Kimball

Data Vault

PySpark

Job description

At Intelligen, we’re building something different. Over the past three years, we’ve evolved from a bold startup to a trusted partner for some of Australia’s most complex data transformations. We’ve helped organizations move from legacy to modern platforms, embedded governance into decision-making, and brought AI into the hands of the business, responsibly and at speed.

As we continue to grow, we’re expanding our consulting team with senior data specialists who can help clients create clear, scalable data structures that support trusted reporting, analytics and decision-making.

We’re looking for a Senior Data Modeler who can step in quickly, bring structure to complex information and develop models that work in practice.

This is not a traditional data modelling role focused only on producing diagrams and specifications. You will work directly in Databricks to profile source data, design and prototype Silver and Gold-layer models, write SQL and physically build and validate tables. You will own modelling decisions covering grain, keys, relationships, dimensional structures, data quality and business rules.

This is a senior role for someone who combines strong technical judgement with the confidence to work through ambiguity and make an immediate impact.

This role is ideal for someone who can:

• Turn complex requirements into clear, scalable data models
• Must design and implement, not hand models to engineers
• Build trust with stakeholders and keep delivery moving

Key Responsibilities

• Develop conceptual, logical and physical data models across enterprise data products.
• Work directly in Databricks to profile data and design Silver and Gold-layer models.
• Define grain, keys, relationships, facts, dimensions, business rules and data-quality controls.
• Write and optimize SQL to physically build, validate and tune tables.
• Apply Kimball and/or Data Vault approaches while maintaining consistent modelling standards and documentation.
• Work with Data Engineers to ensure models are implemented correctly and are scalable, reusable and production-ready.

Stakeholder Leadership & Delivery

• Explain and defend design decisions to business, engineering, architecture and governance stakeholders
• Facilitate modelling workshops with business and technical stakeholders
• Translate ambiguous requirements into clear modelling recommendations
• Must operate autonomously within supplied standards and patterns

Requirements

• 4-5 years’ enterprise data modelling experience across conceptual, logical and physical models.
• Recent production Databricks experience, including designing and physically implementing Silver and Gold-layer tables.
• Advanced SQL for transformation, profiling, validation, reconciliation and performance tuning.
• Practical experience applying Kimball and/or Data Vault approaches.
• Strong understanding of data integration, data quality, data warehousing and lakehouse architecture.
• Strong stakeholder management and the ability to work independently in a fast-paced environment.

ABOUT US

At Intelligen, we’re building something different. Over the past three years, we’ve evolved from a bold startup to a trusted partner for some of Australia’s most complex data transformations. We’ve helped organizations move from legacy to modern platforms, embedded governance into decision-making, and brought AI into the hands of the business, responsibly and at speed.

As we continue to grow, we’re expanding our consulting team with senior data specialists who can help clients create clear, scalable data structures that support trusted reporting, analytics and decision-making.

We’re looking for a Senior Data Modeler who can step in quickly, bring structure to complex information and develop models that work in practice.

This is not a traditional data modelling role focused only on producing diagrams and specifications. You will work directly in Databricks to profile source data, design and prototype Silver and Gold-layer models, write SQL and physically build and validate tables. You will own modelling decisions covering grain, keys, relationships, dimensional structures, data quality and business rules.

This is a senior role for someone who combines strong technical judgement with the confidence to work through ambiguity and make an immediate impact.

This role is ideal for someone who can:

• Turn complex requirements into clear, scalable data models
• Must design and implement, not hand models to engineers
• Build trust with stakeholders and keep delivery moving

Key Responsibilities

• Develop conceptual, logical and physical data models across enterprise data products.
• Work directly in Databricks to profile data and design Silver and Gold-layer models.
• Define grain, keys, relationships, facts, dimensions, business rules and data-quality controls.
• Write and optimize SQL to physically build, validate and tune tables.
• Apply Kimball and/or Data Vault approaches while maintaining consistent modelling standards and documentation.
• Work with Data Engineers to ensure models are implemented correctly and are scalable, reusable and production-ready.

Stakeholder Leadership & Delivery

• Explain and defend design decisions to business, engineering, architecture and governance stakeholders
• Facilitate modelling workshops with business and technical stakeholders
• Translate ambiguous requirements into clear modelling recommendations
• Must operate autonomously within supplied standards and patterns

Requirements

• 4-5 years’ enterprise data modelling experience across conceptual, logical and physical models.
• Recent production Databricks experience, including designing and physically implementing Silver and Gold-layer tables.
• Advanced SQL for transformation, profiling, validation, reconciliation and performance tuning.
• Strong dimensional modelling knowledge, including grain, facts, dimensions, keys and slowly changing dimensions.
• Practical experience applying Kimball and/or Data Vault approaches.
• Strong understanding of data integration, data quality, data warehousing and lakehouse architecture.
• Strong stakeholder management and the ability to work independently in a fast-paced environment.

Highly Desirable

• Utilities or energy-sector experience.
• SAP or enterprise ERP knowledge.
• Python or PySpark experience.

Benefits

At Intelligen, we care about how we deliver, not just what we deliver. You’ll join a smart, kind and ambitious team where curiosity, ideas and practical impact are valued.

• Grow With Purpose
• Structured development pathways, paid certifications and weekly knowledge sharing.
• Support That Helps You Thrive
• A dedicated support lead and regular 360° feedback to guide your development.
• A Community You’ll Enjoy Being Part Of
• Innovation days, team events and opportunities to shape our growing practice.