Collections Reporting Specialist

Job Summary

The Collections Reporting Specialist reports directly to the Director, Customer Services and is responsible for collecting, analyzing, and interpreting data and creating reports related to all Collection activities, including accounts receivable, collection field activity, allowance for doubtful accounts, regulatory compliance and financial performance. Incumbent must ensure strict adherence to the Public Utility Regulatory Authority (PURA) regulations and their counterparts in all three states in which we do business. Successful candidate will possess strong analytical skills, proficiency in data management tools, and ability to manage and interpret data.

Principal Responsibilities

• Gather, interpret data and report trends to management on the above measures to facilitate proper understanding of marketplace and economic activity; prepare reports as necessary.

• Prepare and analyze collection and cash receivables data relative to past and budgeted trends.

• Prepare budgets and forecast information.

• Create information dashboards to present key performance indicators and trends in collection processes.

• Work with IT and 3 party providers to implement data qualify measures to ensure accuracy and reliability of reports.

• Analyze reserve for doubtful accounts and accounts receivable aging for both water and jobbing accounts to measure the efficiency of the Company’s collection efforts and advise management on collection strategy.

• Understand all aspects of the Customer Service Information Systems including control tables. Monitor overall compliance with PURA regulations and their counterparts in all states serviced by Aquarion Water Company through accurate and timely collection activities. Ensure consistency of all collection cycles and compliance with state regulations.

• Monitor timely and accurate collection activity of all 240,000 residential, industrial and commercial customers.

• Act as liaison between Accounting, Rates & Regulations, Billing, Field Service and Customer Service for collection and validation of information.

• Create, produce and maintain system reports; write/update queries for execution in SAP and Bobj systems.

• Analyze and ensure accuracy of collections processes in SAP. Work with IT on testing collection processes related to system changes and upgrades.

• Act as liaison to Accounting and Rates & Regulations on all collections system related projects.

Preferred Requirements

Excellent communications, customer-service, troubleshooting, problem-solving, analytical, organizational and communication skills are required. Must be able to manage multiple tasks simultaneously, prioritize, and meet commitments. Strong skills in Microsoft platform (Word and Excel). SAP experience is desirable. Strong understanding of the collection system's impact on the general ledger system, familiarity with collection practices. Understanding of the regulations of the CT DPUC and MA’s and NH’s economic regulatory counterparts.

Education/Certifications

Bachelor’s Degree in Accounting or Finance, or related field.

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 $72,640 - $90,800.