Settlements Analyst Lead
Electric Reliability Council of Texas

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.
Settlements Analyst performs settlement calculations and responds to inquiries from the Qualified Scheduling Entity/Retail Electric Provider (QSE/REP) Account Representatives.
Demonstrates knowledge and expertise in the detailed operations of congestion, profiling, unaccounted for energy (UFE) analysis, settlement calculation and the associated grid/operational ERCOT charges. Assists with projects, as necessary, to implement ERCOT's Commercial Operation Systems including future enhancements. Assists with system development, product implementation, certification and testing criteria.
JOB DUTIES
- Contributes to specific objectives and outcomes as directed
- Serves as subject matter expert for the Settlement of the ERCOT nodal market
- Develops protocol language and system requirements related to Settlements
- Creates test cases, test scripts, test data and validation tools (using SAS) to test changes to the settlement system
- Demonstrates knowledge and expertise in the detailed settlement system and calculations
- Leads and serves on projects, as necessary, to implement ERCOT's Commercial Operation Systems including future enhancements
- Provides leadership and assists with system development, product implementation, certification and testing
- Ensures the quality of deliverables and artifacts delivered by Settlement Analysts
- Provides mentoring, on-the-job training, and oversees the work of other Settlement analysts
- Develops and maintains a strong level of understanding of the competitive energy markets
- Takes initiative and identifies detailed solutions and improvements to procedures and software to improve accuracy, efficiency, and timeliness
- Resolves Market Participants questions, disputes, and data errors in the operations of settlement computations
- Assists with the day-to-day activities of the team
- Responsible for notifying superiors of key issues
- Develops strong working relationships with the key staff members of the Settlement Team, and promotes similar relationships with staff members of other ERCOT departments
- Clearly communicates complex technical concepts both in a written and oral manner
- Support the Settlement Team and work with peers to accomplish team objectives and ERCOT initiatives
- Has working knowledge of market and power systems and the understanding of the data elements passed from these systems to the settlement system
- Writes and executes SQL queries to generate results used in analytical reports
- Writes and executes SAS code to certify system changes and verify calculations from the production system
- Uses knowledge of software life cycle to complete tasks, enhance tools and ensure effective process flow
- Lead Level: Requires minimum 8 years job related work experience in excess of degree requirements
- Working with excel including: complex formulas, pivot tables and graphs
- Experience in interpreting and manipulating algebraic equations
- Experience with, or aptitude for, SQL, Visual Basic and SAS
- Bachelor's Degree : Business Administration, Engineering, Mathematics, Finance or related; (Required)
- or a combination of education and experience that provides equivalent knowledge to a major in such fields is required
- This position is Remote First. The majority of job duties can be performed remotely from your Texas residence.
- May be required to be on-site at the Taylor or Austin facilities at least once a month, or more based on the business needs and as determined by the Manager
- Work arrangements are subject to business needs and are subject to change accordingly
- Employees may opt to work on-site more than required or 100% of the time
#LI-Remote
About this Employer
The Electric Reliability Council of Texas (ERCOT) manages the flow of electric power to more than 26 million Texas customers -- representing about 90 percent of the state’s electric load. As the independent system operator for the region, ERCOT schedules power on an electric grid that connects more than 52,700+ miles of transmission lines and 1,030+ generation units, including PUNs. It also performs financial settlement for the competitive wholesale bulk-power market and administers retail switching for 8 million premises in competitive choice areas. ERCOT is a membership-based 501(c)(4) nonprofit corporation, governed by a board of directors and subject to oversight by the Public Utility Commission of Texas and the Texas Legislature. Its members include consumers, cooperatives, generators, power marketers, retail electric providers, investor-owned electric utilities, transmission and distribution providers and municipally owned electric utilities.