Technical Business Analyst

The JPI Group; Chicago (IL); In loco; USD 75.000 - 110.000; Tempo pieno

Descrizione del lavoro

The JPI Group seeks a Technical Business Analyst to transform program data into actionable client deliverables and manage dashboards and reports for energy efficiency programs.

Ideal candidates bring advanced Excel and Power BI skills, SQL experience, and a proactive, process-improvement mindset. You will collaborate across programs, IT, and engineering to validate calculations and support program leadership decisions.

Competenze

• Bachelor's degree in analytic discipline or related field.
• Advanced Excel skills with strong Power BI data modeling and dashboard development.
• Experience with SQL data extraction, validation, and reconciliation.
• Understanding of budgets, allocations, and program spend.
• Strong time management and prioritization skills.
• Proactive communication and process-improvement mindset.
• Experience supporting energy efficiency, utility, rebates, or data-intensive programs is a plus.

Mansioni

• Prepare weekly, monthly, and periodic reporting with 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 underlying causes; resolve discrepancies or escalate 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 or underspend.
• 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.

Conoscenze

Advanced Excel

Power BI

Data modeling

Dashboard development

Data validation

Reconciliation

Proactive communication

Time management

Prioritization

Process improvement

Strategic thinking

Data analysis

Formazione

Bachelor's degree in analytic discipline

Strumenti

SQL

Descrizione del lavoro

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.
• 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.