Enterprise Data Modeller & Analytics Engineer

Davidson; City of Brisbane; On-site; AUD 120,000 - 140,000; Full time

Job summary

Davidson is seeking a Data Specialist to own and advance a modern Microsoft data environment in Brisbane. The role focuses 70–80% on data modelling and problem solving, with Power BI reporting taking a balanced portion.

You will work across data lifecycle, integrating data from multiple systems to create trusted, enterprise datasets. You will design dimensional models, build semantic layers, and optimize queries while collaborating with SMEs and applying DevOps practices in a modern data

Qualifications

• Advanced SQL development and query optimisation.
• Strong dimensional and semantic modelling experience.
• Experience integrating data from multiple source systems.
• Power BI reporting and semantic modelling experience.

Responsibilities

• Designing dimensional models, star schemas, facts and dimensions.
• Building trusted semantic models for enterprise reporting.
• Developing complex SQL queries and reusable data structures.
• Ingesting and transforming data from multiple sources.
• Collaborating with SMEs to understand data behaviour.
• Supporting CI/CD practices and source control.

Skills

Advanced SQL

Dimensional modelling

Power BI & DAX

Data reconciliation & quality

Stakeholder engagement

Data warehousing

Tools

Azure Data Factory

Data Vault

Python/PySpark

Git / DevOps

Job description

Davidson is seeking a Data Specialist to own and advance a modern Microsoft data environment in Brisbane. The role focuses 70–80% on data modelling and problem solving, with Power BI reporting taking a balanced portion.

You will work across data lifecycle, integrating data from multiple systems to create trusted, enterprise datasets. You will design dimensional models, build semantic layers, and optimize queries while collaborating with SMEs and applying DevOps practices in a modern data