Data Warehouse Expert in Frankfurt

• 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.

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.

• Designed and specified the technical network integration of a new business-critical application system (MUREX) in the capital markets area in a complex interface and outsourcing environment.

• Created component specifications, a catalog of measures and an implementation plan.

• Ensured proper integration of the developed results in line with the bank’s framework: IT compliance, IT security, change and release management.

• Selected and integrated a new service provider for the bank; moved critical bank applications to the provider.

• Designed, implemented and supported the new Cisco network and Fortinet security setup at the service provider data center.

• Acted as technical interface between the bank, service providers and consulting partners.

• Supported and further developed the network and security infrastructure (clients, servers, networks); performed error analysis and implemented solutions within agreed service levels.

• Analyzed and diagnosed all security and network failures, glitches and malfunctions.

• Initiated continuous improvements to ensure efficient resource use and acceptable response times for users.

• Provided network support in a financial services organization and prepared operational changes on production banking network infrastructure for both large and small projects within strict change management discipline.

• Designed, defined, tested, governed and improved engineering standards.

• Performed the role of network architect for medium to large projects involving team resources.

• Supported the International Web Presence project of the Federal Employment Agency (IntWeb) in quality management, taking on responsibility for the quality of processes and project deliverables while adhering to BA standards. The project's main goals are to give professionals abroad a quick overview of their chances to move to Germany and to enable them to take the necessary steps in a consistently digital way.

• Set the fundamental guidelines using the QA handbook

• Summarized test results in QA reports for PLA

• Analyzed project outcomes for improvement opportunities

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

• Ensured compliance with SERA guidelines

• Created a cross-project test concept

• Agreed on sprint completion reports

• Conducted formal reviews of deliverables according to guidelines and/or project plan

• Acted as contact person for internal audit and external audits by auditors or the Federal Audit Office (BRH)

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

• Datastage 11.7, dbt, Oracle 19, Python 3.12 / PySpark 3.5, Azure GitHub, Azure DevOps, Automic
• Development of migration jobs to transfer data from the collection DWH to the new Risk Mart, as well as development of ETL pipelines to migrate historical data from the old Mart to the new Risk Mart.
• Storage of the silver layer on Hadoop and the gold layer in Oracle.
• Translation of DataStage jobs into dbt to publish reporting data in Google Cloud to a PostgreSQL database.
• Creation and optimization of complex SQL queries for data extraction from a data vault, taking into account historical data in the point-in-time tables.
• Creation of Oracle table definitions (DDL) and adjustment of existing stored procedures.
• Versioning changes in GitHub and deployment via the CI/CD portal.
• Refactoring long-running DataStage jobs into Python using PySpark to reduce server load.
• Migration of SAS scripts to PL/SQL, including new development of distribution functions that have no direct equivalent in Oracle.
• Development of Automic jobs to run DataStage pipelines and Python scripts (PySpark jobs) that control the population of the SME and institutional risk tables in the Risk Mart and perform business calculations.
• Participation in the agile process, including creating user stories, estimations, and planning in Azure DevOps.
• Handling Azure DevOps tickets and close collaboration with testers and business teams for error analysis and resolution.

• Testing the SekIDP and related components
• Test design, execution and automation, microservices, GitHub Enterprise, Eclipse, Katalon Test Platform, API Testing, Confluence 8, JIRA/Xray, Draw.io, Swagger/OpenAPI, Postman, Docker, Kubernetes, Podman, PuTTY, E-Health, Telematik, Gematik standards, EPA, E-Rezept, sektoraler IDP, encryption, XaDES, PaDES, DICOM, HL7, FHIR, IHE, ICD, SSO, SAML/Shibboleth, OAuth, smartcards, JWT, two factor authentication Android and iOS, Wireshark, BrowserStack, Cypress, gRPC, REST, SOAP, WS-Security, Linux Shell, PowerShell, SSH/SSL, Java, Kotlin, Cordova, Gradle, Groovy, Python, TypeScript

• Analysis of web and campaign performance to derive actionable insights for marketing and growth optimization
• Implementation and maintenance of tag management solutions to ensure reliable and consistent data collection
• Continuous development and optimization of reporting structures with a focus on scalability and data quality
• Conducting regular deep-dive analyses and leading monthly stakeholder sessions to present findings and align on optimization measures
• Designing and managing end-to-end data flows from data collection to visualization
• Tools: GA4, Google Tag Manager, Looker Studio, Airbyte, BigQuery

• Project planning and resource planning
• Requirements definition and technology selection
• Data migration and risk management
• Monitoring up to go-live
• Tools: Office365, Jira XRAY, Strato, Onboarding App

• Microsoft Azure: design, sizing, and capacity analysis including PoC
• Microsoft Azure: final implementation for migration from on-prem RAC to single instance Data Guard
• Performance tuning and troubleshooting for crew management systems (pilots and briefings)
• Design and implementation of a disaster recovery-aware system based on RAC Extended Cluster and Data Guard
• OEM: Oracle Cloud Control maintenance, installation and upgrades (12.1.0.5 > 13.3 > 13.5)
• OEM: creating an agent golden image with new RU and security fixes for a full-scale environment
• OEM agent upgrade
• OEM: developing custom metric extensions and reports
• OEM: full monitoring setup with template collection and monitoring templates and incident rule configuration
• Upgrades: GI from 11.2.0.4 to 12.1.0.2, to 18.4, to 19.6+
• Upgrades: databases from 11.2.0.2 to 12.1.0.2, to 19.18+
• Redesign and license optimization based on Oracle SE on ODA and DBVisit
• Design of a virtualized platform based on OLVM and license optimization using hard partitioning
• Migration of databases from bare metal to OLVM

• The replacement of the existing archive system (document management system – DMS) on a host-based platform is well advanced.

• The internal audit is meant to ensure the company's quality standards.

• GDPR

• ISO 27001 ff.

• BSI

• DORA

• Patient data regulations

• Host / Cloud / S3 / Container / highly scalable / Nuxeo

• Budget: 50,000

• Team: 1

• Highly successful role as lead data analytics expert at a US consulting startup.
• Managed stakeholder expectations by ensuring team delivery velocity using Agile and Lean practices.
• Trained and assembled international offshore data science teams of DevOps engineers, BI developers, and technical support specialists.
• As Sparecodes' data analytics experts, we improved our clients’ business outcomes through requirements management, dashboard and report development, migration, automation, and production support using IBM Cognos, AWS, SAP, Oracle, Teradata, CRM, ERP, Confluence, and Microsoft.
• Provided effective coaching and mentoring for international, multicultural teams in a remote environment, covering new tools and techniques, Agile best practices, internal and external communication, and presentation skills.
• Coordinated technical processes efficiently, including managing and implementing project changes and control processes.
• Promoted strong team engagement and supported employees’ career development, including business change management through coaching.
• Enhanced project status reports by providing insights into team productivity, predictability, and backlog burn-down, leading to improved project outcomes.
• Successfully led the coordination and implementation of software solutions for clients in mechanical engineering, including automation system integration and customization to meet client needs.

• Involved in the full development lifecycle, including design, coding, testing, and deployment of Java-based applications.
• Built and maintained high-performance RESTful APIs and microservices, ensuring scalability and reliable data exchange.
• Practiced code reviews, used version control systems (e.g., Git), and collaborated closely with cross-functional teams to deliver robust software solutions.
• Implemented, managed, and optimized complex business logic and decision-making processes using the Drools Rules Engine, leveraging DRL (Drools Rule Language) for dynamic configuration.
• Developed software solutions for a major service provider in the healthcare insurance sector, specifically focusing on claims processing and reconciliation logic to ensure cost-effective reimbursement for health funds.

• Developed a retrieval-augmented generation (RAG) application using LangChain and LangGraph for corporate document parsing, delivered as an installable Electron desktop application with local AI models via Ollama.
• Currently providing ongoing AI feature support for the Loan Pricing Tool at Hamburg Commercial Bank, with a commitment of three days per month.
• Architected Kubernetes-native solutions, including Helm chart configuration and Azure DevOps pipeline integration.

• Creation and implementation of a multilingual, relational MariaDB database to reflect the requirements of a booking system designed for safaris in Africa
• Testing the front- and backend functionality, registration of clients and suppliers, the editorial system and the payment workflow
• Defect management and documentation via BugHerd
• Implementation of an automatic internal deployment of deliveries provided by an external company via bash scripts
• Coordination of external companies in the function of a project manager (Stakeholder Management)