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
.
Positive 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

📌 Data Modeler (Melbourne)
🏢 CareCone Group
📍 Melbourne