Dunning & Collection Analyst (w/m/d)

IONOS EN; Berlin; On-site; EUR 60,000 - 90,000; Full time

Job summary

IONOS EN is seeking a Dunning & Collection Analyst to extract, analyze, and interpret complex data, driving improvements in collection processes and recovery rates. You will transform raw data into actionable intelligence and collaborate with finance and IT to implement improvements.

The role requires expert SQL, advanced Excel, and experience with Power BI/Looker. Fluency in English is essential, Berlin-based with an on-site setup.

Qualifications

• Expert-level SQL skills with the ability to write complex queries to extract, transform, and aggregate data
• Proficiency in MS Excel, including pivot tables, data modeling, and handling large datasets
• Experience with BI tools (Power BI, Looker, BI Cubes) to create dashboards and reports
• Practical experience analyzing financial data in accounts receivable, collection processes, or credit risk
• Strong statistical thinking and descriptive/exploratory analysis skills
• Ability to translate findings into clear, actionable business insights

Responsibilities

• Extract and compile data from multiple systems to create datasets for analysis
• Perform in-depth statistical analysis to identify patterns in payment behavior and dunning performance
• Develop dashboards and reporting frameworks tracking KPIs like collection rates and DSO
• Conduct root cause analysis of collection challenges and payment failures
• Segment customers for targeted collection strategies and personalized dunning approaches
• Propose data-driven solutions and quantify business cases to support changes
• Collaborate with collection, finance, and IT teams to validate findings and monitor impact
• Document methodologies, data sources, and analysis logic for reproducibility

Skills

SQL

MS Excel

Data visualization tools

Education

Data science / mathematics / statistics degree

Tools

Power BI

Looker

BI Cubes

Job description

At IONOS, we don't just manage servers – we shape the digital future for more than 6.2 million customers worldwide with our solutions. As Europe's leading hosting provider and a pioneer in independent cloud solutions, we are building next-generation infrastructure – from sovereign cloud architectures and high-performance GPU clusters to integrated AI automation tools.

What drives us is digital sovereignty for Europe and real impact for small and medium-sized businesses (SMBs) as well as large enterprises. We work in agile teams, rely on transparent structures, and believe that excellence and innovation only emerge through true team spirit.

Ready for your next step? Become part of IONOS and grow with us.

Your responsibilities

As a Dunning & Collection Analyst, you are responsible for extracting, analyzing, and interpreting complex data from multiple sources to uncover patterns, trends, and insights that drive strategic improvements in our collection processes and recovery rates. You transform raw data into actionable intelligence that informs business decisions and process optimization.

• You extract and compile data from various systems and databases to create comprehensive datasets for analysis, utilizing SQL queries and advanced Excel techniques to ensure data accuracy and completeness.
• You perform in-depth statistical and exploratory analysis to identify patterns, trends, anomalies, and correlations in customer payment behavior, delinquency rates, collection effectiveness, and dunning performance across different customer segments.
• You develop and maintain dashboards and reporting frameworks that track key performance indicators (collection rates, days sales outstanding, recovery efficiency, dunning success rates) and provide visibility into performance drivers.
• You conduct root cause analysis on collection challenges and payment failures, drilling down into data to understand why certain customer segments, payment methods, or dunning strategies underperform.
• You segment customers and cohorts based on payment behavior, risk profiles, and response patterns to enable targeted collection strategies and personalized dunning approaches.
• You propose data-driven solutions based on your findings—from process improvements and policy changes to tool enhancements—and provide quantified business cases to support implementation.
• You collaborate with collection teams, finance, and IT to validate findings, ensure data quality, and drive implementation of recommended improvements, monitoring impact through post-implementation analysis.
• You maintain comprehensive documentation of your methodologies, data sources, analysis logic, and assumptions to ensure reproducibility and knowledge sharing across teams.

Your profile

You have completed a degree program in data science, mathematics, statistics, business analytics, business administration, economics, or a related quantitative field, or equivalent professional experience.

• You possess expert-level SQL skills with the ability to write complex queries to extract, transform, and aggregate data from relational databases.
• You are highly proficient in MS Excel, including advanced functions, pivot tables, data modeling, and the ability to handle and analyze large datasets efficiently.
• You have hands-on experience with business intelligence tools or data visualization platforms (Power BI, Looker, BI Cubes or similar) to create compelling dashboards and reports.
• You have practical experience analyzing financial data, specifically in areas such as accounts receivable, collection processes, payment behavior, or credit risk management.
• You possess strong statistical thinking and are comfortable with descriptive and exploratory analysis, hypothesis testing, trend analysis, and correlation studies.
• You have a sharp analytical mind with exceptional attention to detail, a natural curiosity to dig deeper into data, and the ability to challenge assumptions.
• You excel at translating complex analytical findings into clear, actionable insights and compelling business narratives for both technical and non-technical audiences.
• You are results-oriented, proactive, self-directed, and take ownership of your analyses from conception through implementation and measurement.
• You have strong organizational skills and the ability to manage multiple analyses simultaneously, setting priorities effectively and delivering within deadlines.
• You speak English fluently

If you don't check all the boxes above, don't worry—we're looking for the right mindset, analytical drive, and willingness to learn. Your passion for uncovering insights from data matters more than ticking every requirement.

Application Note

We value diversity and welcome all applications – regardless of, for example, gender, nationality, ethnic or social origin, religion, disability, age as well as sexual orientation and identity, physical characteristics, marital status or any other irrelevant factor subject to applicable law.