Revenue & Pricing Analyst

Ampcus Inc.•White Plains, NY

4d•Onsite

About The Position

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. This role involves maintaining client cost-of-service studies, commodity rate models, and supporting monthly reconciliations and rate setting processes. The analyst will also be responsible for analyzing results, validating cost assessments, and developing customer savings comparisons. Staying updated on rate filings and utility trends is crucial. The position requires advanced Microsoft Excel skills, basic knowledge of the utility industry and NYISO market, and intermediate knowledge of economics, finance, and accounting.

Requirements

Advanced level knowledge of Microsoft Excel, including functions such as: pivot tables/charts, advanced sorting, vlookup, match, offset, data linking to Access databases, import of data from Excel, CSV and other flat file formats.
Basic knowledge of the utility industry and NYISO market is required.
Intermediate knowledge of economics, finance and accounting concepts and theories.
Excellent analytical skills required, including the ability to perform statistical and quantitative analysis.
Ability to interpret and analyze financial, marketing and utility tariff data.
Excellent communication and interpersonal skills.
Ability to clearly explain and present concepts in multiple areas of expertise to peers.
Ability to anticipate problems/issues, streamline and propose solutions as appropriate is required.
Ability to work in a team environment is required.
Bachelor’s Degree in Business, Economics, Finance, Accounting, Math or related discipline is required.
Minimum of 2 to 4 years of directly relevant analytical experience is required.

Nice To Haves

MBA or other graduate degree is preferred.
Minimum of 2 years of utility revenue, pricing and market analysis experience is preferred.

Responsibilities

Maintain existing Client governmental and business customer cost-of-service (COS) studies and commodity rate models.
Provide support with running the existing monthly cost recovery reconciliations, including customer Energy Charge Adjustment (ECA) processes.
Analyze the results for reporting to internal and external customers.
Collaborate in the execution of the rate setting processes, inclusive of performing impact analysis on customer bills, gathering rate assumptions and inputs, developing supporting rate data, and verifying rate outputs for accuracy.
Analyze and validate proper costs assessment to customers, including those assessed through cost-of-service and ECAs.
Validate and issue governmental customer Client delivery rates and surcharges for billing.
Develop customer savings/cost comparison by using existing market analysis models, including gathering internal requirements, setting up monthly rate inputs and adjusting the models to appropriately reflect electric market conditions in NYS.
Provide support with the preparation of various COS and rate related Trustee items.
Publish and maintain the accuracy of the rates stored in the SAP billing system, as well as internal and external rate data postings.
Stay abreast of rate filings and research rate setting trends in public and private utilities and analyze how they affect customer costs.