Data specialist who is equipped with a strong business and analytical mindset
Aktualisiert am 10.10.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 10.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
Fluent
Spanish
Fluent
Russian
Fluent

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 eCommerce IT Consulting Confluence
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 CSB (ERP System)
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 CSB (ERP System)
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

  • Developed customized reports and dashboards that enabled a 25% increase in ROI for marketing expenditures by targeting effective channels.
  • Conducted supply and demand analysis to optimize psychologists' utilization.
  • Provided consulting on the implementation of a data warehouse

SQL Server Python Metabase Supermetrics Jira / Confluence Google Sheets Pipedrive Planhat
MS SQL Server Python Data Modeling Datawarehouse Reporting Dashboard
OpenUp
Cologne
2 months
2023-02 - 2023-03

Successfully developed and implemented scalable data pipelines

DATAENGINEER Python Google Cloud Platform Git ...
DATAENGINEER
  • Successfully developed and implemented scalable data pipelines for various API interfaces, improving data processing speed by 50% and significantly enhancing data quality.

Python Google Cloud Platform Git dlt Bigquery Software-Develeopment
ScaleVector GmbH
9 months
2021-07 - 2022-03

Building new data warehouse

Data Engineer PostgreSQL Data Modeling Datawarehouse ...
Data Engineer

  • Developed new data pipelines integrating data from various source systems (BigQuery, API interfaces, Postgres) for more efficient and robust data loading and provisioning to stakeholders.
  • Prepared data (cleaning and transformation) and optimized SQL queries in BigQuery, dbt, and PostgreSQL.
  • Served as the primary point of contact between stakeholders, ensuring clear communication and alignment of requirements and expectations.



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 Google Cloud Platform Python Airflow Metabase Jira Confluence Tableau Google Colab Git dbt agile SaaS Scrum
Urban Sports GmbH
Cologne
2 years 6 months
2019-01 - 2021-06

Increase profitability

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

  • Developed strategic dashboards and reports that enabled a 20% efficiency increase in the Customer Success and Sales teams through data-driven decision-making processes.
  • Quantified and evaluated new business models to enhance profitability.

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, University of Applied Sciences Dortmund
Bachelor of Arts
University of Applied Sciences 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

Highly solution-oriented and communicative individual with a strong understanding of business administration and technical expertise. Skilled at bridging the gap between managers and developers to maximize value for the 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 eCommerce IT Consulting Confluence
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 CSB (ERP System)
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 CSB (ERP System)
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

  • Developed customized reports and dashboards that enabled a 25% increase in ROI for marketing expenditures by targeting effective channels.
  • Conducted supply and demand analysis to optimize psychologists' utilization.
  • Provided consulting on the implementation of a data warehouse

SQL Server Python Metabase Supermetrics Jira / Confluence Google Sheets Pipedrive Planhat
MS SQL Server Python Data Modeling Datawarehouse Reporting Dashboard
OpenUp
Cologne
2 months
2023-02 - 2023-03

Successfully developed and implemented scalable data pipelines

DATAENGINEER Python Google Cloud Platform Git ...
DATAENGINEER
  • Successfully developed and implemented scalable data pipelines for various API interfaces, improving data processing speed by 50% and significantly enhancing data quality.

Python Google Cloud Platform Git dlt Bigquery Software-Develeopment
ScaleVector GmbH
9 months
2021-07 - 2022-03

Building new data warehouse

Data Engineer PostgreSQL Data Modeling Datawarehouse ...
Data Engineer

  • Developed new data pipelines integrating data from various source systems (BigQuery, API interfaces, Postgres) for more efficient and robust data loading and provisioning to stakeholders.
  • Prepared data (cleaning and transformation) and optimized SQL queries in BigQuery, dbt, and PostgreSQL.
  • Served as the primary point of contact between stakeholders, ensuring clear communication and alignment of requirements and expectations.



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 Google Cloud Platform Python Airflow Metabase Jira Confluence Tableau Google Colab Git dbt agile SaaS Scrum
Urban Sports GmbH
Cologne
2 years 6 months
2019-01 - 2021-06

Increase profitability

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

  • Developed strategic dashboards and reports that enabled a 20% efficiency increase in the Customer Success and Sales teams through data-driven decision-making processes.
  • Quantified and evaluated new business models to enhance profitability.

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, University of Applied Sciences Dortmund
Bachelor of Arts
University of Applied Sciences 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

Highly solution-oriented and communicative individual with a strong understanding of business administration and technical expertise. Skilled at bridging the gap between managers and developers to maximize value for the 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.