Nico Schäfer

Quantitative modeling and model development, statistical data analysis, reporting

Nico Schäfer
Cologne, Germany

Experience

Jul 2022 - Present
3 years 7 months

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.
Jan 2021 - Mar 2022
1 year 3 months

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.
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 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.
Dec 2018 - Oct 2019
11 months

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.
Nov 2018 - Apr 2019
6 months

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.
Jun 2018 - Present
7 years 8 months

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.
Feb 2018 - Aug 2018
7 months

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.
Feb 2018 - Jun 2018
5 months

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.
Jul 2017 - Jan 2018
7 months

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.
Jun 2017 - Mar 2018
10 months

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.
Jun 2015 - Present
10 years 8 months

Founder of my registered company

sove.it e.k.

Jan 2015 - May 2017
2 years 5 months

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.
Jan 2015 - Feb 2017
2 years 2 months

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.
Jan 2012 - Dec 2014
3 years

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

German
Advanced
English
Advanced
Italian
Intermediate
French
Elementary

Education

Oct 2010 - Sep 2014

Rheinische Friedrich-Wilhelms University Bonn

Master of Arts in Sociology · Sociology · Bonn, Germany · 1.4

Oct 2006 - Sep 2010

Justus Liebig University Giessen

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

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Philipp Grunert
Philipp Grunert

Data Scientist & Data Engineer

View Profile
Mario Tuta
Mario Tuta

External Lecturer

View Profile
Eduard Van kleef
Eduard Van kleef

Workshop Leader 'Introduction to AI Development Tools'

View Profile
Rutger Boels
Rutger Boels

Partner

View Profile
William Nguyen
William Nguyen

Product Owner Frontend

View Profile
Simon Stegelmeier
Simon Stegelmeier

Cloud Data Platform Product Owner & Project Manager

View Profile
Robert Komorowsky
Robert Komorowsky

IT Consultant

View Profile
Claudius Warwitz
Claudius Warwitz

Project Manager

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Michael Tomaschewski
Michael Tomaschewski

B2B Growth Consultant

View Profile
Himanshu Negi
Himanshu Negi

Principal (Data Scientist/Data Engineer/Gen AI Engineer)

View Profile
Frank Thurner
Frank Thurner

Engineering & Industry 4.0 / IoT Project Manager

View Profile
Jörn Baumann
Jörn Baumann

Expert in Process Optimization

View Profile
Eric Bouendeu
Eric Bouendeu

Quality Assurance Manager (QSV)

View Profile
Andreas Illig
Andreas Illig

Business Development

View Profile
Oliver Köhn
Oliver Köhn

Consultant for data-driven AI solutions

View Profile
Nino Sandmeier
Nino Sandmeier

Freelancer in Data Science

View Profile
Christiane Neher
Christiane Neher

Management Consultant

View Profile
Thomas Meyer
Thomas Meyer

Executive Consultant, Management Coach

View Profile
Kevin Liehn
Kevin Liehn

Interim E-Commerce SME Consultant – Special Accounts

View Profile
André Gensler
André Gensler

MLOps, Python, Azure Cloud Engineer with Energy Economics Background

View Profile
Dany-armand Djeudeu-deudjui
Dany-armand Djeudeu-deudjui

Senior Data Scientist

View Profile
Ashkan Zadeh
Ashkan Zadeh

Microsoft Azure Senior Data Engineer / Senior Data Scientist

View Profile
Bengisu Yapar
Bengisu Yapar

Freelance BI, AI & Digital Strategy Consultant

View Profile
Edris Kamal
Edris Kamal

Co-Founder, Business Strategy & Development

View Profile
Dmitriy Drichel
Dmitriy Drichel

Freelance Senior Data Scientist

View Profile
Gottfried Arens
Gottfried Arens

IT Systems Analyst / Software Developer

View Profile
Anton Klonov
Anton Klonov

Head of Technical Overall Integration NSC / Hadoop Cloud Development

View Profile
Fadi Shoaa
Fadi Shoaa

Document parser for picking lists (PDF & PNG)

View Profile
Armin Fanzott
Armin Fanzott

Head of AI & Data Science

View Profile