Senior BI Architect

Summit Utilities; Branson (MO); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Remote work options

Job summary

Summit Utilities seeks a Senior BI Architect to lead the design, governance, and evolution of its enterprise analytics architecture. You will act as the technical authority for Power BI, semantic modeling, data architecture, and BI development standards.

Working with Data Engineering and stakeholders, you will translate data into scalable analytics solutions supporting operational, financial, and executive decision-making while guiding the growth of Microsoft Fabric analytics.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 10+ years in BI, analytics engineering, enterprise reporting, or data warehousing.
• 6+ years Power BI development with semantic modeling and datasets.
• 3+ years leading or architecting with technical standards.

Responsibilities

• Lead design, governance, and optimization of enterprise analytics architecture.
• Establish and maintain best practices for data modeling, security, and deployment.
• Architect scalable analytics solutions for operational, financial, and executive reporting.
• Partner with Data Engineering to design curated data models.
• Design dataflows, semantic models, and refresh processes for performance.
• Define role-based security across reporting environments.
• Monitor Microsoft Fabric usage and BI ecosystem performance.
• Mentor BI developers and enforce standards.
• Develop architecture documentation and governance standards.
• Advise leadership on BI strategy and future-state architecture.

Skills

Power BI

DAX

SQL

Data modeling

Microsoft Fabric

Data governance

BI development

Data architecture

Education

Bachelors in CS/IS

Tools

SAP

SAP Analytics Cloud

Microsoft Fabric

Azure Data Services

Job description

Summit Utilities

Summit Utilities, Inc. continues to earn national and regional recognition as an employer of choice. Our recognitions include Best Places to Work in Maine (2019–2025); Best Places to Work in Arkansas (2020, 2023, 2025); Best Places to Work in Oklahoma (2022–2025); Best Places to Work in Missouri (2023 and 2026); Best Places to Work in Colorado (2025); Forbes America’s Best Small Employers (2023); and, most recently, Proud and Purposeful Employer (2026). Summit is a growing natural gas utility that’s committed to delivering reliable energy to homes and businesses in Arkansas, Colorado, Maine, Missouri, Oklahoma, and Texas. Being part of the Summit team means embracing excellence and innovation, committing to safety each and every day, and doing all that we can to serve each other, our customers, and the communities where we live. We aim to bring warmth and energy to everything we do.

We have an exciting opportunity for a Senior BI Architect. This role can be hybrid in any of the following states: Arkansas, Missouri, and Maine, or remote in Texas.

POSITION SUMMARY

We are seeking a Senior BI Architect to lead the design, governance, and evolution of Summit Utilities’ enterprise analytics architecture. This role serves as the technical authority for Power BI, semantic modeling, data architecture, and BI development standards.

Working closely with Data Engineering and business stakeholders, the Senior BI Architect will ensure enterprise data is translated into scalable, trusted, and high-performing analytics solutions that support operational, financial, and executive decision-making. This position plays a key leadership role in establishing technical standards, optimizing platform performance, mentoring BI developers, and guiding the continued growth of our Microsoft Fabric analytics environment.

The ideal candidate combines deep expertise in Power BI, data modeling, SQL, and Microsoft Fabric with the ability to influence technical direction, solve complex business challenges, and develop team capability.

PRIMARY DUTIES AND RESPONSIBILITIES

• Lead the design, governance, and optimization of Summit's enterprise analytical architecture, including Power BI semantic models, certified datasets, and reporting standards.
  Establish and maintain best practices for data modeling, security, performance tuning, deployment, and lifecycle management across the BI environment.
  Architect scalable analytics solutions that support operational, financial, and executive reporting needs.
  Partner with Data Engineering to define requirements for curated data models and ensure alignment between enterprise data architecture and business intelligence solutions.
  Design and optimize dataflows, semantic models, DAX measures, and refresh processes to improve performance, scalability, and reliability.
  Define and maintain role-based security and access controls across reporting environments.
  Monitor and optimize Microsoft Fabric platform usage, capacity, and overall BI ecosystem performance.
  Provide technical leadership, mentorship, and code review for BI developers while promoting development standards and best practices.
  Develop and maintain architecture documentation, data definitions, and governance standards.
  Advise leadership on BI strategy, platform capabilities, and future-state architecture decisions.

EDUCATION AND WORK EXPERIENCE

Required

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Administration, or a related field; equivalent professional experience may be considered.
  10+ years of experience in Business Intelligence, analytics engineering, enterprise reporting, or data warehousing.
  6+ years of hands‑on Power BI development experience, including semantic modeling, dataset design, and advanced DAX.
  3+ years serving in a lead, principal, or architect-level role with responsibility for technical standards and architecture decisions.
  Demonstrated experience designing and supporting enterprise-scale analytics solutions.
  Experience working within Microsoft Fabric, Azure data services, or comparable cloud analytics platforms.
  Proven experience mentoring technical teams and establishing development standards.

Preferred

• Experience within utility, energy, financial services, healthcare, or other regulated industries.
  Experience supporting executive and board-level reporting environments.
  Experience with SAP and/or SAP Analytics Cloud (SAC).
  Experience working in Agile or sprint-based delivery environments.
  Microsoft certifications such as DP-600, DP-500, or PL-300.

KNOWLEDGE, SKILLS, ABILITIES

Technical Expertise

• Advanced expertise in Power BI Desktop and Power BI Service.
  Expert-level DAX development and performance optimization.
  Strong Power Query (M) and dataflow development skills.
  Advanced SQL development, tuning, and troubleshooting abilities.
  Experience with Microsoft Fabric components including Warehouses, Lakehouses, Semantic Models, and OneLake.
  Strong understanding of dimensional modeling, star schema design, and enterprise semantic modeling.

Architecture & Governance

• Knowledge of data security, row-level security (RLS), deployment pipelines, and governance practices.
  Experience with version control, release management, and BI lifecycle processes.
  Ability to establish standards for performance, scalability, reliability, and maintainability.

Leadership & Business Partnership

• Strong analytical and problem‑solving skills.
  Ability to translate business requirements into scalable technical solutions.
  Excellent verbal and written communication skills.
  Proven ability to mentor developers and influence technical direction.
  Ability to manage multiple priorities in a fast‑paced environment.
  Collaborative leadership style with a commitment to continuous improvement and data quality.

The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and/or skills required of all personnel so classified.

Summit offers competitive pay and medical/dental/vision and other benefits that provide flexibility, choice, and support to our employees when they need it most. We understand that home and family are essential pieces of your life, and our benefits are designed to support you both at work and at home.

Equal employment opportunity, including veterans and individuals with disabilities.

Summit Utilities, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or protected veteran status and will not be discriminated against on the basis of disability or veteran status.