Advantive · 13 hours ago
Principal Analytics Architect - Microsoft Fabric
Advantive is a company that builds careers and powers the manufacturing and distribution backbone of the global economy. They are seeking a Principal Analytics Architect to architect and deliver the company's enterprise analytics data warehouse built on Microsoft Fabric, focusing on integration with core business systems like Salesforce and NetSuite.
Enterprise Resource Planning (ERP)SaaSSoftware
Responsibilities
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, 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
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
Qualification
Required
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
Preferred
Experience modernizing legacy ETL tools (e.g., Alteryx, SSIS, Informatica) strongly preferred
Company
Advantive
Advantive provides software solutions for specialty manufacturers and wholesale distributors.
H1B Sponsorship
Advantive has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
Funding
Current Stage
Growth StageTotal Funding
unknown2023-09-13Private Equity
Recent News
2025-11-19
Mergers & Acquisitions
2025-07-22
Company data provided by crunchbase