Revenue Analyst

Aquarion Water Company; Bridgeport (CT); On-site; USD 98,000 - 105,000; Full time

Benefits offered by this job

Hybrid schedule

Job summary

Aquarion Water Authority is seeking a Senior Financial Analyst to lead revenue and consumption reporting and monthly accruals for three states and 250k customers. The role supports PURA, DPU, and PUC reporting and drives operational efficiency analytics across 70 water systems.

Responsibilities include leveraging SAP/Business Objects and Hach Wims to develop budgets, analyze variances, and prepare executive summaries for the President. Hybrid work options after probation.

Qualifications

• Bachelor's degree in Finance or Accounting.
• Advanced Excel skills with pivot tables and VLOOKUPs.
• Experience with SAP/Business Objects, Hach Wims and GIS.
• Minimum 5 years experience in report and process development, advanced Excel and database skills, and SAP.

Responsibilities

• Prepare revenue and consumption reporting and monthly accruals for CT, MA and NH.
• Develop budgets and support PURA/non-revenue reporting for multiple systems.
• Create and maintain reports and analytics via SAP/BOBJ to support business decisions.
• Provide monthly write-ups with variance analysis to executives.

Skills

Advanced Excel

Pivot Tables & VLOOKUPs

SAP

Business Objects

Hach Wims

GIS

Financial Reporting

Education

Bachelor's degree in Finance or Accounting

Tools

SAP

Business Objects

Hach Wims

GIS

Job description

The Aquarion Water Authority (AWA) is a locally governed, not-for-profit water authority providing water service to more than 735,000 people in 60 municipalities across Connecticut. Based in Bridgeport, Connecticut, AWA is responsible for the operation, maintenance, and long-term stewardship of one of the state's largest water systems. Through local governance, operational expertise, and continued investment in critical infrastructure, AWA is committed to delivering safe, reliable water service to the communities it serves.

Job Summary

This role reports to the Controller and is responsible for accurate revenue and consumption reporting and monthly accruals for 3 states and 250K customers. Monthly Reporting write up to President includes analysis of current and prior month accruals, consumption variances, revenue variances, weather, key industrial customers, and any other variables relevant to earned revenues. This analysis is used to support monthly revenue decoupling entries. This role is also responsible for company-wide Revenue and Consumption budget development.

In addition, this role is responsible for operational efficiency analytics for 70 separate water systems. This requires compilation of data from Supply Operations, Billing Systems, and leak management systems in order to prioritize monthly field resources effectively. This data is also used to generate annual and semi-annual PURA, DPU and PUC (state required) reporting.

Use of Business Objects is a key area of focus, one which will enhance productivity of the entire Finance group through development of Reports and Analytics. This includes development of both internal and external consumption reporting and metrics.

This role requires mature, independent judgment and requires ability to comprehend complex business processes.

Principal Responsibilities

Month end

• Fixed/Variable Revenue/billing reporting- CT, MA and NH.


• Track and analyze volume by region and by class


• Review all out-sorted unbilled documents and release after evaluation


• Update unbilled revenue (day 2)


• Provide detailed analysis of accuracy and variances to prior month’s accrual


• Update all weather information from 4 NOAA weather stations and chart comparisons as appropriate to support billing and revenue results


• Update Revenue Book which includes fixed and variable billing, consumption, bill counts, monthly accrual and all "other" revenues and reconcile back to SAP booked results.


• Provide monthly write-up to President detailing the above with analysis of MTD and YTD variances of Revenue, Consumption, and their meaning.

Budgets

• Generate revenue budgets for CT, MA and NH


• CT Budgets require dual models between PURA allowed revenue and expected revenue and decoupling values.


• Budget consumption according to master meter reading schedule by MRU and class factoring in number of days, by month for all business units. This creates the standard by which actual results can be compared.Non Revenue Water (Leak/Loss control)


• Provide all data to support Annual and Semi Annual PURA Non Revenue reporting for each of 70 systems.


• Compile data monthly from SAP/BOBJ and Hach Wims to track system delivery in 70 systems which includes 2 years of trend data for comparison.


• Analyze each system for Non Revenue Water trends utilizing billing, supply, leak and main break data (SAP/BW/Hach Wims). This includes charting all systems to view trends easily.


• Review data and prioritize system needs prior to monthly meeting with key stakeholders.


• Meet with supply operations and utility operations and review data to prioritize field resources.

Principal Responsibilities Continued

Non Revenue Water (Leak/Loss control)

• Provide all data to support Annual and Semi Annual PURA Non Revenue reporting for each of 70 systems.


• Compile data monthly from SAP/BOBJ and Hach Wims to track system delivery in 70 systems which includes 2 years of trend data for comparison.


• Analyze each system for Non Revenue Water trends utilizing billing, supply, leak and main break data (SAP/BW/Hach Wims). This includes charting all systems to view trends easily.


• Review data and prioritize system needs prior to monthly meeting with key stakeholders.


• Meet with supply operations and utility operations and review data to prioritize field resources.

Conservation

• Provide ongoing data support to conservation efforts. This includes
  
  
  • Identification of high users in impacted systems
  
  
  • Creation and distribution of customized reports for Golf Courses
  
  
  • Call list generation in drought conditions for special outbound customer communications.
  
  
  • Analysis of usage patterns in high risk areas.
  
  
  
  


• Support marketing with data requests for use in corporate website updates as well as communications with town managers to highlight conservation requirements.


• Analyze on site conservation evaluations for accuracy and propose action plans

Principal Responsibilities Continued

Ad hoc

• Support Engineering in water system data requests for use in project prioritization and hydraulic models.


• Work with GIS team to validate data and correct errors in posting to SAP for ongoing database maintenance.


• Work on special projects as required with all business units. Support change through collaboration, brainstorming, asking questions and thinking outside the box.


• Provide front line interface between business units and IT for data requests and report development. Analyze business needs and processes to determine if systems solutions are advisable and available. Develop detailed requirements documentation for changes, enhancements and new developments.

Preferred Requirements

• Advanced excel skills are required including pivot tables and VLookups.


• Adept at reporting using SAP/Business Objects, Hach Wims and GIS.


• A minimum 5 years experience in report and process development, advanced excel and database skills, and SAP.

Education/Certifications

• Bachelors degree in Finance or Accounting.

Salary

After 3 months of successful employment, this role will be eligible for a hybrid schedule (3 days office/2 days remote).

Job is classified as an exempt position with an annual salary range of $98,000 - $105,000.

• Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity.


• AWA does not accept unsolicited resumes from external recruiting firms. All vendors must have a current and fully executed MSA on file before submitting candidates. Any unsolicited resumes and candidate profiles will be deemed the property of AWA, and no fee will be due.


• Employment with AWA is contingent upon the successful completion of pre-employment screenings, including a drug screening, where permitted by law.

Aquarion Water Authority is an equal opportunity employer, and we prohibit discrimination based on age, color, disability, marital or parental status, national origin, race, religion, sex, sexual orientation, gender identity, military or veteran status, or any other legally protected status in accordance with applicable federal, state and local laws.