Senior Data Modeler - Databricks Gold/Silver Architect

Intelligen Group; Sydney; On-site; AUD 150,000 - 210,000; Full time

Benefits offered by this job

Grow With Purpose

Structured development pathways, paid

Support That Helps You Thrive

A Community You’ll Enjoy Being Part Of

Job summary

Intelligen is seeking a Senior Data Modeler to turn complex requirements into scalable data models and to own the design of Silver and Gold layer datasets in Databricks. You will work with data engineers and stakeholders, define grain, keys, and business rules, and apply Kimball or Data Vault methods to deliver production-ready models in a fast-paced environment.

Join Intelligen to help build trusted reporting and analytics foundations, with opportunities to influence data strategy and

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.
• Strong dimensional modelling knowledge, including grain, facts, dimensions, keys and slowly changing dimensions.

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 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.
• 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.
• 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.
• 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.

Skills

Databricks

SQL

Data modelling

Kimball

Data Vault

Tools

Databricks

Python

PySpark

SAP

Job description

Intelligen is seeking a Senior Data Modeler to turn complex requirements into scalable data models and to own the design of Silver and Gold layer datasets in Databricks. You will work with data engineers and stakeholders, define grain, keys, and business rules, and apply Kimball or Data Vault methods to deliver production-ready models in a fast-paced environment.

Join Intelligen to help build trusted reporting and analytics foundations, with opportunities to influence data strategy and