Data Modeler

CareCone Group; Melbourne; On-site; AUD 130,000 - 190,000; Full time

Job summary

CareCone Group in Melbourne seeks an experienced Data Modeller/Architect to design enterprise data models on Snowflake and translate business needs into scalable data structures for analytics and reporting.

You will run data-modelling workshops, define standards, and collaborate with ETL/ELT teams to ensure governance, data quality, and consistency across source systems such as SAP and Oracle.

Qualifications

• Strong experience in enterprise data modelling, including conceptual, logical, physical, and dimensional modelling.
• Hands-on knowledge of Snowflake and advanced SQL.
• Good understanding of ETL/ELT, data integration, source-to-target mapping, and data transformation patterns.
• Knowledge of the Retail domain and key processes such as Sales, POS, Inventory, Procurement, Pricing and Promotions is desirable.
• Experience with complex enterprise source systems; SAP (70%) expert and/or Oracle (30%) basic to intermediate desirable.
• Understanding of data governance, data quality, metadata, and enterprise data standards.
• Strong stakeholder management, workshop facilitation, communication, and presentation skills.
• Ability to bridge business requirements, source-system data, and target data architecture.
• Identity & authentication design and delivery; PowerShell scripting & automation.

Responsibilities

• Lead the design and development of data models for enterprise solutions on Snowflake.
• Translate requirements into scalable models to support reporting and analytics.
• Conduct modelling workshops with business and technical stakeholders.
• Define dimensional and enterprise modelling standards including keys, hierarchies, and conformed entities.
• Collaborate with data engineering to implement models via ETL/ELT pipelines.
• Ensure alignment with data governance, quality, metadata, and standards.
• Review source data structures and resolve gaps across SAP, Oracle, and other systems.
• Communicate modelling approaches and decisions to stakeholders.

Skills

Enterprise data modelling

Stakeholder management

Workshop facilitation

Communication & presentation

Bridge business requirements to data

Identity design & delivery

PowerShell scripting

Tools

Snowflake

SQL

SAP

Oracle

PowerShell

Job description

• Lead the design and development of conceptual, logical, and physical data models for enterprise data solutions on Snowflake.
• Translate business requirements and existing data structures into scalable, business-aligned data models supporting reporting, analytics, and downstream consumption.
• Conduct requirements and data-modelling workshops with business and technical stakeholders to understand business processes, and drive modelling decisions.
• Define and apply dimensional and enterprise data-modelling standards, including facts, dimensions, conformed entities, hierarchies, keys, and relationships.
• Collaborate with data engineering teams to ensure models are effectively implemented through ETL/ELT pipelines, including source-to-target mapping and transformation requirements.
• Ensure data models align with established data governance, data quality, naming, metadata, and modelling standards.
• Review existing source data structures and work with stakeholders to resolve data gaps, inconsistencies, and modelling decisions across SAP, Oracle, and other source systems.
• Clearly communicate modelling approaches, design decisions, dependencies, and recommendations to both business and technical stakeholders.

Required Skills & Experience

• Strong experience in enterprise data modelling, including conceptual, logical, physical, and dimensional modelling.
• Strong hands-on knowledge of Snowflake and advanced SQL.
• Good understanding of ETL/ELT, data integration, source-to-target mapping, and data transformation patterns.
• Knowledge of the Retail domain and key business processes such as Sales, POS, Inventory, Procurement, Pricing and Promotions is desirable.
• Experience working with complex enterprise source systems; SAP (70%) expert and/or Oracle (30%) basic to intermediate experience is highly desirable
• Understanding of data governance, data quality, metadata, and enterprise data standards.
• Strong stakeholder management, workshop facilitation, communication, and presentation skills.
• Ability to bridge the gap between business requirements, source-system data, and target data architecture.
• Identity amp; authentication design and delivery
• PowerShell scripting amp; automation
• Hybrid identity, SSO amp; access management End-to-end ownership from design through delivery