In the context of advancing the reporting and analysis 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 company-wide analyses. At the same time, existing reporting functions and automations in the standard software HiScout should 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**: Assisting with 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 analyses and creating technical designs 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 creating training materials and knowledge transfer 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 development of a modern data platform in the Azure Cloud for an e-commerce company. Implementation of scalable data pipelines and a lakehouse architecture. - **Typical tasks:** - 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.

The ProMi Squad (Process Mining) project aims to transparently map the entire order process in the portals area. Relevant data sources from order to activation are combined for this. A holistic view of the end-to-end process makes it possible to identify process deviations and optimization potential. Key milestones of the project are connecting the required 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 - 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 - Capturing and evaluating 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 used tools Celonis EMS, Data Pool, and Data Push API - Creating technical queries and visualizations for process mapping based on the platform features provided (Celonis PQL, Studio) - Using system functions to visualize and analyze existing business processes (via the Celonis Process Explorer) - Functional consulting on technical interfaces, data provisioning, and system prerequisites

Typical tasks: - Analyze existing insurance processes and identify digitalization potentials - Gather and document business requirements together with business units - Create solution concepts for digital transformation (including 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 implementing 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 (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 requirement 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 allow flexible adjustments; deep industry knowledge (products, regulations) is crucial to design viable digital solutions

On behalf of a renowned client in the life sciences industry, we are looking for freelance support 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:** - Creating and reviewing the Data Management Plan (DMP) and the Data Validation Plan (DVP). - Designing and implementing electronic case report forms (eCRFs) in EDC systems (Electronic Data Capture). - Coordinating data collection, validation, and cleaning throughout the study lifecycle. - Developing and executing query processes to resolve data inconsistencies with the study sites. - Medical coding of adverse events (AEs) and medications (e.g. using MedDRA, WHODrug). - Performing SAE reconciliation (matching of serious adverse events). - Preparing and executing the database lock after data collection is complete. - Creating status reports and communicating 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 business 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%. - Key challenges, risks or specifics:** - 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. - Shortage of qualified professionals and high demands for onboarding in study-specific systems. - Specific 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, and analysis-ready database. - 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

A company is looking for an experienced MES consultant specializing in MPDV’s Hydra X to support the system’s expansion to additional sites. The system is already rolled out at one location and should now be scaled further. The role includes supporting the introduction of new features or system versions, implementing system customizations and optimizations based on production requirements, and overseeing the rollout. The consultant will work closely with internal teams and external service providers to ensure quick identification and resolution of MES system issues. - Support the introduction of new system features or versions - Implement system customizations and optimizations based on production requirements - Assist with the rollout to additional sites - Quickly identify and resolve issues in the MES system

A company is looking for an experienced professional with extensive knowledge of License Manager, Inventory Server and Integration Manager. The project’s goal is to optimize existing systems, integrate them, and ensure all processes run smoothly and efficiently. In this role, you will work closely with internal teams to analyze requirements, implement solutions, and monitor the systems. Key responsibilities: - Analyze and optimize existing systems (License Manager, Inventory Server, Integration Manager) - Integrate new processes and tools - Collaborate with internal teams for requirements analysis - Ensure system efficiency and security - Document and train the teams

The client runs the Ad Manager, a self-service portal for business customers to book and manage advertising products on the GMX and WEB.DE email portals. The Ad Manager is already live and serves as the central platform for campaign management in the B2B sector. There is currently a separate B2B portal called the trusted Dialog Manager, whose features are to be merged into the Ad Manager. Project goal The goal is the technical and functional enhancement of the Ad Manager with features from the trusted Dialog Manager. In the first step, a unified login system will be implemented. Building on that, existing trusted Dialog features will be gradually migrated and become centrally available in the Ad Manager. Since the trusted Dialog Manager was not previously a self-service tool, this integration also significantly improves user-friendliness and accessibility. The focus of this call for tenders is especially on frontend development (Angular, CSS, HTML). Scope of services - 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 tagging test emails. - Overlay Testmail Intro: Development of an overlay as a step-by-step guide for sending test emails. - Software Design: Incorporating current Angular best practices to optimize the codebase in terms of structure, reusability, and maintainability.

- IT project manager activities - Interface/bridging role between business area and technology, requiring solid subject matter knowledge.

We are looking for 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:** - 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 conceptualize 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 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 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 creation 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 in 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 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 during 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 further development of a complex ServiceNow platform, a developer specialized in the middle layer is sought. The focus is on implementing business logic, integrations, and processing data between the frontend and backend systems. - **Typical responsibilities:** - 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 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 performance and optimizing 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 middle layer processes. - Error rate for 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 middle layer. - **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. - Adhering to ServiceNow best practices to keep the platform upgradeable ("out-of-the-box" vs. customizing). - **Specific 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 production. - **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.

- Establishment of a future O2C standard process in S/4 HANA for a retail customer with a focus on O2C integration and planned handling of the merchandise management system - The existing merchandise management system for trade goods will still be used for all logistics processes and is out of scope. - Requirements definition for interfaces - Process definition and harmonization: Establish company-wide standard processes in S/4 and in O2C process integration for the areas/entities involved (B2C, B2B, B2G) - O2C integration: Definition of the level of integration of third-party systems: - Best possible compliance with legal reporting and documentation obligations - S/4 as the leading system for executing intercompany transactions - Billing flow and invoicing - Price conditions - Rebates - Contracts What should be done for these topics during the Explore phase? - Preparation and facilitation of Fit To Standard workshops (including building a prototype in the sandbox system for the workshops) - Documentation of the results of the Fit To Standard workshops in a BPML up to level 5 - Documentation of gaps/requirements - Process design and documentation of functional concepts (Confluence + Signavio)

To support the further development of an innovative low-code platform, we are looking for a highly skilled Senior Frontend Engineer. The platform enables customers to build complex business applications with minimal coding effort, where seamless integration into existing SAP system landscapes is critical. - 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 E2E tests. Optimizing platform performance for a smooth user experience. Collaborating closely in an agile Scrum team with product owners, UX/UI designers, and backend developers to execute 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: Striking 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 diverse SAP system versions. - Deliverables: Implemented and tested features according to user stories, 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.

A company is looking for an experienced construction supervisor or manager in the fiber optics field to technically oversee and monitor a general contractor’s construction work in FTTH broadband rollout. The goal is to ensure that the construction work follows the execution planning requirements and that the FTTH broadband network is fully deployed. The sites are located near Würzburg and Saarbrücken. The role includes monitoring adherence to schedules, safety regulations, and the quality of construction work, as well as coordinating and documenting construction activities. The manager will independently prepare a construction log and overall documentation, track external services, and verify the accuracy of planning and construction documents. - Technical oversight and monitoring of a general contractor’s construction work in FTTH broadband rollout. - Ensuring compliance with schedules, safety regulations, and quality standards for construction work. - Recording and reviewing planning and construction documents of subcontractors. - Independently preparing a construction log and comprehensive documentation. - Tracking deadlines, inspecting, and documenting ordered services and deliveries. - On-site supervision and safety checks according to the HSE concept.

On behalf of a leading medical technology company, an experienced technical draftsman or product designer is sought for creating and maintaining technical documentation and design drawings. - **Typical tasks:** - Creating standardized 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 bills of materials and technical documents in the PDM/PLM system (e.g. SAP ECTR). - Implementing change orders on 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: Sound knowledge of relevant ISO and DIN standards for technical drawings, especially in a regulated environment. - 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 loops). - Compliance with internal and external design and documentation standards. - Efficiency in implementing changes (throughput time). - **Special challenges, risks or specifics:** - High demands on accuracy and completeness of documentation due to strict regulatory requirements in medical technology (MDR). - Comprehensive traceability of changes (version control). - Complexity of the parts to be designed (e.g. freeform surfaces, complex assemblies). - Close coordination with various stakeholders (development, procurement, quality assurance, manufacturing). - **Specific 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:** - A clear and standardized template management speeds up the creation process significantly. - Regular alignment 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 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 current 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 is urgently needed for the migration and adaptation of the ABB 800xA control system. - 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, user interfaces and alarm management configurations. - Performing system tests, error analysis and performance optimizations to ensure plant availability and controllability. - Technical support for operational staff during commissioning and ramp-up phases. - Creation and maintenance of technical documentation (functional diagrams, configuration descriptions, test protocols). - Close collaboration with process engineering, electrical engineering 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: Knowledge of SQL for analyzing historical data (e.g., 800xA History). - Familiarity with 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 operational staff on the new system environment. - Special challenges, risks or specifics:** - Migration during ongoing 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 technology, process engineering and operations. - Concrete deliverables:** - Migrated and operational control logic on the target system. - Fully tested and customer-approved process graphics and user interfaces. - Acceptance protocols for Factory Acceptance Test (FAT) and Site Acceptance Test (SAT). - Updated technical plant documentation. - Final migration report with lessons learned. - Trained operational staff.

Setup and enhancement of a test automation suite for the core applications of a major insurance company to increase release speed and quality. - **Typical tasks:** - Analyze testing processes and identify automation opportunities. - Select, configure, and implement automation frameworks. - Develop and maintain automated test scripts. - Integrate tests into CI/CD pipelines (Jenkins, GitLab). - Manage test data 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%), reduced test execution 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.