- 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
#J-18808-Ljbffr
Data Modeler in Melbourne employer: CareCone Group
CareCone Group is an exceptional employer located in the vibrant city of Sydney, offering a dynamic work culture that fosters innovation and collaboration. Employees benefit from ongoing professional development opportunities, competitive remuneration, and a supportive environment that values work-life balance. Joining our team means being part of a forward-thinking organisation dedicated to delivering high-quality IT solutions while ensuring compliance with Australian working rights.
