Profilbild von Sven Gonschorek Analytics Engineer | DWH - ETL - SQL - PYTHON aus Hamburg

Sven Gonschorek

nicht verfügbar bis 30.06.2024

Letztes Update: 24.01.2024

Analytics Engineer | DWH - ETL - SQL - PYTHON

Firma: BI Solutions Hamburg
Abschluss: Master of Science
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (Muttersprache) | englisch (verhandlungssicher)




Design and build scalable data processing systems

As Analytics Engineer, I create data products that empower stakeholders to derive valuable insights into your business.
I support your team in designing and building a data processing system tailored to your needs using state-of-the-art technologies.
Programming languages
SQL, T-SQL, PostgreSQL, mySQL, Python, PHP

Version Control - CI/CD
git, github, Docker

Data Warehouses - Platforms
SQL Server, AWS Redshift, Google BigQuery, Snowflake, Palantir Foundry

Tools and Frameworks
dbt (Data Build Tool), Apache Airflow, Spark, data visualization (e.g. Tableau)
About me
Moin, I’m Sven. I am a freelance Analytics Engineer with around five years of experience in various data projects.
Originally I started my career in aeronautical engineering, but after I finished my master’s degree, I began to follow my passion which was more software than hardware driven. I spent a couple of years accomplishing and leading different projects in data analytics for the aircraft industry before I started my career as a freelancer in analytics engineering.
Today I support companies building powerful data platforms by applying software engineering best practices with modern technological solutions.
When I am not at work, you can find me enjoying a lot of different sports. I play badminton, go for bike rides, go standup paddling on the Alster, and many more.


03/2023 - bis jetzt
Data Management Consulting
Freelance (Energie, Wasser und Umwelt, 500-1000 Mitarbeiter)

Implement a data management strategy for a holding company

The objective of this project is to create a data management strategy for a holding company operating in the energy and chemical sector. The plan involves the development of a centralized platform that facilitates data exchange among various operational systems. Additionally, I am responsible for designing and constructing an enterprise data warehouse architecture to cater to the customer's needs for data analytics use cases.

10/2021 - 12/2022
Development of a cloud data warehouse solution
Freelance (Internet und Informationstechnologie, 50-250 Mitarbeiter)

Create a cloud data warehouse solution in AWS redshift 

Goal of the project is to develop a cloud data warehouse solution in AWS redshift to replace the existing on premise data warehouse. To optimize the transform processes and integrate automated testing, I introduce dbt to the project. In the new cloud data warehouse, I redesign the complete data model in a data vault approach and define the standards to the overall data modeling.

04/2022 - 09/2022
XML to kafka Data Warehouse migration
Freelance (Internet und Informationstechnologie, 50-250 Mitarbeiter)

Migrate existing data pipelines using SSIS XML packages to stored procedures consuming data from a kafka data stream. 

For this data warehouse migration project, I created ETL pipelines on SQL Server using data from an Apache kafka stream. These pipelines are orchestrated by Apache Airflow. Additionally I redesigned some of the data models inside the data warehouse.

07/2019 - 04/2021
Project Management for Consulting Projects
CIMPA GmbH (Industrie und Maschinenbau, 50-250 Mitarbeiter)

As a project leader, I am responsible for 2-3 projects at customers in the aviation industry. 

In these projects, I take over the administrative project work (project planning, resource planning, financial planning) and am in direct contact with different customers in aviation.

03/2019 - 04/2021
BI Business Applications and Dashboards
CIMPA GmbH (Industrie und Maschinenbau, 50-250 Mitarbeiter)

Development of different small business applications and business intelligence dashboards to support 3D design processes. 

For these applications, I mainly use data provided by a data warehouse on the customer infrastructure and apply data analysis to discover useful information inside this data. To visualize this data, I use the Palantir skywise platform, the DevExpress / DevExtreme framework, or in some cases JS libraries like Chart.js.

06/2018 - 05/2020
Retirement of Business Owned Tools
CIMPA GmbH (Industrie und Maschinenbau, 50-250 Mitarbeiter)

Support for a Business Intelligence (BI) framework that provides the ability to view data from all customer legacy systems. This framework is used to retire different business owned tools such as Excel tables or MS Access databases.

In this project, I supported users from different engineering departments to create dashboards and perform data analysis (SQL).  Additionally,  I held training / awareness sessions and collaborated with the developers of the framework.

07/2018 - 03/2019
Development of a Reporting Center
CIMPA GmbH (Industrie und Maschinenbau, 50-250 Mitarbeiter)

Creation of a web application with Angular, which connects different legacy systems and derives KPIs from them.

This tool is based on an Angular Frontend, with PHP Backend, which accesses an MYSQL data model. Also, version management with GitLab was set up. The web tool is currently used by over 150 people in the aircraft industry.


Professional Data Engineer


Verfügbar in den Ländern Deutschland, Österreich und Schweiz
Profilbild von Sven Gonschorek Analytics Engineer | DWH - ETL - SQL - PYTHON aus Hamburg Analytics Engineer | DWH - ETL - SQL - PYTHON