Sven G.

Analytics Engineer

Hamburg, Germany

Experience

Jan 2021 - Present
4 years 11 months
Germany
Remote

Freelance Analytics Engineer

BI Solutions Hamburg

Do you need a scalable and robust data solution?

As a partner for modern data warehouse services, I help you optimize your data infrastructure, providing the foundation for efficient data analysis and precise business intelligence.

  • Services**

  • Consulting**: Facing a strategic decision in data architecture or want to make your data processes more efficient? With specialized consulting, I support you in planning and optimizing your data warehouse. Whether it's evaluating cloud solutions, selecting the right technology, or improving existing data processes: together we find the best solution for your needs.

  • Data Warehouse Migration**: Is your data warehouse reaching its limits? The answer often lies in new cloud data warehouse services like Snowflake, Google BigQuery, or Amazon Redshift. I assist you in migrating your processes to the cloud.

  • dbt™ Quickstart**: In modern data architectures, dbt™ has become the standard for all data transformations. Do you also want to use dbt™ features like version control, data lineage, or testing functionalities? I’ll show you how to integrate dbt™ into your data architecture and use it as the transformation layer for your data warehouse applying best practices.

  • Data Transformation as a Service**: Missing staff or know-how for proper data preparation? A solution is to outsource these activities to a partner. In this case, I continuously prepare the data in your data stack so you and your team can focus on analysis and data-driven decision-making.

  • Semantic Layer Implementation**: Semantic what?! Not all potential users of a data warehouse speak fluent SQL. A semantic layer defines metrics and makes them easy to use for non-technical users or self-service reporting tools.

  • And much more**: Data infrastructure requirements are usually as unique as your business. Need help with a specific challenge? Together we’ll find the right solution.

Jul 2019 - Sep 2020
1 year 3 months
Hamburg, Germany
On-site

Project Manager

CIMPA PLM Services Deutschland

As a project manager, I was responsible for 2-3 consulting projects for clients in the aviation industry at the same time.

I handled administrative tasks for the projects, including project and resource planning as well as financial planning.

Apr 2018 - Apr 2021
3 years 1 month
Hamburg, Germany
On-site

Business Analyst

CIMPA PLM Services Deutschland

As a Business Analyst, I successfully drove and implemented data analytics projects in the aviation industry. My focus was on providing engineering departments at major aircraft manufacturers with meaningful analyses and interactive dashboards containing decision-relevant information, thereby sustainably optimizing development processes.

My core tasks included:

  • Setting up and configuring databases
  • Performing complex data analyses
  • Designing and implementing dashboards
  • Conducting training in self-service analytics to empower business units
Mar 2017 - Nov 2017
9 months
Hamburg, Germany
On-site

Internship / Master Thesis

Airbus

  • Thesis Topic:**

  • Development of a Methodology and Extension of the Fault Injection Toolbox (FIT) supporting Trajectory Based Particular Risk Analysis*

Events or influences which are outside the system concerned and have a damaging effect to the system (e.g. bird strike) are called ‘Particular Risks’. It is necessary to investigate the aircraft in terms of these particular risks to fulfill the airworthiness requirements for a system or the overall aircraft design. This thesis focuses on the development of a methodology and the implementation to perform model-based Particular Risks Analysis using the Fault Injection Toolbox (FIT). This tool is used to inject faulty signals to existing design models and investigates the system behavior of the manipulated system model.

Oct 2015 - Mar 2016
6 months
Stade, Germany
On-site

Internship / Bachelor Thesis

Deutsches Zentrum für Luft-und Raumfahrt e.V.

  • Thesis Topic:**

  • Investigation of the influences of repeating, local compaction to the structural-mechanical quality of a prepreg laminate*

This report concentrates on the structural-mechanical influences of a surface pressure to uncured semi finished fibre parts during the production process. For this purpose material samples will be manufactured and a surface pressure to the uncured samples will be applied with a test-bed. Subsequently the samples will be hardened and strength examinations will be performed.

Jan 2011 - Jul 2011
7 months
Nordenham, Germany
On-site

Aircraft Mechanic, Manufacturing Engineering

Premium AEROTEC

Airbus A380 structural assembly

Summary

Hi, I'm Sven – founder of BI Solutions Hamburg. Since 2021, I have been helping companies build efficient data pipelines and robust data warehouses. My goal is to enable data-driven decisions with clean, structured, and easily accessible data.

Skills

  • Data Warehousing
  • Data Engineering
  • Data Orchestration
  • ETL / ELT Pipelines

Frameworks / Platforms

  • dbt
  • Apache Airflow, Dagster
  • Snowflake, Redshift, Bigquery
  • Palantir Foundry
  • Docker, git

Programming

  • SQL
  • Python

Languages

German
Native
English
Advanced

Education

Oct 2016 - Jun 2017

Hamburg University of Applied Sciences

M.Sc. · Aeronautical Engineering · Hamburg, Germany

Oct 2012 - Jun 2016

Hamburg University of Applied Sciences

B.Eng. · Aeronautical Engineering · Hamburg, Germany

Certifications & licenses

Google Cloud Professional Data Engineer

Google Cloud

Professional Scrum Master (PSM 1)

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