The Rate Analyst is responsible for forecasting, managing and calculating monthly tariff rider requirements and, as applicable, maintain SOX compliance with such that activities.  The objective is to establish monthly rates within specific tariff requirements and applicable law that enable the recovery of significant annual expenses and manage the monthly over/under collect amount with oversight from the Manager, Rates and the Director, Rates and Tariff Administration.  The position is responsible for the preparation of witness testimony, accounting schedules, and data request responses in conjunction with various annual reconciliations.  In addition, the position is responsible for preparing other regulatory tariff filings requirements.  Finally, the position supports analytical requirements for rate case preparation, cost of service
analysis, and rate and rider impact analyses.

Functional Expertise:

• Respond to inquiries from regulatory agencies concerning monthly tariff filings and annual reconciliations and consult with Manager of Rates. 
• Maintain and modify the required Excel models/worksheets, prepare estimates of rates, and prepare various monthly filing schedules.    
• Calculate and document periodic updates to rates and riders
• Support other ad-hoc analytical requirements in the department.
• Responsible for revenue forecasting and analysis
• Conduct analysis behind routine, monthly rate department filings
• Prepare and support the analytical requirements for general rate case proceedings (i.e. cost of service activities, rate impact analysis, and preparation of filing requirements). 
• Lead efforts for monthly tariff filings and annual tariff reconciliations of the corresponding monthly filings
•  Support the process of making timely updates to the department website. 
• Respond to internal inquiries for rate comparisons and bill impacts.
• Perform and submit cost of service and depreciation studies 
• Support the Rate Department with other duties as assigned throughout a rate case filing or other commission proceedings.
• Write, review, interpret and apply tariff language relevant to current business processes
• Act as the functional back-up to key monthly tariff filings

Business Acumen:

• Analyze inputs into rate calculations for completeness and accuracy while identifying any deficiencies in the inputs.  
• Make routine decisions regarding the completeness and accuracy of the rate business processes      
• Interpret changes in numerical data and inform others of the impacts
• Perform in the capacity as the regulatory authority on policies and procedures for providing service to new customers.
• Leverage relevant experience to ensure sound business decision making
• Interpret changes in numerical data related to tariff charges and communicate the impact of the results.
• Construct and interpret data from customer information/billing systems for rate analysis.
• Responsible for the writing and submittal of data request responses.
• Write and submit data request response drafts.

Engagement:

• Demonstrate a degree of analytical understanding and spreadsheet skills within peer group with success.
• Demonstrate to leadership a high degree of analytical understanding and spreadsheet skills with success.
• Present recommendations of the tariff charges and factors to the Manager of Rates and Director, Rates and Tariff Administration.
• Discuss ongoing changes in market conditions and other variables that impact rate charges with Manager of Rates and Director of Rates and Tariff Administration.
• Act in an accountable manner, consistently preparing monthly PGA filings for approval on time
• Ensure accuracy of work completed by self and initiate review of data which appears unusual
• Collaborate with internal departments and stakeholders.  
• Demonstrate independent work habits and collaborate in team environments to achieve results.
• Participate on and support cross-functional teams as the Rate Department lead on interdepartmental teams
• Follow-up on emerging issues associated with any rate charge calculations (PGA, taxes, etc.)
• Demonstrate the ability to cross-functionally train other rate department employees.

Driving Results:

• Act in a manner consistent with accurately preparing the monthly tariff filings for approval on time.
• Ensure accuracy of work completed by self and initiate review of data which appears unusual.
• Follow-up on emerging issues associated with any rate charge calculations (corporate communication, rate impact analysis, taxes, etc.).
• Respond to inquiries from external customers, regulatory agency phone calls, and other internal departments as required

Qualifications:

Education, Certifications/Licenses:

Required: 

• Bachelor’s Degree in Economics, Finance, Accounting or relevant field    

Preferred: 

• M.B.A. or Master’s Degree in Economics, Finance or Accounting or relevant field

Related Work Experience:

Required:  

• N/A, See Education Requirements (Analyst I)
• 3 – 5 years of relevant work experience (Analyst II)

Preferred:  

• 1 – 2 years of relevant work experience (Analyst I)
• 3 + years of relevant work experience (Analyst II)

Specific Skills& Knowledge:

Required: 

• Microsoft Excel experience with good finance and analytical competencies (internal rate of return, discounted cash flows).  Competencies with Microsoft Office (PowerPoint and Word).     
• Advanced Excel modeling skills and numerical competency

Preferred:

• Advanced Excel skills and financial modeling.

Working Conditions/Physical Requirements:

TRAVEL REQUIREMENTS

• Infrequent Traveler (0-5% travel): The incumbent may be required to travel on a very limited basis.  Trips may require air travel and/or overnight stay away from home for one or more nights.

WORK ENVIRONMENT

• Will the incumbent(s) in this position be exposed to the following ENVIRONMENTAL CONDITIONS? 

Disclaimer:   This information describes the general nature and level of work performed by employees in this job.  The description is not designed to be a comprehensive inventory of duties, responsibilities and qualifications required in the job.  Reasonable accommodations may be made to qualified disabled individuals for performance of essential duties and responsibilities