Data Analyst
About the role
Bandera Electric Cooperative (BEC) and BEC Fiber are seeking a Data Analyst to turn the cooperative’s energy and demand-response data into clear reports, dashboards, and analysis that support day-to-day program decisions and season performance. The role will work within the Demand Response Program and the broader Energy Services team, building and maintaining recurring reporting, analyzing trends and outcomes, and preparing data views that feed scheduling, go/no-go, and bid decisions.
Responsibilities
- Build and maintain demand-response performance dashboards and recurring reports, including 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 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
- Provide reporting, dashboard, and analysis support to other departments across the cooperative as time allows and as assigned
Skills
- 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
- 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
Qualifications
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) is required.
- 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 (preferred)
- Familiarity with demand response, distributed energy resources, or ERCOT data (preferred)
- Experience with Apolloware or comparable utility/energy platforms (preferred)
Requirements
- Valid Texas Driver’s License and related insurance
- Must pass background and drug screening
Benefits
Highly competitive wages and a generous benefit package, with no waiting period – benefits start on the first day. Paid time off and ten paid holidays are also offered.