Resource Adequacy Analyst

ERCOT • Taylor, TX

3d • $75,000 - $103,000 • Hybrid

About The Position

At ERCOT, our diverse and dynamic work environment provides a platform on which employees can work together to build the future of the Texas power grid and wholesale market utilizing the latest technologies and resources. We encourage you to join our talented, dedicated workforce to develop world-class solutions for today and tomorrow’s energy challenges while learning new skills and growing your career. ERCOT is committed to fostering inclusion at all levels of our company. It is the cornerstone of our corporate values of accountability, leadership, innovation, trust, and expertise. We know that individuals with a wide variety of talents, ideas, and experiences propel the innovation that drives our success. An inclusive and diverse workforce strengthens us and allows for a collaborative environment to solve the challenges that face our industry today and in the future.

Requirements

• Minimum 1-year experience in excess of degree requirements (for Reporting Analyst 2)
• Minimum 3 years’ experience in excess of degree requirements (for Reporting Analyst 3)
• Experience in the electric power industry preferred, or academic coursework/projects related to electric power industry topics preferred
• 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
• 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 basic statistical concepts and experience using descriptive analytics techniques, including generative Artificial Intelligence (AI) tools
• 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 (for Reporting Analyst 3)
• Demonstrated experience in creating dashboards, and building/publishing customized interactive reports using a tool such as Power BI, Tableau, Cognos, or Python visuals (for Reporting Analyst 3)
• Programming experience required in at least one language used for data processing and analysis (Excel VBA, SQL, Python are preferred) (for Reporting Analyst 3)
• 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. (for Reporting Analyst 3)
• 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

Nice To Haves

• 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)
• Experience in the electric power industry, or academic coursework/projects related to electric power industry topics, preferred
• Programming experience required in at least one language used for data processing and analysis (Excel VBA, SQL, Python are preferred)

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

Benefits

• health, dental, vision, life insurance, long/short-term disability insurance, long-term care insurance, Section 125 Flexible Spending Account, and a Retirement Savings Plan.
• 401(k) plans

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level