Settlements Analyst
ERCOT · Taylor, TX · 1 mo ago
Finance$83k–$114k/yrFull-time
We need to output HTML fragment with sections for headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content.
We need to parse the job posting.
Content:
- Intro paragraph about ERCOT environment, inclusive, etc. That's about the role? Could be "About the role" or "About ERCOT". The instruction: use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can use "About the role" heading.
- Job Summary: Settlement Analyst performs settlement calculations... etc. That's part of responsibilities? Could be part of "Responsibilities". We'll include responsibilities.
- Job Duties: Level I, Level II, Senior Level. Those are responsibilities.
- Experience Level I, II, Senior Level: that's experience requirements.
- EDUCATION: Bachelor's degree required, preferences.
- Prefer proficient in Excel, etc. That's skills.
- WORK LOCATION: on-site schedule etc. That's schedule? Could be schedule (on-site days). Also remote work location.
- Expected Salary Range: Pay.
- Benefits: Not mentioned. No benefits details. So we should not include Benefits section.
- Also maybe "Qualifications" could combine education and experience? But we have separate sections for Requirements, Qualifications, Skills. The instruction: Use headings for those categories if content exists. We need to decide what goes where.
We have:
- About the role: intro paragraph.
- Responsibilities: job summary + duties.
- Requirements: maybe experience levels? Or could be "Experience" but we have "Requirements". Could put experience requirements there.
- Qualifications: education requirements.
- Skills: Excel, SQL, SAS, VB, algebraic equations, etc.
- Pay: Expected Salary Range.
- Schedule: Work location details (on-site 2 days per week, flexible, remote from Texas residence). That's schedule.
We must not include boilerplate like EEO, etc. Remove that.
We must not repeat job title as heading. Not include Job ID.
We must preserve all substantive information.
Let's extract substantive info:
About the role: "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."
That's about the role/company.
Responsibilities: Job Summary + Job Duties.
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 list (multiple bullet points). Level II includes all Level I plus additional. Senior Level includes all Level I and II plus additional.
We need to preserve all details. We'll combine into a single
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can use "About the role" heading.
- Job Summary: Settlement Analyst performs settlement calculations... etc. That's part of responsibilities? Could be part of "Responsibilities". We'll include responsibilities.
- Job Duties: Level I, Level II, Senior Level. Those are responsibilities.
- Experience Level I, II, Senior Level: that's experience requirements.
- EDUCATION: Bachelor's degree required, preferences.
- Prefer proficient in Excel, etc. That's skills.
- WORK LOCATION: on-site schedule etc. That's schedule? Could be schedule (on-site days). Also remote work location.
- Expected Salary Range: Pay.
- Benefits: Not mentioned. No benefits details. So we should not include Benefits section.
- Also maybe "Qualifications" could combine education and experience? But we have separate sections for Requirements, Qualifications, Skills. The instruction: Use headings for those categories if content exists. We need to decide what goes where.
We have:
- About the role: intro paragraph.
- Responsibilities: job summary + duties.
- Requirements: maybe experience levels? Or could be "Experience" but we have "Requirements". Could put experience requirements there.
- Qualifications: education requirements.
- Skills: Excel, SQL, SAS, VB, algebraic equations, etc.
- Pay: Expected Salary Range.
- Schedule: Work location details (on-site 2 days per week, flexible, remote from Texas residence). That's schedule.
We must not include boilerplate like EEO, etc. Remove that.
We must not repeat job title as heading. Not include Job ID.
We must preserve all substantive information.
Let's extract substantive info:
About the role: "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."
That's about the role/company.
Responsibilities: Job Summary + Job Duties.
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 list (multiple bullet points). Level II includes all Level I plus additional. Senior Level includes all Level I and II plus additional.
We need to preserve all details. We'll combine into a single - list? But we have hierarchical levels. Could still list each duty as separate bullet, maybe with indication of level. But we must not invent or summarize away detail. We can keep the level headings inside
maybe? But instruction: Use
- for any list of duties/requirements/benefits. So we need to put duties in a list. We could have subheadings inside
but that might be extra text not a list. However we can still include level headings as
before the list? The instruction says use
- for any list of duties/requirements/benefits, and
for prose. It doesn't forbid having headings inside
or separate
for level titles. But we should avoid creating extra sections. Probably we can have a
describing levels then a
with all duties. But we need to preserve the level distinctions. Could embed level info inside each - text.
Let's extract each duty:
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
We need to include all these.
Experience requirements:
- 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
Pay:
- Expected Salary Range $83,000 - $114,000
Benefits: none.
Schedule: we have work location details that include schedule (on-site days). We'll put under Schedule heading.
Now we need to output HTML fragment with
headings and appropriate
or
- .
We must not include any empty sections.
Let's craft:
About the role
...
Responsibilities
- ...
...
Requirements
Experience levels:
- 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
Alternatively could put experience under Requirements.
Qualifications
Education:
- Bachelor's degree in Business Administration, Engineering, Mathematics, Finance, or a related field (required), or an equivalent combination of education and experience
Preferred:
- Proficient in Excel, including complex formulas, pivot tables, and graphs
- Comfortable interpreting and manipulating algebraic equations
- Experience with, or aptitude for, SQL, Visual Basic, and SAS
But we might combine education and preferences under Qualifications.
Alternatively we could have Qualifications heading for education, and Skills heading for technical skills.
Let's follow the suggested headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule.
Thus:
- About the role: intro paragraph.
- Responsibilities: duties list.
- Requirements: experience levels.
- Qualifications: education requirement (Bachelor's degree) maybe also equivalent combo.
- Skills: Excel, algebra, SQL, VB, SAS.
- Pay: salary range.
- Schedule: work location details.
We should not include Benefits.
Now ensure we preserve all substantive info: we must not lose any duty, any experience level, any education, any preferences, any work location details, any salary.
Let's list all duties exactly as text.
We'll produce with each duty as - . Ensure we include all.
Let's write them.
I'll copy duties:
Level I:
1. Assists with projects, as necessary, to implement ERCOT's Commercial Operations Systems, including future enhancements
2. Assists with system development, product implementation, certification, and testing
3. Develops and maintains a strong understanding of the competitive energy markets
4. Identifies and recommends improvements to procedures and software that increase accuracy, efficiency, and timeliness
5. Writes and executes SQL queries to generate results for analytical reports
6. Writes and executes SAS code to certify system changes and verify calculations from the production system
7. Resolves Market Participant questions, disputes, and data errors related to settlement computations
8. Assists with day-to-day team activities
9. Keeps the Senior and/or Lead Settlement Analyst informed of system issues through formal status reports and informal updates (email, team discussion)
10. Notifies leadership of key issues in a timely manner
11. Builds strong working relationships with Settlement Team members and colleagues across ERCOT departments
12. Clearly communicates complex technical concepts, in writing and verbally, to both technical and non-technical audiences
13. Supports the Settlement Team and collaborates with peers to meet team objectives and ERCOT initiatives
14. Maintains working knowledge of market and power systems, and understands how data elements flow from these systems into the settlement system
Level II additions:
15. Demonstrates advanced knowledge and expertise in detailed settlement calculations
16. Takes initiative to identify and recommend solutions and improvements that increase accuracy, efficiency, and timeliness
17. Serves on projects to implement ERCOT's Commercial Operations Systems, including future enhancements
18. Mentors other analysts within the department
19. Applies knowledge of the software development lifecycle to complete tasks, enhance tools, and
maybe? But instruction: Use
- for any list of duties/requirements/benefits. So we need to put duties in a list. We could have subheadings inside
but that might be extra text not a list. However we can still include level headings as
before the list? The instruction says use
- for any list of duties/requirements/benefits, and
for prose. It doesn't forbid having headings inside
or separate
for level titles. But we should avoid creating extra sections. Probably we can have a
describing levels then a
- with all duties. But we need to preserve the level distinctions. Could embed level info inside each
- text.
Let's extract each duty:
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
We need to include all these.
Experience requirements:
- 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
Pay:
- Expected Salary Range $83,000 - $114,000
Benefits: none.
Schedule: we have work location details that include schedule (on-site days). We'll put under Schedule heading.
Now we need to output HTML fragment with
headings and appropriate
or
- .
We must not include any empty sections.
Let's craft:
About the role
...
Responsibilities
- ... ...
Requirements
Experience levels:
- 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
Qualifications
Education:
- Bachelor's degree in Business Administration, Engineering, Mathematics, Finance, or a related field (required), or an equivalent combination of education and experience
Preferred:
- Proficient in Excel, including complex formulas, pivot tables, and graphs
- Comfortable interpreting and manipulating algebraic equations
- Experience with, or aptitude for, SQL, Visual Basic, and SAS
- with each duty as
- . Ensure we include all. Let's write them. I'll copy duties: Level I: 1. Assists with projects, as necessary, to implement ERCOT's Commercial Operations Systems, including future enhancements 2. Assists with system development, product implementation, certification, and testing 3. Develops and maintains a strong understanding of the competitive energy markets 4. Identifies and recommends improvements to procedures and software that increase accuracy, efficiency, and timeliness 5. Writes and executes SQL queries to generate results for analytical reports 6. Writes and executes SAS code to certify system changes and verify calculations from the production system 7. Resolves Market Participant questions, disputes, and data errors related to settlement computations 8. Assists with day-to-day team activities 9. Keeps the Senior and/or Lead Settlement Analyst informed of system issues through formal status reports and informal updates (email, team discussion) 10. Notifies leadership of key issues in a timely manner 11. Builds strong working relationships with Settlement Team members and colleagues across ERCOT departments 12. Clearly communicates complex technical concepts, in writing and verbally, to both technical and non-technical audiences 13. Supports the Settlement Team and collaborates with peers to meet team objectives and ERCOT initiatives 14. Maintains working knowledge of market and power systems, and understands how data elements flow from these systems into the settlement system Level II additions: 15. Demonstrates advanced knowledge and expertise in detailed settlement calculations 16. Takes initiative to identify and recommend solutions and improvements that increase accuracy, efficiency, and timeliness 17. Serves on projects to implement ERCOT's Commercial Operations Systems, including future enhancements 18. Mentors other analysts within the department 19. Applies knowledge of the software development lifecycle to complete tasks, enhance tools, and
- .
We must not include any empty sections.
Let's craft:
- text.
Let's extract each duty:
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
We need to include all these.
Experience requirements:
- 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
Pay:
- Expected Salary Range $83,000 - $114,000
Benefits: none.
Schedule: we have work location details that include schedule (on-site days). We'll put under Schedule heading.
Now we need to output HTML fragment with
- for any list of duties/requirements/benefits, and