Business Intelligence Architect

Job summary

Work with a Top 20 CPA and advisory firm that Accounts for Anything. 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, Apr*** ensures clients are prepared for wherever life or business may take them.

Benefits

Qualifications

• 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
• sessions with business stakeholders, and architect scalable solutions within Microsoft Fabric and Power BI.
• As Apr*** 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.
• gathering sessions with business stakeholders, translating needs into data model specifications and AI-assisted analytics roadmaps
• Serve as a trusted advisor, clearly communicating model design decisions, tradeoffs, and AI capability opportunities to executive and non-technical audiences
• Collaborate with data engineers, DevOps, and business analysts to ensure analytical models support downstream use cases including Copilot and self-service BI
• Champion data literacy and responsible AI use across the organization in collaboration with the data governance manager and data governance committee
• Fabric Platform & Governance
• Own the semantic model layer within the Apr*** Microsoft Fabric Lakehouse architecture (OneLake, Lakehouse, Notebooks)
• Define and enforce naming conventions, model governance standards, certification processes, and AI metadata standards for published datasets
• Coordinate with the data engineering team to ensure clean, well-documented source data is available for modeling and AI consumption

Responsibilities

• Join Apr***'s Information Technology team and you will help clients maximize their opportunities.
• 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
• 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
• AI, Natural Language Query & Copilot Enablement
• Lead Apr***’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

Skills

Certifications

Degrees

Industry

Company size

Contract length