Highlights
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. 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.
Numbers & Facts
| Location | White Plains, NY |
| Industry | Staffing/Employment Agencies |
| Company Size | 500 to 999 employees |
| Website | http://www.ampcus.com |
Description
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.
Job Title: Revenue & Pricing Analyst
Job Location: White Plains, NY
Duration: 12 Months
Work Schedule
- Monday through Friday 7.5 hour work day with .5 hour unpaid lunch
- Paid for time worked only; there are no paid holidays, vacation, or sick days
- Overtime is not permitted unless authorized in advanced.
- Contingent Worker is required to badge in and out of the turnstiles located in the lobby for all daily entrances and exits.
Project Overview
Streamline customer savings calculations and analytics utilizing Power BI to increase the R&PA team's bandwidth and enable us to support larger initiatives more effectively. Support group in other recurring monthly and annual deliverables.
Job Functions & Responsibilities
- Enhance the accuracy and depth of customer savings analyses by implementing in Power BI.
- Effort would include 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.
Skills
- 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. Excel test will be given at interview.
- 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.
Education & Certifications
- Bachelor’s Degree in Business, Economics, Finance, Accounting, Math or related discipline is required.
- MBA or other graduate degree is preferred.
- Minimum of 2 to 4 years of directly relevant analytical experience is required.
- Minimum of 2 years of utility revenue, pricing and market analysis experience is preferred.
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.
About Company
Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.
Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.
We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted" that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.
Industry: Information Technology and Services
Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI
Similar Jobs
- 22nd Century Technologies, Inc. (TSCTI)
Associate Revenue & Pricing Analyst
- White Plains, NY