Senior BI Architect: Power BI & Fabric Leader

Imperialsports

Chesterfield (MO)

On-site

USD 130,000 - 185,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

401(k) with company match

Health care (medical, dental, vision)

Employee Assistance Program

PTO (vacation, personal days, holidays

Continuing education

Employee product discounts

Free hats

Job summary

Imperial is seeking a Senior BI Architect/Engineer to lead the design, governance, and evolution of our enterprise reporting and analytics platform.

This role serves as the internal expert for Power BI, Microsoft Fabric, NetSuite reporting architecture, and enterprise data modeling, partnering with Finance, Sales, Inventory, Operations, and IT leadership to reduce consulting dependency and grow internal BI capabilities.

Qualifications

7+ years of BI, Analytics, or Data Engineering experience.
5+ years of advanced Power BI development experience.
Strong Microsoft Fabric experience including Lakehouse, Data Warehouse, Semantic Models, Data Pipelines, and Security & Governance.
Advanced SQL development and query performance optimization skills.
Experience with ERP reporting and data architecture in complex business environments.
Strong understanding of financial reporting, sales analytics, inventory management, manufacturing operations, and supply chain reporting.
Demonstrated experience translating business requirements into scalable analytics solutions.
Experience mentoring developers and analysts, and leading reporting roadmaps and governance initiatives.
Ability to work directly with executive and departmental leadership.

Responsibilities

Develop and maintain the enterprise reporting and analytics roadmap.
Partner with Finance, Sales, Supply Chain, and Operations leadership to identify reporting priorities and business opportunities.
Translate business objectives into scalable reporting and analytics solutions.
Establish KPI governance and standard definitions across departments.
Advise leadership on reporting capabilities, data quality initiatives, and analytics strategy.
Own overall Power BI and Microsoft Fabric architecture, including enterprise semantic models and data structures.
Establish development standards, naming conventions, deployment processes, and governance controls.
Optimize performance, scalability, and security across reporting environments.
Lead Fabric adoption initiatives including Lakehouse, Data Warehouse, Dataflows, Pipelines, and Semantic Models.
Design and maintain reporting solutions supporting Financial Reporting, Sales Reporting, Inventory Analysis, Supply Chain Analytics, and Operational Performance Reporting.
Develop reporting strategies that address ERP, accounting, inventory, and manufacturing data structures.
Work closely with NetSuite and operational teams to improve data availability and reporting effectiveness.
Support integration and reporting initiatives involving NetSuite, Deposco, and related systems.
Internalize knowledge currently held by consulting partners; document critical business logic, calculations, and technical designs.
Reduce reliance on external development resources through in-house capability development.
Evaluate consulting engagements and ensure strategic use of external resources.
Establish and oversee BI intake processes, requirements gathering standards, prioritization frameworks, development lifecycle management, and release management.
Support business stakeholders in evaluating and prioritizing reporting requests.
Create transparency around reporting backlog, delivery timelines, and resource allocation.
Serve as mentor and technical leader for junior BI resources, coaching in data modeling, Power BI development, DAX, requirements gathering, and report design.
Enable junior team members to assume increasing ownership of report intake, development, stakeholder engagement, and operational support.