Nico Schäfer
Quantitative modeling and model development, statistical data analysis, reporting
Experience
Quantitative modeling 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 modeling and analysis programming with R Studio for fault analysis in preventive maintenance: multivariate modeling using quasi-Poisson, negative binomial, lasso, offset, splines, RandomForest.
- Implementation of various R Shiny dashboards.
- Sparring partner and requirements management for data engineering, data modeling, and ETL pipeline in Tableau Prep.
Customer segmentation; building KPI monitoring, CRM
Auch schön - organic fashion & interior design
- Customer segmentation; building KPI reporting; data analysis; writing scripts in R and Excel.
- Data management and preparation: ETL to create an analyzable data base, interface management to the online shop in R via httr, plumbR.
Statistical data analysis and reporting, biostatistics training
O.I.s OncologyInformationService
- Data analysis: statistical evaluation, complex survival time modeling, reporting and data visualization with SPSS, Visokio, R, Excel. Syntax programming and writing scripts in R and SPSS.
- Data management and preparation: plausibility checks of the data.
- Training in biostatistical methods in R: Kaplan-Meier, Cox regression, propensity score matching.
- Managing a 3-person project team.
Statistical data analysis and reporting, methods consulting, data management and consolidation
Santhera (Germany) GmbH
- Survival analyses to evaluate quantitative data, methods consulting and reporting, as well as result visualization with R, SPSS/PSPP, Excel VBA.
- Automating key metric calculations to update analysis in an R Shiny dashboard.
- Data management, cleaning, and preparation: case-by-case and plausibility checks, standardizing the data base to build maintainable structures, integrating ongoing observation waves.
Quantitative modeling, methods consulting, data analysis
FOM Köln / covelo GmbH
- Data management, data exploration, and time series analysis, methods consulting, and statistical analysis and visualization of price dispersion dynamics in online pharmacy retail.
- Combining and consolidating crawling data in an ETL process: merging, consolidating, cleaning, structuring, and standardizing the datasets (nested data).
- Dashboard development and data analysis and visualization with R, Tableau, SPSS/PSPP, Excel VBA.
Impact monitoring and statistical analysis, data management and consolidation, reporting and data visualization
Gewinnsparverein Köln e.V.
- Impact analysis and customer segmentation for the effect and control of a marketing campaign: indicator development and quantitative evaluation, ex-post design of treatment and control groups, creation of a cross-sectional design.
- Data management, structuring, consolidation: building an ETL pipeline to merge various data sources into a common database solution (n=1,300,000). Visualization of results and design of a reporting format. Development of KPIs for monitoring and evaluating the campaign over time.
- Analysis and visualization with SPSS/PSPP and R, macro programming in ExcelVBA, dashboard development with Tableau.
Evaluation: data analysis and impact monitoring
Verein für Kultur, Politik und Berufsbildung e.V.
- Evaluation and reporting, participative development of indicators and creation of a questionnaire for event evaluation. Conducting data analysis and providing a reporting format.
- Preparation of analysis results into graphical representations and presentations.
- Implementation in R and SPSS and visualization in PowerPoint/Excel.
ETL and data visualization: implementation consulting, data management, database administration, dashboard development
Okba International
- Dashboard development with ExcelVBA and Tableau to visualize key material inventory metrics. Programming in R and ExcelVBA.
- ETL: merging existing data sources and integrating data structures into a common database: consolidation, transformation, and standardization of data sets to build a digital inventory system.
Project coordination, data management, and research at the Competence Center for Women in Science
GESIS – Leibniz Institut für Sozialwissenschaften
- Collaboration on a project evaluating gender equality plans at European universities in the field of gender-related educational inequality, funded by the EU’s Horizon 2020 research framework program.
- Research activities to identify indicators for measuring gender-specific inequalities in academic careers.
- Data management and research ethics; specification of data governance processes for monitoring and evaluation purposes.
Statistical analysis, data visualization, and reporting within the framework of impact-oriented monitoring
Academy for International Cooperation of the German Society for International Cooperation
- Digitization, statistical analysis, monitoring and reporting for the quality management of the Academy for International Cooperation. Providing evaluation reports with quantitative and qualitative results of course evaluations using a solution at the interface of SPSS and ExcelVBA.
- Developing analysis results into graphical representations and presentations, and coordinating the scientific and student staff involved in the project.
Founder of my registered company
sove.it e.k.
Consulting, statistical analysis and reporting as part of impact-oriented project monitoring
Akademie für Internationale Zusammenarbeit der Deutschen Gesellschaft für Internationale Zusammenarbeit (GIZ GmbH)
- Consulting on the further development of impact-oriented monitoring and the internal evaluation of the 'Key Skills for International Cooperation' project at the Academy for International Cooperation.
- Provided methodological advice on the survey tool. Expanded and systematized the monitoring and reporting system: developed uniform reporting standards and set up an integrated database solution.
- Monitoring and reporting for quality management: conducted statistical analysis of around 5000 participant feedback responses per year. Delivered about 100 evaluation reports each quarter with quantitative and qualitative results from course evaluations using a solution linking SPSS and Excel VBA.
- Prepared the analysis results as charts and presentations and coordinated the scientific and student team working on the project.
Planning, coordinating and conducting a qualitative impact study
Akademie für Internationale Zusammenarbeit der Deutschen Gesellschaft für Internationale Zusammenarbeit (GIZ GmbH)
- Conducted a qualitative study on the impact and practical relevance of the pre-departure training in the 'Key Skills for International Cooperation' project. Coordinated a scientific project team and student assistants.
- Designed the research approach and coordinated a two-phase data collection with seven comparison groups (n=100), using guided interviews with former participants, expert interviews, and document analysis. Carried out analysis, prepared reports, and presented the results.
Student research assistant at the Chair of Empirical Social Research
Rheinische Friedrichs-Wilhelm Universität
- Assisted with the chair's research teaching projects and the university teaching evaluation working group: conducted tutorials and methodological consultations for students.
- Created graphical illustrations of multivariate analyses and helped with data collection. Designed questionnaires and processed data. Set up and managed online surveys for the chair's research teaching projects.
Skills
Routine Use Of Software/platforms For Data Analysis: Especially R, Sql, Spss, Excel Vba, Tableau, Visokio, And Maxqda. Knowledge In Python; Php.
Multivariate Modeling, Classification, Survival Analysis, Time Series, Matching, Impact Analyses.
Strong Statistics And Methods Skills In Data Analysis And In Designing Empirical Research, Practical Know-how At The Interface Of Empirical Research, Information Science, And Social Science Services In Data Projects.
Several Years Of Experience Managing Large Datasets And Building Etl Pipelines.
Experience Administering Platforms For Online Surveys (Unipark/questback, Evasys).
Cross-cultural Skills And Several Years Of Work Abroad In Global South Countries.
Consulting Experience (Quantitative Data Analysis And Methods) In Development Cooperation, Program Evaluation, Adult Education, As Well As In The Finance, Rail Transport, And Pharmaceutical Sectors.
Highly Organized And Able To Work Independently As Well As Lead And Collaborate Effectively In Interdisciplinary Teams.
Experience Planning, Leading, And Running Scientific Projects And Contract Research.
Languages
Education
Rheinische Friedrich-Wilhelms University Bonn
Master of Arts in Sociology · Sociology · Bonn, Germany · 1.4
Justus Liebig University Giessen
Bachelor of Arts in Social and Political Sciences · Social and Political Sciences · Giessen, Germany · 1.8
Similar Freelancers
Discover other experts with similar qualifications and experience