Top expert badge
Recommended expert
Profile header background

Nico Schäfer

Quantitative modeling and model development, statistical data analysis, reporting

Nico Schäfer
Profile header overlay
Cologne, Germany

Experience

Jul 2022 - Present
3 years 9 months

Quantitative modeling and model development, statistical data analysis, reporting

DB InfraGO / Brockmann & Büchner Partnergesellschaft

Expertise details
Position Summary
Quantitative modeling and model development, statistical data analysis, reporting at DB InfraGO / Brockmann & Büchner Partnergesellschaft
Industries
Transportation
Business Areas
Business Intelligence
Project Management
  • 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

Expertise details
Position Summary
Customer segmentation; building KPI monitoring, CRM at Auch schön - organic fashion & interior design
Industries
Fashion
Retail
Business Areas
Business Intelligence
Information Technology
Marketing
  • 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

Expertise details
Position Summary
Statistical data analysis and reporting, biostatistics training at O.I.s OncologyInformationService
Industries
Biotechnology
Healthcare
Business Areas
Business Intelligence
Project Management
Research and Development
  • 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

Expertise details
Position Summary
Statistical data analysis and reporting, methods consulting, data management and consolidation at Santhera (Germany) GmbH
Industries
Biotechnology
Pharmaceutical
Business Areas
Business Intelligence
Research and Development
  • 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

Expertise details
Position Summary
Quantitative modeling, methods consulting, data analysis at FOM Köln / covelo GmbH
Industries
Pharmaceutical
Retail
Business Areas
Business Intelligence
Research and Development
  • 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 10 months

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

Gewinnsparverein Köln e.V.

Expertise details
Position Summary
Impact monitoring and statistical analysis, data management and consolidation, reporting and data visualization at Gewinnsparverein Köln e.V.
Industries
Banking and Finance
Business Areas
Business Intelligence
Marketing
  • 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.

Expertise details
Position Summary
Evaluation: data analysis and impact monitoring at Verein für Kultur, Politik und Berufsbildung e.V.
Industries
Education
Business Areas
Business Intelligence
Research and Development
  • 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

Expertise details
Position Summary
ETL and data visualization: implementation consulting, data management, database administration, dashboard development at Okba International
Industries
Information Technology
Professional Services
Business Areas
Business Intelligence
Information Technology
  • 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

Expertise details
Position Summary
Project coordination, data management, and research at the Competence Center for Women in Science at GESIS – Leibniz Institut für Sozialwissenschaften
Industries
Education
Business Areas
Project Management
Research and Development
  • 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

Expertise details
Position Summary
Statistical analysis, data visualization, and reporting within the framework of impact-oriented monitoring at Academy for International Cooperation of the German Society for International Cooperation
Industries
Education
Business Areas
Business Intelligence
Quality Assurance
Research and Development
  • 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 10 months

Founder of my registered company

sove.it e.k.

Expertise details
Position Summary
Founder of my registered company at sove.it e.k.
Industries
Information Technology
Business Areas
Information Technology
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)

Expertise details
Position Summary
Consulting, statistical analysis and reporting as part of impact-oriented project monitoring at Akademie für Internationale Zusammenarbeit der Deutschen Gesellschaft für Internationale Zusammenarbeit (GIZ GmbH)
Industries
Education
Government and Administration
Business Areas
Business Intelligence
Quality Assurance
Research and Development
  • 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)

Expertise details
Position Summary
Planning, coordinating and conducting a qualitative impact study at Akademie für Internationale Zusammenarbeit der Deutschen Gesellschaft für Internationale Zusammenarbeit (GIZ GmbH)
Industries
Government and Administration
Business Areas
Project Management
Research and Development
  • 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

Expertise details
Position Summary
Student research assistant at the Chair of Empirical Social Research at Rheinische Friedrichs-Wilhelm Universität
Industries
Education
Business Areas
Research and Development
  • 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.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Banking and Finance, Education, Transportation, Government and Administration, and Biotechnology.

Information Technology
Banking and Finance
Education
Transportation
Government and Administration
Biotechnology
Profile match chart

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Information Technology, Research and Development, Project Management, Marketing, and Quality Assurance.

Business Intelligence
Information Technology
Research and Development
Project Management
Marketing
Quality Assurance
Profile match chart

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

Statistics

Experience

Total positions 14
Experience in Information Technology 11 y
Avg length 2 y 6 m
Longest experience 10 y 9 m

Expertise

Recent roles Quantitative modeling and model development, statistical data analysis, reporting, Customer segmentation; building KPI monitoring, CRM, Statistical data analysis and reporting, biostatistics training
Main industries Information Technology, Banking and Finance, Education
Main business areas Business Intelligence, Information Technology, Research and Development

Qualifications

Highest degree Master

Profile

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

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Nico based?

Nico is based in Cologne, Germany and can operate in on-site, hybrid, and remote work models.

What languages does Nico speak?

Nico speaks the following languages: German (Advanced), English (Advanced), Italian (Intermediate), French (Elementary).

How many years of experience does Nico have?

Nico has at least 14 years of experience. During this time, Nico has worked in at least 14 different roles and for 13 different companies. The average length of individual experience is 1 year. Note that Nico may not have shared all experience and actually has more experience.

What roles would Nico be best suited for?

Based on recent experience, Nico would be well-suited for roles such as: Quantitative modeling and model development, statistical data analysis, reporting, Customer segmentation; building KPI monitoring, CRM, Statistical data analysis and reporting, biostatistics training.

What is Nico's latest experience?

Nico's most recent position is Quantitative modeling and model development, statistical data analysis, reporting at DB InfraGO / Brockmann & Büchner Partnergesellschaft.

What companies has Nico worked for in recent years?

In recent years, Nico has worked for DB InfraGO / Brockmann & Büchner Partnergesellschaft, Auch schön - organic fashion & interior design, Gewinnsparverein Köln e.V., and sove.it e.k..

Which industries is Nico most experienced in?

Nico is most experienced in industries like Information Technology, Banking and Finance, and Education. Nico also has some experience in Transportation, Government and Administration, and Biotechnology.

Which business areas is Nico most experienced in?

Nico is most experienced in business areas like Business Intelligence, Information Technology, and Research and Development. Nico also has some experience in Project Management, Marketing, and Quality Assurance.

Which industries has Nico worked in recently?

Nico has recently worked in industries like Information Technology, Banking and Finance, and Transportation.

Which business areas has Nico worked in recently?

Nico has recently worked in business areas like Information Technology, Business Intelligence, and Marketing.

What is Nico's education?

Nico holds a Master in Sociology from Rheinische Friedrich-Wilhelms University Bonn and a Bachelor in Social and Political Sciences from Justus Liebig University Giessen.

What is the availability of Nico?

Nico is immediately available full-time for suitable projects.

What is the rate of Nico?

Nico's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Nico?

To hire Nico, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Rate comparison chart
Market avg: 910-1070 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.