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
WORK LOCATION
- May be required to be on-site at the Taylor, TX facilities at least twice a week, or more based on the business needs and as determined by the Manager
The foregoing description reflects the minimum qualifications and the essential functions of the position that must be performed proficiently with or without reasonable accommodation for individuals with disabilities. It is not an exhaustive list of the duties expected to be performed, and management may, at its discretion, revise or require that other or different tasks be performed as assigned. This job description is not intended to create a contract of employment with ERCOT. Both ERCOT and the employee may exercise their employment-at-will rights at any time.
Expected Salary Range:
$75,000 - $103,000
