Energy Data Analyst: Demand Response Dashboards

Bandera Electric Cooperative; Boerne (TX); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Generous benefits package

Job summary

Bandera Electric Cooperative (BEC) is seeking a Data Analyst to turn energy and demand-response data into clear reports, dashboards, and analyses that support day-to-day program decisions.

Reporting to the Energy Services Director, you will build recurring reports, validate data quality, and translate complex data into actionable insights for scheduling, bids, and performance benchmarking.

Qualifications

• 1–3 years of experience producing reports or dashboards or analyzing operational data.
• Experience writing SQL queries against relational databases.
• Familiarity with electric utility or cooperative operations.
• Familiarity with demand response, distributed energy resources, or ERCOT data.
• Experience with Apolloware or comparable utility/energy platforms.

Responsibilities

• Build and maintain demand-response dashboards and recurring reports — event count, thermostat and battery participation, estimated MWh, member savings, and 4CP versus non-4CP value.
• Validate all reports and dashboards for data accuracy before distribution.
• Maintain documentation for all reporting solutions, including data sources, logic, and refresh schedules.
• Update reports and dashboards promptly when underlying data or program needs change.
• Analyze event outcomes, enrollment trends, and forecast accuracy; surface anomalies and trends.
• Prepare the data views that inform the weekly schedule, the monthly bid cycle, and the season benchmark.
• Build lightweight, self-serve connections (Power Query, scheduled refreshes, direct queries) to pull program data for reporting and benchmarking.
• Do not build or own production pipelines feeding the bid or validation path; durable, shared data infrastructure remains with the data and reconciliation engineer.
• Support analysis only; do not certify capacity, prepare or approve bids, or serve as the validation gate.
• Route platform issues through the Program Manager rather than directly to the developer or vendor.
• Work with Energy Services staff and the Program Manager to understand reporting needs and translate them into useful views.
• Provide clear status updates on in-progress work at regular intervals or upon request.
• Contribute to program planning and continuous-improvement efforts.
• As time allows and as assigned, provide the same reporting, dashboard, and analysis support to other departments across the cooperative.

Skills

Data analytics

Business intelligence

SQL

Power BI

Power Query

Excel

Data governance

Documentation

Presentation

Time management

Education

Bachelor's degree in data analytics, business, engineering, energy, information technology, or related field

Microsoft Certified: Power BI Data Analyst Associate or 2+ years with SQL/Power BI/Excel (Power Query)

Tools

Power BI

Power Query

Excel

SQL

Job description

Bandera Electric Cooperative (BEC) is seeking a Data Analyst to turn energy and demand-response data into clear reports, dashboards, and analyses that support day-to-day program decisions.

Reporting to the Energy Services Director, you will build recurring reports, validate data quality, and translate complex data into actionable insights for scheduling, bids, and performance benchmarking.