Lead Enterprise Data Modeller

Softtest Pays Pty; New South Wales; On-site; AUD 120,000 - 150,000; Full time

Job summary

Softtest Pays Pty in Australia seeks an EL1 Data Modeller to lead enterprise data modelling across multiple projects, collaborating with architects, engineers and analysts to design semantic models, govern data and enable analytics across the organisation.

The role focuses on star-schema dimensional modeling, KPI definitions, and scalable data structures for a modern data platform. Strong stakeholder engagement is essential for success.

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.
• Design and develop enterprise-grade dimensional models using star schema principles, including fact tables, dimensions, relationships, hierarchies and appropriate data granularity.

Responsibilities

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

Skills

Reports

Performance Analysts

Data Support

Database Calculations

Data Engineering

Architects

Business Requirements

Metrics

Analytics

Design Engineering

Business

SQL

Job description

Softtest Pays Pty in Australia seeks an EL1 Data Modeller to lead enterprise data modelling across multiple projects, collaborating with architects, engineers and analysts to design semantic models, govern data and enable analytics across the organisation.

The role focuses on star-schema dimensional modeling, KPI definitions, and scalable data structures for a modern data platform. Strong stakeholder engagement is essential for success.