Data Modeller

Xpt Software Australia Pty; Sydney; On-site; AUD 110,000 - 170,000; Full time

Job summary

Xpt Software Australia Pty is seeking a skilled Data Modeller to design and develop project data models aligned with the Enterprise information model. You will contribute to data modelling standards and collaborate with business analysts, data engineers and developers to meet organizational needs.

The ideal candidate has strong experience in logical/physical/dimensional modeling, data warehousing concepts and industry reference models, plus hands-on Erwin and cloud platform familiarity.

Qualifications

• Bachelor’s degree in computer science or equivalent with data model delivery experience.
• Experience leading data model creation and delivery across projects.
• Familiarity with cloud-based data platforms (Azure or equivalent).
• Proficient in industry reference data models and data governance.

Responsibilities

• Design and develop project data models aligned to Enterprise information model.
• Contribute to data modelling standards, processes and best practices.
• Collaborate with analysts, engineers and stakeholders to refine requirements.

Skills

Logical Data Models

Physical Data Models

Dimension Models

Data Warehousing

Industry reference data model

Erwin

Azure

Data architecture

Data naming standards

Stakeholder collaboration

Education

Bachelor’s Degree in Computer Science

Data architecture / modelling certification or experience

Tools

Erwin

Azure

Job description

Job description: Data Modeller

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.