Principal Analytics Architect - Microsoft Fabric

The Principal Analytics Architect, reporting into Advantive’s Business Analytics organization, is responsible for architecting and delivering the company’s enterprise analytics data warehouse being built on Microsoft Fabric.

This role serves as the technical owner of the analytics data foundation, defining architecture, modeling standards, and integration patterns across core business systems. Initial scope will focus on Salesforce and Net Suite, with additional systems incorporated over time.

The Principal Analytics Architect will partner closely with Business Analytics leadership, business stakeholders, and external consultants to design a scalable, governed, and high-performing analytics platform. A critical component of this role will be replicating and modernizing existing Alteryx transformation logic into Fabric-native pipelines, ensuring continuity of business logic while improving transparency, performance, and long-term maintainability.

This role is both strategic and hands-on, balancing architectural leadership with direct contribution during the build phase of the data warehouse.

• Own the end-to-end architecture for Advantive’s enterprise analytics warehouse in Microsoft Fabric
• Define standards for data ingestion, transformation, storage, and semantic modeling
• Design scalable, well-governed data models to support enterprise reporting and analytics
• Establish best practices for historical tracking, incremental loads, and performance optimization

• Lead integration design for Salesforce, Net Suite, and other enterprise platforms
• Ensure consistent definitions and alignment across systems and downstream reporting
• Partner with consultants and internal teams to implement reliable, well-documented pipelines

• Analyze existing Alteryx workflows and transformation logic
• Design Fabric-native equivalents using Dataflows Gen2, Notebooks, and/or SQL
• Ensure functional parity while improving maintainability and observability

• Partner closely with Power BI developers to ensure models support performant reporting
• Define semantic layer patterns that enable reuse and self-service analytics
• Support executive, operational, and financial reporting needs

• Define data standards, naming conventions, and documentation expectations
• Partner on data quality, lineage, and access governance initiatives
• Ensure the platform scales with business growth and acquisitions