Data specialist who is equipped with a strong business and analytical mindset
Aktualisiert am 25.09.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.10.2024
Verfügbar zu: 80%
davon vor Ort: 50%
Data Engineer
Datawarehouse
ETL
Big Data Analytics
PostgreSQL
MS SQL Datenbanken
Metabase
BigQuery
dbt
Airflow
Snowflake
Google Cloud
Oracle
CloverDX
Data Modeling
German
Muttersprache
English
Verhandlungssicher
Spanish
Verhandlungssicher
Russian
Grundkenntnisse

Einsatzorte

Einsatzorte

Cologne (+20km) Cochem (+75km) Bonn (+75km) Soest (+50km)
möglich

Projekte

Projekte

2 months
2024-08 - 2024-09

Deployment of customer profile script

Data Engineer jinja-sql ETL Data Modeling ...
Data Engineer
  • Optimization of a complex data model for creating a comprehensive customer profile through modularization, reducing runtime by 20%.
  • Implementation of best practices for dbt models to sustainably improve the scalability and performance of data pipelines.
Snowflake dbt Prefect
jinja-sql ETL Data Modeling Data Engineer Datawarehouse
Douglas Service GmbH
Cologne
10 months
2023-11 - 2024-08

Development of ETL-Pipelines for crucial accounting project

Data Engineer SQL PL/SQL Python ...
Data Engineer
  • Increased efficiency and robustness of data loading by 30% through the strategic enhancement of the data warehouse, including the integration of MS SQL and Dynamics API.
  • Performed data preparation (cleaning and transformation) and optimization of SQL queries.
  • Strong collaboration with business stakeholders.
CloverDX Oracle MS SQL Datenbanken Atlassian JIRA Atlassian Confluence Agile Softwareentwicklung
SQL PL/SQL Python CTL ETL Data Modeling
REMONDIS IT Services GmbH & Co. KG
Cologne
1 month
2023-07 - 2023-07

Analysis of critical business process

Data Analyst Dashboard Analysefähigkeit
Data Analyst
  • Analyzed and documented the sorting process of Spreewald cucumbers, optimizing process workflows within the data model.
  • Improved Power BI dashboards, leading to significant material savings.
MS Power BI
Dashboard Analysefähigkeit
Spreewaldkonserven GmbH
Golßen
1 year 2 months
2022-04 - 2023-05

Creating reports & dashboards

Data Consultant MS SQL Server Python Data Modeling ...
Data Consultant

  • Creating reports & dashboards for various departments in order to provide data insights.
  • Creating a supply and demand analysis in order to steer the future business.
  • Consulting regarding the implementation of a data warehouse and all necessary processes.

SQL Server Python Metabase Supermetrics Jira / Confluence Google Sheets Pipedrive Planhat
MS SQL Server Python Data Modeling Datawarehouse Reporting Dashboard
OpenUp
Cologne
9 months
2021-07 - 2022-03

Building new data warehouse

Data Engineer PostgreSQL Data Modeling Datawarehouse ...
Data Engineer

  • Maintaining, building and scheduling various ELT jobs for existing and new data pipelines.
  • Ensuring a stable data set up regarding pipelines, transformation and visualisation

Airflow / Cloud Composer Google Cloud Platform (BigQuery Cloud Storage Cloud Functions Composer) Python PostgreSQL Metabase Looker Google Colab GitHub DBT
PostgreSQL Data Modeling Datawarehouse ETL Dashboard Reporting
Urban Sports GmbH
Cologne
2 years 6 months
2019-01 - 2021-06

Increase profitability

Business Intelligence Analyst Reporting Dashboard PostgreSQL ...
Business Intelligence Analyst

  • Creating reports and dashboards in order to enable team leads to steer the Customer Success team.
  • Quantification and evaluation of new business models.
  • Creating analysis to identify the Ideal Customer Profile (ICP)

Metabase Google Docs Jira Confluence GitHub Pipedrive
Reporting Dashboard PostgreSQL Python
Urban Sports GmbH
Berlin
11 months
2018-02 - 2018-12

Increase of Brand awareness and Collaboration

Senior Corporate Account Manager
Senior Corporate Account Manager
  • Collaborating closely with key accounts like Wayfair, Coca Cola & Forto in order to increase activation rates while focusing on high ROIs.
  • Representing Urban Sports Club onsite at various events like Health Days and trade fairs with the aim of increasing brand awareness
Urban Sports
10 months
2017-02 - 2017-11

Creating Leads

Marketing Manager
Marketing Manager
  • Creating content and generating leads via different channels for the purpose of generating more business
  • Controlling of various KPIs regarding profitability and quality
Edenred
1 year 6 months
2015-08 - 2017-01

Managing of multiple Campaigns

Junior Account Amanger Display Marketing & RTB
Junior Account Amanger Display Marketing & RTB
  • Managing multiple RTB campaigns (CPM/CPC) from companies like Babbel, Lidl and Parship within the Ströer network.
  • Analysing of KPIs and developing strategies in order to achieve target performance.
Ströer Digital Media
Berlin

Aus- und Weiterbildung

Aus- und Weiterbildung

4 years
2009-09 - 2013-08

International Business

Bachelor of Arts, FH Dortmund
Bachelor of Arts
FH Dortmund
  • Finance & Controlling internship at Lufthansa Cargo in the Americas headquarter (Atlanta)
  • 2 semesters abroad in Guangzhou (China)
  • Graduated with 1,5

Position

Position

In my most recent project, I was the first data specialist within the organization. My role included the generation of data-driven insights across a spectrum of departments including Marketing, Sales, Finance and Operations.

I engineered a diverse set of dashboards and reports that have become crucial and widely-used tools for steering the business. These important tools facilitate data-driven decision-making and streamlining the employee acquisition process.

Furthermore, I enjoyed the process of empowering my colleagues, particularly those who might not be as well-versed in data analysis. I guided employees in workshops to increase their confidence and acumen in harnessing data to make informed decisions.

In short, I help companies to get on top of their data and derive actionable insights in order to make smarter decisions based on data.

Kompetenzen

Kompetenzen

Top-Skills

Data Engineer Datawarehouse ETL Big Data Analytics PostgreSQL MS SQL Datenbanken Metabase BigQuery dbt Airflow Snowflake Google Cloud Oracle CloverDX Data Modeling

Schwerpunkte

Communication
Experte
Analytical Mindset
Experte
Business knowledge
Experte
Reliability
Experte
Problem solving
Experte

Produkte / Standards / Erfahrungen / Methoden

Data Modeling
Fortgeschritten
ETL Processes
Fortgeschritten
Data Visualization
Experte
Stakeholder Management
Experte

Profile:

I am a highly solution-oriented and communicative person with a strong business and analytical mindset combined with technical know-how. 

This allows me to collaborate with people at all levels (management and developers) in order to achieve the maximum value for a company.

Programmiersprachen

Python
Fortgeschritten
SQL
Experte

Datenbanken

Postgres
Fortgeschritten
SQL Server
Fortgeschritten
Big Query
Fortgeschritten
Snowflake
Fortgeschritten
Oracle
Fortgeschritten

Datenkommunikation

KPI definition
Experte
Data Training
Experte
Dashboard
Experte
Reporting
Experte

Branchen

Branchen

  • Health & wellness
  • ecommerce
  • Food industry

Einsatzorte

Einsatzorte

Cologne (+20km) Cochem (+75km) Bonn (+75km) Soest (+50km)
möglich

Projekte

Projekte

2 months
2024-08 - 2024-09

Deployment of customer profile script

Data Engineer jinja-sql ETL Data Modeling ...
Data Engineer
  • Optimization of a complex data model for creating a comprehensive customer profile through modularization, reducing runtime by 20%.
  • Implementation of best practices for dbt models to sustainably improve the scalability and performance of data pipelines.
Snowflake dbt Prefect
jinja-sql ETL Data Modeling Data Engineer Datawarehouse
Douglas Service GmbH
Cologne
10 months
2023-11 - 2024-08

Development of ETL-Pipelines for crucial accounting project

Data Engineer SQL PL/SQL Python ...
Data Engineer
  • Increased efficiency and robustness of data loading by 30% through the strategic enhancement of the data warehouse, including the integration of MS SQL and Dynamics API.
  • Performed data preparation (cleaning and transformation) and optimization of SQL queries.
  • Strong collaboration with business stakeholders.
CloverDX Oracle MS SQL Datenbanken Atlassian JIRA Atlassian Confluence Agile Softwareentwicklung
SQL PL/SQL Python CTL ETL Data Modeling
REMONDIS IT Services GmbH & Co. KG
Cologne
1 month
2023-07 - 2023-07

Analysis of critical business process

Data Analyst Dashboard Analysefähigkeit
Data Analyst
  • Analyzed and documented the sorting process of Spreewald cucumbers, optimizing process workflows within the data model.
  • Improved Power BI dashboards, leading to significant material savings.
MS Power BI
Dashboard Analysefähigkeit
Spreewaldkonserven GmbH
Golßen
1 year 2 months
2022-04 - 2023-05

Creating reports & dashboards

Data Consultant MS SQL Server Python Data Modeling ...
Data Consultant

  • Creating reports & dashboards for various departments in order to provide data insights.
  • Creating a supply and demand analysis in order to steer the future business.
  • Consulting regarding the implementation of a data warehouse and all necessary processes.

SQL Server Python Metabase Supermetrics Jira / Confluence Google Sheets Pipedrive Planhat
MS SQL Server Python Data Modeling Datawarehouse Reporting Dashboard
OpenUp
Cologne
9 months
2021-07 - 2022-03

Building new data warehouse

Data Engineer PostgreSQL Data Modeling Datawarehouse ...
Data Engineer

  • Maintaining, building and scheduling various ELT jobs for existing and new data pipelines.
  • Ensuring a stable data set up regarding pipelines, transformation and visualisation

Airflow / Cloud Composer Google Cloud Platform (BigQuery Cloud Storage Cloud Functions Composer) Python PostgreSQL Metabase Looker Google Colab GitHub DBT
PostgreSQL Data Modeling Datawarehouse ETL Dashboard Reporting
Urban Sports GmbH
Cologne
2 years 6 months
2019-01 - 2021-06

Increase profitability

Business Intelligence Analyst Reporting Dashboard PostgreSQL ...
Business Intelligence Analyst

  • Creating reports and dashboards in order to enable team leads to steer the Customer Success team.
  • Quantification and evaluation of new business models.
  • Creating analysis to identify the Ideal Customer Profile (ICP)

Metabase Google Docs Jira Confluence GitHub Pipedrive
Reporting Dashboard PostgreSQL Python
Urban Sports GmbH
Berlin
11 months
2018-02 - 2018-12

Increase of Brand awareness and Collaboration

Senior Corporate Account Manager
Senior Corporate Account Manager
  • Collaborating closely with key accounts like Wayfair, Coca Cola & Forto in order to increase activation rates while focusing on high ROIs.
  • Representing Urban Sports Club onsite at various events like Health Days and trade fairs with the aim of increasing brand awareness
Urban Sports
10 months
2017-02 - 2017-11

Creating Leads

Marketing Manager
Marketing Manager
  • Creating content and generating leads via different channels for the purpose of generating more business
  • Controlling of various KPIs regarding profitability and quality
Edenred
1 year 6 months
2015-08 - 2017-01

Managing of multiple Campaigns

Junior Account Amanger Display Marketing & RTB
Junior Account Amanger Display Marketing & RTB
  • Managing multiple RTB campaigns (CPM/CPC) from companies like Babbel, Lidl and Parship within the Ströer network.
  • Analysing of KPIs and developing strategies in order to achieve target performance.
Ströer Digital Media
Berlin

Aus- und Weiterbildung

Aus- und Weiterbildung

4 years
2009-09 - 2013-08

International Business

Bachelor of Arts, FH Dortmund
Bachelor of Arts
FH Dortmund
  • Finance & Controlling internship at Lufthansa Cargo in the Americas headquarter (Atlanta)
  • 2 semesters abroad in Guangzhou (China)
  • Graduated with 1,5

Position

Position

In my most recent project, I was the first data specialist within the organization. My role included the generation of data-driven insights across a spectrum of departments including Marketing, Sales, Finance and Operations.

I engineered a diverse set of dashboards and reports that have become crucial and widely-used tools for steering the business. These important tools facilitate data-driven decision-making and streamlining the employee acquisition process.

Furthermore, I enjoyed the process of empowering my colleagues, particularly those who might not be as well-versed in data analysis. I guided employees in workshops to increase their confidence and acumen in harnessing data to make informed decisions.

In short, I help companies to get on top of their data and derive actionable insights in order to make smarter decisions based on data.

Kompetenzen

Kompetenzen

Top-Skills

Data Engineer Datawarehouse ETL Big Data Analytics PostgreSQL MS SQL Datenbanken Metabase BigQuery dbt Airflow Snowflake Google Cloud Oracle CloverDX Data Modeling

Schwerpunkte

Communication
Experte
Analytical Mindset
Experte
Business knowledge
Experte
Reliability
Experte
Problem solving
Experte

Produkte / Standards / Erfahrungen / Methoden

Data Modeling
Fortgeschritten
ETL Processes
Fortgeschritten
Data Visualization
Experte
Stakeholder Management
Experte

Profile:

I am a highly solution-oriented and communicative person with a strong business and analytical mindset combined with technical know-how. 

This allows me to collaborate with people at all levels (management and developers) in order to achieve the maximum value for a company.

Programmiersprachen

Python
Fortgeschritten
SQL
Experte

Datenbanken

Postgres
Fortgeschritten
SQL Server
Fortgeschritten
Big Query
Fortgeschritten
Snowflake
Fortgeschritten
Oracle
Fortgeschritten

Datenkommunikation

KPI definition
Experte
Data Training
Experte
Dashboard
Experte
Reporting
Experte

Branchen

Branchen

  • Health & wellness
  • ecommerce
  • Food industry

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.