Data Analytics Engineer Haderslev, Denmark

Might be available

(Updated 2024-03-28)

Data Analytics Engineer

Haderslev, Denmark

Native Danish, English, German, Beginner Italian

  • 5+ years experience in open source, cloud based, fully managed data tools
  • dbt, BigQuery, GitHub, Looker, Airbyte, SQL, Metabase, etc.
  • 20 + years experience in international IT and data consulting

Skills (50)

Incident Management

PIPELINE

REQUIREMENTS GATHERING

USER ACCEPTANCE TESTING

Google Docs

Data Migration

DOCUMENTING

MS OFFICE

ETL

SAFETY MANAGEMENT

BUSINESS REQUIREMENTS

BLUEPRINT

MICROSOFT OFFICE

GCP

ENVIRONMENTAL MANAGEMENT

RISK ASSESSMENT

DATASETS

Google Cloud

EHS

DBT

BigQuery

Data Pipeline

Data Pipelines

Data Analysis

SQL

SPLUNK

DATA SERVICES

LOGISTICS

DIGITAL STRATEGY

Github

HELPDESK

Looker

Waste Management

Machine Learning

PUMPS

Environmental Services

USER ACCEPTANCE

PRICING

BPO

SHIPPING

IMDG

MARKETING ANALYSIS

ACCEPTANCE TESTING

FORECASTING

DATA SCIENCE

IN-Memory Data Grid

HANA

EDS

BUSINESS PROCESS OUTSOURCING

BRIDGES

Summary

I am a Data Analytics Engineer utilizing various tools, such as dbt, SQL, BigQuery, git, Airbyte, Looker
Studio, and more.

I like to build things. I believe combining data, IoT and AI will give organizations an opportunity to develop
new products, services, markets and new business processes.

I am also a strong believer in continuous learning. In 2022 I started my dbt journey and in 2019 I completed
the official Google Cloud 'Data and Machine Learning' path with issued credentials for the Data Analyst and
Data Science track.

I am a digital integrator, building bridges between technology, management and business. For more than 20
years with the combination of my personality and technical knowledge I have been part of transforming
business processes for companies around the globe - in retailing, manufacturing, shipping, oil & gas,
chemicals and pharmaceuticals.

I hold a MSc in Engineering (Production, Logistics & Management), a Business Degree in Environmental
Management and a NEBOSH diploma in Environmental Management.

I speak fluent Danish, German and English.

Professional Experience

Data Analytics Engineer
Coelacanth Company ApS

2022-10 - Present

The Modern Data Stack with dbt (Data Build Tool), BigQuery, SQL, GitHub, Airbyte. I use the the ressources dbt Learn, dbt - YouTube, Kahan Data Solutions, SQL BigQuery
Data Analytics Engineer
Coelacanth Company ApS

2023-10 - Present

Proof of concept (PoC) with Online Used Car Shop. I used the Faker Airbyte data, BigQuery, GitHub and dbt and created a report in Looker Studio. The demo of the PoC is published on YouTube https://youtu.be/2NFM5Hr6Mis
Cloud Engineer and Data Engineer
IKEA

2019-11 - 2022-12

Cloud Engineer and Data Engineer
IKEA

2019-11 - 2022-12

We were executing the digital strategy. We were building Google Cloud Platform (GCP) based services as the future technology foundation serving millions of IKEA customers with new shopping experiences around the world. More specifically I was working in an agile team creating data pipeline frameworks as a foundation to support teams in application development, data analysis and data science. We facilitated, supported and drove project execution and collaboration between the development teams and business domains to deliver solutions and business value. We were creating data pipeline architectures, components and initiatives to democratize data. We were exploring and suggesting various data pipeline technologies identifying opportunities for the business domains. We were documenting and communicating the data pipeline technologies including strengths and weaknesses.
Tools used: Dataflow, Cloud Functions, PubSub, Cloud Storage, Data Fusion, GitHub, Cloud Monitoring, Splunk, Jira, Confluence. IKEA, Sweden.

SAP EHS consultant
Project 20

2019-08 - 2019-10

I built a pilot in SAP S/4 HANA Dangerous Goods Management and this was presented to the customer in a workshop. The pilot and the associated business processes were the basis for the final solution. Customer: Henry Schein, Europe.
Data Analyst
Project 21

2019-01 - 2019-06

(Jan 2019-Jun 2019): Official Google Cloud Platform Training 'Data and Machine Learning ' path with issued credentials for the - Data Analyst track (https://www.coursera.org/specializations/from-data-to-insights-google-cloud-platform) - Data Science track.
(https://www.coursera.org/specializations/machine-learning-tensorflow-gcp).
I gained knowledge in the following Google Cloud Platform services used: BigQuery, BigQueryML, CloudAutoML, Cloud Data Prep, Cloud DataLab, Google Data Studio, Google Cloud IoT, Tensorflow.
Google QwikLabs hands-on projects as part of the training: Pub/Sub Lab, Using Cloud IoT Core, Creating a Cloud Storage bucket, Creating a DataFlow pipeline, Streaming IoT Data to Google Cloud Storage and BigQuery, DataPrep Lab, Analyzing IoT Data in Data Studio, ML APIs within Cloud DataLab, Creating repeatable dataset splits with BigQuery, Predicting visitor return purchases with BigQuery, Building a forecasting model in BigQuery, Creating new permanent tables, Ingesting and querying new datasets, Creating and querying partitioned tables, Troubleshooting and solving data join pitfalls, Practice unioning and joining datasets, Exploring a dataset in Google Data Studio, Deriving Insights from advanced SQL functions, Querying nested and repeated fields, Optimizing and troubleshooting Query performance, Rent-a-VM to process earthquake data, Analyzing data using Datalab and BigQuery, Invoking Machine Learning APIs
self-employed
SAP EH&S for Coelacanth Company

2010-01 - 2019-01

consultant
Project 19

2018-08 - 2019-01

We identified and analysed current processes with stakeholders, created a system design and business process descriptions. Based on this we wrote specifications for developments, configured and documented a pilot system in SAP S/4 HANA Dangerous Goods and SAP Transportation Management. Customer: HELM, Germany.
consultant
Project 18

2016-06 - 2017-03

This was a global full cycle project implementation for Dangerous Goods Management, GHS labeling, Chemical Sales block and also included data migration (ETL - extract transform load data). Customer: TetraPak, Sweden
consultant
Project 17

2014-08 - 2015-06

I implemented Global Label Management (GLM) for the factory in China and implemented the Article Information Sheets globally. I supported the HelpDesk for GLM globally, Work Place Instructions (WPI), Dangerous Goods Management and Chemical Management. Customer: Haldor Topsoe, Denmark
consultant
Project 16

2013-06 - 2014-02

We designed and implemented the Chemical Approval business process for the Corporate Quality Management department. This included data migration lead (ETL - extract transform load data) for Chemical Approval and Conformity Records. Customer: Lego, Denmark.
consultant
SAP EHS

2011-12 - 2014-01

We presented the standard solution and conducted fit gap workshops for SAP EH&S Waste Management, Hazardous Substance Management and Dangerous Goods Management. Customer: Vale, Brazil.
Project(s) 13: Consultant for Verisk Ariel 3E implementing the 'Ariel Data Management' (ADM) tool.
This included setting up report templates, regulatory rules, vendor MSDS management, phrases, handling and loading data.
project lead and consultant
Project 15

2012-03 - 2013-05

A full cycle project implementation of SAP EHSM Incident Management across 7 factories globally - streamlining processes into one global system management and reporting system. Customer: Nokia, Finland
website wireframing developer
Litehauz

2009-01 - 2011-01

In cooperation with customers and other stakeholders I was the manager and developer of a software prototype for Environmental Management system for the shipping industry. The prototype was based on the ISO 14000 standard.
SAP EH&S Consultant
Atos / Hewlett Packard in Qatar

2006-01 - 2008-01

Project 12: My role was SAP EHS consultant. This was a full cycle project for SAP EHS Incident Management, Risk Assessment, Hazardous Substance Management and Waste Management. The project approach chosen was not a 'big bang' waterfall method, but a implementation in waves thereby keeping the momentum in the project team but also with the customer. Customer: Qatar Petroleum, Qatar.
self-employed
HSE

2008-01 - 2008-01

I was the manager and developer of a HSE management system and associated business process outsourcing (BPO) for www.gehson.com, Qatar. We defined the HSE business processes, the outsourcing concept and created a business plan to pitch to customers and investors.
SAP EH&S Consultant
Coelacanth Company

2002-01 - 2005-01

for Coelacanth Company (self-employed) Project 11: Consultant for blueprint and high level presentation of Industrial Hygiene and Safety, Occupational Health, Hazardous Substance Management, Dangerous Goods Management and Waste Management. Customer: ICL, Israel. Tasks performed: blueprint and presentation.
Project(s) 10: Consultant for Ariel Research Corporation. Tasks performed: Installation and upgrades of the Product Safety & Dangerous Goods Ariel Staging Area on SAP EH&S for various clients across Europe, mainly in the chemical industry.
Project 9: Project leader and consultant for full cycle implementation of Dangerous Goods Management and Product Safety. Customer: Air Products, Europe & US. Tasks performed: scope definition, blueprint, customising, data migration, Ariel Data Services, Expert rules, testing, training, go-live support.
Project 8: Consultant on Dangerous Goods Management. Customer: Shell Chemicals, Netherlands.
Tasks performed: customising and end-user training.
Project 7: Consultant on Dangerous Goods Management. Customer: Aventis/BayerCropScience, UK. Tasks performed: requirements gathering and customising.
Project 6: Consultant for implementation of Dangerous Goods Management and Product Safety.
Customer: GE Toshiba Silicones, Japan. Tasks performed: scope definition, blueprint, customising.
SAP EH&S Consultant
Technidata AG / SAP

2000-01 - 2002-01

Germany Project 5: Project leader and consultant for implementation of Dangerous Goods Management.
Customer: Danisco Cultor, Denmark. Tasks performed: scope definition, blueprint, customising, testing, go-live support.
Project 4: Project leader and consultant for blueprint of Industrial Hygiene & Safety, Product Safety and Dangerous Goods Management. Customer: Statoil, Norway. Tasks performed: business process definition and blueprint.
Project 3: Project leader and consultant for full cycle implementation of Product Safety and Dangerous Goods Management. Customer: TFL Ledertechnik, Germany & France. Tasks performed: scope definition, blueprint, customising, data migration, Ariel Data Services, testing, training, go-live support.
Project 2: Consultant for implementation of Product Safety. Customer: Avecia, UK. Tasks performed: support for blueprint & customising Project 1: Consultant for full cycle implementation of Product Safety and Dangerous Goods Management. Customer: GE Bayer Silicones, Germany. Tasks performed: scope definition, blueprint, customising, Ariel Data Services, data migration, testing, training, go-live support.
SAP Supply Chain / Logistics consultant
EDS ATKearney

1998-01 - 2000-01

Project 3: Consultant for post implementation enhancements. Customer: CKWitco, Belgium. Tasks performed: Optimisation of Business processes.
Project 2: Team leader for rollout of EDS Enterprise System. Customer: EDS Argentina, Brazil and USA. Tasks performed: Workshops, presentation of template, requirements gathering, set-up and user acceptance testing.
Project 1: Consultant for rollout of EDS Enterprise System. Customer: EDS Germany. Tasks performed: set-up and user acceptance testing.
Storekeeper, United Kingdom
Grundfos Pumps

1987-01 - 1988-01

Academic Background

Nano Degree - Self Driving Cars
Udacity

2024-03 - 2019-01

NEBOSH Diploma in Environmental Management
NEBOSH

2024-03 - 2009-01

Entrepreneurship
Danish Technological Institute

2024-03 - 1998-01

MM
SAP Nordic Academy

2024-03 - 1998-01

BSc.
Copenhagen Business School

1995-01 - 1998-01

MSc. In Engineering.
University of Denmark and Politecnico di Milano

1988-01 - 1996-01

Certifications

Certified SAP MM consultant
Certified SAP

Contact contractor

/