Role: Data Modeller Type: Full time – Perm or Contract

Location:
Melbourne, AU Status: AU valid visa with full work rights

Key Responsibilities
• 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.
• Robust stakeholder management, workshop facilitation, communication, and presentation skills.
• Ability to bridge the gap between business requirements, source-system data, and target data architecture.
• Tenant-to-tenant M365 migrations
• Identity amp; authentication design and delivery
• PowerShell scripting amp; automation
• Migration discovery, testing, cutover amp; remediation
• Hybrid identity, SSO amp; access management End-to-end ownership from design through delivery Interested? Please apply, thanks for your interest and time.

📌 Data Modeller (Melbourne)
🏢 FR Consultancy
📍 Melbourne