Power Marketing Settlements & Billing Support Specialist at Cherokee Nation Businesses LLC

HYBRID OPPORTUNITY 

Power Marketing Settlements & Billing Support Specialist - Folsom, CA

$90K -$95K

POSITION OVERVIEW

This position supports the Sierra Nevada Region in Folsom, CA. The Power Marketing Settlements & Billing Support Specialist provides support for billing, settlement, audit, and data analysis functions.

 Experience, Education, Skills, Abilities requested: 

• Bachelor’s degree required, preferably in fianance or accounting.
• Advanced Excel skills, preferably experience with Excel VBA 
• Possess specialized knowledge of Independent System Operator functions, including market settlement, bilateral power trading, after-the-fact checkout, and hands-on experience of revenue quality meter data interrogation and validation technology such as MV90 of Itron. 
• Knowledge of relational databases, preferably experience with SQL.
• Capable of understanding mathematical formulas and performing algebraic calculations
• Understanding of relationships, dependencies software and system components and the organizations that support them.
• Effective in communication and capable of business process documentation
• Preferably having experience in electrical power market or other energy trading operation
• Must pass pre-employment qualifications.
• Ability to obtain Public Trust required

Responsibilities include, but not limited to: 

• Analyze and manage settlements and billing, and market data utilizing software applications for completeness, accuracy, and timely data submission to ensure that the settlement quality data meet internal standards and other applicable industry standards. 
• Obtain and validate settlement statements, invoices and other supporting data and documents utilizing appropriate software and applications according to established policies, processes, guidelines, and regulations.     
• Obtain and validate bilateral trade data, contracts, schedules, e-Tags, and other supporting data and documentation according to established policies, processes, guidelines, and regulations. 
• Obtain and validate meter and telemetry data and correct if needed.     
• Monitor the integrity of the meter and telemetry data across software applications and systems, performance of related software applications, and report inconsistencies and errors. 
• Complete sub-allocations. 
• Generate, validate, and issue power bills according to business practices.     
• Provide data analysis such as meter data analysis, energy schedule analysis, settlement payment or charge analysis, ancillary service quantity and price analysis, transmission usage and charge analysis, transmission loss quantity analysis, and transmission congestion revenue analysis; and prepare reports to document the findings of the data analysis, to meet annual report requirements, internal and external audit requirements, or reporting requirements from other entities. 
• Develop and maintain Microsoft Excel workbooks to address any computation requirements not performed directly by the established applications. 
• Determine best practices and develop actionable insights and issues for business operations and prepare reports to document findings and recommendation.     
• Assist with internal and external audit requirements. 
• Assist in analysis and implementation of business process improvements.
• Performs other job-related duties as assigned.