Resource Adequacy Analyst
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