Settlements Operations Analyst

ERCOT; Taylor (TX); Hybrid; USD 61,131 - 100,871; Full time

Benefits offered by this job

Hybrid work model

Competitive salary

Professional development opportunities

Job summary

A leading energy solutions provider is seeking a Settlements Operations Analyst to work in a hybrid role based in Texas. The successful candidate will be responsible for overseeing settlements in the ERCOT nodal market, utilizing strong analytical skills and expertise in SQL and Excel. Candidates should have a background in Business, Engineering, Mathematics, or related fields, with a minimum of 2 years of relevant experience. This role offers competitive compensation and opportunities for professional growth.

Qualifications

• Minimum 2 years of job-related work experience.
• Proficient in complex Excel formulas and pivot tables.
• Experience interpreting algebraic equations.

Responsibilities

• Serve as subject matter expert for the Settlement of the ERCOT nodal market.
• Develop protocol language and system requirements related to Settlements.
• Resolve client questions, disputes, and data errors.

Skills

Expertise in market and power systems

Complex problem-solving

SQL proficiency

Advanced Excel skills

Strong communication skills

Education

Bachelor's Degree in Business Administration, Engineering, Mathematics, Finance or related

Tools

SQL

Visual Basic

SAS

Job description

Settlements Operations Analyst at ERCOT

Join the Settlements Operations Analyst role at ERCOT. 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 Duties

• Serves as subject matter expert for the Settlement of the ERCOT nodal market
• Develops protocol language and system requirements related to Settlements

Additional Job Duties

• 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
• Develops and maintains a strong level of understanding of the competitive energy markets
• Identifies detailed solutions and improvements to procedures and software to improve accuracy, efficiency, and timeliness
• Resolves client questions, disputes, and data errors in the operations of settlement computations
• Identifies and recommends improvements to procedures and software to improve accuracy, efficiency, and timeliness
• Assists with the day-to-day activities of the team
• Regularly updates the Senior Settlement Analyst of system issues through formal status reports as well as informally via e‑mails, voice message and regular team interaction
• 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
• Assists in implementing the Settlement and Client Services Training Program
• 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
• Resolves client questions, disputes and data errors in the operations of settlement calculations Takes initiative to identify and recommend detailed solutions and improvements to procedures and tools that increase accuracy efficiency and timelines
• Writes and executes SQL queries to generate results used in analytical reports
• Serves on projects, as necessary, to implement ERCOT's Commercial Operation Systems including future enhancements
• Serves as a mentor for other analysts in the department
• Uses knowledge of software life cycle to complete tasks, enhance tools and ensure effective process flow

Experience

• Requires minimum 2 years job related work experience in excess of degree requirements
• Comfortable working with excel including: complex formulas, pivot tables and graphs
• Comfortable interpreting and manipulating algebraic equations
• Prefer experience with, or aptitude for, SQL, Visual Basic and SAS

Education

• 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

Work Location

• This position is Hybrid. You will be required to be on‑site at the Taylor or Austin facilities at least two times per week, 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

Position and Compensation

Position level and compensation will be determined by the successful candidates overall experience.

Job Description Notice

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.

Equal Employment Opportunity

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

$61,131 - $100,871

Seniority Level

• Entry level

Employment Type

• Full-time

Job Function

• Management and Manufacturing

Industries

• Utilities

Referrals increase your chances of interviewing at ERCOT by 2x.