Responsible for administering all ERCOT electric power market settlement issues including data collection/validation, billing, disputes and power mismatches.

Responsible for administering billing, payment, and settlement for all Power Purchase Agreements and Physical or Financial energy trading activity.

Determine if power market settlement issues need to be disputed with ERCOT Gather, analyze and validate all in-house QSE load, generation, purchased power, ancillary service and financial data by 15-minute intervals on a daily basis for accuracy Prepare and submit appropriate dispute documents to ERCOT, with supporting backup information, within the mandated 10-day deadline Ensure that ERCOT power market settlement data and documents are correct, accurate, timely and are applied as per market protocols Prepares an ERCOT Shadow Settlement daily, continually updating the Excel and Access tools as needed to respond to market and/or DME operational changes Prepare monthly reports for Management Processes all ERCOT and Counterparty Invoices for payment: Receipt, Storage, Validation, Communication, Confirmation & Documentation Conducts analysis and comparisons of utility rates across the ERCOT region Perform various generation, transmission, market studies, and/or administrative duties as delegated/required Performs historical analyses of price, volume, and cost to report annual metrics and provide operational insight to management Verify and process payments for all invoicing concerning DME Power Supply Administration activities Assists in negotiation of power supply contracts Coordinates with other City departments, outside agencies and consultants as appropriate Maintains regular and punctual on-site attendance Additional Duties:

Performs other duties as assigned Minimum Qualifications / Acceptable Equivalency: A Bachelor's degree in Finance, Business Administration, Economics, Accounting or Engineering Six (6) years of previous work experience for an electric utility, two (2) years of which should be in wholesale energy supply and/or ERCOT Settlements OR A Master's Degree in Finance, Business Administration, Economics, Accounting or Engineering with Four (4) years of previous work experience for an electric utility, two (2) years of which should be in wholesale energy supply and/or ERCOT Settlements OR Any combination of related education, experience, certifications and licenses that will result in a candidate successfully performing the essential functions of the job Competencies: Must possess required knowledge, skills, abilities and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed Knowledge of wholesale fuel, electric markets and evolving industry and regulatory developments in ERCOT Skills built through ERCOT Market Training and familiarity with the ERCOT Nodal Protocols General knowledge of electric market and accounting/finance principles terminology Considerable knowledge of Microsoft Excel and Microsoft Access Familiarity with Microsoft SQL Familiarity with writing/debugging Visual Basic Code in Excel Considerable knowledge of other Microsoft Office Software Proficient knowledge and understanding of ERCOT data collection requirements Skill to work in a team environment as a positive influence Ability to analyze complex mathematical equations and understand associated terminology Ability to implement contractual terminology into mathematical expressions Ability to grasp and apply new concepts Skill in handling multiple tasks and prioritizing work Skill in using computers and related software applications Skill in data analysis and problem solving Ability to work with frequent interruptions and changes in priorities Ability to quickly recognize and analyze irregular events Skill in using available software packages and equipment, which may include the following: Personal computer with Windows operating system, Microsoft Office (applications for word processing, spreadsheets, databases, and presentations), and Microsoft Outlook email system Ability to prioritize tasks and work efficiently to cope with many deadlines Ability to communicate effectively both verbally and in writing Preferences: ERCOT Market settlement experience Conditions of Employment: Must pass a drug test, criminal history background check, and social security number verification check Physical Requirements: Overall Strength Demands : The

bold and italicized

word describes the overall strength demand of the functions performed by the incumbent during a typical workday.

Sedentary – lifting no more than 10 pounds Light – lifting no more than 20 pounds; carry up to 10 pounds Medium – lifting no more than 50 pounds, carry up to 25 pounds Heavy – lifting no more than 100 pounds, carry up to 50 pounds Very Heavy – lifting more than 100 pounds, carry more than 50 pounds

Physical Demand Codes:

The following describes if the incumbent is expected to exert the following physical demands during a typical workday and the overall frequency.

Codes for “how often” :

Y = Yes N = No E = extensive (100-70%) M = moderate (60-30%) I = infrequent (20-10%) A = almost never ( Task: Code:

Standing: M Sitting: M Walking: M Lifting: A Carrying: I Pushing/Pulling: A Overhead Work: A Fine Dexterity: M Kneeling: A Crouching: A Crawling: A Bending: I Twisting: I Climbing: A Balancing: A Vision: E Hearing: M Talking: M Video Display: E Other:

Machines, Tools, Equipment and Work Aids: The essential functions of this position require the use of a telephone and computer.

Environmental Factors: This position is required to work indoors in environmentally controlled areas and occasionally may be required to work outdoors, possibly during inclement weather.

This job description is not an employment agreement, contract agreement, or contract. Management has exclusive right to alter this job description at any time without notice. ADA/EOE/ADEA #J-18808-Ljbffr