Data Modeller

XPT Software Australia; Sydney; On-site; AUD 110,000 - 160,000; Full time

Job summary

XPT Software Australia is seeking a Data Modeller to design and develop project data models aligned to the Enterprise information model, across conceptual, logical, and physical layers. You will contribute to data modelling standards and govern data model delivery within project teams.

The role requires strong experience with Erwin and Azure cloud platforms, plus collaboration with analysts, engineers, and developers to implement scalable data architectures.

Qualifications

• Bachelor’s degree in computer science or equivalent with experience delivering data models for analytics projects.
• Certification or proven experience in data architecture/modelling using industry models.
• Strong knowledge of data warehousing concepts and modeling techniques (Kimball, Data Vault).
• Experience leading data modelling delivery and coordinating with stakeholders across teams.

Responsibilities

• Design and develop project data models at conceptual, logical, and physical levels.
• Develop and maintain data modelling standards and governance.
• Collaborate with business analysts, data engineers, and developers to refine data models.

Skills

Logical Data Models

Physical Data Models

Dimension Models

Data Vault

Kimball

Data governance

Requirements gathering

Stakeholder collaboration

Education

Bachelor's degree in Computer Science

Data architecture certification

Tools

Erwin Data Modeler

Azure

Job description

Data Modeller

Job description:

The purpose of this role is to design and develop project data models that meet organizational needs and that is aligned to Enterprise information model using conceptual, logical, and physical data models.

This role will contribute to the development and management of project and enterprise data model, data modelling standards and processes, applying them in the project delivery process to comply with Enterprise data policies and guidelines.

Experience

• Sound experience in a data modeller and/or similar role and significant years of experience in IT
• Solid experience leading the creation of data model and managing the project data modelling delivery
• Demonstrated experience in Azure or other cloud-based data and analytics data platform
• Proven experience and competency in use of Erwin as the data modelling tool.
• Broad expertise across data modelling capabilities, principles and policies.

Skills

• Extensive understanding of Logical Data Models, Physical Data Models and Dimension Models and ability to deliver Logical Models and Physical Designs.
• Intimate knowledge of data warehousing with respect to various data methodologies, such as Data Vault, 3rd Normal Form, Kimball.
• Strong knowledge and experienced on industry reference data model e.g., Teradata-FSLDM, IBM-Industry financial or utilities model (or any other industry reference model) and have used industry data model to deliver data model for a company.
• A deep understanding and experience of enterprise modern data architecture patterns and processes
• Good understanding in creation and management of data management principles, data modelling and data naming standards.
• Suitable understanding of data ingestion, data consumption, data access & authorisation, ETL design and framework knowledge.
• Clear written and verbal communications; able to communicate with a wide range of people and to gather requirements, analytics use cases.
• Collaborating with stakeholders, including business analysts, data engineers, and developers to gather requirements refine data models.

Additional Notes

• Adaptability in working in multiple industry segments with utilities industry being a preference
• Self-starter who can deal with organisational ambiguity
• Collaborative and constructive with strong communication and stakeholder management skills
• Highly proactive with exceptional integrity, professionalism efficiency and accuracy
• Creativity and a passion for discovering and adopting new ways of working

Qualifications, Licences, And Certifications

• Bachelor’s Degree in computer science or equivalent with demonstrated experience in delivery of data model and design for Data and analytics project delivery.
• Either certification or proven experience in data architecture / modelling using Industry model.