Job Duties
- 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
EXPERIENCE
Experience - Reporting Analyst 2
-
Minimum 1-year experience in excess of degree requirements
-
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
Experience - Reporting Analyst 3
-
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
-
Programming experience required 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.
EDUCATION
-
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
Electric Reliability Council of Texas
Texas United States
www.ercot.com
