The ProMi Squad (Process Mining) project aims to provide a transparent, end-to-end view of the entire ordering process in the portals area. Relevant data sources, from order placement to activation, are brought together for this purpose. The holistic view of the end-to-end process enables identification of process deviations and optimization potentials. Key milestones of the project include connecting the required data sources, building self-service reports, and implementing automated alerts for deviations in the process flow. The challenge is the technical and functional integration of heterogeneous systems and data streams 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 collection methods - Functional and technical analysis of existing data sources and ETL processes using database tools - Capturing and evaluating the existing interfaces between source and target systems based on technical documentation - Advising 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 - Creating technical queries and representations for process visualization based on the available platform features (Celonis PQL, Studio) - Using system functions for visualization and analysis of existing business processes (via the Celonis Process Explorer) - Providing functional advice on technical interfaces, data provisioning, and system requirements

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

Typical tasks: - Analyze existing insurance processes and identify digitization potential - Gather and document business requirements together with the business departments - Create solution concepts for digital transformation (including process modeling and cost-benefit analyses) - Act as a liaison between business and IT: translate requirements into technical designs 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: meeting project milestones and budgets, reducing process cycle times, improving customer satisfaction/user acceptance, cutting manual efforts through automation Challenges: coordinating diverse stakeholders in the insurance environment (business units, IT, regulators), integrating new digital solutions into legacy systems, handling 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: early involvement of all stakeholders makes it easier to carry out digitization projects; iterative, agile approaches allow flexible adjustments; deep industry knowledge (products, regulations) is crucial to design effective digital solutions

We are looking for a developer specialized in the middlelayer level to further develop a complex ServiceNow platform. 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-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. - Adhering to ServiceNow best practices to maintain the platform's upgradeability ("out-of-the-box" vs. customization). - **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. - 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.

As part of 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 company-wide analyses. At the same time, existing reporting functionalities and automations in the HiScout standard software should 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 suitable ETL workflows - **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 work performed - **Training**: Advising on creating training materials and transferring know-how to internal 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 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 plan optimized target processes for P&L calculation and attribution. - Prepare functional specs and business requirements for adapting or implementing IT systems (e.g. P&L engines, data warehouses). - Manage project implementation of new processes and tools, including milestone planning, stakeholder management, and test coordination. - Develop control mechanisms to ensure data quality and consistency. - Create training materials and lead 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:** - P&L cycle time reduction: target >25% efficiency gain. - Reduction of manual correction entries: target >50% decrease through process automation. - Data quality index: increase first-time-right data acceptance rate to >99%. - Efficiency ratio (cost-to-income): demonstrate a positive impact on lowering the ratio. - User adoption rate: >80% acceptance of new processes/tools by business units after 3 months. - Key challenges, risks, or specifics:** - Heterogeneous system landscape and inconsistent data sources (data silos). - High complexity of financial products and valuation models. - Resistance to process changes within business units (change management). - Ensuring compliance with regulatory requirements (e.g. IFRS 9, BCBS 239). - Time- and budget-critical execution during ongoing operations. - Deliverables:** - Milestone 1: Completed current-state analysis and process documentation. - Deliverable 1: Detailed analysis report including risk and 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 minutes, training materials, and project closure report.

- Carrying out and handling switching processes (supplier change, new setup, 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 support - Ensuring smooth operations within energy industry processes

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 all processes run smoothly and efficiently. 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 on requirements analysis - Ensuring system efficiency and security - Documenting and training the teams

To support the ongoing development of an innovative low-code platform, we are looking for a highly qualified Senior Frontend Engineer. The platform lets customers build complex business applications with minimal coding effort, with seamless integration into existing SAP ecosystems being mission-critical. - Typical responsibilities: Designing, architecting, and implementing sophisticated, reusable frontend components and modules using React & TypeScript. Ensuring high code quality through code reviews, unit tests, and E2E tests. Optimizing the platform’s performance for a smooth user experience. Collaborating 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 (custom client 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 according to user stories, extended 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 testing strategy, proactive team communication.

A company is looking for an experienced engineering expert in sterile filling to support a demanding project in pharmaceutical production. The goal of the project is to optimize the efficiency and quality of the filling processes and ensure that all regulatory requirements are met. In this role, the expert will work closely with the internal team to develop technical solutions, analyze existing processes, and implement improvements. Main tasks: - Analyze and optimize processes in sterile filling - Ensure compliance with GMP and other regulatory requirements - Develop and implement technical solutions for process improvement - Collaborate with interdisciplinary teams - Document and report on progress and results

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:** - Design and implement ETL/ELT processes with Azure Data Factory/Databricks. - Build and manage the data infrastructure (Data Lake, Synapse). - Develop data models and ensure data quality. - Automate 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.

- Collaboration in the software development process in the field of process automation, word processing - 3rd-level support - Participation in the analysis of software requirements in an agile development environment

Building and enhancing a test automation suite for the core applications of a large insurer to improve release speed and quality. - **Typical responsibilities:** - Analyzing test processes and identifying automation potential. - Selecting, configuring, and implementing automation frameworks. - Developing and maintaining automated test scripts. - Integrating tests into CI/CD pipelines (Jenkins, GitLab). - Managing 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, maintainability of scripts. - **Deliverables:** - Documented test automation framework, automated test suite, CI/CD integration, test reports.

- 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 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 for the migration and adaptation of 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 control capability. - Technical support for operations staff during commissioning and ramp-up phases. - Preparation and maintenance of technical documentation (functional diagrams, configuration descriptions, test reports). - Close cooperation with process engineering, electrical engineering, and the plant operator.

A company is looking for a Siemens PLC Programmer to support a hybrid setup in Siegen. The project focuses on programming and optimizing Siemens PLC systems, particularly within the steel industry. The role requires expertise in S120 and G120 servo drives. The ideal candidate should live close to Siegen to facilitate on-site work when required. Key responsibilities: - Programming and optimizing Siemens PLC systems. - Working with S120 and G120 servo drives. - Collaborating with the team to ensure smooth operations in a hybrid setup. - Troubleshooting and resolving technical issues. - Ensuring compliance with industry standards and safety regulations.

A company is looking for a specialist site manager in electrical engineering as well as a specialist site manager for control systems (Siemens T3000) for a demanding project. The goal of the project is the technical supervision and control of the control system interfaces of the existing plant during the integration of the new plant, as well as ensuring quality and contract compliance during the construction and commissioning phase. The role requires intensive coordination and monitoring of interfaces with construction planning due to the size of the project. The site manager will work closely with control system specialists, planners, experts, and contractors to ensure the successful implementation of the project. Main responsibilities: - Technical supervision of the control system interfaces of the existing plant during the integration of the new plant - Technical management of control system specialists, planners, experts, and contractors - Creation of discipline-specific and project phase–dependent documents - Participation in project meetings and negotiations - Technical management of quality assurance and quality control during the construction and commissioning phase - Advising on control system commissioning - Technical coordination with planning engineers on quality monitoring tasks - Monitoring contract compliance and conducting quality inspections - Participation in safety meetings and implementation of measures to address identified deficiencies

On behalf of a renowned client in the life sciences industry, we are looking for a freelance support in Clinical Data Management. The main responsibility is coordinating all data management activities in clinical trials. - Typical responsibilities in this role:** - Creation and review of 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 across the entire study lifecycle. - Developing and executing query processes to resolve data inconsistencies with investigative sites. - Medical coding of adverse events (AEs) and medications (e.g., using MedDRA, WHODrug). - Performing SAE reconciliation (matching 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 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 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. - Maintaining consistent data quality across multiple global sites. - Shortage of qualified professionals and steep learning curve for 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-assured database ready for statistical analysis. - Final locked study database with full audit trail. - Archived project documentation after study completion.

Management of a strategic digitalization project in a hospital network, e.g. the implementation of a new hospital information system (HIS) or an electronic patient record (ePA) according to KHZG. - **Typical tasks:** - Overall responsibility for project planning, control, and monitoring (time, budget, quality). - Management of the interdisciplinary project team. - Requirements, risk, and stakeholder management. - Planning and management of 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 specification, change concept, cutover plan, project closure report.