In assignment for a renowned client in the life sciences sector, a freelance support is sought in the area of Clinical Data Management. The main task is taking responsibility for 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). - 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 lifecycle. - Development and execution of query processes to resolve data inconsistencies with investigative sites. - Medical coding of adverse events (AEs) and medications (e.g., using MedDRA, WHODrug). - Conducting SAE reconciliation (matching serious adverse events). - Preparation and execution of database locks 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/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 query resolution (target: < 10 business days for critical queries). - Compliance: 100% adherence to DMP-defined milestones and processes. - Protocol adherence: Rate of protocol deviations related to data management < 5%. - Key challenges, risks, or specifics:** - Managing increasing volumes and sources of data (e.g., wearables, ePROs). - Ensuring data integrity and security (cybersecurity, data protection/GDPR). - Complexity due to mid-study changes (protocol amendments) and their impact on the database. - Ensuring consistent data quality across multiple global investigative sites. - Shortage of qualified specialists and high demands for onboarding in 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, and analysis-ready database. - Final locked study database with complete audit trail. - Archived project documentation after study close-out.

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

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

Within the scope of a digitization initiative, software quality is to be ensured and improved through modern testing, analysis, and review procedures. The goal is to increase development quality and efficiency through strategic measures and coaching. - Definition, monitoring, and improvement of test coverage strategies for critical software components. - Organization and execution of code reviews in compliance with coding standards, architectural, and security requirements. - Setup, execution, and evaluation of SonarQube analyses, as well as coordination of the remediation of technical debt and security vulnerabilities. - Training and support of developers in Clean Code, TDD, and CI/CD practices. - Evaluation and continuous further development of QA processes, tools, and metrics.

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

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

A company is looking for an experienced project manager with a civil engineering background for the power plant or energy industry. The aim of the project is to lead the planning, coordination and implementation of construction projects in the energy and power plant sector. The role requires close collaboration with interdisciplinary teams to ensure that projects are completed on time and within budget. It is explicitly stated that construction supervisors are not being sought. Main responsibilities: - Management and oversight of construction projects in the power plant or energy industry - Coordination between various disciplines and external partners - Ensuring compliance with safety and quality standards - Development and monitoring of project schedules and budgets - Identification and resolution of technical challenges - Reporting to stakeholders and management

A leading automotive supplier is seeking an experienced quality expert for the inspection of weld seams on safety-critical body components. The project includes ensuring the highest quality standards through non-destructive testing methods. - Typical tasks: Independent planning, execution and evaluation of non-destructive tests (NDT), in particular visual testing (VT) and ultrasonic testing (UT). Creation and management of test plans and work instructions. Detailed documentation of test results in CAQ systems. Analysis of defect patterns and initiation of corrective actions in close coordination with welding shop and production planning. Calibration and maintenance of testing equipment. - Relevant technologies/tools: Ultrasonic testing devices, endoscopes, videoscopes, CAQ software (e.g. Babtec, QSYS), knowledge of standards DIN EN ISO 9712, ISO 5817, as well as relevant VDA volumes. - KPIs/success metrics: First Pass Yield (FPY) > 98%, reduction of internal defect rate (PPM), zero-defect tolerance on safety-critical seams (escape rate = 0), on-time completion of test orders. - Special challenges: Evaluating complex seam geometries under time pressure. Clear interpretation of test results and distinguishing between permissible irregularities and critical defects. Enforcing quality standards against production. - Deliverables: Completed test protocols, detailed defect analyses and reports, updated work and test instructions, contributions to FMEAs (Failure Mode and Effects Analysis). - Best practices: Regular team coordination (shopfloor management), continuous improvement of test processes (CIP), raising awareness and training of production staff.

A company is looking for an experienced Technical Project Manager in the field of district heating. The project objective is the planning and construction of district heating pipelines across all service phases of HOAI, as well as taking on complex project tasks. The Project Manager will play a key role in managing and coordinating projects, working closely with engineering firms, municipalities, authorities, and internal stakeholders. The role includes developing and optimizing planning options to maximize the efficiency and sustainability of projects. In addition, the Project Manager will continuously improve technical planning guidelines and processes, conduct technical-economic analyses, develop scenarios, and create concepts. Another focus is on budget planning for network investments in the heating sector, in close coordination with central controlling, as well as performing network calculations. - Planning and construction of district heating pipelines across all service phases of HOAI. - Management and coordination of projects in collaboration with engineering firms, municipalities, authorities, and internal stakeholders. - Development and optimization of planning options to increase efficiency and sustainability. - Support in improving technical planning guidelines and processes. - Conducting technical-economic analyses as well as developing scenarios and concepts. - Preparing budget planning for network investments in the heating sector. - Performing network calculations.

For a large pharmaceutical company, an IMP (Investigational Medicinal Product) Quality Manager is sought to ensure GMP compliance and quality of investigational products. **Typical responsibilities in this role:** - Review and approval of manufacturing and batch protocols (Batch Records) for drug substance and drug product. - Execution of final quality release of investigational products for use in clinical trials. - Review and approval of GMP-relevant documents such as SOPs, validation reports, deviations and change control requests. - Creation and maintenance of product-specific quality agreements with internal and external partners. - Support for production and QC departments on all GMP-related questions and quality issues. - Planning and conducting internal audits and support during regulatory inspections and external audits. - Management and oversight of CAPA (Corrective and Preventive Actions) measures for sustainable problem resolution. **Relevant technologies, tools or methods:** - Quality management systems (QMS): Veeva Vault QMS, MasterControl, TrackWise, SAP QM. - Document Management Systems (DMS): Veeva Vault, OpenText Documentum. - ERP systems: SAP S/4HANA (especially QM module). - Laboratory Information Management Systems (LIMS). - Manufacturing Execution Systems (MES). - Methods: risk analysis (FMEA), root cause analysis (5 Whys, Ishikawa), statistical process control (SPC). **Typical KPIs or success metrics:** - Batch Release Time: average time from production completion to final release (target: < X days). - Right-First-Time Rate: percentage of batches released without deviations or rework (target: > 95%). - CAPA Effectiveness: reduction in recurrence rate of deviations after CAPA implementation (target: > 80%). - Audit Performance: number of critical/major findings in internal and external audits (target: 0). - Deviation Closure Rate: percentage of deviations closed within the defined timeframe (target: > 90%). **Key challenges, risks or specifics:** - High complexity and variability due to the development of new molecules and processes in the clinical phase. - Strict adherence to constantly evolving GMP regulations (e.g. EU Annex 1 for sterile products). - Ensuring product quality and patient safety under high time pressure (time-to-market). - Managing interfaces between development, manufacturing, QC, and regulatory affairs. - Risk of supply chain interruptions for critical raw materials or services. - Ensuring data integrity in all quality-relevant systems. **Concrete deliverables:** - Released batches of investigational products. - Approved master batch records and SOPs. - Completed and assessed deviation and change reports. - Audit and inspection reports with tracked action plans. - Valid quality agreements with all relevant partners. - Regular quality reports for management.

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

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

For a project in the power plant environment, a freelance specialist for the migration and adaptation of the ABB 800xA control system is urgently sought. - 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 adaptation of process displays, operator interfaces, and alarm management configurations. - Execution of system tests, error analysis, and performance optimizations to ensure plant availability and controllability. - Technical support for operations personnel during the commissioning and ramp-up phase. - Preparation and maintenance of technical documentation (functional diagrams, configuration descriptions, test protocols). - Close collaboration 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. - Fieldbus systems: PROFIBUS, Foundation Fieldbus, Modbus. - Virtualization: VMware, Hyper-V for test and development environments. - Databases: SQL knowledge for analysis of historical data (e.g. 800xA History). - Knowledge of relevant standards for process and power plant technology (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 personnel on the new system environment. - Specific challenges, risks or peculiarities:** - Migration during live 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 displays 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.

- Construction management for the installation of electrical systems in the context of a grid connection project - Ensuring compliance with budget, schedule and quality objectives as well as all relevant legal regulations - Reviewing technical documents such as construction plans, material lists and performance records - Coordination and communication with subcontractors, suppliers and project stakeholders - Interface management and ensuring a smooth project process

## Service Description without Personal Reference - **IT Project Management**: Creation of software rollout and migration plans for the bi-monthly releases of the MDOI application based on Blueplanet, taking into account all relevant dependencies using JIRA and stakeholder management - **Design Management**: Planning and creation of all relevant designs as well as their review in the Multi Domain Orchestration and Inventory (MDOI) tool for the Transport Networks sub-area, serving as implementation documentation of requirements using JIRA and Confluence - **Stakeholder Management**: Development and execution of communication measures regarding software changes based on the created designs, verification that the requirements are fully covered by the designs, including the preparation of documentation for management using Microsoft Outlook, Microsoft Teams, and JIRA

A company is seeking an experienced engineering expert for sterile filling to support a challenging project in pharmaceutical production. The goal of the project is to optimize the efficiency and quality of filling processes and ensure compliance with all regulatory requirements. In this role, the expert will work closely with the internal team to develop technical solutions, analyze existing processes and implement improvements. Main Tasks: - Analysis and optimization of processes in sterile filling - Ensuring compliance with GMP and other regulatory requirements - Development and implementation of technical solutions for process improvement - Collaboration with interdisciplinary teams - Documentation and reporting of progress and results

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

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

An organization is seeking an experienced construction supervisor or site manager in the fiber optics environment to professionally accompany and oversee the construction services of a general contractor in FTTH broadband deployment. The goal is to ensure that the construction services comply with the requirements of the execution planning and that the FTTH broadband network is fully rolled out. The construction sites are located near Würzburg and Saarbrücken. The role includes monitoring compliance with schedules, occupational safety requirements, and quality of construction services, as well as coordinating and documenting construction activities. The site manager will independently create a construction diary and a complete documentation, track subcontracted services, and verify the accuracy of planning and construction documents. - Professional accompaniment and oversight of a general contractor's construction services in FTTH broadband expansion. - Ensuring adherence to schedules, occupational safety requirements, and the quality of construction services. - Recording and reviewing the planning and construction documents of third-party companies. - Independently creating a construction diary and complete documentation. - Tracking deadlines, controlling, and documenting ordered services and deliveries. - Construction supervision and safety control of the construction site according to the HSE concept.

Steering a strategic digitalization project in a hospital network, e.g. the implementation of a new HIS or an electronic patient record (ePA) in accordance with the KHZG. - **Typical areas of responsibility:** - 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.