In the context of further developing the reporting and analytics capabilities in 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 standard software HiScout will be analyzed and adjusted to meet new requirements. - **Consulting**: Advising on the architecture and setup of a data warehouse based on Microsoft technologies (SQL Server, Power BI) - **Migration**: Advising on migrating existing reports and dashboards from Tableau to Power BI - **Data Analysis**: Analyzing existing data sources and designing appropriate ETL processes - **Automation**: Connecting and automating data sources - **Requirements Analysis**: Conducting requirements analyses and creating technical concepts for reporting adjustments in HiScout - **Reporting**: Implementing and testing reporting adjustments in HiScout - **Documentation**: Quality assurance and documentation of completed work - **Training**: Advising on creating training materials and transferring know-how to internal teams

The ProMi Squad (Process Mining) project aims to fully map the end-to-end order process in the portals area with full transparency. Relevant data sources from order placement to activation are consolidated. This holistic view of the process enables the identification of process deviations and optimization opportunities. Key project milestones include connecting the required data sources, building self-service reports, and implementing automated alerts for process deviations. The challenge lies in the technical and business consolidation of heterogeneous systems and data flows to ensure consistent monitoring and control of the order process. ⸻ Service description - Analyze and document requirements in the omnichannel area using requirement management tools and structured elicitation methods - Perform business and technical analysis of existing data sources and ETL processes using database tools - Capture and evaluate existing interfaces between source and target systems based on technical documentation - Advise on the technical integration of defined data sources into the Celonis environment, considering tools like Celonis EMS, Data Pool, and Data Push API - Create technical queries and visuals for process representation using platform features (Celonis PQL, Studio) - Use built-in system functions to visualize and analyze current business processes (via the Celonis Process Explorer) - Provide business advice on technical interfaces, data provisioning, and system prerequisites

- Development and enhancement of data management in SQL Server for fixed network and all-IP products, and integration of existing and new data sources from SQL Server/Oracle from CRM systems and workflow management systems - Building a database in SQL that collects and consolidates data from different source systems (CRM and workflow systems) - Creating and extending database analyses in Tableau for daily reporting - Advising business units (e.g., Technology, Order Management) on data collection and customer data management - Continuous optimization and establishment of the data management process and data quality for future projects

A company is seeking support for a project aimed at transparently mapping the overall ordering process in the Portals area. The goal is to combine relevant data sources from order to activation to enable a holistic view of the end-to-end process. This should facilitate the identification of process deviations and optimization potentials. Key project milestones include connecting the required data sources, building self-service reports, and implementing automated alerts for deviations in the process flow. The challenge lies in the technical and professional integration of heterogeneous systems and data flows to ensure consistent monitoring and control of the ordering process. - Analysis and documentation of requirements in the Omnichannel area using requirements management tools and structured collection methods - Professional 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 technical integration of defined data sources into the Celonis environment considering the tools used (Celonis EMS, Data Pool and Data Push API) - Creation of technical queries and representations for process visualization based on provided platform functions (Celonis PQL, Studio) - Use of system-side functions for visualization and analysis of existing business processes (via Celonis Process Explorer) - Professional consulting on technical interfaces, data provision and systemic requirements

Design and build a modern data platform in the Azure Cloud for an e-commerce company. Implement scalable data pipelines and a lakehouse architecture. - **Typical responsibilities:** - Designing and implementing ETL/ELT processes with Azure Data Factory/Databricks. - Building and managing the data infrastructure (Data Lake, Synapse). - Developing data models and ensuring data quality. - Automating deployments using IaC (Terraform). - Performance tuning and coordinating 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.

A company is seeking support in setting up or optimizing a structured funding controlling system for municipal energy, infrastructure, or digitization projects. The goal is to increase efficiency and transparency in the use of funding and ensure compliance with funding regulations. The role includes identifying suitable funding programs at the EU, federal, and state levels, assisting with applications, fund disbursements, and preparation of usage reports. It also involves setting up a monitoring and reporting system (e.g., in Excel) that aligns project plans with funding requirements. Consulting on processes and interfaces such as accounting and project management, as well as training internal teams as needed, are also part of the tasks. - Identification of suitable funding programs (EU, federal, state) - Support with application, fund disbursement, and usage reports - Setting up monitoring/reporting (e.g., in Excel) - Aligning project plans with funding requirements - Consulting on processes and interfaces (e.g., accounting, project management) - Training internal teams as needed

- Performing and handling change processes (supplier change, new registration, move-in/move-out) - Independently handling clarification cases with analysis of rejection reasons and follow-up - Supporting market communication and related areas (e.g., meter reading, billing) at least at 2nd-level - Ensuring smooth workflows within energy industry processes

We are the Defense Tech Incubator NRW – a new initiative to support innovative startups in defense technology. Our goal: to connect the best minds and technologies with industry, public stakeholders, and investors – enabling sustainable innovations for security-critical applications. To strengthen our operations team, we are looking for an experienced professional from the defense sector – ideally with experience as an officer in the Bundeswehr or with many years at one of the leading system houses (e.g. Rheinmetall, Hensoldt, MBDA, etc.). - Your tasks: - Identification, outreach, and acquisition of potential partner companies (e.g. from industry, defense, and IT) - Building and maintaining this investor network - Contributing to our financing strategy for the incubator - Representing the incubator at industry events, trade shows, and networks - Supporting the development of strategic alliances at the state and federal level

On behalf of a renowned client in the life sciences sector, freelance support is sought in Clinical Data Management. The main task is to be responsible for coordinating all data management activities in clinical studies. - Typical responsibilities in this role:** - Creation and review of the Data Management Plan (DMP) and the Data Validation Plan (DVP). - Design and implementation of electronic case report forms (eCRFs) in EDC systems (Electronic Data Capture). - Coordination of data collection, validation, and cleaning throughout the study cycle. - Development and execution of query processes to resolve data inconsistencies with study sites. - Medical coding of adverse events (AEs) and medications (e.g., using MedDRA, WHODrug). - Conducting SAE reconciliation (serious adverse event reconciliation). - Preparation and execution of database lock after data collection is complete. - Preparation of status reports and communication with the study team (project management, monitoring, biostatistics). - Relevant technologies, tools or methods:** - EDC systems: Medidata Rave, Oracle Clinical, Viedoc, Zelta, OpenClinica. - Programming languages/analysis tools: SAS, R, Python, SQL. - Standards: CDISC (SDTM, ADaM), GCP (Good Clinical Practice), 21 CFR Part 11. - Collaboration tools: MS Teams, Jira, Confluence. - Data visualization: Tableau, Power BI. - Typical KPIs or success metrics:** - Data quality: Query rate (number of queries per 1000 data points) < X; data entry error rate < 1%. - Time management: time from last patient last visit (LPLV) to database lock (target: 4–6 weeks). - Efficiency: average time to query resolution (target: < 10 working days for critical queries). - Compliance: 100% adherence to milestones and processes defined in the DMP. - Protocol adherence: rate of protocol deviations related to data management < 5%. - Specific challenges, risks or considerations:** - Managing increasing data volumes and sources (e.g., wearables, ePROs). - Ensuring data integrity and security (cybersecurity, data protection/GDPR). - Complexity from mid-study changes (protocol amendments) and their impact on the database. - Ensuring consistent data quality across multiple, globally distributed study sites. - Lack of qualified specialists and high training demands for study-specific systems. - Deliverables:** - Finalized and approved Data Management Plan (DMP). - Live and validated study database (EDC system). - Regular data cleaning reports and status updates. - Clean, quality-assured data set ready for statistical analysis. - Final locked study database with complete audit trail. - Archived project documentation after study completion.

A company is looking for an experienced expert with in-depth knowledge of License Manager, Inventory Server, and Integration Manager. The goal of the project is to optimize existing systems, integrate them, 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 systems. Key responsibilities: - Analyze and optimize existing systems (License Manager, Inventory Server, Integration Manager) - Integrate new processes and tools - Collaborate with internal teams to analyze requirements - Ensure system efficiency and security - Document and train teams

We are looking for an experienced consultant for a process and project initiative in Asset P&L (Profit and Loss) at a leading international financial services provider. - Typical responsibilities in this role:** - Analyze and document the existing end-to-end P&L processes for various asset classes (e.g., equities, fixed income, derivatives). - Identify weaknesses, risks, and inefficiencies in data collection, processing, and reporting. - Design and develop optimized target processes for P&L calculation and attribution. - Create functional specifications and business requirements for adapting or introducing IT systems (e.g., P&L engines, data warehouses). - Manage the implementation of the new processes and tools, including milestone planning, stakeholder management, and test coordination. - Develop controls to ensure data quality and consistency. - Prepare training materials and conduct workshops for business areas (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 in P&L cycle time: target >25% efficiency gain. - Decrease in manual correction entries: target >50% reduction through process automation. - Data quality index: increase in first-time-right rate on data intake to >99%. - Efficiency ratio (cost-to-income): demonstrate a positive impact on lowering the ratio. - User adoption rate: acceptance of new processes/tools in the business area >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 areas (change management). - Ensuring compliance with regulatory requirements (e.g., IFRS 9, BCBS 239). - Time- and budget-critical implementation while ongoing operations. - Concrete deliverables:** - Milestone 1: completed as-is analysis and process documentation. - Deliverable 1: detailed analysis report including risk assessment. - 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.

For the enhancement of a complex ServiceNow platform, we are looking for a developer specialized in the middlelayer. The focus is on implementing business logic, integrations, and processing data between the frontend and backend systems. - **Typical tasks include:** - Designing and developing server-side business logic in ServiceNow using Business Rules, Script Includes, and Workflows. - Designing, implementing, and maintaining REST- and SOAP-based integrations to third-party systems (e.g., SAP, Jira, HR systems) via IntegrationHub or custom scripts. - Developing and optimizing data flows and transformations within the platform. - Analyzing and optimizing performance of server-side scripts and database interactions. - Ensuring platform stability and security through robust, 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 middlelayer 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 features enabled by the middlelayer. - **Key challenges, risks, or specifics:** - Complexity of dependencies between different ServiceNow modules and external systems. - Ensuring scalability under high transaction volumes. - Debugging asynchronous processes and integrations. - Following ServiceNow best practices to maintain upgradeability of the platform ("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 the developed logic and data flows. - Completed Update Sets ready for production deployment. - **Lessons learned/best practices:** - Encapsulate reusable logic in Script Includes instead of duplicating it across multiple Business Rules. - Prefer asynchronous Business Rules for long-running operations to avoid blocking the user experience. - Use Flow Designer over the classic Workflow Editor for new automations.

Project description As part of the implementation and optimization of the **Multi Domain Orchestration and Inventory (MDOI)** tool in the mobile transport domain (B2X), the focus is on planning, setup, commissioning, management, and optimization of several thousand fixed and mobile network devices. The application allows the selection and configuration of suitable devices and technologies for their efficient use to achieve maximum network coverage and customer satisfaction. Efficiently managing these projects and processes while increasing automation requires the use of the MDOI software solution. Description of services without personal reference - **IT Project Management**: Creating software rollout and migration plans for the application's two-month releases of MDOI, based on Blueplanet, considering all relevant dependencies using JIRA and stakeholder management - **Design Management**: Planning and creating all relevant designs, as well as reviewing them in the Multi Domain Orchestration and Inventory (MDOI) tool for the transport networks area, as an implementation description of the requirements using JIRA and Confluence - **Stakeholder Management**: Developing and executing communication measures for software changes based on the created designs, checking whether the requirements are fully covered by the designs, including preparing documentation for management using Microsoft Outlook, Microsoft Teams, and JIRA

To support the further development of an innovative low-code platform, we are looking for a highly qualified Senior Frontend Engineer. The platform allows customers to build complex business applications with minimal coding effort, with seamless integration into existing SAP system landscapes being critical to success. - Typical tasks: 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. Optimizing the platform’s performance for a smooth user experience. Working closely 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, 25% reduction in reported frontend bugs per quarter, user adoption rate. - Key challenges: Finding the right balance between abstraction (low-code) and flexibility (specific customer requirements). Ensuring the scalability and maintainability of the frontend architecture in a fast-growing product. Guaranteeing compatibility with various SAP system versions. - Deliverables: Implemented and tested features according to user stories, an expanded and documented component library (in Storybook), technical architecture documentation, sprint acceptance reports. - Best practices: Applying clean code principles and design patterns (e.g. Atomic Design), building a comprehensive test strategy, proactive communication within the team.

Typical tasks: - Analyze existing insurance processes and identify digitalization potentials - Gather and document business requirements together with departments - Create solution concepts for digital transformation (incl. process modeling and cost-benefit analyses) - Act as liaison between business and IT: translate requirements into technical concepts and support implementation - Support project management in planning and rolling out new digital solutions (agile methods like 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 cycle times, increase in customer satisfaction/user acceptance, reduction of manual efforts through automation Challenges: aligning diverse stakeholders in the insurance environment (departments, IT, regulatory), integrating new digital solutions into existing legacy systems, handling regulatory requirements and data privacy, 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 modified processes Lessons Learned: involving all stakeholders early on makes digitalization projects easier; iterative, agile approaches allow flexible adjustments; deep industry knowledge (products, regulation) is crucial to design sustainable digital solutions

Managing a strategic digitization project in a hospital network, e.g. implementing a new HIS or an ePA in line with KHZG. - **Typical responsibilities:** - Overall responsibility for project planning, management and control (time, budget, quality). - Managing the interdisciplinary project team. - Requirements, risk and stakeholder management. - Planning and managing change management and rollouts. - Ensuring compliance with regulatory requirements (KHZG, GDPR). - **Relevant technologies, tools & methods:** - HIS systems (Orbis, iMedOne), ePA solutions. - Standards: HL7, FHIR. - Methods: PRINCE2, PMI/PMBOK, agile/hybrid. - Tools: MS Project, Jira, Confluence. - **Typical KPIs & success metrics:** - KHZG compliance, user adoption rate (>85%), process efficiency, milestone adherence. - **Key challenges & risks:** - High process complexity, intensive stakeholder management, interoperability, data security. - **Deliverables:** - Project plan, status reports, requirements spec (Lastenheft), change concept, cutover plan, project closure report.

We are looking for an experienced IT project manager to lead and execute IT projects in a hospital setting. The goal is to deliver various digitalization and infrastructure projects (e.g. HIS migration, medical technology integration, ISMS implementation or TI components) on time, within budget and with assured quality. In this role, the project manager takes full responsibility for planning, managing and executing the projects and acts as the link between IT, departments and management. - Overall responsibility for planning, managing and executing IT projects in a clinical environment - Coordination of internal and external stakeholders, including IT department, medical staff, service providers and manufacturers - Ensuring adherence to time, budget and quality requirements - Preparing project plans, status reports, decision documents and presentations - Risk management, resource planning and escalation handling - Managing acceptance and testing procedures, including documentation - Supporting preparation for KHZG or NIS2 related measures - Acting as interface between IT, departments and management

For a project in the power plant environment, a freelance specialist for migrating and adapting the ABB 800xA control system is needed at short notice. - Typical tasks in this role:** - Implementation of programming and commissioning with the ABB 800xA process control system. - Migration of existing control system logic to the new system version, including adaptation of controllers and I/O modules. - Creation and adjustment of process graphics, operator interfaces and alarm management configurations. - Execution of system tests, error analysis and performance optimizations to ensure plant availability and controllability. - Technical support of operations staff during the commissioning and ramp-up phase. - Preparation and maintenance of technical documentation (functional diagrams, configuration descriptions, test protocols). - Close cooperation with the process engineering, electrical engineering departments and the plant operator. - Relevant technologies, tools or methods:** - Control system: ABB Ability™ System 800xA (including AC 800M controller, information management, batch control). - Engineering tools: Control Builder M, Process Graphics Migration Tool, Bulk Data Manager. - Fieldbuses: PROFIBUS, Foundation Fieldbus, Modbus. - Virtualization: VMware, Hyper-V for test and development environments. - Databases: SQL knowledge for historical data analysis (e.g., 800xA History). - Knowledge of relevant standards for process and power plant engineering (e.g., IEC 61508, IEC 61511). - Typical KPIs or success metrics:** - Migration speed: number of system components/functions migrated per week/month. - System availability: control system uptime after migration > 99.9%. - Commissioning error rate: number of critical software bugs after go-live < 5. - Test coverage: percentage of successfully executed and documented test cases > 95%. - Adherence to project schedule: completion of migration and commissioning by the defined deadline. - Operator acceptance: positive feedback from operations staff on the new system environment. - Key challenges, risks or specifics:** - Migration in running operation ("brownfield") with minimal downtime. - Ensuring compatibility between old and new system components (hardware/software). - High complexity of process logic in power plants (e.g., boiler control, turbine regulation). - Risk of cybersecurity vulnerabilities in networked control systems (e.g., CVEs for 800xA). - Management of interfaces to third-party systems (e.g., MES, ERP). - Need for intensive and precise collaboration between control engineering, process engineering and operations. - Concrete deliverables:** - Migrated and operational control logic on the target system. - Fully tested and customer-approved process graphics and operator interfaces. - Acceptance protocols for Factory Acceptance Test (FAT) and Site Acceptance Test (SAT). - Updated technical plant documentation. - Final migration report with lessons learned. - Trained operations staff.

On behalf of a leading medical technology company, we are looking for an experienced technical draftsman or product designer to create and maintain technical documentation and engineering drawings. - **Typical responsibilities:** - Create standards-compliant 2D manufacturing drawings and 3D models of parts and assemblies using CAD software. - Detail and dimension designs, taking form and position tolerances into account. - Create and manage bills of materials and technical documents in the PDM/PLM system (e.g., SAP ECTR). - Carry out revision services on existing drawings and documentation. - Work closely with the development and manufacturing departments to ensure producibility. - **Relevant technologies, tools, or methods:** - CAD systems: Siemens NX, SolidWorks, CATIA V5, Autodesk Inventor (depending on client system) - PDM/PLM systems: SAP ECTR, Teamcenter, Windchill - Standards: Solid knowledge of relevant ISO and DIN standards for technical drawings, especially in regulated environments. - ERP systems: SAP S/4HANA - **Typical KPIs or success metrics:** - On-time delivery of drawings and documents. - Error rate in technical documentation (number of required revision loops). - Compliance with internal and external design and documentation standards. - Efficiency in implementing changes (turnaround time). - **Key challenges, risks, or specifics:** - High demands on the accuracy and completeness of documentation due to strict regulatory requirements in medical technology (MDR). - Seamless traceability of changes (versioning). - Complexity of parts to be designed (e.g., freeform surfaces, complex assemblies). - Close coordination with various stakeholders (development, procurement, quality assurance, manufacturing). - **Concrete deliverables:** - Approval-ready 2D manufacturing drawings and 3D CAD models. - Complete and released bills of materials in the ERP system. - Updated technical product documentation. - Change logs. - **Lessons learned / best practices:** - Clear, standardized template management significantly speeds up the creation process. - Regular alignment meetings with manufacturing can prevent costly errors early on. - Careful maintenance of master data in the PDM/PLM system is key to efficient collaboration.

Building and evolving a test automation suite for the core applications of a large insurer to increase release speed and quality. - **Typical tasks:** - Analysis of test processes and identification of automation potential. - Selection, configuration and implementation of automation frameworks. - Development and maintenance of automated test scripts. - Integration of tests into CI/CD pipelines (Jenkins, GitLab). - Test data management and reporting. - **Relevant technologies, tools & methods:** - Selenium, Cypress, Playwright, Tosca, Postman. - Java, Python, JavaScript. - TestNG, JUnit, Cucumber. - Jenkins, GitLab CI, Docker, Jira. - **Typical KPIs & success metrics:** - Automation rate (>70%), reduction of test run time, defect detection rate. - **Key challenges & risks:** - Complex legacy UIs, stable test data management, script maintainability. - **Deliverables:** - Documented test automation framework, automated test suite, CI/CD integration, test reports.