Billing & Collections Data Analyst
Role summary
The Billing & Collections Data Analyst supports the WSSC Billing and Revenue Division by leveraging data analytics and predictive techniques to provide insights and recommendations. This role focuses on designing end-to-end collections strategies to optimize resource use, minimize delinquencies, reduce revenue leakage, and ensure customer service continuity. Key responsibilities include performing in-depth analysis of delinquent accounts, developing proposals for senior management, analyzing data using SQL, VBA, and MS Excel, and managing projects for business improvement. The analyst will also review the entire collections lifecycle, propose new strategies, conduct root cause analysis, and ensure compliance with regulatory requirements. This position requires independent work, project management experience, and the ability to train colleagues.
The Billing & Collections Data Analyst provides support and recommendations to the WSSC Billing and Revenue Division based upon insight generated through data analytics and predictive techniques. In this role, s/he facilitates the end-to-end collections strategy design to ensure effective and optimal use of resources and minimization of delinquencies while reducing revenue leakage and enabling customers to maintain service. This role operates with limited supervision and is responsible for training colleagues.
Essential Functions
- Performs in-depth analysis on delinquent accounts, reviews existing collections strategies and provides senior management with proposals
- Collaborates with customer service and utility services to drive real and constant business change
- Completes analytics work with minimal oversight and brings suggestions forward to drive direction
- Analyzes data using tools such as SQL, VBA, and MS Excel
- Manages projects to enhance business performance and drive process improvements
- Reviews the entire collections and credit risk lifecycle to help ensure a continuous and seamless customer journey
- Uses analytical approaches such as variable analysis & segmentation, net present value and forecasting to optimize billing and collections strategies
- Proposes and designs new strategies that improve customer engagement and operational effectiveness
- Performs Root Cause Analysis
- Evaluates and maintains customer payment arrangement plans and collectors tools
- Influences design of and ensures optimization of any collections programs
- Ensures strategies are compliant with all regulatory rules and requirements
- Works with IT and other departments to ensure proposals are implementable, implemented robustly and monitored/controlled effectively
Other Functions
- Develops ad hoc training to enable succession planning options and broaden overall capability
- Builds relationships with key stakeholders across business, finance, risk, operations to enable support for collections strategies
- Performs other related duties as assigned
Work Environment And Physical Demands
Worked is performed in a standard office environment.
Required Knowledge, Skills, And Abilities
- Ability to drive work forward independently and collaborate as a member of a team to push thinking and take projects to business leading solutions
- Ability to independently analyze, draw conclusions and make recommendations
- Good communication skills
- Strong work ethic & team skills
- Ability to manage a project to agreed schedule, budget, scope, and quality
- Ability to put our customers’ needs first
- Ability to contribute to an inspired workplace that is focused on success and treating our customers fairly
- Ability to demonstrate integrity and respect within the workplace through dealings with colleagues and customers
- Ability to be innovative and creative in approach – seeking new opportunities to improve our customer experience, our brand, the business and ourselves
- Process mapping and business analysis skills
Minimum Education, Experience Requirements
- Bachelor’s degree in Business, Information Technology, Finance, Statistics or a related field
- 3+ years data analysis experience
- Project management experience
OR
- High school diploma or equivalent
- 7+ years data analysis experience
- Project management experience