Data Architect (MS Fabric)

XPT Software; Sydney; On-site; AUD 150,000 - 210,000; Full time

Job summary

XPT Software in Sydney is seeking a Fabric Data Architect to design, govern, and implement enterprise-scale data platforms using Microsoft Fabric. You will collaborate with business stakeholders, solution architects, data engineers and analytics teams to deliver scalable, secure, and high-performance data solutions.

The role focuses on data architecture, Lakehouse design, data integration, governance, security, analytics enablement, and modernization of legacy platforms.

Qualifications

• Over 10 years in Data & Analytics Architecture.
• Experience with Microsoft Fabric components and Lakehouse patterns.
• Ability to define migration and modernization roadmaps.

Responsibilities

• Design enterprise data architecture using Microsoft Fabric components (OneLake, Lakehouse, Data Warehouse, Data Factory).
• Define conceptual, logical, and physical data models; establish Bronze/Silver/Gold patterns.
• Lead migrations from legacy platforms to Fabric; define modernization strategies.
• Architect batch, streaming, and event-driven ingestion solutions; enable self-service BI with Power BI.

Skills

Leadership

Stakeholder management

Architecture design

Governance

Pre-sales support

Client discussions

Education

DP-600: Implementing Analytics Solutions Using Microsoft Fabric

DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

Microsoft Certified: Azure Solutions Architect Expert

Data Governance

Tools

Microsoft Fabric

Fabric Data Factory

OneLake

Lakehouse

Power BI

Notebooks

Semantic Models

Direct Lake

SQL

ETL/ELT Design

REST APIs

Job description

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

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

• OneLake
• Lakehouse
• Data Warehouse
• Fabric Data Factory
• Dataflows Gen2
• Notebooks
• Semantic Models
• Direct Lake
• Power BI
• Fabric Administration & Governance
• PySpark
• Spark SQL
• Python
• SQL
• Data Modeling
• ETL/ELT Design
• REST APIs

Governance & Security

• Microsoft Purview
• Data Catalog
• Metadata Management
• Data Quality
• RBAC
• Data Security & Compliance

DevOps

• Git Integration
• Infrastructure as Code

Preferred Certifications

• DP-600: Implementing Analytics Solutions Using Microsoft Fabric
• DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric
• Microsoft Certified: Azure Solutions Architect Expert
• Modern Data Platform Design
• Data Governance
• Stakeholder Management
• Solution Consulting
• Technical Leadership
• Cost Optimization

Nice-to-Have

• Databricks
• Snowflake
• Synapse Analytics
• AI/ML Integration
• Generative AI and Copilot Integration
• Data Mesh and Data Products Architecture