Project details

Recommended projects

IT Consultant for Business Intelligence Migration (m/f/d)

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
Telecommunications
Munich, Germany
100% remote
New

Celonis Process Analyst (m/f/d)

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
Telecommunications
Düsseldorf, Germany
100% remote

Digital Marketing & CDP Specialist (m/f/d)

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.
Industry - Consumer Goods
Erlangen, Germany
100% remote

Business Analyst for Digitalization in the Insurance Industry (m/f/d)

Typical tasks: - Analyzing existing insurance processes and identifying digitalization potentials - Gathering and documenting business requirements together with the business units - Creating solution concepts for digital transformation (including process modeling and cost-benefit analyses) - Acting as liaison between business and IT: translating requirements into technical concepts and supporting implementation - Supporting project management in planning and deploying new digital solutions (agile methods such as 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 lead times, increase in customer satisfaction/user adoption, reduction of manual efforts through automation Challenges: coordinating multiple 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 requirements 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 enable flexible adjustments; in-depth industry knowledge (products, regulation) is crucial for designing viable digital solutions
Insurance Industry
Germany
80% remote

Business Analyst - Securities Trading (m/f/d)

A company is seeking an experienced Business Analyst to adopt the product perspective within a squad and advise the Squad Owner (Product Owner) to maximize value creation while continuously incorporating customer and market insights. The Business Analyst will keep track of market requirements, coordinate with customers and partners, maintain the squad backlog, and ensure the professional quality of deliverables. The position requires independent, cross-functional analysis and alignment of business requirements directly with business units, squad owners, technical teams, and product management. - Advising the Squad Owner on the squad’s (partial) products and services, including technical components. - Supporting business aspects from ideation and concept through market launch and maintenance according to the life-cycle process. - Aligning and validating ideas and requirements, as well as assisting in the creation of user stories and maintenance of the squad backlog. - Shaping a customer-centric squad vision, coordinated roadmap, and release plan in line with corporate objectives. - Conducting innovation work and product-specific market observation to ensure competitiveness. - Ensuring stable operations according to agreed service level agreements and regulatory requirements. - Creating requirements specifications, documents, and service descriptions as part of product definition. - Closely coordinating on architecture and refactoring topics with architecture roles. - Ensuring functional and non-functional quality of deliverables by creating and executing test cases.
Finanzen
Frankfurt, Germany
100% remote

(Senior) Cloud Data Engineer (m/f/d) with focus on Azure

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.
E-Commerce – Retail
Berlin, Germany
100% remote

Process and consulting for Asset PnL (m/f/d)

We are seeking 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:** - Analysis and documentation of existing end-to-end P&L processes for various asset classes (e.g., equities, fixed income, derivatives). - Identification of weaknesses, risks, and inefficiencies in data collection, processing, and reporting. - Design and conceptualization of optimized target processes for P&L calculation and attribution. - Development of functional specifications and business requirements for adapting or implementing IT systems (e.g., P&L engines, data warehouses). - Project management for the implementation of new processes and tools, including milestone planning, stakeholder management, and test coordination. - Development of control mechanisms to ensure data quality and consistency. - Creation of training materials and delivery of 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 gain. - Decrease in manual corrective postings: target >50% reduction through process automation. - Data quality index: increase of the "first-time-right" rate in data acquisition to >99%. - Efficiency ratio (cost-to-income): demonstrable positive impact on lowering the ratio. - User adoption rate: acceptance of new processes/tools by the business >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 (“Deliverables”):** - Milestone 1: Completed as-is analysis and process documentation. - Deliverable 1: Detailed analysis report including assessment of weaknesses. - 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.
Financial Services – Asset Management / Investment Banking
Berlin, Germany
100% remote
New

Creative POS Designer (m/f/d)

A company is looking for a creative POS designer who develops and implements innovative ideas for gastronomy areas. The project's goal is to increase visibility and brand presence through creative POS solutions. The focus is on developing and visualizing new concepts that comply with CI/CD requirements and brand guidelines. The role requires close collaboration with a large field sales team as well as small agencies and workshops. - Development of new POS ideas for gastronomy areas (e.g., back counters, bar solutions, illuminated logos, displays) - Visualization and presentation of creative approaches - Close collaboration with the field team (80 people in sales) - Support in POS marketing with a strong focus on visibility and brand presence - Implementation in compliance with CI/CD requirements and brand guidelines - Collaboration with small agencies or workshops for implementation
Gastronomy
Munich, Germany
100% remote

ECL@SS Consultant (m/f/d)

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.
IT
Kassel, Germany
100% remote

Freelance Clinical Data Manager (m/f/d)

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.
Life Sciences – Pharma / Contract Research Organization (CRO)
Munich, Germany
100% remote

Fiber Optic Construction Supervisor/Site Manager (m/f/d)

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.
Telecommunications
Saarbrücken, Germany
80% remote
New

IT Project Manager with Actuarial Knowledge (m/f/d)

- IT project manager activities - Interface / bridging function between business domain and technology, hence the required compelling subject matter expertise.
Insurance
Munich, Germany
100% remote

Consultant / IT Architect for IT Solution Design in RDBMS (m/f/d)

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.
IT – Database Architecture & Management
Munich, Germany
100% remote

Senior IT Consultant - Oracle HCM (m/w/d)

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
IT
Germany
100% remote

MES Consultant with Focus on Hydra X (m/f/d)

A company is looking for an experienced MES consultant focusing on Hydra X from MPDV to support the expansion of the system to additional sites. The system is already rolled out at one site and is now to be further scaled. The role includes supporting the introduction of new functions or versions of the system, implementing system adjustments and optimizations based on production requirements, as well as accompanying the rollout. The consultant will work closely with internal teams and external service providers to ensure the rapid identification and resolution of issues in the MES system. - Support in the introduction of new functions or versions of the system - Implementation of system adjustments and optimizations based on production requirements - Assistance with the rollout to additional sites - Rapid identification and resolution of problems in the MES system
Manufacturing
Germany
100% remote

Technical Drafter / Technical Product Designer / Technician (m/f/d)

On behalf of a leading medical technology company, an experienced technical drafter or product designer is being sought to create and maintain technical documentation and design drawings. - **Typical responsibilities:** - Creation of standards-compliant 2D manufacturing drawings and 3D models of parts and assemblies using CAD software. - Detailing and dimensioning of designs, considering geometric and positional tolerances. - Creation and management of bills of materials and technical documents in the PDM/PLM system (e.g., SAP ECTR). - Implementation of revision services on existing drawings and documentation. - Close collaboration with the development and production departments to ensure manufacturability. - **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: thorough 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 loops). - Compliance with internal and external design and documentation standards. - Efficiency in implementing 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). - Seamless traceability of changes (versioning). - Complexity of parts to be designed (e.g., freeform surfaces, complex assemblies). - Close coordination with various stakeholders (development, purchasing, quality assurance, production). - **Concrete deliverables:** - Approval-ready 2D manufacturing drawings and 3D CAD models. - Complete and released bills of materials in the ERP system. - Updated technical product documentation. - Change logs. - **Lessons learned/best practices:** - A clear and standardized template management significantly accelerates the creation process. - Regular alignment meetings with production can prevent costly errors early. - Careful maintenance of master data in the PDM/PLM system is the foundation for efficient collaboration.
Medical Technology – Development & Design
Leipzig, Germany
100% remote

Electrical Commissioning Engineer (m/w/d)

A company is seeking an experienced Electrical Commissioning Engineer to support an industrial/utility project in Narva, Estonia. The role involves acting as the first point of contact on-site for electrical commissioning issues, reviewing complex documentation, and resolving design and installation challenges, particularly from third-party packages. The engineer will evaluate faults, propose solutions, and defend the client's position when necessary. Clear communication with stakeholders and independent client-side representation are key aspects of this role. - Act as the first point of contact on-site for electrical commissioning issues. - Review and navigate complex documentation related to electrical systems. - Identify and resolve design and installation issues, especially from third-party packages. - Handle MCCs, generic point lists, and interface mismatches. - Evaluate responsibility for faults: If blame is justified → propose and implement a solution. If blame is unjustified → defend the client's position. - Represent and communicate problems clearly to relevant stakeholders.
Germany
100% remote

Expert for Cadastral Surveying and AI (m/f/d)

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
Public Sector
Düsseldorf, Germany
80% remote
New

HSE-Manager / Sicherheitsfachkraft (m/w/d)

Ein Unternehmen sucht eine freiberufliche Unterstützung im Bereich HSE-Management / Sicherheitsfachkraft für ein langfristiges Projekt. Ziel des Projekts ist die Sicherstellung und Koordination der sicherheitstechnischen Maßnahmen auf einer Baustelle in Wiesbaden gemäß gesetzlichen und vertraglichen Vorgaben. Die Rolle umfasst die Verantwortung für die Umsetzung und Überwachung von Arbeitsschutzmaßnahmen, die Durchführung von Schulungen und Audits sowie die Erstellung und Pflege von HSE-Berichtswesen. Der HSE-Manager wird eng mit Kunden, Konsorten und Kontraktoren zusammenarbeiten, um die Einhaltung der Sicherheitsstandards zu gewährleisten. Key responsibilities: - Koordination der sicherheitstechnischen Maßnahmen auf der Baustelle gemäß §4 Arbeitsschutzgesetz - Abstimmung und Koordination der Arbeitsschutzmaßnahmen mit den Kontraktoren - Pflege und Aktualisierung des HSE-Site Manuals - Durchführung von Toolbox-Meetings - Teilnahme an Koordinationsgesprächen - Erstellung und Durchführung gewerke-bezogener Gefährdungsbeurteilungen - Regelmäßige Baustellenbegehungen inkl. Berichterstattung und Fotodokumentation - Meldung und Nachverfolgung von Mängeln sowie Ableitung geeigneter Maßnahmen - Durchführung von Schulungen und Unterweisungen im Bereich HSE - Überwachung der Nutzung persönlicher Schutzausrüstung - Organisation und Durchführung von HSE-Audits - Erstellung und Pflege des HSE-Berichtswesens - Prüfung relevanter Lieferantenunterlagen - Analyse von Arbeits- und Beinaheunfällen inkl. Präventionsmaßnahmen - Weisungsbefugnis gegenüber Kontraktoren in HSE-relevanten Themen
Construction
Wiesbaden, Germany
20% remote
New

LibreOffice Extensions Developer (m/f/d)

- Collaborate in the software development process in the field of process automation and word processing - 3rd level support - Participate in the analysis of software requirements in an agile development environment
Insurance
Dortmund, Germany
100% remote

Frontend developer to HR platform with Angular experience

Reach out to us if you are interested in working with us on the project.
FRATCH
Munich
90% remote
Sign up to get access to more exciting projects that match your skills and preferences!

Time's up! We are no longer accepting applications.

Consulting in the area of Reporting X-Sell, Development & Retention

Industry
Telecommunication
Areas
Business Intelligence
Marketing

Project info

  • Period
    01.08.2024 - 31.12.2024
  • Capacity
    from 90%
  • Daily rate
    750 - 850€
  • Location
    Karlsruhe, Germany
  • Languages
    Essential:
    • German
      (Advanced)
    Desirable:
    • English
      (Advanced)
  • Remote
    from 99%

Description

Building daily reports for steering existing customer marketing (X-Sell, Development & Retention) via the online channels (Control-Center App & Web).

When steering sales measures for existing customers in the online channel (Control-Center App & Web), new regular reports are introduced to measure the efficiency and accuracy of existing and new measures in a timely and continuous manner. The sales success of these measures is reflected in all business transactions in the existing customer business (X-Sell, Development & Retention) and all products. Depending on the use case, specialized reports and KPIs must be created.

Within the scope of this engagement, the following reports are to be created:

  • Cross-channel: Daily Active Users in the channel including conversion rate in all business transactions This report measures the number of active customers who have been targeted by a sales action, as well as their shares in company-relevant segmentations (by product ownership, cancellation status, online activity, customer age). Furthermore, the conversion rate regarding sales successes is determined per active customer to establish and optimize the effectiveness of the actions. This report is provided for a weekly steering committee with board involvement.

  • X-Sell: Campaign / offer performance compared to plan, as well as concrete prioritization of offer delivery A standard report should be created for precise steering of the X-Sell campaigns across all products, starting with Small Screen. As technical input, a quantitative planned number per campaign or delivery is provided and attributed as precisely as possible to the actual orders to accurately steer the performance of individual campaigns.

  • Development & Retention: For these business transactions, a standard report should be created that evaluates daily traffic, funnel depth, and final conversion across products based on customer page movements in the existing customer shop.

How should the service be delivered?

The final reports should be provided in Power BI on the client's reporting server and designed for regular and interactive use. The contents relevant for steering committees should be made available in an easily exportable format in PowerPoint or Excel.

The data supply for the reports should be retrieved via SQL queries from the central Data Warehouse (SQL Server). Prototype SQL queries already exist for most requested reports; these must be technically and functionally reviewed and optimized during the project phase in coordination with internal knowledge holders, and implemented in regularly maintained queries (including "code-level" documentation). The data supply for page movements and funnels (especially in the BK funnel) comes from another, not combinable data source, Adobe Analytics.

In addition to the above documentation, a documentation should be provided in the team's Confluence area that documents report usage for end users and discloses customization options and references to the data used for report developers.

Requirements

Where can the service be performed from: The location of service delivery can be freely chosen by the external resource; it can be performed both remotely and at the project site 76135 Karlsruhe, Hinterm Hauptbahnhof 3. For the first project phase of about 3 weeks, presence at the Karlsruhe site (Tuesdays – Thursdays) is strongly desired.

Required profile:

  • Data Analyst, Data Scientist with subject matter understanding of online marketing and ideally telecom experience

MUST:

  • SQL
  • Power BI
  • Basic statistical knowledge
  • Technical expertise regarding online platform and telecommunications topics

Nice to have:

  • Adobe Analytics
  • Ad insertion / ad server
  • Creation of online standard reports for channel management