Dunning & Collection Analyst (f/m/d)
Posted Updated
Description
1&1 IONOS SE in Berlin seeks a Dunning & Collection Analyst to extract, analyze, and interpret complex data from multiple sources to uncover patterns that improve collection processes and recovery rates. You will transform raw data into actionable intelligence, build dashboards, and collaborate with finance, IT, and collections teams to validate findings and implement data-driven improvements.
The ideal candidate has advanced SQL, excellent Excel skills, and experience with BI tools like Power
Extract and compile data from various systems and databases to create datasets for analysis using SQL and Excel. Perform in-depth statistical analyses to identify patterns, trends, and correlations in payment behavior and dunning performance. Develop and maintain dashboards and reporting frameworks tracking collection metrics and drivers. Conduct root cause analysis on collection challenges and payment failures across segments. Segment customers and cohorts based on payment behavior to enable targeted collection strategies. Propose data-driven solutions and quantified business cases to support improvements. Collaborate with collection teams, finance, and IT to validate findings and implement improvements. Document methodologies, data sources, analysis logic, and assumptions for reproducibility. Degree in data science, mathematics, statistics, business analytics, economics, or related quantitative field, or equivalent professional experience. Expert-level SQL skills with the ability to write complex queries to extract, transform, and aggregate data from relational databases. Proficiency in MS Excel including advanced functions, pivot tables, data modeling, and handling large datasets. Hands-on experience with business intelligence tools or data visualization platforms (Power BI, Looker, BI Cubes or similar). Experience analyzing financial data, accounts receivable, collection processes, payment behavior, or credit risk management. Strong statistical thinking, descriptive/exploratory analysis, hypothesis testing, trend analysis, and correlation studies. Ability to translate complex analytical findings into clear, actionable insights and business narratives for both technical and non-technical audiences. Results-oriented, proactive, self-directed, with ownership of analyses from conception through implementation.Skills
Sign in to read and join the discussion.