Senior Data Modeler: Databricks Gold/Silver Models

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

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.