Upgrade Projekt einstellen
Profilbild von Steve Rein Data Solution-Architect & Engineer | Modern data solutions | Hands-On & Pragmatic| 15 Jahre EXP aus MuehlheimamMain

Steve Rein

Mühlheim am Main
nicht verfügbar bis 01.10.2025

Letztes Update: 12.02.2025

Data Solution-Architect & Engineer | Modern data solutions | Hands-On & Pragmatic| 15 Jahre EXP

Abschluss: FastTrack Solution-Architect (2022), B.Sc. - Wirtschaft & Management; Projektmanagement-Ökonom (VWA); Fachinformatiker - Systemintegration
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: Deutsch (Muttersprache) | Englisch (verhandlungssicher)

Schlagwörter

Data Analysis Microsoft Azure Power Bi Azure Machine Learning SQL Sql Server Data Tools (SSDT) Data Cube Sql Data Warehouse Microsoft Analysis Services Agile Methodologie + 30 weitere Schlagwörter anzeigen

Dateianlagen

CV-2025-Projects-DE_030225.pdf
CV-2025-Projects-EN_030225.pdf

Skills

 
For more than 15 years, I have been working for companies in various roles in the field of D&A and have been responsible for projects >1,000 man-days per year.

My experience as a controller, data engineer, project manager and platform solution architect enables me to support companies technically, methodically and professionally. I specialise in the management, conception and architecture of projects for data-driven solutions as well as in consulting and implementing these solutions for medium-sized companies through to large corporations.

In the last two years I was responsible for data platform solutions on Microsoft Azure & MS Fabric with the tools Power BI, Azure Data Factory, Databricks & MS Fabric Data Services.

In addition, I am an enthusiastic developer, architect, consultant and coach for the topic of (managed) self-service analytics with a focus on Power BI/MS Fabric. In 2022, 2023 and 2024 I was honoured as one of 40 experts worldwide as FastTrack Recognized Solution Architect - Power BI by Microsoft.


Solution design & project management
  • Data platform enterprise concept, technical designs & strategy
  • Conception & architecture modeling of enterprise self-service data platforms
  • Technical architecture - ETL processes & analytical data models
  • Analysis of functional requirements and implementation in a technical solution design
  • Project management of data & analysis teams -> 15 experts
  • Support in the development of detailed implementation roadmaps
  • Team coordination, project and stakeholder management
  • Conception of business processes (data & analytics)
Microsoft & Azure data platform solution architecture
  • MS Fabric Data Services: Power BI, One Lake, Lakehouse, SQL Warehouse, Schematic Models, Data Factory
  • Azure Data Platform: ADF, Azure SQL DB, Databricks
  • On-Premise Data Platform: SSIS, SSAS, SSRS
  • Delta Lake, ADLS Gen2, RDBMS, Azure Event+IoT-Hub
(Advanced) Data Analytics & Data Exploration experience
  • (Advanced) Analytics
  • Microsoft stack (Power BI, SQL, BI-Stack, Azure ML)
  • Open source stack (Python, R Studio, Jupyter, Spyder )
  • Data modelling
  • Data Vault 2.0, Inmon, Kimball
Additional qualifications
  • Azure DevOps
  • ML Engineering in Azure ML Services / Power BI
  • T-SQL, SparkSQL
  • Python, DAX, M, R

Projekthistorie

01/2024 - 01/2025
Trainer & Coach - Building a modern data platform on Microsoft Azure (various workshops)
verschiedene Kunden (Sonstiges, 1000-5000 Mitarbeiter)
  • Content / focus (per workshop scope)
    • Data Platform Lakehouse Architecture Consulting
    • Data Mesh & Data Governance
    • Data security, encryption & right to be forgotten (GDPR)
    • Consultancy and coaching for technical SAP data integration with the Azure Data Factory
    • Consulting and coaching - Analytical data modelling in Databricks
    • Counselling - Requirements: Infrastructure & connectivity to build Azure data platform
    • Consulting - Prerequisites/Setup: Development processes & version management for a data platform on Azure with Azure DevOps
    • Insight into MS Fabric formerly Power BI incl. technical depth
01/2024 - 01/2025
Trainer & Coach - Best practice for the use of MS Fabric & MS Power BI
(Sonstiges)
  • Implementation of various coaching sessions for companies for the use of the Microsoft Data & Analyrics SaaS solution MS Power BI / MS Fabric (since 2024)
  • (Individualised) education & training for various target groups
    • End user
    • Power User 
    • Report developer
    • DAX Developer & Data Modeller
    • Data Engineering
  • Provision of how-to guides 
09/2024 - 11/2024
Solution Architect & Advisor - Evaluation of a SAP BW Migration to the Microsoft Data Platform
(Industrie und Maschinenbau, 1000-5000 Mitarbeiter)
Conception, solution architecture and development of an MVP to evaluate and assess the
replacement of SAP BW solution by an MS Azure Data Platform. I was actively involved in the
development and requirements engineering for the implementation of the PoC.
  • Project management, conception & platform architecture (layer model, lakehouse)
  • Lead Engineer: ETL processes in MS Fabric & Databricks (Python, SQL, ADF, Delta Lake)
  • Power BI: Development of the analytical data model & reporting (DAX, M, Dataflows)
05/2024 - 10/2024
Project Management & Trusted Advisor - Evaluation of the migration from SAP BW & Lumira to a Microsoft Data Platform
(Transport und Logistik, 1000-5000 Mitarbeiter)
  • Project management, conception & platform architecture of a data & analytics platform
  • Lead Developer for the development of ETL pipelines (Azure Data Factory) & transformation codes (Databricks)
  • Development of the Power BI data model & reporting
  • Stakeholder-Management C-Level
  • Creation of the results matrix
06/2023 - 12/2023
Trusted Advisor - Modernising CRM marketing operational & analytical data processes
(Versicherungen, 1000-5000 Mitarbeiter)
In 2023, the client commissioned a strategy consultancy to analyse the existing processes for managing market and customer processes. As part of the initial project, the processes across the entire value chain were evaluated within 6 months and a recommendation was made to modernise the market systems. The results led to a modernisation project for the market systems for the next 10 years.
  • Conception & development of a customer data hub for the migration of data processes
  • Strategy consulting at C-level - modern data processes for market control
  • Project and team management of a 6 experts strong strategic data & analytics expert team
09/2020 - 12/2023
Solution Architect, Lead Dev, Power BI Advisor & Project management
(Versicherungen, 1000-5000 Mitarbeiter)
The client's goal was to introduce a new data platform that is aligned with modern architecture principles. I provided support with the conception, architecture and strategic positioning. The enterprise platform went live in April 2022. The DAP is based on a data mesh approach and is operated on Microsoft Azure.
  • Power BI Self-Service Platform Enterprise Concept & Strategy
  • Conception & Architecture of an Enterprise Power BI Self-Service Platform
  • Lead Developer - Power BI Data Process Developments
  • Lead Developer - ETL Processes & Analytical Data Models in Azure Synapse Analytics
  • Conception & development of an enterprise data & analytics platform
  • Team leader of a 15 experts’ strong data & analytics team
10/2021 - 02/2022
Lead Developer Power BI - Development of an internal Power BI controlling solution
(Medien und Verlage, 1000-5000 Mitarbeiter)
A Power BI reporting system based on the newly introduced CRM MS Dynamics 365 had to be set up.

Technologies used
  • MS Power BI
  • Dataverse
Own tasks in the project
  • Support in the creation of an analytical data model
  • Quality assurance when setting up the Power BI reporting system
11/2019 - 12/2021
Trusted Advisor - D&A consulting for the conception & architecture of a data lake
(Transport und Logistik, 500-1000 Mitarbeiter)
The customer requires support in the conception & architecture of a data lake for the implementation of new ML use cases and the migration of the current data storage structures to the Microsoft Azure Data Platform. The aim is to achieve greater agility, improved scaling and cost efficiencies for the customer compared to the existing solution.

Technologies used
  • MS Powerpoint (Presentations for workshops)
  • Azure Data Lake Gen2
  • Azure Data Factory v2
  • Azure Machine Learning Services
Eigene Aufgaben im Projekt
  • Conception & architecture of the data lake
  • Best practice consulting for data structures in the cloud
  • Best-practice advice on the implementation of ETL processes & pipelines
  • Support with solution design of ML use cases on the data lake
  • Consultancy on the migration of data structures
03/2021 - 11/2021
Senior Developer Power BI - Development of the new claims database solution with Power BI
(Versicherungen, 5000-10.000 Mitarbeiter)
The customer required support with the migration of the existing claims database solution from MS Access to Power BI. An assessment of the existing solution was carried out together and then a migration scenario was developed to transfer the claims database to Power BI. The new claims database solution was then developed, the users were trained in the new solution and the Power BI claims database was published in the Power BI portal.

Technologies used
  • MS Power BI
  • M
  • DAX
Own tasks in the project
  • Development of the analytical data model
  • Architecture of the Power BI solution
  • Report design and development
  • Data preparation in Power Query with M
  • Creation of M-function for dynamised data preparation
  • Creation of Power BI dataflows and datasets
  • Conception of a Power BI deployment process
  • Key figure development with DAX
  • Project management
09/2021 - 09/2021
Expert advice for setting up Power BI deployment processes
(Sonstiges, 500-1000 Mitarbeiter)
The customer uses Power BI as an enterprise reporting platform for internal supply chain reporting. In the course of using Power BI, the processes of the reporting platform are to be professionalised.

To this end, an expert workshop was organised for the best-practice use of CI/CD processes with the Power BI reporting platform.
06/2020 - 12/2020
Solution Architect & Lead Developer - Migration of the SAS D&A platform to an Azure Data Platform
(Industrie und Maschinenbau, 500-1000 Mitarbeiter)
  • Project management for the migration project
  • Analysing the current D&A structures of the SAS platform​
  • Training end users on the new reporting platform​
  • Development of new ETL routes, data lake & DWH structures Development of analytical (tabular) cube models
  • Development of data transformation routes for the integration of heterogeneous and complex data sources​
10/2019 - 12/2019
Expert & Coach Azure architecture consulting & analysis
(Energie, Wasser und Umwelt, 1000-5000 Mitarbeiter)
A technical analysis of the existing DWH landscape and support in developing a procedure for the target architecture was required.

The requirement here was for advice on a technical and methodical migration procedure, the cost estimate and the project plan for the migration of the analytical data requirements of the sales data and analysis structures in the context of the consolidation of the data and analysis environments.

Own tasks in the project
  • Analysis & evaluation of the implementation possibilities of the actual architecture on the target architecture
  • Execution of cost estimates for the migration of analytical functions
  • Organisation of workshops to determine the framework
  • Advice on report & dashboard implementation options with Power BI
  • Analysis of data vault structures and implementation on the target architecture
  • Evaluation of the analytical actual data modelling
  • Consultancy on methodical procedures for the implementation of analytical data warehouse solutions on the Microsoft Data Platform
  • Identification of open fields of action from the perspectives of skills, architecture, processes and organisation
07/2019 - 12/2019
Lead Developer - Development of an on-premises BI solution
(Öffentlicher Dienst, 500-1000 Mitarbeiter)
Project description
  • Development of a BI infrastructure & architecture
  • Development of a reporting & self-service architecture
  • Connection of a Sharepoint 2017 solution as a data source
  • Creation of an XML export function with SSRS
  • Structure of a Power BI data model

Technologies used
  • Analysis Services
  • SSRS
  • SSIS
  • SQL Server 2017
  • Sharepoint 2017
  • Power BI

Own tasks in the project
  • Conception & development of the BI architecture
  • Development of the ETL routes
  • Development of a DWH layer model according to Kimball
  • Ensuring data quality
  • Structure of historicised dimensions
  • Setting up SSRS
  • Connection of the Sharepoint lists
03/2019 - 09/2019
Lead Developer - Migration of an SAP D&A platform to an Azure Data Platform
(Energie, Wasser und Umwelt, 1000-5000 Mitarbeiter)
  • Conception & development of the basic functionalities for the modern D&A platform​
  • Conception and development of solution architectures for the individual requirements of different departments
  • Recording of the functional requirements & transformation of the technical data structures to the new D&A platform
  • Development of ETL pipelines
08/2017 - 06/2019
Lead Developer SSAS (tabular) - Microsoft Business Intelligence Platform for process control
(Konsumgüter und Handel, 5000-10.000 Mitarbeiter)
Project description
Development of a company-wide reporting and analysis environment on the Microsoft Business Intelligence On-Premise Data Platform and migration of the old Business Intelligence solution based on IBM Cognos. This solution was completely redesigned and developed for the company and interfaces were created with the data science processes established in the company, with some of the operational processes from the specialist departments serving as the data basis.

Technologies used
  • SSAS Tabular
  • Power BI
  • Power BI Report Server
  • SSIS & SSRS
  • MS SQL Server 2017
  • Oracle Developer
  • StarUML
  • NBi
  • BIML

Own tasks in the project
  • Conception and development of a tabular cube model (In-Memory/DirectQuery)
  • Development of the analytical DWH model
  • Key figure analysis and development
  • Conception, design and development of the reporting and analysis platform
    Functional tests
  • Contact person for key users for process recording and technical report development
  • Development of process key figures
  • Interface between data science and BI
  • Requierements Engineering

Zertifikate

FastTrack Recognized Solution Architekt - Power BI
Microsoft Corporation
2023
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
2020
Verified Certificate for Data Science Professional Project
eDX
2017
Microsoft Certified Professional
Microsoft
2016

Reisebereitschaft

Verfügbar in den Ländern Deutschland, Österreich, Schweiz, Großbritannien, USA, Spanien, Liechtenstein, Ukraine, Neuseeland, Australien, Dänemark, Finnland, Irland, Island, Japan, Kanada, Luxemburg, Niederlande, Norwegen, Polen, Schweden und Südkorea
Profilbild von Steve Rein Data Solution-Architect & Engineer | Modern data solutions | Hands-On & Pragmatic| 15 Jahre EXP aus MuehlheimamMain Data Solution-Architect & Engineer | Modern data solutions | Hands-On & Pragmatic| 15 Jahre EXP
Registrieren