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 NetSuite, 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. Key ResponsibilitiesAnalytics Architecture & Platform Design 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 Source System Integration Lead integration design for Salesforce, NetSuite, 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 Alteryx to Fabric Modernization 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 Analytics & Power BI Enablement 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 Governance, Quality & Standards 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 Skills & RequirementsQualifications Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field 8-12+ years of experience in data warehousing, analytics engineering, or data architecture Hands-on experience with Microsoft Fabric, Azure Synapse, or modern cloud data platforms Strong experience integrating ERP and CRM systems (NetSuite and Salesforce preferred) Proven experience supporting Power BI at scale Experience modernizing legacy ETL tools (e.g., Alteryx, SSIS, Informatica) strongly preferred Location: Tampa, FL While we offer flexibility, this role includes an expectation of being onsite three days a week in our Tampa office to support team alignment and cross-functional collaboration.

Created: 2026-03-04