Technical Business Analyst

Technical Business Analyst

The Technical Business Analyst supports Utility Energy Efficiency programs. This role is responsible for turning program data into accurate client deliverables, management of information, controlled transactions, dashboards, and repeatable processes. The position operates with a high degree of independence and is expected to proactively identify issues, improve processes, and help program leadership understand what the data is showing and what actions may be needed.

Tasks include:

· Prepare weekly, monthly, and periodic reporting, including charts, visuals, and executive-ready program updates.

· Build, maintain, and improve Power BI dashboards used for program management, KPI tracking, QA/QC, and executive reporting.

· Use Excel and SQL to pull, transform, reconcile, and validate data across multiple systems and sources.

· Create SQL queries for data extraction, validation, reconciliation, and dashboard development.

· Identify data errors and investigate the underlying cause; resolve discrepancies or escalate issues with clear recommendations.

· Support the development of QA/QC reporting and controls, particularly where no existing QA/QC system or dashboard is in place.

· Maintain allocation and budget-related reporting; monitor program dollars and identify potential overages, underspend, or strategic tradeoffs.

· Work with program, engineering, IT, and third-party stakeholders to implement new measures, update qualified product lists, and validate calculations and system changes.

· Work collaboratively across the three supported programs while maintaining clear ownership of assigned analysis, reporting, and technical deliverables.

The ideal candidate will have:

· Bachelor’s degree in analytic discipline, such as engineering, mathematics, statistics, or finance is strongly preferred. Or relevant experience

· Advanced Excel skills and Strong Power BI skills, including data modeling, dashboard development, data validation, and complex reconciliation.

· Intermediate SQL skills

· Some understanding of dollars, budgets, allocations, and the operational or strategic tradeoffs behind the numbers. *Formal accounting expertise is not required*

· Strong time management and prioritization skills

· Proactive communication skills and comfort flagging issues

· Self-starter mentality with a process-improvement mindset

· Strategic thinking and the ability to connect data & reporting to program objectives and decisions.

· Experience supporting energy efficiency, utility, rebate, or similarly data-intensive programs is a plus.