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 inclusion at all levels of our company. It is the cornerstone of our corporate values of accountability, leadership, innovation, trust, and expertise. We know that individuals with a wide variety of talents, ideas, and experiences propel the innovation that drives our success. An inclusive and diverse workforce strengthens us and allows for a collaborative environment to solve the challenges that face our industry today and in the future.
JOB SUMMARY
The Settlement Analyst performs settlement calculations for the ERCOT nodal market and responds to inquiries from Market Participants' Account Representatives. Analysts build deep expertise in settlement calculations and support projects to implement and enhance ERCOT's Commercial Operations Systems. Serves as the subject matter expert for 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.
JOB DUTIES
Level I
- Assists with projects, as necessary, to implement ERCOT's Commercial Operations Systems, including future enhancements
- Assists with system development, product implementation, certification, and testing
- Develops and maintains a strong understanding of the competitive energy markets
- Identifies and recommends improvements to procedures and software that increase accuracy, efficiency, and timeliness
- Writes and executes SQL queries to generate results for analytical reports
- Writes and executes SAS code to certify system changes and verify calculations from the production system
- Resolves Market Participant questions, disputes, and data errors related to settlement computations
- Assists with day-to-day team activities
- Keeps the Senior and/or Lead Settlement Analyst informed of system issues through formal status reports and informal updates (email, team discussion)
- Notifies leadership of key issues in a timely manner
- Builds strong working relationships with Settlement Team members and colleagues across ERCOT departments
- Clearly communicates complex technical concepts, in writing and verbally, to both technical and non-technical audiences
- Supports the Settlement Team and collaborates with peers to meet team objectives and ERCOT initiatives
- Maintains working knowledge of market and power systems, and understands how data elements flow from these systems into the settlement system
Level II — Includes all Level I duties, plus:
- Demonstrates advanced knowledge and expertise in detailed settlement calculations
- Takes initiative to identify and recommend solutions and improvements that increase accuracy, efficiency, and timeliness
- Serves on projects to implement ERCOT's Commercial Operations Systems, including future enhancements
- Mentors other analysts within the department
- Applies knowledge of the software development lifecycle to complete tasks, enhance tools, and support effective process flow
Senior Level — Includes all Level I and II duties, plus:
- Provides on-the-job training and oversees the work of other analysts
- May lead projects to implement ERCOT's Commercial Operations Systems, including future enhancements
- Ensures the quality of deliverables and artifacts produced by Settlement Analysts
- Supports the Lead Settlement Analyst with day-to-day team activities
EXPERIENCE
- Level I: Requires no minimum work experience beyond degree requirements
- Level II: Minimum 2 years of relevant work experience beyond degree requirements
- Senior Level: Minimum 5 years of relevant work experience beyond degree requirements
EDUCATION
- Requires Bachelor's degree in Business Administration, Engineering, Mathematics, Finance, or a related field (required), or an equivalent combination of education and experience
- Prefer proficient in Excel, including complex formulas, pivot tables, and graphs
- Prefer comfortable interpreting and manipulating algebraic equations
- Prefer experience with, or aptitude for, SQL, Visual Basic, and SAS
WORK LOCATION
- Employees are required to work on-site in Taylor, TX at least 2 days per week, or more as business needs require, as determined by management
- On-site schedules are flexible and may be adjusted based on business needs, as determined by the Manager
- Remote work must be performed from the employee's Texas residence
- Employees may choose to work on-site more than required, up to full-time
- #LI-DN
ERCOT is firmly committed to equal employment for all qualified persons without regard to race, sex, medical condition, religion, age, creed, national origin, citizenship status, marital status, sexual orientation, physical or mental disability, ancestry, veteran status, genetic information or any other protected category under federal, state or local law.
Expected Salary Range:
$83,000 - $114,000Skills Required
- Bachelor's degree in Business Administration, Engineering, Mathematics, Finance, or a related field, or an equivalent combination of education and experience
- Level I requires no minimum work experience beyond degree requirements
- Level II requires at least 2 years of relevant work experience beyond degree requirements
- Senior Level requires at least 5 years of relevant work experience beyond degree requirements
- Proficiency in Excel, including complex formulas, pivot tables, and graphs
- Comfort interpreting and manipulating algebraic equations
- Experience with or aptitude for SQL, Visual Basic, and SAS
What We Do
The Electric Reliability Council of Texas (ERCOT) manages the flow of electric power to 27 million Texas customers - representing about 90 percent of the state's electric load. As the independent system operator (ISO) for the region, ERCOT schedules power on an electric grid that connects more than 54,100 miles of transmission lines and 1,250+ generation units, including Private Use Networks. ERCOT 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. ERCOT's members include consumers, cooperatives, generators, power marketers, retail electric providers, investor-owned electric utilities (transmission and distribution providers), and municipal-owned electric utilities.
