Principal Analytics Architect - Microsoft Fabric jobs in United States
cer-icon
Apply on Employer Site
company-logo

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
check
H1B Sponsor Likelynote

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

Microsoft FabricData WarehousingPower BIERP IntegrationCRM IntegrationAzure SynapseData EngineeringETL ModernizationData ModelingDocumentation StandardsData Quality Governance

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

twittertwittertwitter
company-logo
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 Stage
Total Funding
unknown
2023-09-13Private Equity

Leadership Team

leader-logo
Benoit de la Tour
Chief Executive Officer
linkedin
leader-logo
Andries Hanekom
Chief Technology Officer
linkedin
Company data provided by crunchbase