Data Architect (MS Fabric)

XPT Software; Sydney; On-site; AUD 170,000 - 250,000; Full time

Job summary

XPT SoftwareAustralia PTY Ltd in Sydney seeks a Fabric Data Architect to design, govern, and implement enterprise data platforms using Microsoft Fabric. You will lead lakehouse and data integration initiatives across ERP/CRM integrations and BI enablement.

The role collaborates with business stakeholders, data engineers, and analytics teams to deliver scalable, secure data solutions, migrate legacy platforms, and drive data governance and security with Purview.

Qualifications

• 10+ years in Data & Analytics Architecture with cloud data platforms.
• Experience designing lakehouses and medallion architecture (Bronze, Silver, Gold).
• Strong governance, security, and data quality practices.
• Proven ability to lead enterprise data projects and migrations.

Responsibilities

• Design enterprise data architecture using Fabric components (OneLake, Lakehouse, Data Warehouse, Data Factory).
• Define conceptual, logical, and physical data models and standards.
• Lead migration from legacy platforms to Microsoft Fabric and modernize references.
• Build scalable ELT/ETL pipelines and real-time data ingestion.
• Develop governance, RBAC, and security models; ensure regulatory compliance.
• Collaborate with stakeholders, data engineers, and BI teams; support pre-sales.

Skills

Microsoft Fabric

Power BI

PySpark

Python

SQL

Data Modeling

Data Governance

ETL/ELT Design

REST APIs

Education

DP-600/DP-700 Certifications

Azure Solutions Architect Expert

Tools

Fabric Data Factory

Notebooks

DirectLake

PowerBI

Dataflows Gen2

Git

Purview

Job description

• XPT SoftwareAustralia PTY Ltd, incorporated in 2016, is a Software Services company
  
• XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and Manufacturingdomains.
  
• We have 120+technocrats in Australia working at our clientlocations.
  
• XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.
  
• We have served100+ clients globally, fulfilling their onsite-offshoreneeds.
  

Experience

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

Role Summary

The Fabric Data Architect isresponsible for designing, governing, and implementing enterprise-scale dataplatforms 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 businessstakeholders, solution architects, data engineers, and analytics teams todeliver scalable, secure, and high-performance data solutions.

Key Responsibilities

• Designenterprise data architecture using Microsoft Fabric components includingOneLake, Lakehouse, Data Warehouse, Data Factory, Real-Time Intelligence,Semantic Models, and Power BI.
  
• Defineconceptual, logical, and physical data models.
  
• EstablishLakehouse and Medallion Architecture patterns (Bronze, Silver, Gold).
  
• Designenterprise-wide data integration frameworks and reusable architecturepatterns.
  
• Architectbatch, streaming, and event-driven ingestion solutions.
  
• Designdata pipelines using Fabric Data Factory, Notebooks, Dataflows Gen2, andAPIs.
  
• Integratedata from ERP, CRM, SaaS, databases, files, and external platforms.
  
• Implementscalable ELT/ETL solutions.
  

Data Modeling & Analytics

• Definedimensional models, semantic models, and data product structures.
  
• DesignDirect Lake and Warehouse optimization strategies.
  
• Enableself-service BI and advanced analytics through Power BI.
  

Governance & Security

• Implementdata governance using Microsoft Purview and Fabric governancecapabilities.
  
• Definesecurity architecture including RBAC, row-level security, masking,encryption, and access controls.
  
• Ensurecompliance with privacy, regulatory, and organizational securitystandards.
  
• Establishdata quality, metadata, lineage, and catalog strategies.
  

Migration & Modernization

• Leadmigrations from legacy Data Warehouses, Synapse, Hadoop, SQL Server,Teradata, Snowflake, or Databricks to Microsoft Fabric.
  
• Definemigration roadmaps and modernization strategies.
  
• Conductplatform assessments and architecture reviews.
  

Performance &Optimization

• OptimizeFabric workloads for scalability and performance.
  
• Monitorand improve query performance, storage utilization, and cost efficiency.
  
• DevelopFinOps and capacity management strategies for Fabric F-SKUs.
  

Leadership & StakeholderManagement

• Conductarchitecture workshops and client discussions.
  
• Providetechnical leadership to data engineers, analysts, and BI teams.
  
• Reviewsolution designs and ensure alignment with enterprise architecturestandards.
  
• Supportpre-sales, solutioning, estimations, and RFP/RFT responses.
  

Required Technical Skills

Microsoft Fabric

• OneLake
  
• Lakehouse
  
• DataWarehouse
  
• FabricData Factory
  
• DataflowsGen2
  
• Notebooks
  
• DirectLake
  
• PowerBI
  
• FabricAdministration & Governance
  
• PySpark
  
• SparkSQL
  
• Python
  
• SQL
  
• DataModeling
  
• ETL/ELTDesign
  
• RESTAPIs
  

Governance & Security

• MicrosoftPurview
  
• DataCatalog
  
• MetadataManagement
  
• DataQuality
  
• RBAC
  
• DataSecurity & Compliance
  

DevOps

• GitIntegration
  
• Infrastructureas Code
  

Preferred Certifications

• DP-600:Implementing Analytics Solutions Using Microsoft Fabric
  
• DP-700:Implementing Data Engineering Solutions Using Microsoft Fabric
  
• MicrosoftCertified: Azure Solutions Architect Expert