Settlements Services Analyst

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.

Leads and assists with projects to implement settlement changes in ERCOT's Commercial Operation Systems. The analyst will develop business requirements, use cases, test cases and test changes to the integration system.

JOB DUTIES

• Leads and assists with projects to implement ERCOT's Commercial Operation Systems, including future enhancements
• Translates protocol revisions into detailed functional business requirements
• Creates test cases, test scripts, test data and validation tools to test changes to the integration system
• Understands relational database concepts
• Supports production issues related to the data passed to the Settlement system through the integration system
• Represents the Settlements Team at project and status meetings
• Uses knowledge of software life cycle to complete tasks, enhance tools and ensure effective process flow
• Writes and executes SQL queries to generate results used in testing and analytical reports
• Regularly updates management and the Settlement team of system issues through formal status reports as well as informally via e-mails, voice message and regular team interaction
• Identifies and recommends detailed solutions and improvements to procedures and software to improve accuracy, efficiency, and timeliness
• Develops strong working relationships with the key staff members of the Settlement Team, and promotes similar relationships with staff members of other ERCOT departments

QUALIFICATIONS

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

EXPERIENCE

• Level 1: Requires 0-2 years job related work experience in excess of degree requirements
• Level 2: Requires minimum of 2 years job related work experience in excess of degree requirements
• Senior Level: Requires minimum of 5 years job related work experience in excess of degree requirements
• Lead Level: Requires minimum of 8 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
• Experience with SQL
• Experience with SAS or Python preferred

WORK LOCATION:

• Employees will be required to be on-site in Taylor, TX at minimum 2 days per week, or more, as needed based on the business needs as determined by management
• On-site schedules are flexible or may be rotated based on business needs as determined by the Manager
• Remote work is required to be performed from your Texas residence
• Employees may opt to work on-site more than required or 100% of the time

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:
$75,273 - $127,931