Business Intelligence Analyst II

Overview

Summit Utilities is a growing natural gas utility serving homes and businesses in Arkansas, Colorado, Maine, Missouri, Oklahoma, and Texas. Summit is focused on safety, excellence, and innovation, and aims to bring warmth and energy to all we do. This hybrid opportunity is for a Business Intelligence Analyst II located in Fort Smith, AR;
Fayetteville, AR;
Little Rock, AR;
Branson, MO;
Lawton, OK; or Portland, ME.

The Business Intelligence Analyst II is a mid-level, high-impact contributor responsible for translating business questions into actionable insights to accelerate operational excellence and strategic decision-making. This role operates at the intersection of data, process, and performance, delivering dashboards and analyses that business leaders can rely on.

• Lead the design, build, and enhancement of dashboards, scorecards, and reports that anchor our enterprise KPI framework.
• Translate business problems into analytical questions and solution designs using strong business acumen and BI best practices.
• Build visualizations that adhere to corporate standards and leverage semantic models to enable rapid, informed action.
• Facilitate structured discovery sessions to extract true business needs, challenge assumptions, and shape clear requirements.
• Interpret business processes, system flows, and pain points to define KPIs, metrics, thresholds, and data definitions.
• Provide coaching to the business on leading vs. lagging indicators and dashboard consumption best practices.
• Perform analysis on complex datasets to identify trends, anomalies, risks, and improvement opportunities.
• Use exploratory techniques to answer ad-hoc questions, validate hypotheses, and guide decision-making.
• Assess data quality, completeness, and lineage issues and escalate effectively.
• Collaborate with Data Engineering & Architecture to ensure pipelines and models meet business logic and analytics needs.
• Validate the accuracy of semantic models, KPIs, and business rules; support the maturation of certified data products.
• Partner with Operations, Finance, Customer Experience, Regulatory, IT, and other units to ensure analytics meet strategic needs.
• Communicate complex data and insights to leadership in a clear, actionable way.
• Support training and user enablement to build data literacy across the organization.
• Provide support for self-service users and ensure alignment with BI standards and KPI definitions.
• Drive adoption of BI tools, dashboards, and the Analytics Center of Excellence framework.
• Adhere to BI governance processes including metadata documentation, version control, and dashboard lifecycle management.
• Identify reporting redundancies, streamline legacy assets, and coach requesters on high-value use cases.
• Contribute to evolving enterprise visualization standards and metric definitions.

• Bachelor’s degree in Business, Data Analytics, Information Systems, Economics, Engineering, or related field—or equivalent experience.
• 5+ years of hands-on experience in BI development, analytics, or data visualization roles.
• Strong proficiency in Power BI (or similar tools) including DAX, data modeling, and dashboard design.
• Ability to translate business problems into analytic solutions and present insights to non-technical audiences.
• Experience with relational databases, SQL, and complex data models.
• Proven ability to manage competing priorities, engage stakeholders, and deliver in a dynamic environment.
• Experience in utilities, energy, infrastructure, or regulated industries.
• Exposure to Microsoft Fabric or modern cloud analytics platforms.
• Background with KPI frameworks, performance management, or operational analytics.
• Familiarity with semantic modeling, certified data products, or data governance programs.

• Strong analytical and critical-thinking skills with the ability to interpret complex data and provide actionable insights.
• Excellent written and verbal communication to convey technical information to non-technical stakeholders.
• Advanced problem-solving abilities and a proactive approach to data-related issues.
• High attention to detail and commitment to data accuracy and quality.
• Strong organizational skills and ability to manage multiple tasks in a fast-paced environment.
• Willingness for continuous learning and adaptation to new technologies and methodologies.
• Ability to collaborate with cross-functional teams and build strong relationships with stakeholders.
• Self-motivation and a results-driven mindset focused on delivering business value.

The statements above describe the general nature and level of work performed and are not intended to be exhaustive of all responsibilities, duties, and skills.

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…