Senior BI Architect

Posted 3 Days Ago
Be an Early Applicant
7 Locations
In-Office or Remote
Senior level
Utilities
The Role
Leads enterprise business intelligence architecture, governance, and optimization across Power BI and Microsoft Fabric. Designs semantic models, dataflows, DAX measures, security controls, deployment processes, and reporting standards. Partners with data engineering and business stakeholders to deliver scalable analytics for operational, financial, and executive decisions. Provides technical leadership, mentors BI developers, documents architecture, and advises leadership on platform strategy and future-state analytics capabilities.
Summary Generated by Built In

Join our growing team and discover why 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. 

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.

Skills 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 in a lead, principal, or architect-level role with responsibility for technical standards and architecture decisions.
  • Experience designing and supporting enterprise-scale analytics solutions.
  • Experience with Microsoft Fabric, Azure data services, or comparable cloud analytics platforms.
  • Experience mentoring technical teams and establishing development standards.
  • Experience within utility, energy, financial services, healthcare, or another regulated industry.
  • Experience supporting executive and board-level reporting environments.
  • Experience with SAP and/or SAP Analytics Cloud.
  • Experience working in Agile or sprint-based delivery environments.
  • Microsoft certifications such as DP-600, DP-500, or PL-300.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Englewood, Colorado
500 Employees
Year Founded: 1997

What We Do

Summit Utilities, Inc. is a privately-held holding company that owns and operates several natural gas distribution and transmission subsidiaries that operate in Arkansas, Colorado, Maine, Missouri, Oklahoma, and the Texarkana, Texas area. The company provides safe, clean and affordable natural gas to businesses and residents in six states through Arkansas Oklahoma Gas, Colorado Natural Gas, Summit Natural Gas of Maine, Summit Natural Gas of Missouri, Summit Utilities of Arkansas, and Summit Utilities of Oklahoma. Each of Summit’s natural gas distribution and transmission subsidiaries constructs and installs natural gas distribution systems with the goal of supporting economic development by providing clean-burning, safe and reliable natural gas to residential and commercial customers through exceptional customer service and commitment to community. Overall, Summit entities serve approximately 625,000 customers and operate more than 23,400 miles of pipeline. Being part of the Summit team means embracing excellence, diversity 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. To see our latest job openings, please visit: https://summitutilitiesinc.com/careers See also: Colorado Natural Gas at https://www.linkedin.com/company/colorado-natural-gas/ Summit Natural Gas of Missouri at https://www.linkedin.com/company/summit-natural-gas-of-missouri/ Summit Natural Gas of Maine at https://www.linkedin.com/company/summit-natural-gas-of-maine/ Arkansas Oklahoma Gas (AOG) at https://www.linkedin.com/company/arkansas-oklahoma-gas-corp./ and Summit Utilities https://www.linkedin.com/company/summit-utilities

Similar Jobs

Boeing Logo Boeing

Senior Systems Engineering - Integration & Test SEIT (Vitual)

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
In-Office or Remote
San Antonio, TX, USA
170000 Employees
153K-239K Annually

MetLife Logo MetLife

Senior Controls Analyst

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Remote or Hybrid
United States
43000 Employees
65K-81K Annually

Atlassian Logo Atlassian

Account Manager

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
In-Office or Remote
Austin, TX, USA
11000 Employees
112K-175K Annually

Motive Logo Motive

Internal Communications, Lead (Individual Contributor)

Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Easy Apply
Remote
United States
4000 Employees
160K-190K Annually

Similar Companies Hiring

T-Mobile Thumbnail
Other • Utilities
Bellevue, WA
89016 Employees
Treeswift Thumbnail
Artificial Intelligence • Hardware • Machine Learning • Robotics • Software • Utilities
New York, New York
55 Employees
Energy CX Thumbnail
Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Chicago, IL
108 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account