Principal Analytics Architect
Advantive, Tampa, FL, United States
Principal Analytics Architect
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 role will also ensure the analytics platform is structured to support emerging AI-driven analytics, automation, and advanced insight capabilities across the organization.
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.
The ideal candidate brings strong experience designing analytics architectures across modern data platforms and can quickly adapt to new tools and technologies. Candidates with experience in modern data platforms (e.g., Microsoft Fabric, Snowflake, Databricks) are strongly encouraged to apply.
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 platform, leveraging a modern cloud data stack (currently 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
Ensure data models and pipelines are structured to support AI-enabled analytics and future advanced analytics use cases
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 scalable, platform-native equivalents using SQL, notebooks, and/or modern data pipeline tooling
Ensure functional parity while improving maintainability and observability
Identify opportunities to streamline or enhance transformation logic using AI-assisted development capabilities where appropriate
Analytics & Power BI Enablement
Partner closely with BI developers (e.g., Power BI) to ensure models support performant reporting
Define semantic layer patterns that enable reuse and self-service analytics
Support executive, operational, and financial reporting needs
Enable responsible use of AI capabilities within the analytics platform (e.g., forecasting, anomaly detection, copilots) to enhance business insights
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
Support responsible AI usage by ensuring transparency, data quality, and appropriate governance controls
Qualifications
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field
5+ years of experience in data warehousing, analytics engineering, or data architecture
Hands-on experience with modern cloud data platforms (e.g., Microsoft Fabric, Snowflake, Databricks, Azure Synapse, BigQuery)
Experience with Microsoft Fabric is a plus, not required
Strong experience integrating ERP and CRM systems (NetSuite and Salesforce preferred)
Proven experience supporting BI tools (e.g., Power BI) at scale
Experience modernizing legacy ETL tools (e.g., Alteryx, SSIS, Informatica) strongly preferred
Familiarity with enabling analytics platforms to support AI-driven or advanced analytics capabilities preferred
Location: Southeast United States
Office Requirement: Remote; Open to travel to Tampa on as needed basis (likely 1-2 times per quarter)
This role is strongly aligned to candidates who are based in the Eastern or Central Time Zones and able to work Eastern Time hours.
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.
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 role will also ensure the analytics platform is structured to support emerging AI-driven analytics, automation, and advanced insight capabilities across the organization.
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.
The ideal candidate brings strong experience designing analytics architectures across modern data platforms and can quickly adapt to new tools and technologies. Candidates with experience in modern data platforms (e.g., Microsoft Fabric, Snowflake, Databricks) are strongly encouraged to apply.
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 platform, leveraging a modern cloud data stack (currently 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
Ensure data models and pipelines are structured to support AI-enabled analytics and future advanced analytics use cases
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 scalable, platform-native equivalents using SQL, notebooks, and/or modern data pipeline tooling
Ensure functional parity while improving maintainability and observability
Identify opportunities to streamline or enhance transformation logic using AI-assisted development capabilities where appropriate
Analytics & Power BI Enablement
Partner closely with BI developers (e.g., Power BI) to ensure models support performant reporting
Define semantic layer patterns that enable reuse and self-service analytics
Support executive, operational, and financial reporting needs
Enable responsible use of AI capabilities within the analytics platform (e.g., forecasting, anomaly detection, copilots) to enhance business insights
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
Support responsible AI usage by ensuring transparency, data quality, and appropriate governance controls
Qualifications
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field
5+ years of experience in data warehousing, analytics engineering, or data architecture
Hands-on experience with modern cloud data platforms (e.g., Microsoft Fabric, Snowflake, Databricks, Azure Synapse, BigQuery)
Experience with Microsoft Fabric is a plus, not required
Strong experience integrating ERP and CRM systems (NetSuite and Salesforce preferred)
Proven experience supporting BI tools (e.g., Power BI) at scale
Experience modernizing legacy ETL tools (e.g., Alteryx, SSIS, Informatica) strongly preferred
Familiarity with enabling analytics platforms to support AI-driven or advanced analytics capabilities preferred
Location: Southeast United States
Office Requirement: Remote; Open to travel to Tampa on as needed basis (likely 1-2 times per quarter)
This role is strongly aligned to candidates who are based in the Eastern or Central Time Zones and able to work Eastern Time hours.
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.