Program Analyst

CLEAResult

Operations Analyst managing data PowerBi reporting and integrations for energy efficiency programs. Collaborating with IT and operations to ensure compliance and data reliability in service delivery.

Posted 5/15/2026full-timeAllentown • Pennsylvania • 🇺🇸 United StatesJuniorMid-Level💰 $55,700 - $83,500 per yearWebsite

About the role

Key responsibilities & impact

Manage and support data PowerBi reporting and data integrations between internal systems and client platforms, ensuring accurate, timely, and compliant data delivery.
Build, monitor, and maintain PowerBi dashboards, both for internal program team use and client facing reporting.
Build, monitor, and maintain automated data pipelines using integration tools (such as SnapLogic) to load, validate, and reconcile data across systems.
Analyze source and target data structures to identify mapping requirements, transformation logic, and data quality risks.
Partner with internal operations, IT, and data teams to troubleshoot integration issues, resolve failures, and improve integration reliability.
Support program reporting deliverables and requirements with data analytic and visual reporting needs.
Support recurring and ad‑hoc data loads, validation checks, and audit requests to ensure alignment with client reporting and system requirements.

Requirements

What you’ll need

2 or more years of relevant experience in PowerBi, data integrations, operations analytics, systems support, or a related field
Bachelor’s degree preferred or equivalent professional experience
Hands‑on experience with Salesforce and/or data integration platforms (SnapLogic strongly preferred); experience managing automated system‑to‑system data transfers
Strong proficiency in Microsoft Excel and data validation techniques; experience working with structured datasets from multiple source systems
If applicable, meet all DOT qualification requirements and comply with all applicable federal, state, and local transportation regulations.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PowerBidata integrationsautomated data pipelinesdata validationdata analyticsdata qualitydata mappingdata transformationoperations analyticsstructured datasets

Soft Skills

troubleshootingproblem-solvingcommunicationcollaborationattention to detail