ERCOT is a dynamic organization focused on building the future of the Texas power grid and wholesale market. They are seeking a Resource Adequacy Analyst to compile and validate data, prepare reports, and analyze electricity generation and demand data to support decision-making processes.

Responsibilities

• Compiles and validates data
• Prepares resource adequacy and interconnection request status reports, and conducts reviews of reports prepared by others
• Analyzes data related to electricity generation, energy storage technologies, electricity demand, demand response programs, and ERCOT planning & operations for report preparation and ad hoc analyses
• Assists the Resource Adequacy team in building and maintaining interactive reports/dashboards using data visualization tools and techniques
• Applies advanced analytical techniques (trend analysis, correlation analysis, time series modeling, data visualization, etc.) to analyze and validate data
• Performs QA/QC activities to minimize data errors; develops data analysis/validation tools as needed to improve report quality
• Responds to data requests made by governmental entities, ERCOT Market Participant groups, or other ERCOT departments
• Helps prepare responses to public inquiries and data filing requests from the North American Reliability Corporation, Federal Energy Regulatory Commission and Texas Reliability Entity
• Prepares technical reports/summaries, presentation materials, operating procedures, and other process documentation
• Uses programming skills in SQL and Microsoft Office Suite to support existing or new automation tools for report development
• Uses Generative Artificial Intelligence tools and ERCOT’s Microsoft Power BI/Databricks platform to support work activities
• Performs other duties as assigned

Skills

• Minimum 1-year experience in excess of degree requirements
• Bachelor's Degree: Mathematics, Finance, Economics, Data Science or related field (Required)
• Or a combination of education and experience that provides equivalent knowledge to a major in such fields is required
• Demonstrated experience in producing multiple reports using quality control procedures
• Familiarity with dashboards and automated report development using a tool such as Power BI, Tableau, Cognos, or Python visuals
• Programming experience required in at least one language used for data processing and analysis (Excel VBA, SQL, Python are preferred)
• Understanding of basic statistical concepts and experience using descriptive analytics techniques, including generative Artificial Intelligence (AI) tools
• Experience in the electric power industry preferred, or academic coursework/projects related to electric power industry topics preferred
• Knowledge of advanced Excel features desired, such as pivot tables, data tools, conditional formatting, etc
• Programming experience desired in at least one language used for data processing and analysis (Excel VBA, SQL, Python are preferred)
• Understanding of advanced statistical concepts and demonstrated application of descriptive/predictive analytics methods such as regression analysis, time-series models, curve-fitting, data interpolation/extrapolation, etc
• Minimum 3 years' experience in excess of degree requirements
• Experience in the electric power industry, or academic coursework/projects related to electric power industry topics, preferred
• Extensive experience in designing and building data sets from various sources, and managing the production of multiple, complex reports adhering to strict release schedules and quality control processes
• Demonstrated experience in creating dashboards, and building/publishing customized interactive reports using a tool such as Power BI, Tableau, Cognos, or Python visuals

Company Overview

Company H1B Sponsorship