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 diversity and inclusion at all levels of our company. It is the cornerstone of our corporate values of accountability, leadership, innovation, trust, and expertise. We accept and celebrate those that join us and recognize that individuals with a wide variety of talents, ideas, and experiences propel the innovation that drives our success. A diverse and inclusive workforce strengthens us and allows for a collaborative environment to solve the challenges that face our industry today and in the future.

ERCOT offers the flexibility to work both in and out of the office within the state of Texas, providing our employees with an enhanced work life balance.

JOB SUMMARY

Responsible for all phases of report development and associated data acquisition, compilation, analysis, interpretation, and quality assurance/control activities. Prepares several monthly, quarterly, and annual reports with information on generation technology trends and resource adequacy forecast and risk assessment information ranging from months to years ahead. Maintains interactive online reports in addition to handling basic data management and report preparation responsibilities.

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
• Supports analysis 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 C or C++, SQL and Microsoft Office Suite to develop models, design systems and resolve technical problems
• Performs other duties as assigned

REQUIRED EXPERIENCE

Experience - Reporting Analyst 1

• No minimum work experience required
• Experience in the electric power industry preferred, or academic coursework/projects related to electric power industry topics
• Experience in Microsoft Excel required
• Familiarity with data mining and visualization tools such as Tableau, Power BI, Cognos, Python visuals
• Programming experience helpful (Excel VBA, SQL, Python, R, SAS, Matlab, or other languages/tools used for data analysis)
• Understanding of statistics concepts and demonstrated application of statistical analysis methods

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 within the electric utility industry preferred
• Demonstrated experience in creating dashboards, and building/publishing customized interactive reports using a tool such as Tableau, Power BI, Cognos, Python visuals
• Knowledge of advanced Excel features required, such as pivot tables, data analysis tools, forecasting tools, etc.
• Programming experience desired in at least one language (Excel VBA, SQL, Python, R, SAS, Matlab, or other languages/tools used for data analysis)
• Understanding of statistical concepts and experience using descriptive analytics techniques

Experience - Reporting Analyst 3

• Minimum 3 years' experience in excess of degree requirements
• Experience in the electric power industry preferred, or academic coursework/projects related to electric power industry topics
• Extensive experience in designing and building data sets from various sources, and managing the production of multiple, complex reports adhering to strict release schedules.
• Demonstrated experience in creating complex dashboards, and building/publishing customized interactive reports.
• Programming experience required in at least one language (Excel VBA, SQL, Python, R, SAS, Matlab, or other languages/tools used for data analysis).
• 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.

Experience - Reporting Analyst Sr

• Minimum 5 years' experience in excess of degree requirements
• Experience in the electric power industry preferred, or academic coursework/projects related to electric power industry topics
• Extensive experience in designing and building data sets from various sources, and managing the production of multiple, complex reports adhering to strict release schedules
• Demonstrated experience in creating complex dashboards, and building/publishing customized interactive reports
• Programming experience required in more than one language (Excel VBA, SQL, Python, R, SAS, Matlab, or other languages/tools used for data analysis)
• 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.