Aprio
Business Intelligence Architect
At a Glance
- Location
- Atlanta, Georgia, United States
- Work Regime
- hybrid
- Employment
- Full Time
- Experience
- 5–8 years
- Department
- Business Operations
- Posted
- 2026-07-22T20:06:32.529000+00:00
Key Requirements
Required Skills
Domain Knowledge
- Accounting
Benefits & Perks
edical, Dental, and Vision Insurance on the first day of employment - Flexib
Requirements
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)
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
Familiarity with data governance, RLS, dataset certification, and Power BI deployment pipelines
Responsibilities
Semantic Modeling & Architecture
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
About the Company
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.