9 Month Contract - Full-time | Major healthcare data and analytics transformation

Only apply if you are based in Brisbane Australia with Australian Work Rights THE OPPORTUNITY

We are seeking an experienced Data Architect and Modeller whose primary expertise is conceptual and dimensional modelling for complex analytical environments. You will own the design integrity of source-independent Silver and Gold structures within Microsoft Fabric and guide the Certified Data Engineers implementing them.

This role forms part of a three-way delivery partnership with the Business Analyst / Project Manager and Senior Power BI Developer.

WHAT YOU WILL DELIVER

- Lead conceptual and Kimball-aligned dimensional modelling across complex healthcare and research business processes.
- Define facts, dimensions, grain, conformed entities, hierarchies, keys, temporal meaning and historical treatment.
- Design source-independent Silver and Gold structures that protect downstream analytics from source-system replacement, consolidation or change.
- Work with the Business Analyst / Project Manager to translate business processes, definitions, reporting needs and acceptance criteria into clear modelling requirements.
- Define source-to-target mappings, transformation rules, authoritative-source relationships, lineage, identity linkage, quality controls and reconciliation requirements.
- Provide design direction and assurance to Certified Data Engineers, remaining hands-on for complex modelling, mapping and transformation issues.
- Work with the Senior Power BI Developer to agree grain, relationships, history, measures, security and performance across the dimensional and semantic layers.
- Design AI-ready data structures supported by governed business terminology, metadata, lineage and explainable relationships suitable for later approved AI use cases.




- Maintain models, mappings, dictionaries, design decisions, test expectations and known limitations through structured handover.

WHAT YOU WILL BRING
- Significant commercial experience in data architecture and dimensional modelling for complex analytical environments.
- Advanced Kimball capability covering grain, fact-table design, conformed dimensions, surrogate keys, hierarchies and historical treatment.
- Strong Microsoft Fabric, SQL and Medallion Architecture experience across Bronze, Silver and Gold layers.
- Demonstrated ability to translate business processes and analytical needs into maintainable, source-independent data models.
- Strong source-to-target mapping, data quality, lineage, reference-data, identity-resolution and reconciliation capability.
- Experience guiding and assuring data-engineering implementation while remaining technically hands-on.
- Solid business stakeholder engagement and the ability to explain complex modelling decisions clearly.
- Practical, responsible use of approved AI tools to improve delivery quality and productivity without replacing professional judgement, traceability or validation.
- Ability to work collaboratively with business analysis, project management, data engineering and Power BI specialists in a privacy-sensitive environment.

QUALIFICATIONS Essential: A current relevant Microsoft Fabric, Azure Data or data-engineering certification is mandatory.

Highly regarded: Healthcare, clinical or research data; Microsoft Fabric lakehouses and warehouses; Azure Synapse Analytics; SQL-based data warehouses; SAP data; source-system migration or consolidation; and privacy-sensitive or regulated environments.

Ready to make an impact? Apply with your CV and a brief example of a complex dimensional-modelling or data-architecture solution you have delivered.

📌 Data Architect and Modeller (Brisbane)
🏢 Transfit Australia
📍 Brisbane