Title: Project Manager, Settlements (Settlement Analyst)
Timeline: They are growing and want to have hire this person quickly
Location: Los Angeles – Their office is downtown, they plan on being back into the office later this year so the person must be based in Los Angeles, or willing to relocate there
Reports to: Director of Power Planning and Procurement
Job Description: This person will oversee settlement processing, validation, and allocation of costs and revenues derived from transactions of wholesale energy, carbon free energy, renewable energy credits, and capacity products conducted through bilateral agreements and the organized California Independent System Operator (CAISO) bulk electric market. The team member will focus on developing and implementing settlements processes and controls to support the management of CPA’s portfolio of power supply resources, which includes over 2,000 MW of new solar, wind, and battery storage assets.
Responsibilities
• Working closely with CPA’s third-party scheduling coordinator, validate weekly CAISO settlement statements to identify discrepancies, evaluate historical market performance, and identify opportunities for procurement cost optimization.
• Validate five-minute, fifteen-minute, hourly, daily, and monthly data (as applicable) associated with meter data and transactions of energy, Resource Adequacy capacity, Renewable Energy Credits (RECs), carbon free, and other wholesale products.
• Develop, run, and maintain reports and databases to validate power generation and price detail for bilateral counterparties in accordance with contractual provisions. Identify and perform analytical research to determine cause of settlements variances and work with counterparties to resolve variances. Ensure invoices and payment reports are validated, correctly coded, and internally distributed in time to meet all payment deadlines.
• Assist with tracking and validating data associated with various power transactions and compliance instruments (including REC and carbon free deliveries) to ensure they are captured in CPA’s transaction management system correctly and can be used to support monthly accounting functions.
• Navigate CAISO website and scheduling coordinator portals to obtain settlement files and pricing data to reconcile invoices.
• Support other power procurement and finance department activities as needed, including but not limited to deal entry and capture, contracting support related to settlements mechanics and terms, compliance reporting, accounting, and other financial reporting, in coordination with CPA’s scheduling coordinator, front, mid, and back-office functions.
Requirements
- Bachelors Degree
- CAISO Experience
- Los Angeles or Willing to relocate to Los Angeles
- Ability to work in time series data in a relational database using SQL programming and other data analysis tools including Excel, Power BI, SAS, R, and Python
- CCA (Community Choice Aggregation) experience is a plus.