The ProMi Squad (Process Mining) project aims to transparently map the end-to-end order process in the portals area. Relevant data sources from ordering to activation are consolidated for this purpose. The holistic view of the end-to-end process enables the identification of process deviations and optimization potentials. Key milestones of the project are the integration of the required data sources, the development of self-service reports, and the implementation of automated alerts for deviations in the process flow. The challenge lies in the technical and functional integration of heterogeneous systems and data streams to ensure consistent monitoring and control of the order process. ⸻ Service description - Analysis and documentation of requirements in the omnichannel area using requirements management tools and structured elicitation methods - Functional and technical analysis of existing data sources and ETL processes using database tools - Recording and evaluation of existing interfaces between source and target systems based on technical documentation - Consulting on the technical integration of defined data sources into the Celonis environment, taking into account the tools used (Celonis EMS, Data Pool, and Data Push API) - Creation of technical queries and representations for process visualization based on the provided platform functions (Celonis PQL, Studio) - Use of system functions for visualization and analysis of existing business processes (via the Celonis Process Explorer) - Functional consulting on technical interfaces, data provisioning, and system prerequisites

Typical tasks: - Analyzing existing insurance processes and identifying digitalization potentials - Gathering and documenting business requirements together with the business units - Creating solution concepts for digital transformation (including process modeling and cost-benefit analyses) - Acting as liaison between business and IT: translating requirements into technical concepts and supporting implementation - Supporting project management in planning and deploying new digital solutions (agile methods such as Scrum/Kanban) Relevant tools & technologies: BPMN modeling tools (e.g. Visio, Signavio), requirements management (Jira, Confluence), knowledge of common insurance IT systems, MS Office KPIs & metrics: adherence to project milestones and budgets, reduction of process lead times, increase in customer satisfaction/user adoption, reduction of manual efforts through automation Challenges: coordinating multiple stakeholders in the insurance environment (business units, IT, regulatory), integrating new digital solutions into existing legacy systems, dealing with regulatory requirements and data protection, change management and user adoption Deliverables: comprehensive requirements documents and process models, developed business concepts and user stories for IT implementation, defined implementation roadmap, training materials for updated processes Lessons learned: early involvement of all stakeholders facilitates the implementation of digitalization projects; iterative, agile approaches enable flexible adjustments; in-depth industry knowledge (products, regulation) is crucial for designing viable digital solutions

For a client in the IT sector, an experienced IT architect with a focus on relational database management systems (RDBMS) is sought to take responsibility for the solution design of a new data-intensive application. - **Typical areas of responsibility:** - Analysis of existing system landscapes and gathering of functional and technical requirements for data storage. - Design and conception of a scalable, highly available, and secure RDBMS architecture (e.g., based on PostgreSQL, Oracle, or MS SQL Server). - Creation and optimization of data models (physical, logical) and definition of data flows. - Consulting of the development team in the implementation of database structures, stored procedures, and queries. - Planning and support of data migration strategies from legacy systems. - Definition of standards for backup, recovery, and disaster recovery scenarios. - **Relevant technologies, tools or methods:** - RDBMS: PostgreSQL, Oracle, MS SQL Server, MySQL/MariaDB - Cloud platforms: AWS RDS, Azure SQL, Google Cloud SQL - Modeling tools: ER/Studio, Sparx Enterprise Architect, draw.io - DevOps & IaC: Terraform, Ansible, Jenkins for database deployment automation - Monitoring: Prometheus, Grafana, specialized DB monitoring tools (e.g., pgAdmin, Oracle Enterprise Manager) - **Typical KPIs or success metrics:** - System availability and uptime (> 99.95%) - Response times of critical database queries (< 200ms) - Adherence to RTO/RPO targets (Recovery Time/Point Objective) - Scalability: performance under load simulation (e.g., 2x user growth) - Reduction of database operating costs through optimized design. - **Key challenges, risks or specifics:** - Ensuring data consistency and integrity in distributed systems. - Management of schema changes in production (zero-downtime deployment). - Balancing normalization and performance optimization (denormalization). - Securing sensitive data in accordance with GDPR and other compliance requirements. - **Concrete deliverables:** - Final architecture document (Solution Architecture Document) for the database solution. - Implemented and approved data model. - Proof-of-concept for critical non-functional requirements (e.g., high availability). - Migration plan and test protocols. - **Lessons learned / best practices:** - Early involvement of development and operations teams is essential. - Automated tests for database schema changes prevent regression errors. - Consider security-by-design from the outset, not as an add-on.

A company is looking for an experienced expert with comprehensive knowledge of License Manager, Inventory Server, and Integration Manager. The project’s goal is to optimize and integrate existing systems and ensure that all processes run efficiently and smoothly. In this role, the expert will work closely with internal teams to analyze requirements, implement solutions, and monitor the systems. Key responsibilities: - Analyzing and optimizing existing systems (License Manager, Inventory Server, Integration Manager) - Integrating new processes and tools - Collaborating with internal teams for requirements analysis - Ensuring system efficiency and security - Documenting and training teams

A company is looking for an experienced SAP Basis Architect to implement technical components in applications based on SAP S/4HANA, SAP BW/4HANA, JavaScript, ABAP, SQLScript and SAP HANA-native architecture. The focus is on roles and authorizations as well as SAP Basis related activities. The tasks include maintaining roles and authorizations in SAP ECC, applying and introducing the tool XAMS, creating system documentation, communicating with technical operations management and supporting transports and transport packages. In addition, the role includes handling technical basis topics such as performance, parameter settings, network and development. - Implementing technical components in SAP systems - Maintaining roles and authorizations in SAP ECC - Introducing and applying the tool XAMS - Creating system documentation - Supporting transports and transport packages - Implementing OSS Notes - Managing technical basis topics (performance, network, parameter settings)

A company is looking for an experienced Senior IT Consultant with a focus on Oracle HCM. The project’s goal is to support the management of the HR IT Data Management unit as well as the implementation and further development of HR IT systems in line with business requirements and strategic HR objectives. The consultant will play a key role in the GDPR-compliant provision of IT services, project initiation and execution, and collaboration with internal and external service providers. - Support in managing the HR IT Data Management unit - Strategy and organizational consulting - Implementation of HR IT systems for company-wide and internal data management - Ensuring GDPR-compliant provision of IT services - Conducting project initiation, planning, and execution - Collaboration with service providers and analysis of the cost-effectiveness of system application - Technical advancement of HR IT systems and implementation of innovative impulses, e.g., AI solutions

As part of the further development of reporting and analytics capabilities in the area of Business Continuity Management (BCM), the existing BI landscape is being migrated from Tableau to Microsoft Power BI. The goal is to build a future-proof, scalable data warehouse that provides a consolidated data foundation for enterprise-wide analyses. At the same time, existing reporting functionalities and automations in the HiScout standard software are to be analyzed and adapted with regard to new requirements. - **Consulting**: Advising on the architecture and building of a data warehouse based on Microsoft technologies (SQL Server, Power BI) - **Migration**: Consulting on the migration of existing reports and dashboards from Tableau to Power BI - **Data Analysis**: Analysis of existing data sources and design of suitable ETL processes - **Automation**: Integration and automation of data sources - **Requirements Analysis**: Conducting requirements analyses and creating technical concepts for reporting adjustments in HiScout - **Reporting**: Implementation and testing of reporting adjustments in HiScout - **Documentation**: Quality assurance and documentation of the work performed - **Training**: Consulting on the creation of training materials and knowledge transfer to internal teams

A company is seeking an experienced Business Analyst to adopt the product perspective within a squad and advise the Squad Owner (Product Owner) to maximize value creation while continuously incorporating customer and market insights. The Business Analyst will keep track of market requirements, coordinate with customers and partners, maintain the squad backlog, and ensure the professional quality of deliverables. The position requires independent, cross-functional analysis and alignment of business requirements directly with business units, squad owners, technical teams, and product management. - Advising the Squad Owner on the squad’s (partial) products and services, including technical components. - Supporting business aspects from ideation and concept through market launch and maintenance according to the life-cycle process. - Aligning and validating ideas and requirements, as well as assisting in the creation of user stories and maintenance of the squad backlog. - Shaping a customer-centric squad vision, coordinated roadmap, and release plan in line with corporate objectives. - Conducting innovation work and product-specific market observation to ensure competitiveness. - Ensuring stable operations according to agreed service level agreements and regulatory requirements. - Creating requirements specifications, documents, and service descriptions as part of product definition. - Closely coordinating on architecture and refactoring topics with architecture roles. - Ensuring functional and non-functional quality of deliverables by creating and executing test cases.

A company is looking for an experienced SAP Basis Administrator who specializes in the administration and operation of the SAP Basis system landscape. The focus of the project is to ensure a stable and high-performance SAP Basis operation as well as to support the ongoing SAP S/4HANA transformation. The administrator will also participate in system relocations, migrations, and the parallel operation of legacy systems, as well as handle troubleshooting, performance optimization, monitoring, and user management. - Administration and operation of the SAP Basis system landscape - Support in the provisioning and operation of SAP systems on IBM Power systems (Unix) - Collaboration on the ongoing SAP S/4HANA transformation - Participation in system relocations, migrations, and the parallel operation of legacy systems - Troubleshooting, performance optimization, monitoring, and user management

For the further development of a complex ServiceNow platform, a developer specializing in the middle layer is sought. The focus is on implementing business logic, integrations, and processing data between the frontend and backend systems. - **Typical areas of activity:** - Design and development of server-side business logic in ServiceNow using Business Rules, Script Includes, and Workflows. - Designing, implementing, and maintaining REST- and SOAP-based integrations with third-party systems (e.g., SAP, Jira, HR systems) via IntegrationHub or custom scripts. - Developing and optimizing data flows and transformations within the platform. - Performance analysis and optimization of server-side scripts and database interactions. - Ensuring platform stability and security through robust and error-resistant coding. - **Relevant technologies, tools, or methods:** - ServiceNow platform: in-depth knowledge of the Glide API (GlideRecord, GlideSystem), server-side scripting (JavaScript ES5). - Integrations: IntegrationHub (Spokes), REST/SOAP API Explorer, JSON, XML. - Automation: Flow Designer, Workflow Editor. - Development tools: ServiceNow Studio, VS Code with ServiceNow plugins. - Methodology: Agile (Scrum), use of Update Sets and Application Scopes for deployment. - **Typical KPIs or success metrics:** - Transaction response times for critical middle-layer processes. - Error rate in API calls and integrations (< 1%). - Success rate of automated workflows. - Code complexity (e.g., measured via SonarQube integration). - Adoption rate of new functionalities enabled by the middle layer. - **Specific challenges, risks, or specifics:** - Complexity of dependencies between various ServiceNow modules and external systems. - Ensuring scalability with high transaction volumes. - Debugging asynchronous processes and integrations. - Adhering to ServiceNow best practices to avoid jeopardizing platform upgradability ("out-of-the-box" vs. customizing). - **Concrete deliverables:** - Implemented and tested Script Includes and Business Rules. - Fully configured and documented integrations in IntegrationHub. - Technical documentation of developed logic and data flows. - Completed Update Sets, ready for deployment to the production environment. - **Lessons learned/best practices:** - Encapsulate reusable logic in Script Includes instead of duplicating it in multiple Business Rules. - Prefer asynchronous Business Rules for long-running operations to avoid blocking the user experience. - The Flow Designer is preferred over the classic Workflow Editor for new automations.

To support the further development of an innovative low-code platform, a highly qualified Senior Frontend Engineer is sought. The platform enables customers to build complex business applications with minimal coding effort, while seamless integration into existing SAP system landscapes is mission-critical. - Typical responsibilities: Designing, architecting, and implementing sophisticated, reusable frontend components and modules with React & TypeScript. Ensuring high code quality through code reviews, unit tests, and end-to-end tests. Performance optimization of the platform for a smooth user experience. Close collaboration in an agile Scrum team with Product Owners, UX/UI designers, and backend developers to deliver the product roadmap. Connecting SAP backend systems via REST and OData APIs. - Relevant technologies/tools: React, TypeScript, React Hooks, state management (e.g. Redux Toolkit, Zustand), SAP Business Technology Platform (BTP), UI5 Web Components, Storybook, Jest, React Testing Library, Cypress, Git, Jira, CI/CD. - KPIs/success metrics: Time-to-market for new platform features, Lighthouse performance score (>90), component reusability rate, reduction of reported frontend bugs by 25% per quarter, user adoption rate. - Key challenges: Finding the right balance between abstraction (low-code) and flexibility (specific customer requirements). Ensuring scalability and maintainability of the frontend architecture in a fast-growing product. Guaranteeing compatibility with various SAP system versions. - Deliverables: Implemented and tested features per user stories, expanded and documented component library (in Storybook), technical architecture documentation, sprint acceptance protocols. - Best practices: Applying clean code principles and design patterns (e.g. Atomic Design), establishing a comprehensive testing strategy, proactive communication within the team.

A company is looking for an experienced MES consultant focusing on Hydra X from MPDV to support the expansion of the system to additional sites. The system is already rolled out at one site and is now to be further scaled. The role includes supporting the introduction of new functions or versions of the system, implementing system adjustments and optimizations based on production requirements, as well as accompanying the rollout. The consultant will work closely with internal teams and external service providers to ensure the rapid identification and resolution of issues in the MES system. - Support in the introduction of new functions or versions of the system - Implementation of system adjustments and optimizations based on production requirements - Assistance with the rollout to additional sites - Rapid identification and resolution of problems in the MES system

A company is looking for an expert with comprehensive technical expertise in cadastral surveying in North Rhine-Westphalia. The aim of the project is to optimize the business processes of the cadastral authorities and to incorporate scientific findings from the fields of geodesy and artificial intelligence to develop innovative solutions. The role requires a combination of practical experience, scientific work, and the ability to analyze and improve complex processes. Key responsibilities: - Analysis and optimization of the business processes of the cadastral authorities in NRW - Application of scientific findings in geodesy and artificial intelligence - Development and implementation of innovative solutions - Collaboration with interdisciplinary teams - Preparation of reports and presentations for stakeholders

Setting up and further development of a Customer Data Platform (CDP) to optimize digital marketing campaigns. The goal is to create a 360-degree view of the customer. - Typical areas of responsibility: conceptualizing the CDP strategy, defining use cases, integrating data from various sources (CRM, web analytics, email marketing), segmenting target audiences, setting up and monitoring personalized marketing automation workflows, performance analysis and reporting. - Relevant technologies, tools or methods: CDP systems (e.g. Segment, Tealium, mParticle), CRM systems (e.g. Salesforce), web analytics tools (e.g. Google Analytics), email marketing tools, A/B testing frameworks, SQL, data visualization tools (e.g. Tableau). - Industry-typical KPIs or success metrics: conversion rate, customer lifetime value (CLV), churn rate, marketing ROI, engagement rate, number of customer profiles captured in the CDP. - Special challenges, risks or specifics: ensuring GDPR compliance, data quality and harmonization, complex system integrations, building internal know-how, platform scalability. - Concrete examples of deliverables: implemented and configured CDP, documentation of data flows and use cases, deployed automation campaigns, regular performance dashboards, training materials for the marketing team.

A company from the automotive sector is looking for an experienced expert in Snow Software components to execute a release migration. The Snow Software components (License Manager, Inventory Server, Integration Manager) are used for software license management and inventory. The goal of the project is to ensure the security, stability, and functionality of the systems by upgrading to the current version. Experiences from the last comparable update should be incorporated into the planning. The role includes planning, execution, and follow-up of the release migration, including creating a migration plan, aligning with stakeholders, performing functional tests, and documenting all measures. Key responsibilities: - Creation of a migration plan for test and production environments - Identification and documentation of all necessary steps, resources, and dependencies - Coordination of downtime windows with relevant stakeholders - Execution of the updates during the agreed downtime - Ensuring flawless installation of the new versions - Performing functional tests and error analysis - Documenting all measures and producing a final report - Handover to operations including lessons learned

A company is looking for an expert in handling ECLASS for product classification. The goal of the project is to create a company-wide classification system for unambiguous description of products and services, similar to ECLASS. The expert will work closely with the specialist departments to capture company-specific requirements and terms. In addition, a central database structure for the classification system will be created, documented, and a training concept for company-wide application and integration will be developed. - Creation of a company-wide classification system for unambiguous description of products and services. - Coordination with specialist departments to capture company-specific requirements and terms. - Development of a central database structure for the classification system. - Documentation and creation of training concepts for company-wide application and integration.

A company in the decentralized ventilation systems sector is looking for an experienced Odoo CRM expert to implement and customize Odoo CRM and the Sales module. The goal is to map sales processes efficiently and train an internal team member so that she can independently work with the system in the future. - Setup and customization of Odoo CRM and Sales module - Development of efficient workflows (Lead → Quotation → Order) - User roles and permissions management - Configuration of custom fields, filters, and dashboards - Assistance with data import - Training of the internal project team member

We are seeking an experienced consultant for a process and project initiative in the area of Asset P&L (Profit and Loss) at a leading international financial services provider. - Typical areas of responsibility in this role:** - Analysis and documentation of existing end-to-end P&L processes for various asset classes (e.g., equities, fixed income, derivatives). - Identification of weaknesses, risks, and inefficiencies in data collection, processing, and reporting. - Design and conceptualization of optimized target processes for P&L calculation and attribution. - Development of functional specifications and business requirements for adapting or implementing IT systems (e.g., P&L engines, data warehouses). - Project management for the implementation of new processes and tools, including milestone planning, stakeholder management, and test coordination. - Development of control mechanisms to ensure data quality and consistency. - Creation of training materials and delivery of workshops for business units (trading, controlling, risk). - Relevant technologies, tools or methods:** - Advanced analytics: MS Excel (Pivot, Power Query, VBA), SQL. - Business intelligence: Tableau, Power BI, Qlik. - Project management: Jira, Confluence, MS Project. - ERP/finance systems: SAP FI/CO, Oracle Financials, or industry-specific asset management platforms. - Methods: Business Process Model and Notation (BPMN 2.0), agile project management (Scrum/Kanban). - Typical KPIs or success metrics:** - Reduction of P&L generation time (cycle time): target >25% efficiency gain. - Decrease in manual corrective postings: target >50% reduction through process automation. - Data quality index: increase of the "first-time-right" rate in data acquisition to >99%. - Efficiency ratio (cost-to-income): demonstrable positive impact on lowering the ratio. - User adoption rate: acceptance of new processes/tools by the business >80% after 3 months. - Key challenges, risks or specifics:** - Heterogeneous system landscapes and inconsistent data sources (data silos). - High complexity of financial products and valuation models. - Resistance to process changes in business units (change management). - Ensuring compliance with regulatory requirements (e.g., IFRS 9, BCBS 239). - Time- and budget-critical implementation during ongoing operations. - Concrete deliverables (“Deliverables”):** - Milestone 1: Completed as-is analysis and process documentation. - Deliverable 1: Detailed analysis report including assessment of weaknesses. - Milestone 2: Finalized target concept and Business Requirements Document. - Deliverable 2: Implementation roadmap and project plan. - Milestone 3: Successful User Acceptance Test (UAT) of the new process/tool. - Deliverable 3: Acceptance protocols, training materials, and project closure report.

Design and build a modern data platform in the Azure Cloud for an e-commerce company. Implementation of scalable data pipelines and a lakehouse architecture. - **Typical tasks:** - Design and implementation of ETL/ELT processes with Azure Data Factory/Databricks. - Setup and management of data infrastructure (Data Lake, Synapse). - Development of data models and ensuring data quality. - Automation of deployments using IaC (Terraform). - Performance tuning and coordination with stakeholders. - **Relevant technologies, tools & methods:** - Azure Data Factory, Synapse, Databricks, Data Lake Storage. - Apache Spark, Delta Lake. - Python (PySpark), SQL. - Terraform, Azure DevOps. - **Typical KPIs & success metrics:** - Data latency, pipeline uptime (>99.9%), query performance, cost efficiency. - **Key challenges & risks:** - High data volumes, GDPR compliance, avoiding data silos. - **Deliverables:** - Production-ready data pipelines, structured data lake/warehouse, IaC scripts, technical documentation.

- Customizing / parametrization of the core banking system according to the requirements of the business division - Maintaining ongoing operations - Initial and further training of internal staff