Principal Analytics Architect - Microsoft Fabric

Principal Analytics Architect - Microsoft Fabric At Advantive, we don't just make softwarewe build careers and power the manufacturing and distribution backbone of the global economy. We are growing fast, investing in AI, and building a culture where motivated, curious people rise quickly. 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 Responsibilities Analytics 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 Qualifications Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field 812+ 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. Why Advantive? Culture of Growth: We don't hire to fill seatswe hire to develop talent. You'll be supported like an athlete, coached like a leader, and challenged like a builder. Career Acceleration: Many of our best leaders started in frontline roles like this one. We believe in moving fast and promoting from within. Real Impact: You're not a cog in the machine here. Your work helps real businesses that keep supply chains, manufacturing lines, and entire industries running. Artificial intelligence (AI) technology may be used during the hiring process to record, transcribe, analyze, and rank interview responses. By submitting your application and participating in the interview process, you acknowledge and consent to the use of AI technology in the hiring process. Interview Process: We believe in identifying a strong fit between our company and our employees and supporting a culture of creative problem solving and innovation. To that extent, if selected for next steps, you will be invited to complete a series of assessments that focus on aptitude and personality prior to a recruiter interview. Everyone at the company from early career all the way to CEO has taken these assessments. The assessment email will be coming from a no-reply email address via our ATS (Hirebridge), so please be on the lookout! Advantive is an equal opportunity employer. We are committed to equal employment regardless of race, color, ethnicity, ancestry, religion, sex (including pregnancy, sexual orientation, or gender identity or expression), national origin, age, disability, veteran status, or other class protected by applicable law. All qualified applicants will receive consideration for employment without regard to these characteristics. We are committed to providing reasonable accommodations to individuals with disabilities and to ensuring a fair and inclusive hiring process. Warning! Advantive does not make job offers without conducting face-to-face (including virtual) interviews and will never ask you for money and/or personal information such as Social Security or bank information during the interview process. Job scams have been reported against many companies. For more information, please visit: FTC Job Scams.

Created: 2026-03-10