Lead Data Modeller

DFP Recruitment; Melbourne; Sur place; AUD 130 000 - 190 000; Plein temps

Résumé du poste

DFP Recruitment is seeking a Lead Data Modeller to drive enterprise data modelling initiatives across a range of projects and strategic programs. You will lead the design, governance and optimisation of data models that support modern data platforms, reporting and analytics capabilities.

You will collaborate with architects, engineers and stakeholders to translate requirements into robust semantic models and scalable data solutions.

Qualifications

• Extensive experience leading enterprise data modelling in large, complex environments.
• Ability to translate business requirements into logical, physical and semantic models.
• Proven proficiency with dimensional modelling, ERWIN and Snowflake.
• Strong data governance, metadata management and model documentation skills.

Responsabilités

• Lead design and governance of enterprise semantic models, datasets, KPIs and business metrics.
• Translate business requirements to logical, dimensional and semantic models with stakeholders.
• Develop enterprise-grade dimensional models using star schemas, facts, dimensions and relationships.
• Create and optimise analytical data models in the data warehouse with SQL transformations.
• Develop reusable semantic models in BI tools to support enterprise reporting.
• Define business measures, KPIs and reusable logic.
• Collaborate with data engineering to source data and ensure analytical readiness.
• optimise model performance and query efficiency.
• Enable consumption of governed semantic models without duplicating logic in reports.

Connaissances

Enterprise data modelling

SQL

Stakeholder engagement

Data governance

Dimensional modelling

Data architecture

Outils

Snowflake

ERWIN

Power BI

Description du poste

• Position is available in: QLD, ACT, VIC, NSW
• Australian Citizenship Required

DFP Recruitment is seeking a Lead Data Modeller to drive enterprise data modelling initiatives across a range of projects and strategic programs. Working closely with architects, engineers, analysts and business stakeholders, you will lead the design, governance and optimisation of data models that support modern data platforms, reporting and analytics capabilities. This role plays a key part in establishing best-practice data standards, ensuring data quality and enabling scalable, data-driven decision-making across the organisation.

Key duties and 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.

Essential criteria

• Extensive experience leading enterprise data modelling activities within large and complex data environments, with a strong understanding of enterprise data modelling principles, naming conventions, metadata management, model documentation and governance standards.
• Proven ability to analyse complex business requirements, identify business entities, relationships, measures, KPIs and dimensions, and translate these into logical, physical and semantic data models.
• Strong hands-on experience designing and developing analytical data models in Snowflake, including presentation layer design, complex SQL transformations, query optimisation, and validation of semantic models against business requirements to ensure accuracy and consistency of business metrics.
• Demonstrated proficiency in data modelling tools and techniques, including ER modelling, dimensional modelling, data normalisation, and the use of ERWIN or equivalent modelling tools.
• Extensive experience architecting and developing scalable semantic data models that support self-service reporting, analytics and business intelligence solutions, including Power BI and similar platforms.
• Excellent stakeholder engagement, communication and facilitation skills, with the ability to conduct workshops, collaborate across technical and business teams, and present complex technical concepts to senior stakeholders.

Desirable criteria

• Experience working with cloud data platforms including AWS, Databricks, Snowflake, MS Fabric, Redshift or similar technologies.
• Experience supporting enterprise architecture, data strategy or large-scale data transformation programs.
• Knowledge of data governance, metadata management, master data management and data quality frameworks.
• Previous experience working within the Australian Government or other highly regulated environments.

Applicants new to DFP may be asked to provide additional information including work rights status via a survey link – if requested, we ask that you provide this information in order to expedite your application.

DFP welcomes applications from Aboriginal and Torres Strait Islander people, people with diverse cultural and linguistic backgrounds and people with disability. In addition, DFP will provide reasonable adjustments for individuals with disability throughout the recruitment process. If you identify as a person with disability and require adjustments to the application, recruitment, selection and/or assessment process, please advise [e-mail]1300 337 000and indicate your preferred method of communication (email, phone, text) so we can keep in touch and meet your accessibility needs.

By clicking 'apply', you give consent that DFP may use your personal information to process your job application and to contact you for future employment opportunities. For further information on how DFP process your personal information please review the DFP Information Collection and Privacy Policy via https://www.dfp.com.au/legal_documents/privacy_policy.Do not submit any sensitive personal information in your resume.