Data Warehouse Experts in Frankfurt

• 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

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.

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

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

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

• Ensured proper integration of developed results in accordance 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 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 enhancements to guarantee efficient resource utilization and acceptable response times to users.

• Provided network support in financial service organization and operational change preparation 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 role of network architect for medium-large projects involving team resources.

• 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

• 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

• 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 results and align on optimization measures
• Design and operation of end-to-end data flows from data collection to visualization
• Tools: GA4, Google Tag Manager, Looker Studio, Airbyte, BigQuery

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

• Planning, management and execution of six integration projects for the in-vehicle passenger information system
• Agile software development using Scrum
• Full responsibility for quality, schedule, scope and budget of the integration projects
• Supporting further development of product groups and services (Wi-Fi & network) and implementing new features
• Preparing and updating change requests and releases in JIRA, and reviewing supplier and integration lab tests