Share this Job






Energy Analyst/Data Analyst/Business Analyst

Johnson City, TX, US, 78636

Open until filled

Position Summary:

This position is responsible for assisting the Markets Department in the analysis of electric energy supply strategies, power purchase contracts, project development, load trends and rates and pricing strategies in support of the Cooperative's strategic initiatives.


Essential Duties and Responsibilities:

  • Perform quantitative analysis of historic market pricing data, load data and other factors that drive the strategic decisions for the cooperatives power supply
  • Create models and tools to automate, increase accuracy and expedite analysis
  • Assist the Markets Department with database queries,  cleaning and formatting of large amounts of data
  • Identify sources of appropriate economic demographic and load data,  design studies to collect and analyze pertinent information in support of load and revenue forecasting activities
  • Develop and maintain cash flow simulation models for purchased power, load costs and rate recovery
  • Develop portfolio and market impact analysis based on Nodal Protocols Revision Requests
  • Develop analytical techniques used in the economic analysis of various supply options and contracts
  • Develop, analyze and interpret load data to understand customer usage patterns for use in forecasting models, rate design and energy services offerings
  • Update existing and create new revenue and expense forecasting models using proven methodologies
  • Compare forecast performance with actual results,   explain variances and recommend changes for future forecasting cycles
  • Perform financial evaluation and analysis of different retail rate structures
  • Research economic trends, emerging industry issues, impact of technologies, i.e.,  renewables, energy storage, end-use efficiencies, etc. and develop recommendations regarding their effects on usage patterns and the future demand
  • Monitor electric market data and factors, regulatory changes and competitor’s rate offerings
  • Develop and maintain critical information, history and databases
  • Provide routine and ad-hoc reports and analysis
  • Develop presentations and reports
  • Maintain the security of confidential information
  • Stay abreast of changes in technology


Supervisory and/or Leadership Responsibilities: 

  • May provide technical direction, training and project lead responsibilities


Knowledge, Skills and Abilities:

  • Knowledge of using computer systems, which may include setting up and using hardware and software programs, entering data, configuration, or processing information
  • Knowledge of principles and processes for providing customer service
  • Knowledge of ERCOT market operations
  • Knowledge of ERCOT’s Nodal Protocols and financial settlement concepts
  • Skilled in time management
  • Skilled in prioritizing and managing changing priorities
  • Skilled in prioritizing, time management and managing changing priorities
  • Skilled in project management
  • Ability to function in a complex, rapid changing environment
  • Ability to query data, manipulate databases, and create reports and dashboards from databases
  • Ability to compute and interpret complex financial and statistical data
  • Ability to stay organized amid many evolving projects; detail-oriented and methodical with large amounts of data
  • Ability to manipulate and analyze data
  • Ability to work in a team oriented environment providing ideas and open feedback
  • Ability to maintain confidentiality
  • Ability to communicate effectively verbally and in writing
  • Ability to listen and understand information verbally and in writing
  • Ability to anticipate, identify, analyze and resolve conflict and problems


Minimum Qualifications – (Education, Experience, Certification, & Licensure):

  • Bachelor’s Degree in Mathematics, Statistics, Engineering, Economics, Accounting, Finance or related discipline
  • Five years relevant experience
  • Directly related experience may substitute for education
  • Valid Driver’s License


Preferred Qualifications:

  • Advanced degree
  • Forecasting, statistical analysis and financial evaluation experience 
  • Five years querying and managing large data sets
  • Advanced user of Microsoft Excel
  • Advanced user of database querying tools
  • Proficiency with SQL, VBA, and other programming languages
  • Experience with scrubbing and managing large data sets





Pedernales Electric Cooperative is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected Veteran status, sexual orientation and gender identity. 

Join PEC

At PEC, we know happy employees produce great work. That’s why we’ve recently been named a Top Workplace by both the Austin American-Statesman and the San Antonio Express-News! As a PEC employee, you’ll find we’re always willing to invest in you — because we know that we do better when you do better.



Nearest Major Market: Austin

Job Segment: Database, Law, Supply, SQL, Technology, Energy, Legal, Operations