4 дня назад
Dunning & Collection Analyst (w/m/d)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Текст:
TL;DR
Dunning & Collection Analyst (SQL/Excel): Analyzing customer payment behavior, delinquency, collection effectiveness, and dunning performance to improve recovery rates and collection processes with an accent on statistical analysis, segmentation, and business intelligence dashboards. Focus on identifying root causes of payment failures, developing data-driven collection strategies, and translating findings into measurable process improvements.
Location: Berlin, Germany
Company
provides cloud infrastructure, cloud services, hosting, and digitalization solutions for small and medium-sized businesses and enterprises across Europe and North America.
What you will do
- Extract, combine, and validate data from multiple systems and databases using complex SQL queries and advanced Excel techniques.
- Analyze customer payment behavior, delinquency rates, collection effectiveness, and dunning performance across customer segments.
- Develop dashboards and reporting frameworks tracking collection rates, days sales outstanding, recovery efficiency, and dunning success rates.
- Perform root cause analysis of collection challenges and payment failures, including payment methods, customer segments, and dunning strategies.
- Segment customers and cohorts by payment behavior, risk profiles, and response patterns to support targeted collection strategies.
- Collaborate with collection, finance, and IT teams to implement improvements and measure their impact.
Requirements
- Degree in data science, mathematics, statistics, business analytics, business administration, economics, or a related quantitative field, or equivalent professional experience.
- Expert-level SQL skills for extracting, transforming, and aggregating data from relational databases.
- Advanced MS Excel skills, including functions, pivot tables, data modeling, and large dataset analysis.
- Practical experience with business intelligence or data visualization tools such as Power BI, Looker, or similar platforms.
- Experience analyzing financial data related to accounts receivable, collections, payment behavior, or credit risk.
- Fluent English, strong statistical thinking, analytical judgment, attention to detail, and the ability to communicate findings to technical and non-technical audiences.
Culture & Benefits
- Open structures, flat hierarchies, and a collaborative team environment.
- Work alongside teams across a growing European digitalization and cloud services provider.
- Inclusive workplace welcoming applications regardless of nationality, gender, age, disability, religion, or other legally protected characteristics.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →
Похожие вакансии
9 дней назад
Intern Financial Planning & Analytics (f/m/x)
5 дней назад
Investment Analyst (Full Time - Remote) (M&A)
6 дней назад
Finance Controller, Technology
6 дней назад
Manager Commercial Strategy & Pricing (Automotive Marketplace)
5 дней назад
Mandatory Intern (f/m/d) Corporate Controlling
10 дней назад