Senior Data Architect and technical lead specializing in enterprise data governance, modern data architecture, lakehouse migration, and analytics delivery across Microsoft Fabric, OneLake, Azure Synapse, Databricks, Snowflake, and Power BI. Experienced in platform strategy, workspace governance, access control, medallion architecture, catalog and lineage enablement, semantic modeling, data quality, CI/CD, and production BI delivery.

SHUO XU

Senior Data Architect and technical lead specializing in enterprise data governance, modern data architecture, lakehouse migration, and analytics delivery across Microsoft Fabric, OneLake, Azure Synapse, Databricks, Snowflake, and Power BI. Experienced in platform strategy, workspace governance, access control, medallion architecture, catalog and lineage enablement, semantic modeling, data quality, CI/CD, and production BI delivery.

Available to hire

Senior Data Architect and technical lead specializing in enterprise data governance, modern data architecture, lakehouse migration, and analytics delivery across Microsoft Fabric, OneLake, Azure Synapse, Databricks, Snowflake, and Power BI. Experienced in platform strategy, workspace governance, access control, medallion architecture, catalog and lineage enablement, semantic modeling, data quality, CI/CD, and production BI delivery.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Work Experience

Data Architect at Adastra Corporation
September 1, 2025 - Present
Designed a medallion-style lakehouse architecture and ELT approach for Oracle ERP and OTM data, aligning bronze/silver/gold layers to reporting and governance needs. Modeled curated gold-layer datasets for analytics consumption and helped define reusable transformation patterns for future onboarding.
Cloud Architect at Adastra Corporation
July 1, 2025 - Present
Designed an enterprise Power BI and Fabric framework including workspace strategy, environment separation, governance standards, role-based access control, and development practices. Delivered production Power BI reports and reusable semantic model patterns on very large Snowflake-backed datasets using import mode, partitioning, incremental refresh, and memory optimization. Implemented Fabric CI/CD using Azure DevOps, Git integration, and YAML-based validation; built governed Snowflake source tables and views with dbt to support Power BI models. Also designed a medallion-style Fabric lakehouse architecture and ELT approach for Oracle ERP/OTM data, producing curated gold-layer datasets and reusable transformation patterns aligned to reporting and governance needs.
Cloud Architect / Power BI and Fabric Architect at Adastra Corporation
July 1, 2025 - Present
Designed an enterprise Power BI and Microsoft Fabric framework covering workspace strategy, environment separation, governance standards, role-based access control, and development practices. Delivered production Power BI reports and reusable semantic model patterns on Snowflake-backed datasets, using import mode, partitioning, incremental refresh, and memory optimization techniques. Implemented Fabric CI/CD using Azure DevOps with Git integration and YAML-based deployment validation. Built Snowflake source tables and views with dbt to support governed Power BI models.
Data Architect at Hitachi Solutions
September 1, 2022 - July 31, 2025
Migrated and governed an internal analytics platform from Azure Synapse to Microsoft Fabric using OneLake and Delta tables, reusable notebooks, validation routines, and deployment documentation. Integrated Microsoft Purview Unified Catalog and Purview Data Map with Fabric Lakehouse and Power BI semantic models to improve lineage, metadata discoverability, and governance operations. Also supported analytics and reporting needs across Dynamics sources by configuring Fabric Link/target workspaces and building reporting data models, translating legacy reporting logic into modern semantic models, and supporting Power BI report outputs with validated measures. Led cloud analytics pilots by designing ELT patterns and validating source-to-report data movement for executive reporting foundations.
Data Architect at Dynamics F&O Analytics Reporting Platform (The Lamb Company) / Cloud Analytics Pilot (Joeris General Contractors) / Marketing Analytics Platform (Planet Home Lending) / Asset Utilization Analytics Pilot (Knutson Construction) / Empower Lakehouse Platform
September 1, 2022 - July 31, 2025
Configured Fabric Link and target Fabric workspaces/lakehouses for Dynamics 365 F&O analytics and built reporting models across Dynamics sources. Translated legacy reporting logic into modern semantic models and supported Power BI Report Builder outputs with validated measures. Designed ELT patterns and ingestion pipelines across Dynamics and construction/procore data for executive reporting pilots with source-to-report validation. Built cross-source analytics models, implemented medallion layers, data quality checks, monitoring patterns, and governance practices. Designed governed analytics with ADF/Fivetran/Databricks Unity Catalog/Collibra/Fabric/Power BI and integrated Collibra with Unity Catalog to strengthen metadata and quality workflows.
Senior Data Architect at Hitachi Solutions
September 1, 2022 - July 31, 2025
Migrated and governed an internal analytics platform from Azure Synapse to Microsoft Fabric using OneLake, Delta tables, reusable notebooks, validation routines, and deployment documentation. Integrated Microsoft Purview (Unified Catalog and Data Map) with Fabric lakehouse and Power BI semantic models plus Synapse assets to improve lineage, metadata discoverability, and governance operations. Led multiple Fabric-based analytics architecture and delivery initiatives across internal and customer platforms.
Data Architect at Adastra Corporation
February 1, 2021 - September 1, 2022
Azure practice lead / senior data engineering work for Finastra, including designing Azure ingestion and Delta Lake framework for a large-scale insight reporting application. Built reporting models and Power BI Embedded patterns, led technical proof-of-concepts, and provided architecture direction for delivery teams. Worked across Azure Data Factory, Azure SQL Database, Azure Databricks, and related data delivery patterns.
Data Architect / Senior Data Engineer at Adastra Corporation
February 1, 2021 - September 30, 2022
Led Azure practice work including architecture and delivery of Azure data pipelines and Delta Lake frameworks for large-scale insight reporting. Built reporting models and Power BI Embedded patterns, led technical proof-of-concepts, and provided architecture direction to delivery teams. Designed ingestion, storage, transformation, and reporting components supporting enterprise analytics use cases.
Azure Practice Lead / Senior Data Engineer at Adastra Corporation
February 1, 2021 - September 30, 2022
Designed Azure data pipelines and Delta Lake framework for ingestion, storage, transformation, and reporting for a large-scale insight reporting application. Built reporting models and Power BI Embedded patterns, led technical proof-of-concepts, and provided architecture direction for delivery teams.
Power BI Consultant at Dimensional Strategies Inc.
October 1, 2019 - February 28, 2021
Built SSIS pipelines and operational reporting solutions including SSAS tabular models and Power BI Report Server reports. Developed Power BI dataflows, gateways, and reporting implementations. Delivered Power BI, DAX, data modeling, administration, and reporting training for technical and business audiences.
Power BI Consultant (and Training) at Dimensional Strategies Inc.
October 1, 2019 - February 28, 2021
Built SSIS pipelines and end-to-end BI/reporting solutions including SSAS tabular models, Power BI Report Server reports, dataflows, and operational reporting with gateways. Delivered Power BI/DAX/data modeling/admin training to client technical and business teams.
Senior Business Intelligence Developer at Finastra
November 1, 2017 - October 31, 2019
Developed enterprise tabular models and dimensional warehouse structures supporting the Canada Student Lending Program reporting environment. Designed SSIS and SQL pipeline frameworks for loading strategy, governance patterns, and migration path toward Azure Data Factory.

Education

Add your educational history here.

Qualifications

Master of Applied Science, Management Sciences - Operations Research
January 11, 2030 - August 27, 2026
Bachelor of Mathematics, Actuarial Science, Computer Science Option
January 11, 2030 - August 27, 2026
Master of Applied Science, Management Sciences - Operations Research
January 11, 2030 - August 27, 2026
Bachelor of Mathematics, Actuarial Science, Computer Science Option
January 11, 2030 - August 27, 2026
Microsoft Certified: Fabric Analytics Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Fabric Data Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Databricks Data Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Solutions Architect Expert
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Administrator Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Network Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Cosmos DB Developer Specialty
January 11, 2030 - August 27, 2026
Microsoft Certified: DevOps Engineer Expert
January 11, 2030 - August 27, 2026
Microsoft Certified: AI Agent Builder Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Agentic AI Business Solutions Architect
January 11, 2030 - August 27, 2026
Microsoft Certified: Cloud and AI Security Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Information Security Administrator Associate
January 11, 2030 - August 27, 2026
Databricks Certified Data Engineer Associate
January 11, 2030 - August 27, 2026
Azure Platform Architect - Databricks
January 11, 2030 - August 27, 2026
MCSA BI Reporting
January 11, 2030 - August 27, 2026
Master of Applied Science, Management Sciences - Operations Research
January 11, 2030 - August 27, 2026
Bachelor of Mathematics, Actuarial Science, Computer Science Option
January 11, 2030 - August 27, 2026
Microsoft Certified: Fabric Analytics Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Fabric Data Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Databricks Data Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Solutions Architect Expert
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Administrator Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Azure Network Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: DevOps Engineer Expert
January 11, 2030 - August 27, 2026
Microsoft Certified: AI Agent Builder Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Agentic AI Business Solutions Architect
January 11, 2030 - August 27, 2026
Microsoft Certified: Cloud and AI Security Engineer Associate
January 11, 2030 - August 27, 2026
Microsoft Certified: Information Security Administrator Associate
January 11, 2030 - August 27, 2026
Databricks Certified Data Engineer Associate
January 11, 2030 - August 27, 2026
Azure Platform Architect - Databricks
January 11, 2030 - August 27, 2026
MCSA BI Reporting
January 11, 2030 - August 27, 2026

Industry Experience

Financial Services, Professional Services, Government, Retail, Real Estate & Construction, Software & Internet, Media & Entertainment, Manufacturing