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.