Nico Schäfer

Quantitative modelling and model development, statistical data analysis, reporting

Cologne, Germany

Experience

Jul 2022 - Present
3 years 1 month

Quantitative modelling and model development, statistical data analysis, reporting

DB InfraGO / Brockmann & Büchner Partnergesellschaft

  • Technical project management, requirements management and design to guide the data team in developing a predictive maintenance model for DB InfraGo's maintenance planning.
  • Statistical modelling and analysis programming with R Studio for fault analysis in preventive management: multivariate modelling using quasi-Poisson, negative binomial, lasso, offset, splines, random forest.
  • Implementation of various R Shiny dashboards.
  • Sparring partner and requirements management for data engineering, data modelling and ETL process in Tableau Prep.
Jan 2020 - Mar 2022
1 year 3 months

Customer segmentation; KPI monitoring setup, CRM

Auch schön - organic fashion & interior design

  • Customer segmentation; KPI reporting setup; data analysis; writing scripts in R and Excel.
  • Data management and processing: ETL to prepare analysis-ready data, interface management to the online shop in R via httr, plumbR.
Aug 2019 - Feb 2021
1 year 7 months

Statistical data analysis and reporting, biostatistics training

O.I.s) OncologyInformationService

  • Data analysis: statistical evaluation, complex survival time modelling, reporting and data visualization with SPSS, Visokio, R, Excel. Syntax programming and writing scripts in R and SPSS. Data management and processing: checking data plausibility.
  • Training on biostatistics methods in R: Kaplan-Meier, Cox regression, propensity score matching.
  • Leading a three-person project team.
Dec 2018 - Oct 2019
11 months
Germany

Statistical data analysis and reporting, methodological consulting, data management and consolidation

Santhera (germany) GmbH

  • Survival analyses for quantitative data evaluation, methodological consulting and reporting as well as result visualization with R, SPSS/PSPP, Excel VBA.
  • Automating metric calculation for continuous analysis in an R Shiny dashboard.
  • Data management, cleaning and processing: case-by-case and plausibility checks, standardizing data base for building extendable structures, integration of ongoing observation waves.
Nov 2018 - Apr 2019
6 months
Cologne, Germany

Quantitative modelling, methodological consulting, data analysis

FOM Köln / covelo GmbH

  • Data management, data exploration and time series analysis, methodological consulting as well as statistical evaluation and visualization of price dispersion dynamics in online pharmacy retail.
  • Merging and consolidating crawling data in an ETL process: merging, consolidating, processing, structuring and standardizing nested data sets.
  • Dashboard development as well as analysis and visualization with R, Tableau, SPSS/PSPP, Excel VBA.
Jun 2018 - Present
7 years 2 months
Cologne, Germany

Impact monitoring and statistical evaluation, data management and consolidation, reporting and data visualization

Gewinnsparverein Köln e.V.

  • Impact analysis and customer segmentation to assess and manage a marketing campaign: indicator development and quantitative evaluation, ex-post design of treatment and control groups, setting up a cross-sectional design.
  • Data management, structuring, consolidation: building an ETL pipeline to merge various data sources into a single database solution (n=1,300,000). Visualizing results and designing a reporting format. Developing KPIs to manage and evaluate the campaign over time.
  • Analysis and visualization with SPSS/PSPP and R, macro programming in Excel VBA, dashboard development with Tableau.
Feb 2018 - Aug 2018
7 months

Evaluation: data analysis and impact monitoring

Verein für Kultur, Politik und Berufsbildung e.V.

  • Evaluation and reporting, participatory indicator development and providing a questionnaire for event evaluation. Conducting data analysis and providing a reporting format.
  • Preparing analysis results as graphics and presentation slides.
  • Implementation in R and SPSS and visualization in PowerPoint/Excel.
Feb 2018 - Jun 2018
5 months
Bonn, Germany

ETL and data visualization: implementation consulting, data management, database administration, dashboard development

Okba International

  • Dashboard development in Excel VBA and Tableau to visualize material stock metrics. R and Excel VBA programming, Tableau.
  • ETL: merging existing data sources and integrating data structures into a shared database: consolidating, transforming and standardizing data sets to build a digital inventory system.
Jul 2017 - Jan 2018
7 months
Cologne, Germany

Project coordination, data management and research activities at the Competence Centre for Women in Science (CEWS)

GESIS – Leibniz Institut für Sozialwissenschaften

  • Collaborating on a project to evaluate gender equality plans at European universities in the field of educational gender inequality, funded by the EU's Horizon 2020 research program.
  • Research to identify indicators for measuring gender-related inequalities in academic careers.
  • Data management and research ethics; specifying data management processes for monitoring and evaluation purposes.
Jun 2017 - Mar 2018
10 months
Bonn, Germany

Statistical analysis, data visualization and reporting within the Academy’s impact-oriented monitoring

Akademie für Internationale Zusammenarbeit der deutschen Gesellschaft für Internationale Zusammenarbeit

  • Digitization, statistical analysis, monitoring and reporting for quality management at the Academy for International Cooperation. Providing analysis reports with quantitative and qualitative course evaluation results through a solution interfacing SPSS and Excel VBA.
  • Developing graphical presentations of analysis results and coordinating the scientific and student staff involved in the project.
Jun 2015 - Jun 2015
1 month

Founder

sove.it e.k.

Founded my registered company.

Jan 2015 - May 2017
2 years 5 months
Bad Honnef, Germany

Consulting, statistical analysis and reporting for impact-oriented assignment monitoring for the German Society for

Akademie für Internationale Zusammenarbeit der Deutschen Gesellschaft für Internationale Zusammenarbeit (GIZ GmbH)

  • Consulting on the further development of impact-oriented monitoring and internal evaluation of the 'Key Competencies for International Cooperation' assignment at the Academy for International Cooperation.
  • Methodological advice on survey instruments. Expanding and systematizing the monitoring and reporting system: developing unified reporting standards, building an integrated database solution.
  • Monitoring and reporting for quality management: statistical analysis of about 5,000 annual participant feedbacks. Providing about 100 quarterly analysis reports with quantitative and qualitative course evaluation results via a solution interfacing SPSS and Excel VBA.
  • Preparing analysis results as graphics and presentation slides and coordinating the scientific and student staff involved in the project.
Jan 2015 - Feb 2017
2 years 2 months
Bad Honnef, Germany

Planning, coordination and execution of a qualitative impact study for the German Society for International Cooperation

Akademie für Internationale Zusammenarbeit der Deutschen Gesellschaft für Internationale Zusammenarbeit (GIZ GmbH)

  • Qualitative study on the impact and practical relevance of the pre-departure training for the 'Key Competencies for International Cooperation' assignment at the Academy for International Cooperation. Coordinating a scientific project team and student assistants.
  • Designing the study and coordinating a two-phase survey with seven comparison groups (n=100), guideline interviews with former training participants (specialists and managers in German IC: AA, BMZ, GIZ), expert interviews, document analysis. Analysis, reporting and presentation of results.
Jan 2011 - Dec 2015
3 years
Bonn, Germany

Student assistant at the Chair of Empirical Social Research under Prof. Jörg Blasius

Rheinische Friedrichs-Wilhelm Universität

  • Working on teaching and research projects of the chair and in the evaluation working group for higher education teaching: conducting tutorials and method consulting for students.
  • Graphic illustration of multivariate analyses, participating in data collection. Questionnaire design and data processing. Designing and managing online surveys for the chair’s teaching research projects.

Languages

German
Native
English
Advanced
Italian
Intermediate
French
Elementary

Education

Oct 2010 - Sep 2014

Rheinische Friedrichs-Wilhelms University

Master of Arts · Sociology · Bonn, Germany · 1.4

Oct 2006 - Sep 2010

Justus Liebig University

Bachelor of Arts · Social and Political Sciences · Giessen, Germany · 1.8