Data & Reporting Analyst – Debt Collection

Reporting Analyst – Debt Collection

Salary – £40,000, plus Benefits

Sheffield

Job functions

Analyse current collections performance and make recommendations for improvement, including:

Sms, Email, Website, Chat (business transmission and customer interaction)
Ai Agents interaction and performance
Dialler systems (business transmission and customer interaction)
Payment’s activity (online payments, bank transfers, card payments over the phone
B2C Communications frequency and customer behaviour
Peaking and troughing analysis of collections performance
Payment types and pattern recognition

Experience

Debt collection or unsecured lending business (loans, credit cards, lines of credit)
E-commerce, marketing

Required hard skills

SQL. Any dialects (MySQL, PgSQL, MsSQL). CTEs, window functions, hard queries, stored procedures.
Mathematical statistics. Different types of distributions, correlation, regressions, hypothesis testing.
Excel proficient level. Data sorting, data filtering, pivot tables, vlookup, SUMIF / SUMIFS, charts.
BI tools. Desirable PowerBI
A/B testing. Split principles, test planning, logging.

Desirable hard skills

Python. Data analysis, pandas, numpy, scipy, statsmodels, seaborn, matplotlib etc.
ETL processes. Airflow, Pentaho etc.
IT understanding. Client-server processes. API. Back-end and front-end. Parsing. Algorithms and data structures.
Management. Sprints, AGILE. Waterfall. Jira etc.

Benefits: