Jobs in Overland Park, KS

About the role

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.

What you'll bring

• 5–8 years of experience designing and publishing Power BI semantic models in enterprise environments
• Proficiency in DAX, Power Query (M), and data modeling concepts (star schema, relationships, cardinality)
• Hands-on experience with Microsoft Fabric (OneLake, Lakehouses, Dataflows Gen2, Direct Lake mode)
• Demonstrated experience with Power BI Q&A, linguistic schema authoring, and synonym configuration for natural language query
• Familiarity with Power BI Copilot, Microsoft 365 Copilot, or Azure OpenAI Service integrations with Fabric data sources
• Demonstrated ability to gather, document, and translate business requirements into data models and AI-readiness roadmaps
• Experience coaching or mentoring junior analysts or developers
• Strong communication skills with the ability to explain technical concepts—including AI capabilities and limitations—to non-technical audiences
• Familiarity with data governance, RLS, dataset certification, and Power BI deployment pipelines
• Understanding of responsible AI principles, data privacy considerations, and AI output auditability in enterprise analytics contexts
• Strong Communication
• Microsoft certifications: PL-300 (Power BI Data Analyst), DP-600 (Fabric Analytics Engineer), or DP-100 (Azure Data Scientist)

Benefits

Locations