Data engineer with experience in data warehouses, business intelligence. Experience with KNIME, Java, Power BI, SQL
Aktualisiert am 18.09.2024
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 18.09.2024
Verfügbar zu: 50%
davon vor Ort: 0%
KNIME
SQL
MS Power BI
Java
ETL
Python
VBA
Docker
MS Excel
German
Mother tongue
English
Professional proficiency
Spanish
Intermediate proficiency
French
Intermediate proficiency
Norwegian
Intermediate proficiency

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
nicht möglich

Projekte

Projekte

1 year 7 months
2023-03 - now

Creation of Power BI Dashboards

Data Engineer
Data Engineer
  • Internal consulting to empower the decision-making process across different business areas and departments
  • Creation of Power BI Dashboards for different stakeholders
  • Coordination of data and KPI requirements across different levels of the organisation
  • Creation of ETL workflows and data processing with KNIME
  • Set-up and operation of PostgreSQL database
  • Set-up and operation of a webapp for productionising ETL workflows
  • Creation of REST-API pages for Microsoft Dynamics 365 Business Central (AL Language)
Wascosa AG
Lucerne, Switzerland
3 years 2 months
2020-01 - 2023-02

Implementation of mathematical model

Senior Consultant
Senior Consultant
  • Conceptual development, data modelling and implementation of mathematical models to predict the condition of railway assets as a function of CAPEX/OPEX using VBA and SQL
  • Organising and leading workshops with subject matter experts to discuss model parameters and validate simulation results
  • Composing specifications for a software development team, sprint planning in Agile framework
  • Data analysis for network condition reports with different European railway infrastructure managers using Excel, Power Queries, and SQL
  • Implementation of prototypes for a life-cycle-cost optimization tool in Microsoft VBA
  • Creation of ETL workflows and data processing with KNIME
AFRY Switzerland AG
Basel, Switzerland
1 year 4 months
2018-09 - 2019-12

Writing and composing technical documentation

Engineering Consultant
Engineering Consultant
  • Writing and composing technical documentation (Manufacturing Process Information) to prove compliance with the EU Medical Device Regulation (MDR)
  • Coding Microsoft VBA scripts to extract manufacturing data from SAP R/3
  • Document control in Agile PLM and Windchill
  • Feasibility study on automated optical control of Rapid Sorb Resorbable implants
  • Involvement in CAPA (Implementation of Actions)
Johnson & Johnson
Basel, Switzerland
5 months
2017-01 - 2017-05

Research into heat transport within machine tools

Research Assistant
Research Assistant
  • Fluid dynamics simulations using ANSYS CFX
Institute for Machine Tools and Manufacturing (IWF), ETH Zürich
Zürich, Switzerland
4 months
2016-03 - 2016-06

Product Development

Intern
Intern
  • Basic & Detail Engineering
  • Structural mechanics with Ansys Mechanical
  • Procurement of parts, coordination with suppliers
  • Communication with customers
  • Support and calculations for quotes
Zühlke Engineering AG
Schlieren, Switzerland
4 months
2015-09 - 2015-12

course Analysis III

Teaching assistant
Teaching assistant
  • Teaching exercise classes for students
  • Correction of assignments
Mathematics Department, ETH Zürich
Zürich, Switzerland
2 months
2013-05 - 2013-06

Workshop

intern
intern
  • Metal processing: manufacturing parts according to specification
Bruno Dabelstein Stahl- und Maschinenbau GmbH
Hamburg, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

2 years
2016-09 - 2018-08

Process Engineering

M.Sc., ETH Zürich, Zürich, Switzerland
M.Sc.
ETH Zürich, Zürich, Switzerland
4 years 5 months
2012-09 - 2017-01

Mechanical Engineering

B.Sc., ETH Zürich, Zürich, Switzerland
B.Sc.
ETH Zürich, Zürich, Switzerland
1 year 5 months
2011-02 - 2012-06

School Education

International Baccalaureate Diploma, Malvern College, Malvern, UK
International Baccalaureate Diploma
Malvern College, Malvern, UK

Kompetenzen

Kompetenzen

Top-Skills

KNIME SQL MS Power BI Java ETL Python VBA Docker MS Excel

Produkte / Standards / Erfahrungen / Methoden

KNIME
Microsoft VBA
Office 365
Agile PLM
ANSYS CFX
C++
Java
KNIME Analytics
Python
Siemens NX
SolidWorks
UNIX/Bash shell
ANSYS Mechanical
Cron
Git
Matlab
OpenFOAM
Qt
SAP R/3

International Experience

2016

  • 12-weeks-travel throughout South America

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
nicht möglich

Projekte

Projekte

1 year 7 months
2023-03 - now

Creation of Power BI Dashboards

Data Engineer
Data Engineer
  • Internal consulting to empower the decision-making process across different business areas and departments
  • Creation of Power BI Dashboards for different stakeholders
  • Coordination of data and KPI requirements across different levels of the organisation
  • Creation of ETL workflows and data processing with KNIME
  • Set-up and operation of PostgreSQL database
  • Set-up and operation of a webapp for productionising ETL workflows
  • Creation of REST-API pages for Microsoft Dynamics 365 Business Central (AL Language)
Wascosa AG
Lucerne, Switzerland
3 years 2 months
2020-01 - 2023-02

Implementation of mathematical model

Senior Consultant
Senior Consultant
  • Conceptual development, data modelling and implementation of mathematical models to predict the condition of railway assets as a function of CAPEX/OPEX using VBA and SQL
  • Organising and leading workshops with subject matter experts to discuss model parameters and validate simulation results
  • Composing specifications for a software development team, sprint planning in Agile framework
  • Data analysis for network condition reports with different European railway infrastructure managers using Excel, Power Queries, and SQL
  • Implementation of prototypes for a life-cycle-cost optimization tool in Microsoft VBA
  • Creation of ETL workflows and data processing with KNIME
AFRY Switzerland AG
Basel, Switzerland
1 year 4 months
2018-09 - 2019-12

Writing and composing technical documentation

Engineering Consultant
Engineering Consultant
  • Writing and composing technical documentation (Manufacturing Process Information) to prove compliance with the EU Medical Device Regulation (MDR)
  • Coding Microsoft VBA scripts to extract manufacturing data from SAP R/3
  • Document control in Agile PLM and Windchill
  • Feasibility study on automated optical control of Rapid Sorb Resorbable implants
  • Involvement in CAPA (Implementation of Actions)
Johnson & Johnson
Basel, Switzerland
5 months
2017-01 - 2017-05

Research into heat transport within machine tools

Research Assistant
Research Assistant
  • Fluid dynamics simulations using ANSYS CFX
Institute for Machine Tools and Manufacturing (IWF), ETH Zürich
Zürich, Switzerland
4 months
2016-03 - 2016-06

Product Development

Intern
Intern
  • Basic & Detail Engineering
  • Structural mechanics with Ansys Mechanical
  • Procurement of parts, coordination with suppliers
  • Communication with customers
  • Support and calculations for quotes
Zühlke Engineering AG
Schlieren, Switzerland
4 months
2015-09 - 2015-12

course Analysis III

Teaching assistant
Teaching assistant
  • Teaching exercise classes for students
  • Correction of assignments
Mathematics Department, ETH Zürich
Zürich, Switzerland
2 months
2013-05 - 2013-06

Workshop

intern
intern
  • Metal processing: manufacturing parts according to specification
Bruno Dabelstein Stahl- und Maschinenbau GmbH
Hamburg, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

2 years
2016-09 - 2018-08

Process Engineering

M.Sc., ETH Zürich, Zürich, Switzerland
M.Sc.
ETH Zürich, Zürich, Switzerland
4 years 5 months
2012-09 - 2017-01

Mechanical Engineering

B.Sc., ETH Zürich, Zürich, Switzerland
B.Sc.
ETH Zürich, Zürich, Switzerland
1 year 5 months
2011-02 - 2012-06

School Education

International Baccalaureate Diploma, Malvern College, Malvern, UK
International Baccalaureate Diploma
Malvern College, Malvern, UK

Kompetenzen

Kompetenzen

Top-Skills

KNIME SQL MS Power BI Java ETL Python VBA Docker MS Excel

Produkte / Standards / Erfahrungen / Methoden

KNIME
Microsoft VBA
Office 365
Agile PLM
ANSYS CFX
C++
Java
KNIME Analytics
Python
Siemens NX
SolidWorks
UNIX/Bash shell
ANSYS Mechanical
Cron
Git
Matlab
OpenFOAM
Qt
SAP R/3

International Experience

2016

  • 12-weeks-travel throughout South America

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.