Data Modeler

CareCone Group; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

CareCone Group in Sydney is seeking an experienced Data Modeller to lead the design and delivery of enterprise data models, shaping logical and physical models, and working with analytics stakeholders to ensure alignment with business needs.

You will collaborate with business analysts, data engineers and developers, applying best practices in data vault, Kimball and other methodologies, and leverage Erwin and Azure for modeling and governance.

Qualifications

• 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.
• A deep understanding and experience of enterprise modern data architecture patterns and processes
• Good understanding in creation and management of data naming standards and data management principles.
• 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.

Responsibilities

• Collaborating with stakeholders, including business analysts, data engineers, and developers to gather requirements refine data models

Skills

Data modelling

Data warehousing

Industry data models

Data architecture

Data governance

ETL design

Stakeholder communication

Tools

Erwin

Azure

Job description

• 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