Johannes Wagner - Senior Data Engineer

Q: Where is Johannes based?

Johannes is based in Cologne, Germany .

Q: What languages does Johannes speak?

Johannes speaks the following languages: German (Advanced), English (Advanced), Spanish (Advanced), French (Advanced) .

Q: How many years of experience does Johannes have?

Johannes has at least 8 years of experience. During this time, Johannes has worked in at least 8 different roles and for 8 different companies . The average length of individual experience is 1 year . Note that Johannes may not have shared all experience and actually has more experience.

Q: What is Johannes's latest experience?

Johannes's most recent position is Senior Data Engineer at Soorce GmbH .

Q: What companies has Johannes worked for in recent years?

In recent years, Johannes has worked for Soorce GmbH , STRABAG BRVZ , ARAG SE , Stadtwerke Düsseldorf AG , and Sopra Steria .

Q: Which industries is Johannes most experienced in?

Johannes is most experienced in industries like Insurance , Utilities , and Automotive . Johannes also has some experience in Education , Manufacturing , and Construction .

Q: Which business areas is Johannes most experienced in?

Johannes is most experienced in business areas like Information Technology , Business Intelligence , and Research and Development . Johannes also has some experience in Quality Assurance , Strategy , and Project Management .

Q: Which industries has Johannes worked in recently?

Johannes has recently worked in industries like Utilities , Automotive , and Education .

Q: Which business areas has Johannes worked in recently?

Johannes has recently worked in business areas like Information Technology , Research and Development , and Business Intelligence .

Recommended expert

Cologne, Germany

Check rate

Experience

Dec 2025 - Present

8 months

Senior Data Engineer

Soorce GmbH

Analysis of business requirements
Integration of different data sources such as ERP systems, production systems, and external data sources
Implementation of load processes and processing logic with MSSQL
Data modeling and optimization of data models
Setting up data quality management incl. data profiling with dynamic programming
Support in designing and establishing data governance, especially in the areas of data quality management and data protection
Support in developing BI solutions with Tableau to help decision-making processes

Jul 2025 - Oct 2025

4 months

Identity and Access Management Engineer

STRABAG BRVZ

Modeling architecture models for a central application to manage digital identities (Entra ID, MS Azure) with ArchiMate 2.0
Working on policies (IAM & IAG) for the lifecycle of digital identities with this application
Modeling the data layer of the same application with ERM
Modeling business process models with BPMN 2.0
Requirements engineering and writing out requirements as use cases
Deriving measures to improve (data) quality and the software testing process
Deriving proposals for new types of encryption for user logins
(Improving) documentation in Confluence & Jira
Software testing & documentation via Zephyr
Planning workshops & moderating meetings

Mar 2025 - Jun 2025

4 months

SAP Cloud Consultant & BI Specialist

ARAG SE

Requirements gathering and communication with the business departments
Design and implementation of load processes in SAP BW
Working with new SAP technologies (e.g. SAP Datasphere) and implementing them in the company's own data architecture
Attending specialist conferences
Moderating meetings
Project management

Jul 2023 - Feb 2025

1 year 8 months

Data Architect

Stadtwerke Düsseldorf AG

Definition and control of the company's data governance
Building the group-wide data governance organization
Creating training materials and leading workshops on Data Vault 2.0 (hubs, links & satellites and advanced concepts such as same-as links and bridge tables)
Designing data models for data areas (e.g. electricity, water, risk management, and sales) according to Data Vault 2.0 (especially raw vault modeling)
Designing the data infrastructure / data and AI factory
Market analysis for selecting a technology for the central data platform (Snowflake, Databricks, MS Fabric, and others)
Inventory of data and data sources
Role design in data governance (including data owner and data steward) and recommendations for data quality

Apr 2022 - Jun 2023

1 year 3 months

BI Consultant

Sopra Steria

Development of ETL processes via SAP Data Services (e.g. for delta loading and pivoting datasets)
Redesign and implementation of a Data Vault for the automotive data area
Implementation of business logic via MS SQL Server, SAP HANA Studio, and the SAP Information Design Tool
User administration in the Central Management Console (CMC)
Support of the test and production environment to verify that daily reports were loaded correctly, including error analysis and fixing if needed
Project manager in the Graduate Program Data & Analytics

Mar 2021 - Mar 2022

1 year 1 month

Scientific staff member at the Chair of Business Administration, especially for the development of information systems

FernUniversität in Hagen

Further development and administration of a modeling observatory (with Java, PostgreSQL, HTML, and CSS)
Teaching tasks: supervision of seminars, modules, and students, and conducting classes in the field of logical data modeling
Preparation and execution of studies on logical data modeling (e.g. cluster analyses)
Publication of a study on logical data modeling at the European Conference on Information Systems (ECIS) 2022

Feb 2020 - Mar 2021

1 year 2 months

BI Quality Engineer

Gothaer Systems GmbH & Gothaer Finanzholding AG

Setup of a data quality infrastructure for a DWH (DQ tool, console for user setup and permission management, metapedia, and interface to the DWH) with SAP Information Steward
User management (user setup and permission management) for SAP Information Steward in the CMC
Creation of total and hash tests to determine the completeness of and changes in records in SAP BW / 4 HANA
Profiling of records and support in creating DQ scorecards in SAP Information Steward
Moderation of daily meetings (Scrumban)

Sep 2018 - Jan 2020

1 year 5 months

Data Warehouse Developer

Gothaer Systems GmbH

Gathering requirements for standard and ad-hoc reporting in SAP BusinessObjects Web Intelligence from the business departments (especially non-life insurance)
Development of load processes for transactional data (posted premiums and commissions) in SAP HANA Studio and SAP BW / 4 HANA
Anonymization and pseudonymization of personal data

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Insurance, Utilities, Automotive, Education, Manufacturing, and Construction.

Insurance

Utilities

Automotive

Education

Manufacturing

Construction

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Research and Development, Quality Assurance, Project Management, and Strategy.

Information Technology

Business Intelligence

Research and Development

Quality Assurance

Project Management

Strategy

Skills

Technologies (E.G. Quantum Computing, Airflow, Dbt, Snowflake)
Playing The Violin
Qiskit Advocate

Languages

German

Advanced

English

Advanced

Spanish

Advanced

French

Advanced

Education

Apr 2016 - Nov 2020

FernUniversität in Hagen

M.Sc. · Business Informatics · Hagen, Germany · 2,4

Oct 2012 - Feb 2016

University of Cologne

B.Sc. · Business Informatics · Cologne, Germany · 2,5

Statistics

Experience

Total positions 8

Experience in Insurance 3 y

Avg length 11 m

Longest experience 1 y 7 m

Expertise

Recent roles Senior Data Engineer, Identity and Access Management Engineer, SAP Cloud Consultant & BI Specialist

Main industries Insurance, Utilities, Automotive

Main business areas Information Technology, Business Intelligence, Research and Development

Qualifications

Highest degree Master

Profile

Created

July 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Johannes based?

Johannes is based in Cologne, Germany.

What languages does Johannes speak?

Johannes speaks the following languages: German (Advanced), English (Advanced), Spanish (Advanced), French (Advanced).

How many years of experience does Johannes have?

Johannes has at least 8 years of experience. During this time, Johannes has worked in at least 8 different roles and for 8 different companies. The average length of individual experience is 1 year. Note that Johannes may not have shared all experience and actually has more experience.

What roles would Johannes be best suited for?

Based on recent experience, Johannes would be well-suited for roles such as: Senior Data Engineer, Identity and Access Management Engineer, SAP Cloud Consultant & BI Specialist.

What is Johannes's latest experience?

Johannes's most recent position is Senior Data Engineer at Soorce GmbH.

What companies has Johannes worked for in recent years?

In recent years, Johannes has worked for Soorce GmbH, STRABAG BRVZ, ARAG SE, Stadtwerke Düsseldorf AG, and Sopra Steria.

Which industries is Johannes most experienced in?

Johannes is most experienced in industries like Insurance, Utilities, and Automotive. Johannes also has some experience in Education, Manufacturing, and Construction.

Which business areas is Johannes most experienced in?

Johannes is most experienced in business areas like Information Technology, Business Intelligence, and Research and Development. Johannes also has some experience in Quality Assurance, Strategy, and Project Management.

Which industries has Johannes worked in recently?

Johannes has recently worked in industries like Utilities, Automotive, and Education.

Which business areas has Johannes worked in recently?

Johannes has recently worked in business areas like Information Technology, Research and Development, and Business Intelligence.

What is Johannes's education?

Johannes holds a Master in Business Informatics from FernUniversität in Hagen and a Bachelor in Business Informatics from University of Cologne.

What is the availability of Johannes?

Johannes will be available full-time from August 2026.

What is the rate of Johannes?

Johannes's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.