Responsibilities:

• Development and support of regular reports on key collection KPIs: recovery rate, cure rate, roll rate, collection efficiency 0–90, autodialer funnel.
• Building and updating dashboards in Looker Studio (Google Data Studio) for operational managers and top management.
• Automation of data extracts and reports (Python, schedulers), reduction of manual labor in report preparation.
• Processing requests from heads of soft / hard / legal collection departments: segment analysis of the portfolio, effectiveness of contact channels, conversion by collection stages.
• Analysis of reasons for deviations of actual results from the plan for collections and prompt preparation of comments.
• Analysis of customer behavior by DPD buckets, product, origination channel, scoring groups.
• Participation in the design of A/B tests and pilots (contact strategies, call pricing, robot vs operator, letters, field collection).
• Calculation of target samples, control groups, holdouts; monitoring pilot metrics in dynamics.
• Preparation of final pilot reports with recommendations for scaling.
• Writing and optimizing SQL queries in ClickHouse, PostgreSQL, MS SQL Server.
• Development of Python scripts for ETL/data extracts, loading data into analytical data marts (sandbox).
• Data validation, searching for and logging bugs in sources, collaboration with data engineering on expanding data marts.

Requirements:

• SQL — confident level: all types of JOINs, window functions (ROW_NUMBER, RANK, LAG/LEAD), CTEs, aggregations, HAVING, subqueries.
• Experience with at least one of the DBMS: PostgreSQL, MS SQL Server, ClickHouse (readiness to quickly master others).
• Python — basic level: pandas, file handling, simple scripts for data extraction/transformation.
• BI tools: experience in building reports in Looker Studio, Power BI, Qlik Sense, or Tableau (basic level).
• Excel — confident level: pivot tables, VLOOKUP/INDEX basic formulas.
• Basic understanding of statistics: proportions, averages, distributions, simple hypothesis testing.
• Understanding of basic debt collection processes: stages (soft / hard / legal), DPD buckets, roll rate, cure rate, recovery rate.
• Basic understanding of call center and autodialer operation.
• Understanding of credit products: payment schedule, accruals, payment discipline.

Conditions:

• 5/2 schedule from 9 to 6
• Office in BC Uzbum, Fergana highway, 23
• Official employment under the Labor Code of Uzbekistan from the first day
• Competitive salary
• Wide opportunities for training
• Discount programs from partner companies, voluntary medical insurance (DMS)
• Lack of bureaucracy