Stefan Auerbach

Data Scientist & BI Professional

Stefan Auerbach
Berlin, Germany

Experience

Nov 2023 - May 2024
7 months

Data Scientist

Trendence Institute

Analyzing and visualizing survey data (big data) Infrastructure and database performance optimization AWS, GCP, BigQuery, SQL, Tableau, Python, Tableau Server

Sep 2020 - Apr 2021
8 months

Data Scientist

Trendence Institute

Analyzing and visualizing survey data (big data) Infrastructure and database performance optimization AWS, GCP, BigQuery, SQL, Tableau, Python, Tableau Server

Aug 2020 - Oct 2023
3 years 3 months

Data Engineer

ProSiebenSat1/SevenOneMedia

Project Management Data warehouse and ETL development Data layer development KPI development and analysis Implementation of ML algorithms such as outlier detection, forecasting Ad targeting and consumer behaviour environment Migration of full stack to infrastructure as code in AWS (S3, RDS, RedShift, Glue, Athena, Lambda, Kinesis, PySpark, TerraForm, CloudFormation, Travis CI, Git) Visualization with Tableau and Python Tableau Server maintenance Data backup and recovery strategy

Jun 2020 - Aug 2020
3 months

Project Manager / Data Scientist

Optiopay

Management of a focus KPI reporting project in banking / ecommerce environment Definition and visualization of data pipelines and KPIs Azure, SQL, PowerBI, Kafka, Python, Git

Jun 2019 - Feb 2020
9 months

Data Engineer

ProSiebenSat1/SevenOneMedia

Project Management Data warehouse and ETL development Data layer development KPI development and analysis Implementation of ML algorithms such as outlier detection, forecasting Ad targeting and consumer behaviour environment Migration of full stack to infrastructure as code in AWS (S3, RDS, RedShift, Glue, Athena, Lambda, Kinesis, PySpark, TerraForm, CloudFormation, Travis CI, Git) Visualization with Tableau and Python Tableau Server maintenance Data backup and recovery strategy

May 2018 - Apr 2019
1 year

Project Manager / Data Analyst

MediaMarktSaturn

Management of migration of reporting project to Tableau environment Rebuilding DWH layers and whole reporting system including key reports Data analytics and machine learning algorithms such as RFM, outliers, customer lifecycle SPSS, SAS, Tableau, PowerBI, TeraData, SQL, PowerShell

Nov 2017 - Mar 2018
5 months

Data Consultant

Barkawi Consulting

Supply chain logistics Modelling and unification of hundreds of different data sources and formats Big data analysis, cleansing, dashboarding with Spark, SQL, Qlik, R

For Dräxlmeier Group (BMW Supplier)

May 2017 - Present
7 years 10 months
Lorem ipsum dolor sit amet

Side Projects: Web scraping, 3D modelling, Advent of Code, Machine Learning, Generative AI Analysis of Twitter and Youtube data Investor consulting

May 2017 - Present
7 years 10 months
Berlin, Germany
Lorem ipsum dolor sit amet

Freelancer

Project Management Leading of small teams (up to 5) Implementation of ML algorithms Optimization of cloud infrastructure Visualization of big data Budgets between 200K-2M

Data Science and Engineering in various projects for clients such as ProSiebenSat1, MediaMarktSaturn, Dräxlmaier (BMW Supplier), Trendence, Optiopay MyLorry FoodExpress / Just Eat Takeaway

May 2015 - May 2017
2 years 1 month

Sr. BI Manager, Team Lead BI

MyLorry FoodExpress / Just Eat Takeaway

Machine Learning & Analytics Reporting, modelling, visualizing

Responsible for BI infrastructure of FoodExpress and implementation of driver/demand forecasting. Identifying high potential delivery areas.

Jan 2013 - Dec 2015
3 years
Lorem ipsum dolor sit amet

Round the world trip

Dec 2010 - Aug 2013
2 years 9 months

Trainee & Business Analyst

Deutsche Bahn AG

Project Management Leading of small teams (up to 5) Budgets between 500K-2M

Started as Trainee in ICT and later Manager for complex Software Development Projects

Summary

Getting your data, transforming, analyzing, training it and finally gaining insights. I cover the whole pipeline: - Scraping - ETL (Extract, Transform, Load) - Machine Learning - Aggregation - Vizualisation You get 20+ years coding experience including but not limited to - Python, PySpark, R, Java, JavaScript, Scala, SQL - Tableau, PowerBI, Qlik, Leaflet, Shiny - AWS, Google Cloud, Azure - Docker, Git, Terraform, Travis

Languages

German
Native
English
Advanced
Spanish
Intermediate
French
Elementary

Education

Oct 2005 - Jun 2010

University of Technology, Berlin

Diploma · Business Mathematics · Berlin, Germany