Lead Enterprise Data Modeller - Semantic Models & Analytics

Softtest pays pty ltd; Brisbane; On-site; AUD 110,000 - 150,000; Full time

Job summary

Softtest pays pty ltd in Australia invites applications for an EL1 Data Modeller who will lead enterprise data modelling across multiple projects and initiatives. You will work with architects, engineers, analysts and business stakeholders to drive best practice data modelling, governance and design for the agency’s data platform.

The role focuses on semantic models, data quality, KPIs and analytics capability, and requires strong collaboration with data engineering and reporting teams to ensure

Qualifications

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
• Translate business requirements into logical, dimensional and semantic data models.
• Collaborate with business stakeholders and data architects to understand business requirements and translate them into logical, dimensional and semantic data models.

Responsibilities

• Lead the design and governance of enterprise semantic models, certified datasets, KPIs, and business metrics.
• Engage with business stakeholders and data architects to understand business requirements and translate them into logical, dimensional and semantic data model.
• Design and develop enterprise grade dimensional models using start schema principles, including fact tables, dimensions, relationships, hierarchies and appropriate data granularity.
• Develop and optimise analytical data models within data warehouse, including presentation layer tables, views and SQL transformations to support semantic model requirements.
• 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, resolve data modelling challenges and ensure data is structured appropriately for analytical consumption.
• Optimise semantic model performance including relationships, cardinality, filter propagation and underlying database query performance.
• Work closely with reporting and analytics teams to enable consumption of governed semantic models without duplicating business logic across individual reports.

Skills

Data modelling

Data governance

SQL

Data warehousing

Job description

Softtest pays pty ltd in Australia invites applications for an EL1 Data Modeller who will lead enterprise data modelling across multiple projects and initiatives. You will work with architects, engineers, analysts and business stakeholders to drive best practice data modelling, governance and design for the agency’s data platform.

The role focuses on semantic models, data quality, KPIs and analytics capability, and requires strong collaboration with data engineering and reporting teams to ensure