Lead Data Modeller: Enterprise Semantic Modeling

Softtest pays pty ltd; Sydney; On-site; AUD 120,000 - 150,000; Full time

Job summary

Softtest pays pty ltd is seeking an EL1 Data Modeller to lead enterprise data modelling activities across multiple projects. The role collaborates with architects, engineers, analysts and business stakeholders to drive best practice data modelling, governance and design for a modern data platform and analytics capability.

The role will design, develop and maintain semantic models, KPI calculations and data structures within the data warehouse, ensuring governance and performance standards are

Responsibilities

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
• Engage with business stakeholders and data architects to translate requirements into logical, dimensional and semantic data models.
• Design and develop enterprise grade dimensional models using star schema principles, including fact tables, dimensions, relationships, hierarchies and data granularity.
• Develop and optimise analytical data models within data warehouse, including presentation layer tables, views and SQL transformations.
• Design, develop and maintain reusable and scalable semantic models in BI tools to support enterprise reporting and analytics.
• Define and implement business measures, KPIs, calculations and reusable business logic.
• Collaborate with data engineering teams to identify source data requirements and resolve modelling challenges for analytical consumption.
• Optimise semantic model performance including relationships, cardinality, filter propagation and query performance.
• Work with reporting and analytics teams to enable consumption of governed semantic models without duplicating logic across reports.

Skills

Data modelling

Stakeholder collaboration

SQL

Data governance

BI tools

Job description

Softtest pays pty ltd is seeking an EL1 Data Modeller to lead enterprise data modelling activities across multiple projects. The role collaborates with architects, engineers, analysts and business stakeholders to drive best practice data modelling, governance and design for a modern data platform and analytics capability.

The role will design, develop and maintain semantic models, KPI calculations and data structures within the data warehouse, ensuring governance and performance standards are