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 inenterprise data modelling, including conceptual, logical, physical, and dimensional modelling.
Strong hands-on knowledge ofSnowflakeand advancedSQL.
Positive understanding ofETL/ELT, data integration, source-to-target mapping, and data transformation patterns.
Knowledge of theRetail domainand key business processes such asSales, POS, Inventory, Procurement, Pricing and Promotionsis desirable.
Experience working with complex enterprise source systems;SAP (70%) expert and/or Oracle (30%) basic to intermediate experience is highly desirable
Understanding ofdata governance, data quality, metadata, and enterprise data standards.
Strongstakeholder management, workshop facilitation, communication, and presentation skills.
Ability to bridge the gap betweenbusiness 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
#J-*****-Ljbffr

📌 Data Modeler (Melbourne)
🏢 CareCone Group
📍 Melbourne