Data Architects in Germany

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide context-based business information.

Development of an AI agent with Function/Tool Calling for the secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Building automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and Service Principal, and integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.

I delivered following projects and engagements as a freelancer.

• Data Migration of CRM System for AL-FA Objekt Service Gmbh
• Microsoft Software Resales Partnership

I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer

Technical Focus Areas

• Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
• DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
• Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
• MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
• Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.

Scope: Embedded as FP&A Data & AI Architect within the Finance function of a major European refrigeration manufacturer, leading the transformation of manual, fragmented financial reporting into an automated, governance-driven intelligence platform. Driving the shift from Excel-based controlling to structured data architecture, Power BI analytics, and AI-assisted financial operations.

Financial Data Integrity & ERP Governance

• Initiated and led GL vs. subledger reconciliation investigations, identifying and resolving structural mismatches between General Ledger and subledger data that had gone undetected prior to engagement
• Conducted asset analysis to identify items missing from General Ledger postings, surfacing gaps in fixed asset tracking and period-end completeness
• Validated SAP reports, establishing baseline data quality standards for Finance team consumption
• Established systematic SAP data validation framework ensuring ongoing integrity between ERP postings and downstream reporting outputs

Finance Reporting Transformation

• Designed and implemented a structured Transformation Project approach for converting manual Finance reports into fully automated processes
• Created and owns the Data Reporting Audit Log; a centralized tracking system capturing report owners, stakeholders, data sources, manual effort estimates, and automation opportunity scores across the Finance function
• Mapped the full reporting landscape identifying quick-win automation targets and strategic Power BI migration candidates
• Actively reducing manual Excel and PowerPoint dependency across FP&A workflows; replacing point-in-time snapshots with live, governed data models

Power BI & Analytics Enablement

• Introduced and presented Power BI as the strategic reporting platform to Finance leadership, building internal buy-in for the BI transformation roadmap
• Designed initial Power BI architecture aligned with SAP, Salesforce and Oracle data structures and FP&A reporting requirements
• Established report ownership, governance documentation, and data lineage standards enabling sustainable self-service analytics across the Finance team

Transformation Infrastructure & Collaboration

• Configured and deployed Jira as the transformation project management hub, establishing structured sprint workflows, backlog management, and progress visibility for Finance IT initiatives
• Proposed and initiated a dedicated FP&A Communication & Transformation Hub, a structured cross-functional forum aligning Finance, IT, and business stakeholders around the reporting transformation roadmap
• Positioned the Finance function as an active driver of data governance and digital transformation within the broader organization

Outcomes

• GL/subledger reconciliation gaps identified and investigation framework established within first two weeks of engagement
• Data Reporting Audit Log deployed; first structured inventory of Finance reporting landscape in company history
• Power BI transformation roadmap presented and approved by Finance leadership
• Jira-based project governance live; Finance transformation now tracked with full sprint visibility

Technologies: SAP FI/CO · Power BI · DAX · SQL · Excel (advanced) · Power Query (M) · Power Automate · VBA · Jira · Microsoft 365 · SharePoint · Salesforce (Sales Data) · Oracle HCM · Python

• Architected and deployed private cloud data platform on VMware vSphere, integrating Greenplum MPP, Apache Kafka, Kubernetes, and Apache Solr, and developed real-time ingestion pipelines with Kafka Connect and Schema Registry.
• Led Oracle Exadata to Greenplum migration, rearchitected data models, optimized storage, implemented RabbitMQ with Debezium for CDC, and deployed VectorDB for Generative AI.
• Designed and executed multi-cloud migration PoC across AWS, Azure, and GCP, defined KPIs for throughput, latency, and cost efficiency, executed bulk data transfers, validated analytics and streaming workloads, and delivered full-scale architecture recommendations.
• Assessed legacy on-premises infrastructure and designed modern cloud-native data platforms using Greenplum and containerized microservices, advising on scalability, disaster recovery, and high-availability.

• Delivered MVP-focused full-stack architecture for a health-sector client: Vite/React frontend, backend services on Google Cloud Run, and Supabase for database plus IAM/authentication.
• Supported product requirements engineering and prioritized cost-aware workload placement, implementing browser-side/edge computation where feasible before moving logic to backend services.

Development of a route planner for incident communication.

• Development of the REST API
• Set up a patch system for maintaining the routing graph
• Expansion of the testing infrastructure
• Performance and memory optimization (JMeter, JFR)

Technologies: Java 21, Spring Boot, JGraphT, Flyway, MapStruct, Caffeine, ShedLock, JMeter, Kubernetes, JFR

Consumer Cards Solution Architect

• Provided architectural leadership in Consumer Cards Domain establishing best practices and improving architectural transparency and maintainability by designing a structured documentation framework to enable reverse engineering of legacy card systems.
• Standardized architectural artefacts including BIAN Business Capabilities, UML diagrams in draw.io format (Use Case, Component, Sequence), naming conventions, document repository, design templates and blueprints, microservices.
• Produced high-level and low-level designs aligned with enterprise architecture governance processes and artefact standards.
• Provided architectural support to the Strategic Card Simplification Programme, focusing on card product migrations and application decommissioning across all countries. Agile environments (Scrum/SAFe).
• Analysed and designed AI use cases in the architecture domain.

Project: Payment Card Industry Data Security Standards (PCI DSS) Strategic Programme

• Analysed and documented existing data flows across card products and geographic regions to assess PCI DSS compliance.
• Identified areas involving sensitive data at rest and data in motion requiring encryption or masking, ensuring adherence to PCI DSS requirements.
• Collaborated with security, infrastructure, and application teams to align encryption strategies with regulatory and organizational policies.
• Provided strategic advisory services on data strategy, data governance, data management, data quality, data architecture, data mesh, MEGA HOPEX, DAMA-DMBOK, event-driven architecture, end-to-end data flows and card product harmonization models.
• Ensured solution design alignment with regulatory compliance (BCBS 239, DORA, GDPR) and internal policies.

Project: Denmark ATM Outsourcing Project

Objective: Outsource ATM operations and maintenance to a third-party provider while expanding the Denmark ATM fleet, with Nordea retaining ownership of ATMs and cash for the existing and extended infrastructure.

• Led a cross-functional delivery team (project management, business analysis, and architecture) and documented the as-is ATM ecosystem architecture, including end-to-end data flows, integrations, and internal/external application interfaces.
• Designed end-to-end processes for authorization, reconciliation, and settlement, aligning operating model, controls, and compliance requirements across Nordea and the outsourced service provider.
• Produced high-level and low-level solution designs using standardized UML artefacts (Use Case, Component, and Sequence diagrams) to support vendor onboarding, integration planning, and implementation.
• Ensured architectural alignment and decision-making across enterprise stakeholders and third-party providers, managing dependencies and interfaces in the context of the outsourcing initiative.

• DWH modernization
• Migration from Informatica PowerCenter to IDMC/CDI
• Migration from IBM DB2 to Databricks

Technologies: Informatica IDMC, Databricks

• Definition of the software architecture
• Design and development of modules
• Supporting internal employees in the learning and onboarding process
• Tools: SAP CAP / CDS, Java 21, SAP Hana, SAP Business Technology Platform (BTP)

Evaluation, structuring, and handling of complex tenders for Sogeti as well as as part of larger Capgemini proposals. Focus on analyzing demanding customer requirements, deriving solid solution concepts, and translating technical, functional, and commercial aspects into convincing proposal storylines. In close alignment with delivery, sales, account, and bid teams, scalable and implementable Quality Engineering solutions were designed, evaluated, and prepared for customer decisions. This included selecting suitable role profiles and right-shore staffing options, assessing available skills and capacities, as well as the commercial preparation of reliable price and effort calculations.

A special focus was on bid management and handling service proposals (RfP/RfI analysis), solution design, presentation and management materials, as well as the functional and technical evaluation of customer requirements in the context of Quality Engineering & Testing, agentic AI-supported test automation using modern quality assurance approaches.

SOGETI projects:

• BMW: Development of a test strategy including test management, test automation, and provision of a rightshore delivery model.
• GEA: SAP Business Assurance and Quality Engineering for an SAP rollout including test governance, test automation, AI agent layer, and hypercare concept.
• AIXTRON: SAP S/4HANA Cloud migration explore phase with QA assessment, testable blueprint structure, staffing, and scalable Sogeti delivery approach.
• Deutsche Glasfaser: Quality Engineering & Testing for DG development squads, including ServiceNow and Salesforce, testing automation and governance.
• ERGO: RfP/proposal support for Managed Service Test Data Provisioning as well as a Jira/Atlassian rollout with assessment, target picture, MVP, rollout, and governance.
• Munich Re: Proposal and solution design in the insurance environment with a focus on test data provisioning, process analysis, compliance, and automation.
• BWI: Project/proposal context in the public/IT service environment with reference to Quality Engineering, Test Factory, and digital transformation support.
• Rolls-Royce: Proposal/project support in the Sogeti context with a focus on structured RfP analysis, solution design, and customer-oriented proposal preparation.

• Consultant for system architecture, AI agents & integration, coach for data & process logic, Graph-RAG approaches, security and data protection.
• On-premise AI solutions with high compliance and performance requirements.
• Architecture decisions, operational setup, strategic prioritization & deployment.
• Technologies: LiveKit JS SDK, LiveKit Agents, Web Audio API, JS, AudioWorklet, Loki, vLLM, Zscaler, Docker, Neo4j, MySQL, Python.
• Models: GPT-OSS 20B, Whisper large v3 turbo, Qwen3-TTS.

(Technology)

• Design and implementation of an SAP BTP CAP microservice to consolidate cross-system transactional checks between SAP Sales Cloud (C4C) and On-Premise SAP CRM (05/2024– 06/2025)
• Bi-directional Cloud-to-On-Premise integration enabling real-time validation of Contact lifecycle and open document dependencies prior to record updates (05/2024– 06/2025)

Responsibilities / Deliverables

• development of custom CAP (Cloud Application Programming) services on SAP BTP
• API design, data mapping, and end-to-end integration across C4C (Cloud Runway) and legacy CRM (Traditional Runway)

• Lead enterprise architecture, data and AI strategy initiatives across business domains, value streams, SAP, cloud, integration, process intelligence and governance, aligning transformation roadmaps with strategic business outcomes.
• Define enterprise data and knowledge strategy across business domains and enterprise taxonomy, including knowledge graph, data governance with focus on ownership, metadata frameworks, business glossaries, data product orientation, interoperability and AI-enabling architecture.
• Shape AI governance and decision-intelligence strategy using autonomous enterprise concepts, including policies, guardrails, reference architectures and knowledge-based patterns for responsible AI adoption and enterprise knowledge reuse.
• Support SAP S/4HANA cloud migration strategy and evaluate the future SAP ecosystem, including SAP BTP, Integration Suite, Business Data Cloud, SAP Analytics Cloud and Datasphere.
• Drive architecture debt management, portfolio transparency and application rationalization through architecture principles, governance models, decision frameworks and LeanIX-based Enterprise Architecture Management.
• Align business architecture and process intelligence using Signavio to connect value chains, capabilities, processes, data strategy, knowledge flows and transformation roadmaps.
• Define operating models for data governance, architecture governance, cloud, integration, API management, AI governance and knowledge sharing.
• Act as trusted advisor to executive stakeholders and business domain leaders across product, sales, finance, logistics, customer care and shared services.

• Technical program ownership for the IPv6 migration at DRV RP and DRV BW, with a focus on migration planning, execution structure, and cross-functional technical coordination.
• Designed and implemented an operational control model with dashboard, action board, KPI portfolio, risk register, and decision index to translate technical topics into structured delivery artifacts.
• Coordinated technical groundwork for architecture and rollout across IPv6 addressing, segmentation, dual-stack target design, test-lab planning, and cross-team dependencies.
• Supported security and compliance-related requirements in the context of BSI, NIS2, and critical infrastructure, translating them into traceable evidence, risks, and management reporting.
• Achievement: Established a reusable intake-to-governance workflow for systematically capturing technical actions, risks, open issues, and evidence requirements.
• Achievement: Created an operational baseline for technical program execution with measurable KPIs, clear ownership, and transparent decision support.