Within the further development of reporting and analysis capabilities in Business Continuity Management (BCM), the existing BI environment 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 basis for company-wide analysis. In parallel, existing reporting functionalities and automations in the standard software HiScout will be analyzed and adapted to new requirements. - **Consulting**: Advising on the architecture and setup of a data warehouse based on Microsoft technologies (SQL Server, Power BI) - **Migration**: Advising on the migration of existing reports and dashboards from Tableau to Power BI - **Data Analysis**: Analyzing existing data sources and designing suitable ETL processes - **Automation**: Connecting and automating data sources - **Requirements Analysis**: Conducting requirements analysis and creating technical concepts for reporting adjustments in HiScout - **Reporting**: Implementing and testing reporting adjustments in HiScout - **Documentation**: Quality assurance and documentation of the work performed - **Training**: Advising on the creation of training materials and transferring know-how to internal teams

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

The ProMi Squad (Process Mining) project aims to map the entire order process in the portals area in a transparent way. To do this, relevant data sources from order to activation are consolidated. This end-to-end view of the process makes it possible to identify deviations and optimization opportunities. Key milestones include connecting the needed data sources, building self-service reports, and implementing automated alerts for process deviations. The challenge lies in the technical and functional integration of heterogeneous systems and data flows to ensure consistent monitoring and control of the ordering process. ⸻ Service Description - Analyze and document requirements in the omnichannel area using requirements management tools and structured elicitation methods - Perform functional 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 Celonis EMS, Data Pool, and Data Push API - Create technical queries and visualizations for process mapping using platform features (Celonis PQL, Studio) - Use system functions to visualize and analyze existing business processes (via Celonis Process Explorer) - Provide functional advice on technical interfaces, data provisioning, and system requirements

Typical tasks: - Analyze existing insurance processes and identify digitalization opportunities - Gather and document business requirements together with the business teams - 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 launching 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 effort through automation Challenges: coordinating diverse stakeholders in the insurance environment (business units, IT, compliance), 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, detailed business concepts and user stories for IT implementation, defined implementation roadmap, training materials for updated processes Lessons learned: involving all stakeholders early on makes digitalization projects easier to execute; iterative, agile approaches allow flexible adjustments; deep industry knowledge (products, regulations) is crucial to design sustainable digital solutions

On behalf of a renowned client in the life sciences sector, freelance support is being sought in clinical data management. The main task is to take responsibility for coordinating all data management activities in clinical trials. - Typical tasks in this role:** - Create and review the Data Management Plan (DMP) and Data Validation Plan (DVP). - Design and implement electronic case report forms (eCRFs) in EDC systems (Electronic Data Capture). - Coordinate data collection, validation, and cleaning throughout the study lifecycle. - Develop and execute query processes to resolve data inconsistencies with study sites. - Medical coding of adverse events (AEs) and medications (e.g., using MedDRA, WHODrug). - Perform SAE reconciliation (matching of serious adverse events). - Prepare and carry out the database lock after data collection is complete. - Create status reports and communicate 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 1,000 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 resolve queries (target: < 10 working days for critical queries). - Compliance: 100% adherence to milestones and processes defined in the DMP. - Protocol adherence: Rate of data management–related protocol deviations < 5%. - Key challenges, risks, or specifics:** - Handling increasing volumes and sources of data (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. - Maintaining consistent data quality across global, distributed study sites. - Shortage of qualified professionals and high demands for training on study-specific systems. - Concrete deliverables:** - Finalized and approved Data Management Plan (DMP). - Live and validated study database (EDC system). - Regular data cleaning reports and status updates. - Clean, quality-controlled database ready for statistical analysis. - Final locked study database with a complete audit trail. - Archived project documentation after study completion.

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

The client runs the Ad Manager, a self-service portal for business customers to book and manage advertising products on the email portals GMX and WEB.DE. The Ad Manager is already in productive use and serves as the central platform for campaign management in the B2B sector. A separate B2B portal, the trusted Dialog Manager, currently exists, and its features are to be integrated into the Ad Manager. Project Goal The goal is to technically and functionally expand the Ad Manager with features from the trusted Dialog Manager. The first step is to implement a unified login system. Building on that, existing trusted Dialog features will be migrated step by step to be centrally available in the Ad Manager. Since the trusted Dialog Manager was not a self-service tool, this integration will also significantly improve user-friendliness and accessibility. The focus of this tender is especially on frontend development (Angular, CSS, HTML). Scope of Work - Unified Login System: Integration of trusted Dialog features into the Ad Manager via a central authentication mechanism. - Domain Overview Page: Development of an overview page with DKIM details, logo/avatar preview, and status information (active, inactive, ready for completion). - Auth Code Creation: Development of a function to generate time-limited authentication codes for marking test emails. - Overlay Test Mail Intro: Development of an overlay as a step-by-step guide for sending test emails. - Software Design: Applying current Angular best practices to optimize the codebase in terms of structure, reusability, and maintainability.

- IT project manager activities - Interface / bridging role between business and technology, thus also the required in-depth subject matter knowledge.

Looking for an experienced consultant for a process and project initiative in the field of Asset P&L (Profit and Loss) at a leading international financial services provider. - Typical responsibilities in this role:** - Analyze and document 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 designs and business requirements for the adjustment or introduction of IT systems (e.g. P&L engines, data warehouses). - Manage the project for implementing the new processes and tools, including milestone planning, stakeholder management, and test coordination. - Develop control mechanisms to ensure data quality and consistency. - Prepare training materials and conduct 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 improvement. - Decrease in manual correction entries: target >50% reduction through process automation. - Data quality index: increase first-time-right rate for data intake to >99%. - Efficiency ratio (cost-to-income): demonstrate a positive contribution to lowering the ratio. - User adoption rate: acceptance of new processes/tools in business units >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:** - Milestone 1: Completed as-is analysis and process documentation. - Deliverable 1: Detailed analysis report including gap 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 further development of a complex ServiceNow platform, we are looking for a developer specializing in the middlelayer level. The focus is on implementing business logic, integrations, and processing data between the frontend and backend systems. - **Typical tasks:** - Designing and developing server-side business logic in ServiceNow using Business Rules, Script Includes, and Workflows. - Designing, implementing, and maintaining REST and SOAP 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. - Analyzing and optimizing the 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), using 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 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 the developed logic and data flows. - Completed Update Sets ready for deployment to production. - **Lessons learned/best practices:** - Encapsulate reusable logic in Script Includes instead of duplicating it across multiple Business Rules. - Use asynchronous Business Rules for long-running operations to avoid blocking user experience. - Prefer Flow Designer over the classic Workflow Editor for new automations.

- Establishing a future O2C standard process in S/4 HANA for a customer in the retail sector with a focus on O2C integration and planned handling of the merchandise management system - Existing merchandise management system for trading goods will continue to be used for all logistical processes and is out of scope. - Requirement definition for interfaces - Process definition and harmonization: establishing company-wide standard processes in S/4 and in O2C process integration for the affected areas/companies (B2C, B2B, B2G) - O2C integration: definition of the level of integration of third-party systems: - Best possible compliance with legal reporting and documentation requirements - S/4 as the leading system for the process execution of intercompany transactions - Invoice flow and billing - Price conditions - Rebates - Contracts What should be done in the Explore phase? - Preparation and execution of Fit to Standard workshops (including setting up a prototype in the sandbox system for the workshops) - Documentation of the Fit to Standard workshop results within a BPMN up to level 5 - Documentation of gaps / requirements - Process design / documentation of business concepts (Confluence + Signavio)

A company is looking for an experienced construction supervisor or site manager in the fiber optics field to professionally support and monitor the construction services of a general contractor in FTTH broadband rollout. The goal is to ensure that the construction work meets the requirements of the execution planning and that the FTTH broadband network is fully expanded. The sites are located near Würzburg and Saarbrücken. The role includes monitoring adherence to schedules, safety regulations and quality of work, as well as coordinating and documenting construction activities. The site manager will independently create a construction diary and full documentation, track subcontractor services and verify the accuracy of planning and construction documents. - Professional support and monitoring of a general contractor’s construction work in FTTH broadband rollout. - Ensuring compliance with schedules, safety regulations and quality standards. - Recording and checking planning and construction documents of subcontractors. - Independently creating a construction diary and full documentation. - Tracking schedules, controlling and documenting ordered services and deliveries. - Site supervision and safety control of the construction site according to the HSE concept.

On behalf of a leading medical technology company, we are looking for an experienced technical drafter or product designer to create and maintain technical documentation and design drawings. - **Typical tasks:** - Creating standards-compliant 2D manufacturing drawings and 3D models of parts and assemblies using CAD software. - Detailing and dimensioning designs, considering form and position tolerances. - Creating and managing parts lists and technical documents in the PDM/PLM system (e.g., SAP ECTR). - Implementing revision changes to existing drawings and documentation. - Close collaboration 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 correction cycles). - Compliance with internal and external design and documentation standards. - Efficiency in processing changes (throughput time). - **Key challenges, risks or specifics:** - High demands on accuracy and completeness of documentation due to strict regulatory requirements in medical technology (MDR). - Complete 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:** - Approved 2D manufacturing drawings and 3D CAD models. - Complete and released parts lists in the ERP system. - Updated technical product documentation. - Change logs. - **Lessons learned / best practices:** - A clear, standardized template management significantly speeds up the creation process. - Regular coordination meetings with manufacturing can prevent costly errors early on. - Careful maintenance of master data in the PDM/PLM system is the basis for efficient collaboration.

A company is looking for an experienced expert in P2P / Purchase to Pay / Procure to Pay to merge the IT finance systems of two entities. The goal of the project is to ensure a smooth system integration and optimize processes. In this role, the expert will work closely with relevant stakeholders to analyze requirements, develop solutions, and support the implementation. Main tasks: - Analyze the existing IT finance systems of both entities - Develop a strategy for system consolidation - Optimize P2P processes - Support implementation and integration - Collaborate with internal teams and external partners - Ensure compliance with finance and regulatory guidelines

For a project in the power plant environment, a freelance specialist for the migration and adaptation of the ABB Ability™ System 800xA control system is urgently needed. - 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 adapting controllers and I/O modules. - Creation and adjustment of process graphics, operator interfaces, and alarm management configurations. - Conducting system tests, error analysis, and performance optimizations to ensure plant availability and controllability. - Technical support for operations staff during commissioning and ramp-up phases. - Preparation and maintenance of technical documentation (functional diagrams, configuration descriptions, test protocols). - Close cooperation with process engineering, electrical engineering, and plant operator departments. - 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: knowledge of SQL for analyzing historical data (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 migrated system components/functions 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. - Special challenges, risks or specifics:** - Migration in a live environment (“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 management, turbine control). - Risk of cybersecurity vulnerabilities in networked control systems (e.g. CVEs for 800xA). - Managing interfaces to third-party systems (e.g. MES, ERP). - Necessity of intense and precise collaboration between automation, 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 personnel.

A company is seeking support for carrying out the engineering of energy generation and consumption plants and their connection to the transmission and/or distribution grids of network operators in Germany and abroad. The project includes both existing plants and those under development, such as power plants, consumer installations, and hybrid systems like battery installations. The goal is to plan, coordinate, and implement grid connections efficiently. Main tasks: - Managing approval processes for grid connections at the respective voltage level - Preparing technical documents for grid connection requests - Creating grid connection applications, including technical documentation for network operators - Technical engineering for grid connection concepts - Designing extra-high, high, and medium-voltage switchgear and substations - Basic and detailed engineering, including tender documents and specifications - Developing technical standards to implement quality requirements - Control and coordination tasks within project execution - Consulting and coordination for quality assurance measures - Project management in line with technical regulations and project management strategies - Advice on contract management, e.g., grid connection contracts - Coordinating processes and carrying out on-site construction support measures - Developing retrofit concepts for conventional power plants, hydropower plants, and other installations

To support projects in energy infrastructure, we are looking for a freelance electrical engineer specializing in high and extra-high voltage as a primary planner (m/f/d). The projects include grid connections of generation plants (especially wind and solar parks) as well as the construction and modification of substations. - Typical tasks in this role:** - Developing primary technical concepts and layouts for air- and gas-insulated high and extra-high voltage switchgear (AIS/GIS) from 110 kV to 380 kV. - Sizing and dimensioning of primary equipment (circuit breakers, disconnectors, instrument transformers, transformers, etc.). - Creating single-line diagrams, single-phase overview and arrangement drawings. - Performing short-circuit and load flow calculations as well as sizing grounding systems and lightning protection. - Technical coordination and alignment with clients, grid operators, authorities and suppliers. - Preparing technical specifications and tender documents for primary equipment. - Coordinating with other disciplines such as secondary equipment, civil engineering and control technology. - Supporting commissioning and acceptance of the systems. - Relevant technologies, tools or methods:** - Planning software: AutoCAD, Primtech, REVIT, EPLAN. - Calculation tools: PowerFactory (DIgSILENT), NEPLAN, or vendor-specific tools. - Standards & regulations: VDE-AR-N 4120 (High Voltage Connection Conditions), IEC standards, EN standards. - Project management tools: MS Project, Jira. - BIM (Building Information Modeling) in plant engineering. - Typical KPIs or success metrics:** - Planning quality: Number of required plan changes after approval < 5%. - Schedule adherence: Meeting planning milestones according to the overall project schedule. - Cost efficiency: Staying within budget for the planned primary equipment. - Technical compliance: Successful acceptance by the grid operator without primary technical objections. - Interface management: Smooth coordination, measured by number of delays in other disciplines caused by planning errors. - Key challenges, risks or specifics:** - High complexity and safety requirements in the high and extra-high voltage area. - Need for exact compliance with grid connection rules (High Voltage Connection Conditions) of respective grid operators. - Long delivery times and price fluctuations for large primary equipment components. - Coordination in tight spaces, especially during upgrades of existing facilities. - Increasing requirements due to integration of renewables (e.g. reactive power management, FRT behavior). - Ensuring physical safety and occupational health in planning. - Concrete deliverables:** - Approval-ready primary technical planning documents (layouts, elevations, sections). - Final single-line diagrams and overview schematics. - Technical calculation reports (e.g. short-circuit withstand, grounding). - Prepared bills of quantities and technical specifications for procurement. - Minutes of technical coordination meetings. - Revision documents and as-built documentation.

A leading company in the field of non-destructive testing of metallic materials, metal detection, and magnetics is looking for temporary support for its IT department. The goal of this project is to assist in infrastructure management, especially in server environment administration, backup solutions, and networks. The administrator will work closely with the existing team and ensure structured documentation of the systems.

A company is looking for an experienced project manager for the approval planning of infrastructure projects. - Management and coordination of the approval planning - Technical support and coordination of all involved service providers (routing, land management, environmental, communications) - Coordination of interfaces between departments and alignment with relevant stakeholders - Preparation of regular project reports and continuous updating of project documentation - Review and approval of deliverables from contracted service providers - Ensuring compliance with legal and technical requirements - Advising on the selection and hiring of specialist planners and experts - Independently creating scope of work documents and evaluating offers