1

Microsoft Bi Architect Jobs (NOW HIRING)

Responsibilities Architect, design and develop end to end business intelligence solution based on Microsoft Power BI platform. Work with clients to define user requirements for web systems ...

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 ...

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 ...

... architecture using Microsoft BI Stack (SSIS, SSAS, SSRS) or Informatica Understanding of traditional DW/BI components (ETL, Staging, DW, ODS, Data Marts, BI Tools) Intermediate programming and ...

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 ...

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 ...

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 ...

Showing results 41-60

Microsoft Bi Architect information

See salary details

$119K

$122.5K

$125K

How much do microsoft bi architect jobs pay per year?

As of Aug 26, 2026, the average yearly pay for microsoft bi architect in the United States is $122,500.00, according to ZipRecruiter salary data. Most workers in this role earn between $121,000.00 and $124,000.00 per year, depending on experience, location, and employer.

What is a Microsoft BI Architect?

A Microsoft BI Architect is responsible for designing, developing, and implementing business intelligence (BI) solutions using Microsoft technologies such as Power BI, SQL Server, Azure Synapse Analytics, and other related tools. They collaborate with stakeholders to define data requirements, create data models, and optimize BI infrastructure for performance and scalability. Their role includes ensuring data accuracy, security, and accessibility to support business decision-making.

What are the main responsibilities of a Microsoft BI Architect within a typical project lifecycle?

As a Microsoft BI Architect, you play a central role in analyzing business needs, designing end-to-end BI architectures, and overseeing the implementation of data solutions. Your responsibilities often include gathering requirements, modeling data, creating ETL workflows, and optimizing reporting structures using the Microsoft BI stack. You’ll collaborate closely with business stakeholders, data engineers, and analysts to ensure alignment with organizational goals and data governance standards. This multifaceted position offers continuous learning and advancement opportunities as you develop innovative analytics solutions and mentor team members.

What are the key skills and qualifications needed to thrive in the Microsoft BI Architect position, and why are they important?

To thrive as a Microsoft BI Architect, you need strong expertise in data modeling, ETL processes, and business intelligence solution design, often supported by a degree in computer science or a related field. Proficiency with Microsoft BI stack tools such as SQL Server, SSIS, SSAS, SSRS, Power BI, and familiarity with Azure cloud services and relevant certifications like Microsoft Certified: Data Analyst Associate are essential. Strong analytical thinking, effective communication, and leadership abilities help in translating business requirements into technical solutions and managing project teams. These skills enable the architect to deliver scalable, impactful BI systems that drive data-driven decision-making in organizations.

More about Microsoft Bi Architect jobs

What states have the most Microsoft Bi Architect jobs?

States with the most job openings for Microsoft Bi Architect jobs include:

What job categories do people searching Microsoft Bi Architect jobs look for?

The top searched job categories for Microsoft Bi Architect jobs are:

What are popular job titles related to Microsoft Bi Architect jobs?

For Microsoft Bi Architect jobs, the most frequently searched job titles are:

Infographic showing various Microsoft Bi Architect job openings in the United States as of August 2026, with employment types broken down into 33% Full Time, and 67% Contract. Highlights an 100% In-person job distribution, with an average salary of $122,500 per year, or $58.9 per hour.

BI Technical Lead/Architect

Joint Commission

Oakbrook Terrace, IL • On-site

$121K - $161K/yr

Other

Re-posted 17 days ago


Job description

Overview
This is a hands-on architectural role, responsible for designing, building, and governing core BI solutions while ensuring architectural integrity across the enterprise BI environment. The role owns the end-to-end BI architecture, develops and maintains the multi-year BI platform roadmap, partners closely with Data Engineering and Data Architecture, and serves as the lead technical mentor for BI Developers and Analysts. In addition to strategic responsibilities, the architect actively contributes to solution design, modeling standards, governance patterns, and complex implementations, and provides day to day technical direction for two offshore development consultants.
Responsibilities
  • Develop and maintain the multi-year BI platform roadmap, including tool evaluation, platform evolution, and alignment with enterprise data strategy.
  • Translate business requirements into physical data environments that support the Enterprise Data Warehouse, including fact and dimension design using Kimball methodology.
  • Lead the design of Tabular semantic models in Power BI Premium and Microsoft Fabric, including DAX, Row Level Security, and performance optimization.
  • Define and enforce BI development standards and governance across data models, naming conventions, DAX patterns, report design, and performance thresholds.
  • Manage Power BI and Fabric capacities, including resource allocation, on premises gateway administration, and performance monitoring across Dev, Test, and Production environments.
  • Own platform compliance and audit readiness, including regular review of Power BI Activity Logs, usage metrics, and user behavior against HIPAA and enterprise security standards.
  • Author deployment plans with rollback procedures, validation criteria, dependency mapping, and approval gates. Lead postmortems and drive root cause analysis to closure.
  • Enable self-service analytics and foster a culture of data literacy across the organization through documented standards, reusable assets, and stakeholder enablement.
  • Direct the technical work of two offshore consultants, including assigning work, reviewing code and designs, and ensuring deliverables meet platform standards.
  • Partner with business stakeholders to gather requirements, estimate effort, build business cases for platform investments, and communicate tradeoffs in terms non-technical audiences can act on.

Qualifications
  • Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.
  • 8+ years building relational dimensional data models using Kimball methodology.
  • 5+ years of hands-on Power BI development, including semantic model design, advanced DAX, and performance tuning with DAX Studio or Tabular Editor.
  • 5+ years with Power BI Datasets and SSAS Tabular, including Row Level Security and Object Level Security.
  • 5+ years working with an Enterprise Data Warehouse and writing ETL.
  • Expert level Microsoft SQL Server T SQL, including complex queries, stored procedures, and performance optimization.
  • Hands on experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake, OneLake) and judgment on when to apply Import, Direct Query, or Direct Lake modes.
  • Experience with Power BI deployment pipelines, Git source control, and workspace lifecycle management across Dev, Test, and Production.
  • Experience with Azure data pipelines moving data from Data Lake to Synapse. SSIS experience for data extraction.
  • Excellent written and verbal communication, with the ability to produce technical and business documentation others can act on independently.

This job description is intended to describe the general nature and level of work performed by an employee assigned to this position. The description is not an exhaustive list of all duties, responsibilities, knowledge, skills, and abilities, and working conditions associated with this position. All requirements are subject to possible modification and reasonably accommodate individuals with disabilities.
Equal Opportunity Field
We offer a comprehensive benefit package. For a complete overview of our benefits package, please visit our Joint Commission Career Page
We are an Equal Opportunity Employer. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by law.
Min
USD $121,000.00/year
Max
USD $161,000.00/year