Location & Contract
Location: Fitzroy, Victoria
Contract Duration: 4-6 months
Start Date: Early December
Work Type: Contract
Role Overview
The Data Modeler will design, govern, and optimise the data structures underpinning the organisation's Dynamics 365 ecosystem, including current CRM development, future CRM consolidation initiatives, and integrations with D365 Finance & Operations, Microsoft Fabric, and enterprise applications. The role establishes canonical data models, entity relationships, integration contracts, and metadata standards that enable interoperability across multiple organisations, business units, and platforms. The Data Modeler works closely with the D365 Solutions Architect to ensure the data layer is consistent, scalable, and aligned with long-term enterprise architecture and governance.
Key Responsibilities
1. Design and maintain conceptual, logical, and physical data models for Dataverse, D365 CRM, and Fabric Lakehouse/Warehouse.
2. Define canonical data entities and shared schemas for use across CRM, F&O, and future integration points.
* Establish entity naming conventions, relationship patterns, attribute standards, and metadata definitions.
Integration & Interoperability
3. Produce source-to-target mappings for CRM F&O, CRM external systems, and CRM Fabric ingestion pipelines.
4. Define API payload structures, event schemas, and transformation logic in collaboration with the Solutions Architect.
5. Document lineage, integration contracts, and versioning standards.
* Support Azure integration teams with schema definitions and validation rules.
Analytics & Fabric Enablement
6. Ensure CRM models support downstream Business Intelligence (BI) and Machine Learning (ML) workloads in Microsoft Fabric.
7. Collaborate with analytics teams to optimise star schemas, semantic models, and medallion architecture.
* Define attribute-level data quality rules and exception thresholds.
Governance & Documentation
8. Build and maintain data dictionaries, Entity Relationship Diagrams (ERD), metadata catalogues, and domain definitions.
9. Ensure models comply with the organisation's governance, ISO27001, and APP 11.
* Support application of sensitivity labels, retention tags, and lifecycle rules across CRM entities.
Stakeholder Engagement
10. Facilitate workshops to validate data definitions and flows.
11. Advise delivery teams, vendors, and product owners on modelling standards.
* Maintain alignment with the D365 Solutions Architect across all streams.
Mandatory Skills & Experience
12. Expertise modelling enterprise data for Dynamics 365 / Dataverse.
13. Experience designing canonical models and schemas for multi-system environments.
14. Hands‑on experience with Microsoft Fabric, semantic modelling, and Common Data Model (CDM) schema mapping.
15. Strong understanding of metadata, classification, retention, and governance.
16. Familiarity with Azure integration patterns (APIM, Logic Apps, Functions).
17. Ability to produce ERDs, lineage documentation, and data dictionaries.
* Strong communication skills for architecture reviews and cross‑vendor coordination.
How to apply
To submit your application, please apply online using the appropriate link below. If you have any questions, please contact Oormila Uthaman through email on ***************@hudson.com, quoting Ref No:. Your interest will be treated in the strictest of confidence.
Diversity, Equity & Inclusion
Diversity, Equity & Inclusion at HudsonHudson is committed to helping you find a workplace where you feel respected, supported, and free to thrive. We welcome applications from all backgrounds, identities, and lived experiences—because when different voices come together, amazing things happen.
Casual Loading
Please note for all Australian based contract and temporary roles only, the pay rate is inclusive of mandatory 25% casual loading. This excludes permanent and fixed term roles.
#J-18808-Ljbffr