Hello, I'm

Björn
Karoly

Data Architect

I design and build scalable data architectures and BI solutions – from cloud-native data warehouses and lakehouses to self-service reporting platforms with Power BI. With 7+ years of experience at Novatec and CGI, I help enterprises modernise their data infrastructure and turn raw data into actionable insight.

View Projects Get in Touch
Björn Karoly

About Me

01

I'm a Data Architect with 7+ years of experience as a BI and Data Architecture consultant, currently working as a Senior Consultant at CGI (formerly Novatec Consulting). I've delivered end-to-end solutions across manufacturing and finance & banking — designing scalable data architectures that bridge the gap between raw operational data and meaningful business insight.

My expertise spans the full spectrum: crafting data architecture blueprints and target designs, modelling with Star Schema, Snowflake, and Data Vault, building robust ETL/ELT pipelines, and delivering self-service BI with Power BI on the Azure stack — including Synapse, Data Factory, Analysis Services, and Microsoft Fabric. I take data governance and lineage seriously and operate fluently in both agile and classic delivery environments.

When I'm not architecting data systems, you'll find me cooking something elaborate, out hiking or fishing, capturing landscapes with my camera, or tinkering with the latest smart home automation.

Location

Remshalden, Germany

Focus

Data Architecture & Business Intelligence

Power BI · Azure · Lakehouse · Governance

Experience

02

Work History

  1. 06/2025 – Present

    Senior Consultant

    CGI

    Advising clients on architecture topics including cloud, data strategy, and integration patterns. Responsible for the technical target architecture in complex modernisation projects. Leading project teams and providing expert guidance in architecture decisions.

    Cloud Architecture Data Strategy Integration Patterns Target Architecture
  2. 01/2024 – 06/2025

    Senior Consultant

    Novatec Consulting GmbH (acquired by CGI in 06/2025)

    Delivering complex data and BI architectures in enterprise environments. End-to-end ownership of cloud migration and modernisation projects. Primary contact for business units regarding data strategy and reporting requirements.

    Data Architecture Cloud Migration BI Data Strategy Azure
  3. 12/2018 – 12/2023

    Consultant

    Novatec Consulting GmbH

    Implementing ETL/ELT pipelines, data models, and reporting solutions for various enterprise clients. Contributing to architecture concepts and building modern cloud data platforms. Developing Power BI reports, data models, and integrations.

    ETL/ELT Power BI Data Modeling Azure Reporting

Education

2019 – 2023

M.Sc. Business Informatics

FernUniversität in Hagen

2014 – 2018

B.Eng. Business Informatics

University of Applied Sciences Esslingen

2012 – 2013

Geprüfter Industriemeister

Johannes-Gutenberg-Schule Stuttgart

Certifications

  • Professional Scrum Master I
  • Vocational & Occupational Pedagogical Qualification (AEVO)
  • IBM Cloud Essentials

Skills

03

Data Architecture

Data Architecture Data Modeling Star Schema Snowflake Schema Data Vault Semantic Modeling Data Governance Metadata Management

Cloud & Azure

Azure Synapse Azure Data Factory Azure Data Explorer Azure Analysis Services Microsoft Fabric Databricks Azure SQL

Business Intelligence

Power BI DAX Power Query Self-Service BI Data Storytelling Power BI Report Server

Data Integration

Dynamics BC Dynamics 365 CRM SQL Server Oracle API Integration IoT / Streaming

Client Projects

04

A selection of projects from my work at Novatec Consulting & CGI. Private projects will be added soon.

Senior Data Architect – Cloud BI Migration

German IT Service Provider

Replacement of an on-premises data landscape and design/implementation of a fully cloud-based BI architecture in Microsoft Azure, including migration of existing reporting and data sources. Delivered a governance-compliant, scalable cloud BI platform with improved performance, data quality, automation, and a modern Power BI self-service ecosystem.

Azure Data Factory Azure Synapse Azure Analysis Services Power BI Dynamics BC Dynamics CRM

Senior Data Architect – BI & IoT Data Architecture

DACH Market Leader · Manufacturing

Development of a scalable, strategically aligned BI data architecture integrating classical DWH data with extensive IoT data from various production systems. Delivered a future-proof data architecture as the central foundation for data-driven decision-making, with a harmonised data model, clear governance structures, and scalable integration mechanisms.

Power BI Azure Data Vault Dataspot IoT Azure Data Explorer

Senior Data Analyst – Finance BI

DACH Market Leader · Manufacturing

Modernisation and scaling of an existing BI architecture to support finance departments. Defined the target architecture, built robust data models, developed PoC reports, and documented data flows for governance compliance. Improved transparency over data processes and reporting efficiency.

Power BI Azure Synapse Azure Data Factory Dataspot

Contact

05

Interested in working together, exploring a new opportunity, or just want to say hi? My inbox is always open — I'll do my best to get back to you within 24 hours.

Email

Bjoern.Karoly@gmail.com

LinkedIn

linkedin.com/in/björn-karoly

GitHub

github.com/BjoernKaroly