LI
Settlement Analyst
LanceSoft Inc
- 🇺🇸 United States
- On-site
- 1 day ago
- Excel
- Pivot Tables
- VLOOKUP
- Power BI
- Data Visualization
1 day ago
Job Title: Settlement Analyst
Location: White Plains, NY 10601
Duration: 12 months (onsite)
Pay Rate - $35/hr. - $38/hr. on W2
Shift: (hybrid) minimum of 3 days on-site, fully on-site depending on department requirements.
Job Description:
This role will support the Settlements team's daily and monthly deliverables.
Roles and Responsibilities:
- Analyze, reconcile, and/or evaluate the accuracy of energy and capacity NYISO transactions and details, ensuring proper amounts and classification.
- Support the creation of daily and monthly invoice estimates, analysis, and various other reports for Accounting and other internal & external stakeholders.
- Reconcile physical and financial commodity invoices with third parties and work with Accounts Payable and Sales & Energy Accounting teams to process invoices.
- Ensure high focus for reporting relating to deal structuring and settlement.
- Assist with the processes necessary to allocate costs to the associated cost centers, customer groups, and individual customers in accordance with company’s procedures or contracts.
- Develop a working knowledge of all relevant wholesale energy contracts, tariffs and agreements to properly effectuate all settlement calculations and provide support for all customer and internal inquiries related to the administration of such agreements.
Skills:
- Strong verbal and written communication skills.
- Ability to provide accurate reports, summaries and electronic data to internal and external stakeholders in accordance with agreed upon deadlines.
- Ability to demonstrate understanding of NYISO market dynamics and the role of Settlements. Knowledge of NYISO Settlements systems (DSS, SDX, ICAP/UCAP AMS) is preferred.
- Basic understanding of cost allocation calculation methodologies.
- Proficiency with Microsoft Excel. Demonstrated ability to use Pivot Tables and database formulas (SUMIF, VLOOKUP, etc.).
- Proficiency in Micosoft Power BI data visualization is preferred.
- Bachelor's degree in Finance, Accounting, Economics, Engineering or related field is required.
- Utility/Commodities experience is preferred.
Settlement Analyst · LanceSoft Inc