Data Architect (MS Fabric)

XPT Software Australia

Sydney

On-site

AUD 180,000 - 240,000

Full time

19 hours ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Databricks

Snowflake

Synapse Analytics

AI/ML Integration

Generative AI and Copilot Integration

Data Mesh and Data Products Industry

Job summary

XPT Software Australia in Sydney is seeking a Fabric Data Architect to design, govern, and implement enterprise-scale data platforms using Microsoft Fabric. You will lead data modeling, lakehouse design, and data integration while enabling self-service BI with Power BI.

The role emphasizes security, governance, and modernization of legacy systems, collaborating with stakeholders across data engineering and analytics teams.

Qualifications

10+ years in Data & Analytics Architecture with 3+ years in Cloud Data Platforms and Microsoft Fabric.
Experience designing enterprise-scale data platforms and governance models.
Strong skills in data modeling, Lakehouse architecture, and BI enablement.

Responsibilities

Design enterprise data architecture using Fabric components including OneLake, Lakehouse, Data Warehouse and Power BI.
Define conceptual, logical, and physical data models and establish Bronze-Silver-Gold patterns.
Create reusable data integration frameworks and scalable ELT/ETL designs.
Build data pipelines with Fabric Data Factory, Notebooks, Dataflows Gen2 and APIs.
Integrate data from ERP, CRM, SaaS, databases and external sources.
Enable self-service BI and advanced analytics via Power BI.
Implement governance using Microsoft Purview and Fabric governance features.
Define security architecture including RBAC, RLS, masking, encryption and access controls.
Lead migrations to Microsoft Fabric from legacy platforms and drive modernization.
Perform architecture reviews and support pre-sales activities.

Skills

OneLake

Lakehouse

Data Warehouse

Fabric Data Factory

Real-Time Intelligence

Eventstreams

Dataflows Gen2

Notebooks

Semantic Models

Direct Lake

Power BI

Fabric Administration & Governance

PySpark

Spark SQL

Python

SQL

Delta Lake

ETL/ELT Design

Azure Data Lake Storage

Azure Synapse Analytics

Azure Data Factory

Azure SQL

Azure Event Hub

Azure Functions

REST APIs

Microsoft Purview

RBAC

DevOps (Azure DevOps)

CI/CD Pipelines

Infrastructure as Code

DP-600

DP-700

DP-203

Azure Solutions Architect Expert

Azure Fundamentals AZ-900

Education

DP-600: Implementing Analytics Solutions Using Microsoft Fabric

DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

DP-203: Azure Data Engineer Associate

Microsoft Certified: Azure Solutions Architect Expert

Azure Fundamentals (AZ-900)

Tools

Power BI

Fabric Data Factory

Notebooks

Dataflows Gen2

OneLake

Lakehouse

Direct Lake

Semantic Models

Job description

Experience

10+ years in Data & Analytics Architecture, with 3+ years in Cloud Data Platforms and Microsoft Fabric

Role Summary

The Fabric Data Architect is responsible for designing, governing, and implementing enterprise-scale data platforms using Microsoft Fabric. The role focuses on data architecture, Lakehouse design, data integration, governance, security, analytics enablement, and modernization of legacy data platforms. The architect collaborates with business stakeholders, solution architects, data engineers, and analytics teams to deliver scalable, secure, and high-performance data solutions.

Key Responsibilities

Data Architecture & Platform Design

Design enterprise data architecture using Microsoft Fabric components including OneLake, Lakehouse, Data Warehouse, Data Factory, Real-Time Intelligence, Semantic Models, and Power BI.
Define conceptual, logical, and physical data models.
Establish Lakehouse and Medallion Architecture patterns (Bronze, Silver, Gold).
Design enterprise-wide data integration frameworks and reusable architecture patterns.

Data Engineering & Integration

Architect batch, streaming, and event-driven ingestion solutions.
Design data pipelines using Fabric Data Factory, Notebooks, Dataflows Gen2, and APIs.
Integrate data from ERP, CRM, SaaS, databases, files, and external platforms.
Implement scalable ELT/ETL solutions.

Data Modeling & Analytics

Define dimensional models, semantic models, and data product structures.
Design Direct Lake and Warehouse optimization strategies.
Enable self-service BI and advanced analytics through Power BI.

Governance & Security

Implement data governance using Microsoft Purview and Fabric governance capabilities.
Define security architecture including RBAC, row-level security, masking, encryption, and access controls.
Ensure compliance with privacy, regulatory, and organizational security standards.
Establish data quality, metadata, lineage, and catalog strategies.

Migration & Modernization

Lead migrations from legacy Data Warehouses, Synapse, Hadoop, SQL Server, Teradata, Snowflake, or Databricks to Microsoft Fabric.
Define migration roadmaps and modernization strategies.
Conduct platform assessments and architecture reviews.

Performance & Optimization

Optimize Fabric workloads for scalability and performance.
Monitor and improve query performance, storage utilization, and cost efficiency.
Develop FinOps and capacity management strategies for Fabric F-SKUs.

Leadership & Stakeholder Management

Conduct architecture workshops and client discussions.
Provide technical leadership to data engineers, analysts, and BI teams.
Review solution designs and ensure alignment with enterprise architecture standards.
Support pre-sales, solutioning, estimations, and RFP/RFT responses.

Required Technical Skills

Microsoft Fabric