Revenue & Pricing Analyst

Ampcus Inc. • White Plains, NY

4d • Onsite

About The Position

Ampcus Inc. is seeking a highly motivated Revenue & Pricing Analyst to join their talented team. The primary focus of this role is to streamline customer savings calculations and analytics using Power BI, thereby increasing the R&PA team's bandwidth and enabling support for larger initiatives. The analyst will also support the group in other recurring monthly and annual deliverables.

Requirements

• Advanced level knowledge of Power BI.
• 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

• Enhance the accuracy and depth of customer savings analyses by implementing in Power BI, including gathering internal requirements, automating monthly rate inputs, accounting for electric market conditions in NYS, tracking Public Service Commission policies and rulings, streamlining calculations, and creating more dynamic and informative visualizations.
• Support other recurring monthly and annual deliverables including analyzing customer Energy Charge Adjustments, Cost of Service studies, customer rate developments, and rate reporting.
• Collaborate in the execution of the rate setting processes, inclusive of performing impact analyses on customer bills, gathering rate assumptions and inputs, developing supporting rate data, and verifying rate outputs for accuracy.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level