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
- 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.
- 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
- 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.
- 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.
- 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.
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
