![City of Denton](https://media.trabajo.org/img/noimg.jpg)
Settlement Analyst
2 months ago
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