Power BI Analyst

CLEAResult

1d • $55,700 - $83,500

About The Position

At CLEAResult, we lead the transition to a sustainable, equitable, and carbon-neutral energy-efficient future for our communities and our planet. We do that by creating a people-first culture built on trust, accountability, and transparency; where every employee – regardless of position, role, or identity is treated with respect and given an equal chance to thrive. To be considered you must live in Pennsylvania. We are looking for a talented individual… To join our team as an Operations Analyst! Operations support staff ensure smooth delivery of projects and programs, both internally and externally, while adhering to program, practice, and operations guidelines. Operations support staff roles often encompass multiple areas including; data management, metrics and reporting, team facilitation and coordination, and process definition and improvement. These roles tend to be more internal-facing than client-facing, although people in operations roles will often have direct client, customer, or trade ally communication and contact. For this opportunity, you’re a great fit if you can… Analyze large, complex datasets to drive operational insights, identify trends and anomalies, and explain performance drivers using structured analytical methods. Design, maintain, and continuously improve workflows and business processes to increase efficiency, accuracy, and scalability. Build, own, and maintain automated Power BI reports and dashboards for internal and external stakeholders, including operational scorecards, forecasting views, and overall program performance reporting. Develop automated and reliable data transformations by cleaning, reshaping, validating, and combining data from multiple source systems using Power Query and related tools. Support recurring and ad‑hoc data collection and validation efforts to enable internal analysis, audits, compliance checks, and performance tracking. In this exciting career opportunity, you will have…

Requirements

• 5–8 years of relevant experience in operations analysis, reporting, data analytics, or a related field.
• Bachelor’s degree preferred or equivalent professional experience.
• Advanced proficiency in Microsoft Excel (including PivotTables and complex formulas), Power BI, and Power Query.

Responsibilities

• Analyze large, complex datasets to drive operational insights, identify trends and anomalies, and explain performance drivers using structured analytical methods.
• Design, maintain, and continuously improve workflows and business processes to increase efficiency, accuracy, and scalability.
• Build, own, and maintain automated Power BI reports and dashboards for internal and external stakeholders, including operational scorecards, forecasting views, and overall program performance reporting.
• Develop automated and reliable data transformations by cleaning, reshaping, validating, and combining data from multiple source systems using Power Query and related tools.
• Support recurring and ad‑hoc data collection and validation efforts to enable internal analysis, audits, compliance checks, and performance tracking.

Benefits

• Medical, Dental, and Vision Insurance; we also offer a company-paid health care concierge service to help navigate our health plan to make the best decisions for you and yours
• 401(k) with company match
• Paid vacation, sick, personal and parental leave time
• Paid Volunteer Time: giving back to our communities is important to us
• Employee Recognition Program – convert your recognition points into gift cards
• Employee Assistance Program – offers benefits to help you manage daily responsibilities
• Access to on-demand training courses to advance further in your career

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 501-1,000 employees