Business Intelligence Architect

Work with a Top 20 CPA and advisory firm that Accounts for Anything. Aprio has 40 U.S. office locations, as well as international office locations and more than 3,200 team members that speak 60+ languages across the globe. By bringing together proven expertise, deep understanding, and strategic foresight for fast-growing industries, Aprio ensures clients are prepared for wherever life or business may take them.

Discover a top-rated culture, vast growth opportunities and your next big career move with Aprio.

Join Aprio's Information Technology team and you will help clients maximize their opportunities. Aprio Advisory Group, LLC is a progressive, fast-growing firm looking for a Business Intelligence Architect to join their dynamic team.

Aprio’s Insights & Analytics team is expanding its Microsoft Fabric platform capabilities and is seeking a skilled Power BI & Fabric Semantic Model Architect to lead the design, development, and governance of enterprise‑grade semantic models. This role bridges the gap between raw data and business insight—translating complex stakeholder requirements into well‑structured, performant data models that power decision‑making across the firm.

The ideal candidate is both technically deep and interpersonally strong—someone who can lead and coach a team of report developers, facilitate requirements sessions with business stakeholders, and architect scalable solutions within Microsoft Fabric and Power BI. As Aprio accelerates its AI strategy, this role will play a central part in enabling natural language query (NLQ) capabilities, AI‑powered analytics, and Copilot integration across the firm’s reporting ecosystem.

• Design and build enterprise semantic models in Microsoft Fabric using Direct Lake mode, Power BI Datasets, and Dataflows Gen2
• Develop well‑structured star and snowflake schemas optimized for Power BI performance, NLQ discoverability, and Copilot compatibility
• Author complex DAX measures, calculated columns, and KPI logic following organizational standards; ensure measure naming and descriptions support AI‑assisted querying
• Establish and maintain a governed, reusable semantic layer across reporting domains (finance, operations, marketing, HR, growth)
• Evaluate and implement incremental refresh, aggregations, and query reduction strategies
• Architect semantic models to support natural language query (Q&A, Power BI Copilot, Azure OpenAI integration) by enforcing descriptive field names, synonyms, and measure annotations
• Define and maintain Q&A synonyms, linguistic schemas, and field‑level descriptions that enable accurate AI‑driven query interpretation

• Lead Aprio’s adoption of Power BI Copilot and Microsoft Fabric AI features, including AI‑generated report summaries, smart narratives, and anomaly detection
• Design semantic models and data products with AI‑readiness in mind—ensuring metadata quality, field descriptions, and schema consistency support large language model (LLM) integrations
• Collaborate with IT and data engineering to evaluate and implement natural language query interfaces, including Power BI Q&A, Copilot for Microsoft 365, and Azure OpenAI Service connections to Fabric data
• Develop prompting strategies and governance guardrails for AI‑generated insights to ensure accuracy, auditability, and alignment with firm standards
• Evaluate emerging Microsoft AI capabilities (Fabric Workload Hub, Copilot Studio, One Lake AI catalog) and provide architectural recommendations for phased adoption
• Partner with business stakeholders to identify high‑value use cases for AI‑assisted analytics, self‑service insights, and conversational BI
• Educate and upskill team members and business users on responsible use of AI tools within the BI ecosystem

• Mentor and coach a team of 4+ report developers, providing technical guidance on best practices, model design, DAX, and AI‑era BI patterns
• Conduct code and model reviews, establishing a culture of quality and continuous improvement
• Create internal documentation, standards guides, and reusable component libraries for the team
• Su…