Data Analyst

Bandera Electric Cooperative•Boerne, TX

19d

About The Position

Bandera Electric Cooperative (BEC) and BEC Fiber are seeking a Data Analyst to join their team. This role will be responsible for transforming the cooperative's energy and demand-response data into clear reports, dashboards, and analyses to support daily program decisions and seasonal performance. The Data Analyst will work within the Demand Response Program and the broader Energy Services team, building and maintaining recurring reports, analyzing trends, and preparing data views for scheduling, go/no-go, and bid decisions. The position reports to the Energy Services Director, with program work directed by the Demand Response Program Manager. A working knowledge of electric power distribution and demand-response concepts is expected.

Requirements

Bachelor’s degree in data analytics, business, engineering, energy, information technology, or a related field, or equivalent work experience
Microsoft Certified: Power BI Data Analyst Associate certification or 2 years of experience working extensively with SQL, Power BI, or advanced Excel (Power Query)
1-3 years of experience producing reports or dashboards or analyzing operational data
Experience writing SQL queries against relational databases
Experience working with Python software
Working knowledge of data analytics, business intelligence, reporting, dashboard design, and data visualization principles.
Working knowledge of relational databases, SQL, Power BI, Power Query, Excel, and data-quality practices.
Working knowledge of electric utility operations, demand response, distributed energy resources, and related program performance measures.
Working knowledge of Python software.
Knowledge of forecasting, trend analysis, KPI development, and documentation standards.
Knowledge of data governance and documentation best practices
Strong data analysis, problem-solving, and critical-thinking skills.
Proficiency in developing reports, dashboards, visualizations, and SQL queries.
Strong data-validation, documentation, and quality-control skills.
Strong written, verbal, and presentation skills, including the ability to explain technical information to nontechnical audiences.
Strong organizational and time-management skills with the ability to manage multiple priorities and deadlines.
Ability to interpret complex data, identify trends and anomalies, and translate findings into actionable insights.
Ability to understand business needs and develop practical reporting and analytical solutions.
Ability to work independently while collaborating effectively with Energy Services, the Demand Response Program Manager, and other departments.
Ability to adapt reports and dashboards as data sources, program needs, and priorities change.
Ability to exercise sound judgment, maintain accuracy, and protect confidential or sensitive information.
Ability to manage multiple tasks and communicate proactively about workload and timelines
Valid Texas Driver’s License and Related Insurance
Must pass background and drug screening

Nice To Haves

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 performance dashboards and recurring reports — event count, thermostat and battery participation, estimated MWh, member savings, and 4CP versus non-4CP value — benchmarked against the prior-year baseline
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
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