Power BI Analyst

CLEAResult

48d • $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. Additionally, you will enjoy: • 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 Job Description 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… 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. Target compensation... $57,000 - $68,000 Compensation Range $55,700.00 - $83,500.00 Currency USD Type Salary Any offered salary is determined based on internal equity, internal salary ranges, market data/ranges, applicant’s skills and prior relevant experience, certain degrees and certifications (e.g. JD/technology), for example. CLEAResult will not provide sponsorship or support for immigration status or work authorization including for international students. Applicants must be authorized to work in the country where the position is located without the need for employer sponsorship or support. Successful hires must pass pre-employment checks. Equal Opportunity Employer As an Equal Opportunity Employer, we are committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job-related reasons regardless of an applicant’s race, color, religion, national origin, marital status, age, sex, gender identity, sexual orientation, status as a qualified individual with a disability or protected veteran, or any other protected status. The above job description and job requirements are not intended to be all inclusive. CLEAResult retains the right to make changes or adjustments to job descriptions and/or requirements at any time without notice. We change the way people use energy. CLEAResult started in Austin, Texas, in 2003 with a simple idea: a results-oriented company could have a positive impact by helping people make smart energy decisions. In the years since, we've grown to become the single largest provider of energy solutions in North America. Now, with offices in over 60 cities in the U.S. and Canada, we're able to tailor our efforts to fit our clients' specific needs, while positively impacting the energy landscape on a global scale. OUR MISSION We are driven to make a change. We offer a comprehensive set of energy programs and demand-side management strategies. Our energy experts design and maintain energy optimization services for utility companies as well as institutional, commercial and industrial organizations. We deliver solutions that lower load requirements for utilities, reduce energy bills for end users and minimize environmental burdens on communities. Every day, in every way possible, we change the way people use energy.

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