Stefan Auerbach
Data Scientist
Experience
Nov 2023 - May 2024
7 monthsData 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 monthsData 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 monthsData 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 behavior 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 monthsProject 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 monthsData 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 behavior 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 yearProject 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 monthsData Consultant
Barkawi Consulting
- Project for Dräxlmaier Group (BMW Supplier).
- Supply chain logistics.
- Modelling and unification of hundreds of different data sources and formats.
- Big data analysis, cleansing, dashboarding with Spark, SQL, Qlik, R.
May 2017 - Present
8 years 3 monthsSide Projects
- Web scraping, 3D modelling, Advent of Code, machine learning, generative AI.
- Analysis of Twitter and Youtube data.
- Investor consulting.
May 2017 - Present
8 years 3 months Frankfurt, Germany
Data Scientist & BI Professional
Self-Employed
- Data science and engineering in various projects for AI, Finance & Insurance Maths clients such as ProSiebenSat1, MediaMarktSaturn, Dräxlmaier (BMW Supplier), Trendence, Optiopay.
- 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.
May 2015 - May 2017
2 years 1 monthSr. BI Manager, Team Lead BI
MyLorry FoodExpress / Just Eat Takeaway
- Responsible for BI infrastructure of FoodExpress and implementation of driver/demand forecasting.
- Identifying high potential delivery areas.
- Machine learning & analytics.
- Reporting, modelling, visualizing.
Dec 2010 - Aug 2013
2 years 9 months Germany
Trainee & Business Analyst
Deutsche Bahn AG
- Started as Trainee in ICT and later Manager for complex Software Development Projects.
- Project management.
- Leading of small teams (up to 5).
- Budgets between 500K-2M.
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
- Visualization
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
Similar Freelancers
Discover other experts with similar qualifications and experience