Data Modeling Experts in Frankfurt

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.

• Supporting the International Web Presence of the BA (IntWeb) project in the area of quality management, with the aim of taking responsibility for the quality of processes and project results while considering BA standards. The main objectives of the project are to give professionals abroad a quick overview of their opportunities for moving to Germany and to enable them to take the necessary steps consistently and with digital support by providing access to services.

• Defining the general guidelines in the QA handbook

• Summarising test results in QA reports for PLA

• Analysing project results for improvement opportunities

• Quality management of requirements analysis (particularly processes, methods, and tools)

• Ensuring compliance with SERA requirements

• Creating a cross-project test concept

• Agreeing on sprint completion reports

• Formal review of work results in accordance with requirements and/or the project plan

• Contact person for internal audit, external audits by auditors, or BRH (Federal Court of Audit)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

Asset of GPP (Private Equity)

• B2B, Provider of cooled packaging solutions for the pharmaceutical industry
• €20m in revenue, 50 employees, 2 locations

Responsibilities:

• Responsibility for all commercial and financial activities
• Establishment of a finance and reporting structure
• Carve-Out / Post-closing transition management

Achievements:

• Preparation of investor reporting package (sales, financials, cash) using Power BI
• Development of a sales funnel
• Business process redesigns and implementation of regular business reviews

Independently built a data platform with cross-system process monitoring.

• Designed the Bronze/Silver/Gold architecture and Python-based pipelines for diverse operational sources.
• Cleaned, harmonized, and validated data; processed and stored it in Parquet format.
• Tracked data history and built business-focused fact and dimension models for traceable reporting.
• Automated data delivery with Python and Power Automate (desktop and cloud); used SharePoint for archiving and data access.
• Developed the Power BI solution from data preparation through to visualizing process statuses, work progress, and deviations.

Technologies: Python, SQL, Parquet, Power BI, Power Query, Power Automate, SharePoint, Copilot

• Analysis of the existing reporting platform, including processes and governance topics, with stakeholders from Sales and Marketing.

• Detailed analysis and evaluation of customer-defined requirements for existing reporting and new dashboards to be established.

• Support for stakeholders in managing sales processes and identifying KPI trends at an early stage.

• Use of Microsoft Power BI as the central analysis and reporting platform.

• Development of a proposal for the required further development of processes and the Power BI platform.

• Documentation of AS-IS business processes and derivation of company-wide KPIs, including coordination with stakeholders.

• Analysis and assessment of the customer's Power BI platform.

• Analysis of processes and data governance.

• Documentation of AS-IS business processes.

• Development of recommendations for further developing processes and the reporting platform.

• Design and implementation of dashboards in Power BI.

• Development of company-wide KPIs and coordination with stakeholders.

• Microsoft Power BI.

• Data analytics.

• KPI definition and reporting.

• Dashboard design and data visualization.

• Stakeholder management and requirements management.

Project, Strategic Consulting – building the Data Strategy and Data Governance Policy for the German branch, client (private bank Julius Bär, headquarters Zurich), March 2026 – present

• Design and negotiation of the data strategy with key stakeholders, including obtaining board sign-off (strategic consulting) – in this context, regulatory advice on data regulations in the EU and specifically for Germany. The data strategy includes: Data Lifecycle Management: data capture, data storage, data usage, data retention policy, data quality incident management
• Definition of milestones and technical feasibility for implementing TOM for the data strategy, data quality checks, metrics, and a metadata inventory to ensure the bank’s compliance with DORA, BCBS239, and MaRisk requirements.

Core project data change, client: (ING Bank, Frankfurt am Main), March – December 2025

• Concept development and solution design for new end-to-end processes including technical interfaces
• Definition of synchronization logic and data flows between legacy and target systems (decommissioning of legacy systems)
• Analysis and validation of data models
• Stakeholder communication with product owners, feature engineers, UX designers, and operational teams for decision-making
• Analytics and impact assessments, e.g. to assess downstream effects and regulatory requirements
• Documentation and comments on technical and business requirements to support implementation in agile squads

Project digitalization of a user group, client: (ING Bank, Frankfurt am Main), as Interim Product Owner, Jan 2025 – present

• Co-shaping key decisions on data architecture and process logic in the context of historized data and user login functionality
• Development of business solution concepts for migration to the target system, including system integration and data flows
• Support with analytics and impact analyses, especially regarding the ability to provide information to law enforcement authorities
• Active coordination with stakeholders from different squads to support decision-making and ensure regulatory requirements are met
• Creation of test scenarios for operational teams and backend systems in the area of API management using Postman and Bruno.

• Analyze business situation: stagnation of sales, small recurring customer rate, huge number of visitors but little conversion rate, average order value does not increase, no customer segmentation or targeting, performance marketing approach fails to acquire the right customer
• Advise on sales and marketing strategies and improve operations; agile coach advice with key business strategy using Scrum and Kanban
• Acquire key requirements and derive user stories for e-shop product owner development and customer data analysis
• Develop comprehensive 360 degree customer data model using Shopify and Amazon; implement data feeds from more than 10 systems (Klaviyo, Typeform)
• Develop meaningful ad-hoc data analysis detailing aspects of Triple Whale customer behavior using standard e-commerce KPIs such as AOV, Google Analytics, churn, conversion and abandoned checkout rates, ROAS, CPA, CPC; tools: SQL, Power Query
• Derive clear and data-driven customer segmentation and targeting; ETL processes and Power BI
• Introduce and feed new content agency with customer insights using GraphQL and Postman; improve messages, frequency, and targeted audience; Microsoft Planner
• Provide crystal clear data proof to steer new performance marketing approach
• Develop standard business operations reporting

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.

• Manage and coordinate various software development projects between product management and agile dev teams of external service providers
• Communication with all stakeholders
• Promoting transparency and focus on project topics
• Facilitating alignment between business departments and external partners
• Supporting Product Managers and Product Owners in preparing and managing requirements in workshops and tools
• Using short feedback loops to optimize agile collaboration
• Supporting hybrid and agile collaboration

• Designed a network management strategy focused on NetDevOps principles and model-driven telemetry using YANG data models
• Conducted NETCONF/YANG workshops for L2VPN/L3VPN services over SRv6
• Automated configuration deployment in the testing environment with Ansible
• Developed end-to-end service measurement concepts with IPSLA and the Telegraf-Prometheus-Grafana stack
• Created the dual-stack architecture design (router + switch + firewall) including a detailed test plan; planned, executed, and documented acceptance tests for the management network
• Performed BSI IT baseline protection checks according to the IT-Grundschutz catalog (needs assessment, modeling, risk analysis, deriving measures)
• Protocols: SRv6, IPv6, MPLS, BGP, ISIS, OSPF, NETCONF/YANG, model-driven telemetry, IPSLA
• Systems: Cisco Crosswork Network Controller, SolarWinds Orion, Grafana, InfluxDB, Telegraf, Ansible, Git
• Components: Cisco NCS router series, Cisco Catalyst switch series, Cisco Firepower firewall series

• Development and implementation of backend components with PL/SQL and Oracle Forms 12c. Adaptation and further development of the policy administration system. Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.
• The project takes place in the technical environment of BIPRO, SQL databases and Oracle Forms applications. The assigned work includes backend development and technical further development in the above project with the following tasks:
• Development and implementation of backend components with PL/SQL and Oracle Forms 12c to technically map the business processes and ensure a stable and efficient system architecture
• Adaptation and further development of the policy administration system to ensure system functionality in line with the requirements of the new broker communication program
• Analysis of the existing system to identify and avoid errors and technical problems during implementation, in order to enable a smooth transition to the new system
• Carrying out patching and further development of existing Oracle and Oracle Forms applications to ensure compatibility and security of the systems in use
• Technical consulting in UI design with a focus on integrating existing Oracle Forms and the requirements of the BIPRO framework.

Label: PL/SQL, Java, Oracle RDBMS and Oracle Forms

• Spearheaded the development and deployment of a Generative AI solution tailored for the automotive industry focusing on improving customer experience through AI-driven innovations.

• Conducted in-depth market research to understand unique challenges and opportunities within the automotive sector by analyzing industry trends, customer pain points, and competitive offerings to inform the product strategy.

• Formulated a strategic vision for the Generative AI solution targeting personalized customer experiences, aligned product vision with the company’s long-term goals and automotive market demands.

• Enhanced customer satisfaction by introducing personalized AI-driven features, achieving a 15% increase in customer engagement and loyalty.

• Attended and represented Audi AG on a group-wide level in workshops for AI strategy for customer experience.

• Leveraged knowledge of recurrent neural networks and transformer architecture.

• Utilized GPT-3 generative AI frameworks.

• Employed TensorFlow and PyTorch for machine learning.

• Used Tableau from Salesforce for data analysis and visualization.

• Served as solution manager for the Business Architecture team.

• Collaborated with business stakeholders within Audi OEM to gather requirements for CRM strategy including marketing department, CRM heads across countries, VW group brands and CARIAD SE.

• Represented Audi AG in CRM strategy workshops held in different countries.

• Discussed CRM strategy with head of CRM and Data based on workshop outcomes.

• Conducted business analysis on gathered market data to improve customer experience.

• Planned and launched marketing campaigns such as welcome mailing, license renewal reminders, Audi Progress Circle and Black Friday campaigns.

• Managed project budget.

• Acted as solution manager for the ONE.CRM team at CARIAD SE on loan from Audi AG.

• Collaborated with business owners of VW group brands to develop a central solution.

• Represented CARIAD SE in CRM strategy workshops in Spain, France and Italy.

• Discussed CRM strategy with head of CRM at CARIAD SE based on workshop outcomes.

• Conducted business analysis on market and brand data to improve customer experience.

• Planned and delivered campaign capabilities from template to brands such as welcome mailing for Audi AG, SEAT and SKODA.

• Managed project budget together with head of CRM.

• Design an interactive Tableau dashboard to analyze historical aviation accidents using data from the Federal Bureau of Aircraft Accident Investigation
• Develop visualizations to provide actionable insights to improve aviation safety measures employing data modeling and transformation techniques
• Develop a Power BI dashboard to monitor sales KPIs and product performance integrating data from multiple sources
• Design a star schema data model and implement advanced DAX measures for high-performance and dynamic reporting
• Design a comprehensive BI architecture solution focusing on ETL pipelines, data integration, and data governance
• Recommend Power BI as the central tool and create a security-compliant implementation roadmap

• ITSM consulting, analysis and optimization of IT capacity with BMC TSCO / BMC Helix
• Drafting "Governance guidelines for operational capacity management"