Data Modeling Experts in Germany

• Redesign of the company’s BI infrastructure: replacement of a fragmented landscape of manually maintained Excel solutions and CSV imports with a centralized Power BI environment using a unified data model as the company-wide single source of truth
• Consolidation of previously isolated reporting logic in a central semantic model – elimination of redundant files, manual data transfers and inconsistent metrics across departments
• Forecasting & Planning: Design and implementation of company-wide liquidity planning in Power BI – from business logic to a fully automated, data-source-driven planning model replacing the previous manual Excel process; enabling rolling forecasts and continuously up-to-date cash flow transparency for management
• Optimization of existing Power BI dashboards in terms of performance, structure and analytical value using an AI-native approach
• Analysis and improvement of the data model, including data quality analyses, data cleansing and consistent modeling using Star Schema, DAX and Power Query
• Incident & Anomaly Analysis: Identification, investigation and explanation of data anomalies, including root-cause analysis and specific recommendations for action
• AI Solution Architecture: Connecting Business Central and Power BI to LangDock via MCP (Model Context Protocol) for AI-supported data usage
• Development of a historical data layer as a basis for trend and time-series analyses
• AI-supported automation: Design and development of AI skills, agents, loops and processes for the automated analysis and interpretation of reports
• Automated reporting workflow: Setup of scheduled, automated email delivery of AI-generated analyses and recommendations to stakeholders
• Gathering and documentation of business requirements and coordination with business departments and IT as part of requirements engineering / product owner activities
• Breaking down overall requirements into clearly defined work packages and tasks
• Definition, prioritization and management of milestones throughout the entire project lifecycle

Tools: POWER BI, M365, Copilot Studio, MIRO, Microsoft Business Central, Microsoft Fabric, Claude AI, ChatGPT, LangDock, MS VS Code

Working Environment

• Insurance / Claims Management (Property, Liability, Automotive)
• REST-based ClaimAPI with Guidewire ClaimCenter

Scope

• Further development of the internal REST-based ClaimAPI with Guidewire ClaimCenter as the backend and various portals/front-end offices as clients, and with the following objectives: + increased AI-supported claims processing outside of Guidewire ClaimCenter + and support for all lines (property, liability, automotive).
• Further development of automated claims processing

Activities

• Interfacing IT & Business
• Design activities with documentation in Confluence, Jira: + Requirements engineering (functional and non-functional) + Design of REST endpoints and coordination with interface partners (esp. AI-colleagues) + Identification, design and evaluation of alternative solutions (moving away from a monolithic approach toward fine-grained endpoints, with code reuse across all lines if possible) + Creation / refinement of product backlog items in Jira, i.e. epics, user stories and tasks, incl. alignment with developers & POs during (pre-)refinement sessions + Using AXA Secure GPT when creating / refining user stories (description, acceptance criteria) and designing REST endpoints + Estimation and prioritization of user stories and tasks during Sprint Planning sessions + Coordination and support during the implementation of Product Backlog items + Driving decision making with preparation and presentation of decision-making documents
• Quality assurance: + Test management, including test case creation using Xray in Jira + Test execution using Bruno as REST client and in Guidewire ClaimCenter + Submission of test artifacts for PO approval + Analysis of production bugs

Methods Big Room Planning (aka PI-Planning in SAFe), Scrum, BPMN, EPK, UML, ERM, DDD

Tools / Tech Stack Teams, Confluence, Jira with Xray, OpenAPI/Swagger, REST, JSON, XML, MS Office, Bruno, GitHub repository (reading), Guidewire ClaimCenter, AXA Secure GPT (AXA's in-house GenAI solution based on Azure OpenAI)

• Designed and developed a production-ready data platform based on Microsoft Fabric for an e-commerce company
• Built a scalable Medallion Architecture (Bronze, Silver, Gold) with Lakehouse and Delta Lake as the foundation for analytics and AI applications
• Developed a metadata-driven ETL platform with PySpark and a generic Incremental Loading Framework (SQL Server → Bronze → Silver → Gold)
• Developed reusable components for Microsoft Fabric Notebooks to standardize data integration, transformation, and validation
• Implemented automated data pipelines including monitoring, logging, error handling, and Delta MERGE strategies for stable production operations
• Built a business layer architecture for reporting, data warehousing, and reusable data products
• Integrated heterogeneous data sources via SQL Server, REST APIs, Amazon SP API, and Google Analytics 4
• Worked closely with business departments to analyze business requirements and translate them into scalable data architectures

Technologies: Microsoft Fabric, PySpark, Python, SQL Server, Delta Lake, Lakehouse, OneLake, Data Factory, Data Warehouse, REST APIs, Amazon SP-API, Google Analytics 4

Further Development of the Integrated Capacity Management Platform InKa

Rail Infrastructure

• Power BI shared datasets and reports via DirectQuery on Amazon Redshift (timetable, construction and capacity data)
• Automated report testing with Playwright in Docker containers, version control with GitLab
• Concept and implementation of user communication (information page, changelog, known bugs)

Initial Situation:

The integrated capacity management platform (InKa) is a monitoring and analysis platform for data from timetable and capacity management: customer orders, infrastructure, timetable operations, construction, as well as route capacity and width. The data is stored and linked in a structured data warehouse. This makes it possible to create complex KPIs across different source systems and display current and future route utilization as well as construction activity across the network. The goal is to improve strategic, medium-term and intra-year planning and provide users with easy access to capacity management analyses.

Measures:

• Enablement: Introduction of Power BI with training and workshops for development teams.
• Consulting & Design: Problem analysis, concepts and solution consulting for reporting requirements; implementation of reporting solution plans.
• Data Model: Development of shared datasets with DirectQuery on Amazon Redshift and import tables; DAX measures for utilization and capacity KPIs.
• Development: Data analysis, data transformation and visualization in Power BI; extension and migration of business applications to Power BI; AI-supported development in VS Code with GitHub Copilot.
• Test Automation: Automated testing of Power BI reports with Playwright; setup of the test environment in Docker containers.
• User Communication: Concept and implementation of a central information page with hot news, changelog and known bugs, access from reports with report filters, updates via Power Automate.
• Deployment: Management of Power BI Deployment Pipelines across the DEV, TEST and PROD environments.
• Agile Working: Work in an agile team according to SAFe (Scaled Agile Framework); refinement of user stories and features including effort estimates in Jira; version control with Git and GitLab.
• Quality & Documentation: Reviews for quality assurance, error analysis and resolution, technical documentation in AsciiDoc and Confluence.

Technologies: Power BI, DAX, Power Query, DirectQuery, Amazon Redshift, Git / GitLab, Deployment Pipelines, Playwright, Docker, AsciiDoc, Power Automate, Jira, Confluence, VS Code with GitHub Copilot, SAFe

Results:

• Capacity management KPIs from multiple source systems combined on one platform
• Transparency regarding current and future route utilization and construction activity across the network
• Easy access to analyses for users
• Automated regression testing of Power BI reports
• User communication implemented: central information page with hot news, changelog and known bugs, directly accessible from the reports

• Electronics – Surface Solutions | Carve-out of IT, data and system landscape*

• Separation of a full business division's IT, data and system landscape following divestment across cloud, on-premises and connected laboratory systems; centrally governed investment envelope in the three-digit m€ range

• Laboratory notebook and laboratory analytics platform stream: Palantir Foundry, Snowflake, Signals Notebook, Power BI and connected laboratory instrumentation; SharePoint and JIRA; site transition completed without interruption to laboratory operations

• Decision authority and escalation point for business, IT infrastructure, IT security and vendors; separation executed across globally distributed users and systems and handed over on schedule, avoiding a contractual penalty for the client

• Optimized the data architecture (Medallion) to better decouple processing steps and improve transparency and reproducibility

• Ensured the technical quality of data processing in Databricks by introducing schema enforcement, data quality checks, and a structured data architecture

• Pipeline orchestration with Azure Data Factory

• Improved and automated the development and deployment process by integrating Git and GitHub Actions

• Technical leadership of the Data Engineering team (3 employees)

• Led workshops to optimize and stabilize the data platform and development process

• Collected and prioritized new requests and maintained the product backlog

• Technologies: Microsoft Azure (Data Lake, Data Factory), Databricks, Apache Spark (PySpark), Python, SQL, Git, Confluence, Power BI, Power Apps, Dataverse, MS Sharepoint, Mural

• Impact: Structured requirements analysis and quality assurance as a foundation for the further development of a software solution.
• Analysis, documentation, and coordination of requirements. Conducting stakeholder analyses, interviews, and workshops to gather and validate requirements. Conducting requirements reviews and working closely with business departments and development teams.

Techniques & Tools: Requirements Engineering, Stakeholder Management, Workshop Facilitation, System Context Modeling, Requirements Reviews, Quality Scenarios, Miro, Jira, Confluence

Assignment focus: Leading digital restructuring in a highly regulated Defence and Aerospace environment. Focus areas: improving data flows and data quality, introducing paperless data collection in production, integrating machine data for automatic SPC calculation and process control, as well as cybersecurity analyses.

Main objectives:

• Analyze, structure and improve data flows and data quality in production
• Introduce paperless data collection in manufacturing areas
• Integrate machine data for automatic SPC data calculation and process control
• Implement digital restructuring while meeting regulatory requirements in the Defence environment

Measures and results:

• Analyzed and structured existing production data flows as a basis for control and reporting
• Established mechanisms to ensure data quality and availability across manufacturing areas
• Introduced paperless data collection in production — replacing manual and paper-based processes
• Integrated machine data for automatic SPC data calculation (control charts, Cp/Cpk) and real-time process control
• Conducted cybersecurity analyses in the production and IT environments

Area of responsibility: Project management for digital restructuring, paperless production, data management and data quality in a highly regulated Defence and Aerospace environment.

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.

• Architected an enterprise Fabric-based data-product governance framework, authoring data contracts and schema-validation KPIs to enforce completeness, freshness and SLA standards across reporting data products.
• Operationalized pipeline observability by integrating Dagster orchestration data into automated data-health reporting, proactively validating data integrity and pipeline reliability before production reporting layers refresh.
• Established BI-as-Code and end-to-end governance through Git-based version control, CI/CD and Alpha→GA release management, strengthening lineage, schema-drift detection and production change traceability.

• I support medium-sized clients with their funding needs.
• I evaluate operational business processes and translate complex legal and regulatory requirements into business requirements, target models and actionable roadmap epics.
• I use Generative AI tools and automation in a targeted way to efficiently create requirements documentation, process analyses, evaluations, meeting preparation materials, customer analyses and decision papers.

• Project: ESU Windows and SQL Server Consolidation / Configuration Management in ServiceNow
• Prepared an as-is analysis of all servers worldwide
• Prepared an as-is analysis of all SQL servers worldwide
• Conducted requirements analyses for SQL and server migrations
• Coordinated requirements with partners for migrations to Hyper-V (on-premises) or Azure Cloud
• Facilitated regular status meetings (Jour Fixe)
• Developed roadmaps and solution models for server migrations
• Set up test scenarios
• Facilitated workshops for the rollout of a global admin team
• Designed data models (CMDB) in ServiceNow
• Led workshops for the CMDB data model
• Developed solution models for the CMDB
• Created end-to-end configuration documentation and work instructions for the CMDB
• Prepared reports for license management
• Defined KPIs for data quality in ServiceNow
• Created a service catalog
• Facilitated workshops to define service requests
• Acted as interface between requirements analysis and the ServiceNow development team
• Systems used: Windows 7, Windows 10, Microsoft Office 365/2010, Windows Server 20xx, SQL Server 20xx, SharePoint, Azure Cloud, Hyper-V, ServiceNow, various tools

• Restructuring of the network architecture/topology, followed by installation, setup and testing of the network at a small business.
• Resolution of server (permissions and roles) and connection problems (WAN, (V)LAN, WLAN).
• Infrastructure support and maintenance.
• Creation of documents such as manuals, architecture documents and design documents.
• Revision of manuals and technical documents, as well as creation of VBA macros.
• Use of AI and basic prompting, as well as formulation of AI requests.
• Adjustment of workflows due to legal requirements and optimization of existing workflows.
• Delivery of courses and training for adaptations, new features and changed workflows.
• Modeling basis: BPMN.
• System environment: MS Office 2019/365, Win10/11, Teams, Netgear (Switch), QNAP, Synology (NAS), Linux (Ubuntu).

• Repaired a broken “ScrumBan” process, then established a pure Kanban system; increased output in the Kanban flow by 22% within four weeks

• Increased team autonomy and decision-making ability by implementing new decision strategies; resulting in up to 25% better outcomes

• Redesigned retrospectives (including one-to-one coaching and workshops), which led to consistent implementation of the resulting action items

• Intensive coaching of Product Owners (POs) to develop and support “Empowered Teams”, alongside leadership development to place agile frameworks and methods in a realistic context (“de-illusioning”)

• Supported change management processes to promote an agile company culture among management and teams, improving internal communication to increase transparency and effectiveness in agile processes