Data & Analytics Engineer | PowerBI | Modern Data Stack | E-Commerce
Aktualisiert am 28.05.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.06.2024
Verfügbar zu: 100%
davon vor Ort: 100%
PowerBI
Google Big Query
dbt
German
English

Einsatzorte

Einsatzorte

München (+200km)
Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

1 Jahr 1 Monat
2022-05 - 2023-05

Extension of the existing data warehouse models for reporting

Analytics Engineer
Analytics Engineer
  • Creating high dynamic reports in Power BI, enabling end user to provide dynamic analysis on various measures & dimensions within the same reports
  • Design and realization of an extensive eCommerce & Tracking Reporting
  • Extension of the existing data warehouse models for reporting
  • Review and extension of the central Power BI concept
  • Introducing Git Integration for Power BI development
Looker Big Query Data Virtuality
International Pharmaceuticals & Cosmetics Company
Bielefeld
1 Jahr 1 Monat
2022-05 - 2023-05

Structuring of internal BI processes

Teamlead BI
Teamlead BI
  • Structuring of internal BI processes
  • Design of a new integrated reporting structure for optimized data analysis (Looker)
  • Education and training of the Analytics department, through weekly training sessions
  • Planning of a modern BI cloud architecture, to optimize existing development processes
  • Enlargement of the BI team and active recruiting
Looker Big Query Data Virtuality
Brand platform for pet food
Munich
2 Jahre
2021-06 - 2023-05

BI Strategy & Power BI Rollout

BI Consultant
BI Consultant
The customer's goal was to replace the existing Qlik reporting with Power BI and to create a modern BI landscape.
  • Requirements analysis of the existing system and data landscape, consisting of Qlik Sense and MySQL
  • Creation of the architecture concept for the new modern BI stack in Azure, consisting of Databricks, dbt & PowerBI
  • Creation of data models and ELT pipelines in dbt
  • Support the implementation of PowerBI, especially in the area of data modeling, permissions and complex DAX implementations
  • Project management
Power BI Databricks dbt Azure DevOps
Franchise Gastronomy
Munich
1 Jahr 2 Monate
2021-03 - 2022-04

Design & Development of a modern BI landscape

Head of Data Intelligence
Head of Data Intelligence
  • Design & Development of a modern BI landscape (Google BigQuery & dbt)
  • Analysis of the existing data landscape and business logics
  • BI-Tool evaluation for the internal & external Reporting (Looker, Sisense, PowerBI)
  • Development of a company-wide reporting and definition of key figures with stakeholder
  • Development of several Dashboards in PowerBI
  • Ad hoc Reporting & Analysis for Stakeholder
Power BI Big Query dbt Hevo data MySql
E-Procurement Platform
Munich
1 Jahr 8 Monate
2019-07 - 2021-02

Management & coordination of external service providers

Head of Data & Business Intelligence
Head of Data & Business Intelligence
  • Rollout of Power BI as main reporting tool, planing and realization of dashboards, in coordination with stakeholder
  • Creation of automated reports and analysis applications as well as ad hoc Reports (SQL, Excel, Knime, Python)
  • Management & coordination of external service providers
  • Product Owner - Master data & data integration platform development of data-pipelines (SQL, Python, KNIME)
  • Ad hoc Reporting & Analysis for Stakeholder
Power BI Knime S3 Athena Glue MySql
eCommerce Start-up for Grocery
Munich
1 Jahr 5 Monate
2018-01 - 2019-05

Design of a generic data model for vertical and horizontal scaling

Solution Architect
Solution Architect
The goal of this project was the implementation of an automated predictive framework (based on R) into the existing group reporting system, based on SAP HANA & SAP BW on HANA
  • Creation of the architecture concept for the integration into the Enterprise Data Warehouse (SAP BW)
  • Identification of appropriate internal and external (e.g. market data) data sources as well as their preparation and provision
  • Design of a generic data model for vertical and horizontal scaling
  • Successful implementation and realization of the concept as well as continuous enhancement (SQL / SQLScript, ABAP)
  • Design of loading processes and control as well as complex parameterization logics
SAP HANA native SAP BW on HANA SAP SDA SQLScript
International chemical and pharmaceutical company
Leverkusen
3 Monate
2017-06 - 2017-08

Build a prototype for processing and analyzing

Big Data Developer
Big Data Developer
The goal of the project was to build a prototype for processing and analyzing complex furniture configuration data
  • Technical design and conceptualization of the prototype
  • Analysis and provision of required master data
  • Implementation and development of the prototype in Hadoop
  • Creation of a Big Data governance concept
  • Definition of relevant metrics
Hadoop hdfs Apache Pig Apache Hive
International furnishing group
Sweden
2 Monate
2017-05 - 2017-06

Various modeling activities on the graph data model

Graph Developer
Graph Developer
The goal of the project was to develop a first prototype to demonstrate possible solutions for representing and simplifying complex product configuration dependencies
  • Administration of the neo4j server
  • Various modeling activities on the graph data model
Azure neo4j
International furnishing group
Sweden
1 Jahr 3 Monate
2015-10 - 2016-12

Implementation of an Enterprise DWH, based on SAP HANA native

SAP HANA Consultant
SAP HANA Consultant
The goal of the project was the implementation of an Enterprise DWH, based on SAP HANA native
  • Design authority for platform security; creation of the security design concept
  • Implemented an automated user and role management system in SAP HANA (SQL / SQLScript) based on MS Active Directory 
  • designed and builded the data model of the integrated metadata management system of all platform components (SAP HANA, SAP BO Data Service, SAP PowerDesigner, TIBCO Spotfire)
  • Design and modeling of the virtual data model (HANA Native Modeling, SQLScript)
  • Technical lead of 5 developers for the HANA backend development
SAP HANA native SAP PowerDesigner
Petroleum company
Netherlands
4 Monate
2015-01 - 2015-04

Design and implementation of a BI platform

SAP HANA Consultant
SAP HANA Consultant
Design and implementation of a BI platform based on SAP HANA / BW on HANA
  • Creation of integration concepts of different source systems
  • Design and development of data models
  • Integration of various report requirements with SAP BEx, Business Objects and MS Power BI
SAP HANA native SDA SAP BW on HANA SAP BO
international brewery
Netherlands

Kompetenzen

Kompetenzen

Top-Skills

PowerBI Google Big Query dbt

Produkte / Standards / Erfahrungen / Methoden

About Me:
I'm a Data & Analytics Engineer with 9+ years of experience in designing and implementing modern BI systems, primary utilizing Power BI and GCP/Big

Query. I?ve specialized in analytics engineering, providing business with insightful data and visualisations, to improve data-driven decision making.


Expertise:

  • Data Analysis & Visualisation
  • BI Architecture
  • Data Modelling
  • Leadership


Technology:

  • Power BI
  • Looker
  • GCP (Big Query, Functions)
  • AWS (S3, Athena, Lambda)
  • Databricks
  • dbt
  • KNIME

Programmiersprachen

SQL
DAX
Python

Einsatzorte

Einsatzorte

München (+200km)
Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

1 Jahr 1 Monat
2022-05 - 2023-05

Extension of the existing data warehouse models for reporting

Analytics Engineer
Analytics Engineer
  • Creating high dynamic reports in Power BI, enabling end user to provide dynamic analysis on various measures & dimensions within the same reports
  • Design and realization of an extensive eCommerce & Tracking Reporting
  • Extension of the existing data warehouse models for reporting
  • Review and extension of the central Power BI concept
  • Introducing Git Integration for Power BI development
Looker Big Query Data Virtuality
International Pharmaceuticals & Cosmetics Company
Bielefeld
1 Jahr 1 Monat
2022-05 - 2023-05

Structuring of internal BI processes

Teamlead BI
Teamlead BI
  • Structuring of internal BI processes
  • Design of a new integrated reporting structure for optimized data analysis (Looker)
  • Education and training of the Analytics department, through weekly training sessions
  • Planning of a modern BI cloud architecture, to optimize existing development processes
  • Enlargement of the BI team and active recruiting
Looker Big Query Data Virtuality
Brand platform for pet food
Munich
2 Jahre
2021-06 - 2023-05

BI Strategy & Power BI Rollout

BI Consultant
BI Consultant
The customer's goal was to replace the existing Qlik reporting with Power BI and to create a modern BI landscape.
  • Requirements analysis of the existing system and data landscape, consisting of Qlik Sense and MySQL
  • Creation of the architecture concept for the new modern BI stack in Azure, consisting of Databricks, dbt & PowerBI
  • Creation of data models and ELT pipelines in dbt
  • Support the implementation of PowerBI, especially in the area of data modeling, permissions and complex DAX implementations
  • Project management
Power BI Databricks dbt Azure DevOps
Franchise Gastronomy
Munich
1 Jahr 2 Monate
2021-03 - 2022-04

Design & Development of a modern BI landscape

Head of Data Intelligence
Head of Data Intelligence
  • Design & Development of a modern BI landscape (Google BigQuery & dbt)
  • Analysis of the existing data landscape and business logics
  • BI-Tool evaluation for the internal & external Reporting (Looker, Sisense, PowerBI)
  • Development of a company-wide reporting and definition of key figures with stakeholder
  • Development of several Dashboards in PowerBI
  • Ad hoc Reporting & Analysis for Stakeholder
Power BI Big Query dbt Hevo data MySql
E-Procurement Platform
Munich
1 Jahr 8 Monate
2019-07 - 2021-02

Management & coordination of external service providers

Head of Data & Business Intelligence
Head of Data & Business Intelligence
  • Rollout of Power BI as main reporting tool, planing and realization of dashboards, in coordination with stakeholder
  • Creation of automated reports and analysis applications as well as ad hoc Reports (SQL, Excel, Knime, Python)
  • Management & coordination of external service providers
  • Product Owner - Master data & data integration platform development of data-pipelines (SQL, Python, KNIME)
  • Ad hoc Reporting & Analysis for Stakeholder
Power BI Knime S3 Athena Glue MySql
eCommerce Start-up for Grocery
Munich
1 Jahr 5 Monate
2018-01 - 2019-05

Design of a generic data model for vertical and horizontal scaling

Solution Architect
Solution Architect
The goal of this project was the implementation of an automated predictive framework (based on R) into the existing group reporting system, based on SAP HANA & SAP BW on HANA
  • Creation of the architecture concept for the integration into the Enterprise Data Warehouse (SAP BW)
  • Identification of appropriate internal and external (e.g. market data) data sources as well as their preparation and provision
  • Design of a generic data model for vertical and horizontal scaling
  • Successful implementation and realization of the concept as well as continuous enhancement (SQL / SQLScript, ABAP)
  • Design of loading processes and control as well as complex parameterization logics
SAP HANA native SAP BW on HANA SAP SDA SQLScript
International chemical and pharmaceutical company
Leverkusen
3 Monate
2017-06 - 2017-08

Build a prototype for processing and analyzing

Big Data Developer
Big Data Developer
The goal of the project was to build a prototype for processing and analyzing complex furniture configuration data
  • Technical design and conceptualization of the prototype
  • Analysis and provision of required master data
  • Implementation and development of the prototype in Hadoop
  • Creation of a Big Data governance concept
  • Definition of relevant metrics
Hadoop hdfs Apache Pig Apache Hive
International furnishing group
Sweden
2 Monate
2017-05 - 2017-06

Various modeling activities on the graph data model

Graph Developer
Graph Developer
The goal of the project was to develop a first prototype to demonstrate possible solutions for representing and simplifying complex product configuration dependencies
  • Administration of the neo4j server
  • Various modeling activities on the graph data model
Azure neo4j
International furnishing group
Sweden
1 Jahr 3 Monate
2015-10 - 2016-12

Implementation of an Enterprise DWH, based on SAP HANA native

SAP HANA Consultant
SAP HANA Consultant
The goal of the project was the implementation of an Enterprise DWH, based on SAP HANA native
  • Design authority for platform security; creation of the security design concept
  • Implemented an automated user and role management system in SAP HANA (SQL / SQLScript) based on MS Active Directory 
  • designed and builded the data model of the integrated metadata management system of all platform components (SAP HANA, SAP BO Data Service, SAP PowerDesigner, TIBCO Spotfire)
  • Design and modeling of the virtual data model (HANA Native Modeling, SQLScript)
  • Technical lead of 5 developers for the HANA backend development
SAP HANA native SAP PowerDesigner
Petroleum company
Netherlands
4 Monate
2015-01 - 2015-04

Design and implementation of a BI platform

SAP HANA Consultant
SAP HANA Consultant
Design and implementation of a BI platform based on SAP HANA / BW on HANA
  • Creation of integration concepts of different source systems
  • Design and development of data models
  • Integration of various report requirements with SAP BEx, Business Objects and MS Power BI
SAP HANA native SDA SAP BW on HANA SAP BO
international brewery
Netherlands

Kompetenzen

Kompetenzen

Top-Skills

PowerBI Google Big Query dbt

Produkte / Standards / Erfahrungen / Methoden

About Me:
I'm a Data & Analytics Engineer with 9+ years of experience in designing and implementing modern BI systems, primary utilizing Power BI and GCP/Big

Query. I?ve specialized in analytics engineering, providing business with insightful data and visualisations, to improve data-driven decision making.


Expertise:

  • Data Analysis & Visualisation
  • BI Architecture
  • Data Modelling
  • Leadership


Technology:

  • Power BI
  • Looker
  • GCP (Big Query, Functions)
  • AWS (S3, Athena, Lambda)
  • Databricks
  • dbt
  • KNIME

Programmiersprachen

SQL
DAX
Python

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.