Bachelor's degree in business administration, finance, accounting, economics, or related field.
5+ years of experience in financial or energy industries, preferably in Back/Middle-Office functions.
Proficient in preparing, reviewing, and auditing complex Excel models.
Strong skills in MS Excel-based modeling, financial planning, and analytics.
Familiarity with ISO market operations and settlements, especially in PJM, MISO, and ERCOT.
Knowledge of physical and financial power products; basic derivative knowledge is a plus.
Ability to analyze contracts and extract relevant information.
Responsibilities
Perform shadow settlements and validate final settlements, communicating with counterparties to resolve discrepancies.
Collaborate with Accounting on invoicing and revenue reconciliations for monthly reporting.
Serve as a key contact for asset management clients, translating market events into revenue explanations.
Verify ISO bilateral trade scheduling and support Day-Ahead/Real-Time Scheduling execution.
Draft transaction confirmations for sales and analyze their accuracy against commercial terms.
Collaborate with Asset Management and Accounting to deliver investor reporting and analyze budget vs. actual variances.
Create and maintain revenue models for internal and external reporting, focusing on efficiency and improvements.
Benefits
Opportunity to work with a dynamic Commercial team in the energy sector.
Engagement with external clients and stakeholders, enhancing professional networking.
Access to advanced tools like Excel and Power BI for efficiency improvements.
Involvement in market analysis and reporting, contributing to strategic decision-making.
Potential for career growth within a rapidly evolving industry.
Full Job Description
The SeniorCommercial Analyst will be responsible for complex back/middle office activities of the Commercial team, with a focus on performing more complex settlement calculations, revenue reporting, and reviewing contacts for tracking obligations. This role includes the maintenance and management of revenue-centric models that facilitate the distribution of investor reporting and invoicing. This role will also interface with external clients performing market analyses and reporting on monthly results.
Essential Responsibilities
Perform shadow settlements; validate final settlements; communicate with counterparties to facilitate alignment, disputing errors as necessary; and execute invoicing. This includes but is not limited to ISO, hedge, and REC settlements.
Collaborate with Accounting on invoicing, payments, and providing revenue reconciliations for monthly reporting.
Serve as a key point of contact for asset management clients and offtakers, translating market events and pricing dynamics into clear explanations of revenue outcomes.
Verify ISO bilateral trade scheduling and support execution of Day-Ahead/Real-Time Scheduling
Draft transaction confirmations (REC sales, etc.)
Analyze, reconcile, and evaluate the accuracy of confirmations, ensuring proper amounts and Commercial terms.
Collaborate with Asset Management and Accounting to deliver investor reporting; investigate, explain, and present budget vs. actual variances as well as the related market analysis.
Create, manage, and maintain revenue models for reporting to internal and external stakeholders, with the expectation that models will be continually monitored for efficiency and continued improvements.
Explain and verify revenue calculation methodologies and financial impacts internally to other departments.
Analyze energy market trends to optimizethe financial performance of solar, wind and other assets.
Read contracts to understand Commercial obligations; record and communicate obligations to Management and Contract Administration.
Support the development of new Commercial tools to promote efficiencies in Excel and Power BI.
Maintain knowledge of ISO rules and proposed changes.
Manage REC trading and tracking system activity (PJM GATS, NCRETS, WREGIS, TX REC etc.).
Education and Experience Requirements
Bachelor's degree in business administration, finance, accounting, economics, or related field.
5+ years' of experience working in the financial or energy industries; experience directly supporting Back/Middle-Office functions in wholesale or retail electricity preferred.
Experience preparing, reviewing, and auditing complex models in Excel.
Proven competence in MS Excel-based modeling, financial planning and analytics.
Knowledge of ISO market operations and settlements, especially in PJM, MISO and ERCOT preferred.
Knowledge of physical and financial power products; basic derivative knowledge preferred.
Basic understanding of energy markets, solar technology, and wind technology.
Ability to analyze and extract relevant information within contracts.
Ability to extract, manipulate, and summarize large amounts of data.
