Business Intelligence Analyst II

Summit Utilities Inc•Portland, ME

5h•Hybrid

About The Position

The Business Intelligence Analyst II is a mid-level, high-impact contributor accountable for converting business questions into actionable insights that accelerate operational excellence and strategic decision-making. This role sits at the intersection of data, process, and performance—driving clarity, enabling leaders to “see the business,” and elevating our maturity across analytics. This individual is expected to navigate ambiguity, pressure-test requirements, and deliver dashboards and analyses that business leaders can run their operations on with confidence.

Requirements

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.
Demonstrated ability to translate business problems into analytic solutions and present insights to non-technical audiences.
Experience working with relational databases, SQL, and complex data models.
Proven ability to manage competing priorities, engage stakeholders, and deliver in a dynamic environment
Strong analytical and critical thinking skills, with the ability to interpret complex data and provide actionable insights.
Excellent communication skills, both written and verbal, to effectively convey technical information to non-technical stakeholders.
Advanced problem-solving abilities and a proactive approach to identifying and resolving data-related issues.
High attention to detail and commitment to data accuracy and quality.
Strong organizational skills with the ability to manage multiple tasks and prioritize work in a fast-paced environment.
Demonstrated capacity for continuous learning and adaptation to new technologies and analytical methodologies.
Ability to collaborate effectively with cross-functional teams and build strong working relationships with stakeholders.
Self-motivation and a results-driven mindset, with a focus on delivering value to the business.

Nice To Haves

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.

Responsibilities

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, leverage semantic models, and position leaders to take swift, 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.
Leverage exploratory techniques to answer ad-hoc questions, validate hypotheses, and guide decision-making.
Stress-test data quality, completeness, and lineage issues and escalate effectively.
Partner with the Data Engineering & Architecture team to ensure pipelines and models meet business logic and analytic use case needs.
Validate the accuracy of semantic models, KPIs, and business rules and help mature certified data products.
Partner with Operations, Finance, Customer Experience, Regulatory, IT, and other business units to ensure analytics meet strategic needs.
Communicate complex data and insights to leadership in a clear and actionable way.
Support training and user enablement efforts that build data literacy across the organization.
Provide support for self-service users, ensuring they are aligned 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 the evolution of enterprise visualization standards and metric definitions.