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