Project details
Recommended projects
IT Consultant for Business Intelligence Migration (m/f/d)
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
[9689] TECH Data Warehousing Consultant (m/f/d)
- Build and enhance data management in SQL Server for fixed-line and All-IP products, and integrate existing and new data sources from SQL Server/Oracle from CRM systems and workflow management systems
- Develop a database in SQL that captures and consolidates data from different source systems (CRM and workflow systems)
- Create and expand database reports in Tableau for daily reporting
- Advise business units (e.g. Technology, Order Management) on data collection and management of customer data
- Continuously optimize and establish the data management process and data quality for future projects
Celonis Process Analyst (m/f/d)
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
Consultant for Process Management and Data Analysis (m/w/d)
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
Business Analyst for Digitalization in the Insurance Industry (m/f/d)
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
(Senior) Cloud Data Engineer (m/f/d) with focus on Azure
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.
Process and consulting for Asset PnL (m/f/d)
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.
Technical Editor (m/f/d)
A company is looking for an experienced Technical Editor responsible for creating and managing data sheets, product brochures, and catalogs.
These documents are crucial for sales, legally binding, and part of internal quality assurance. The product brochures showcase the key product features and customer benefits, while the data sheets contain detailed specifications.
The role includes independently managing and overseeing all correction and review processes until final approval, as well as ensuring the defined quality and release processes according to company guidelines. In addition, filing the final data in the relevant systems such as the Promo Office database, PDM, and internet CMS is required.
- Creation of data sheets, product brochures, and catalogs according to specifications.
- Preparation of data for print production and ISO-compliant archiving in the product management system.
- Management of versioned documents for print production and online publication.
- Ensuring the defined quality and release processes.
- Filing the final data in the relevant systems.
Construction Supervisor/Construction Manager Fiber Optics (m/w/d)
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.
Freelance Clinical Data Manager (m/f/d)
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.
Creative POS Designer (m/f/d)
A company is looking for a creative POS designer who develops and implements innovative ideas for hospitality spaces.
The goal of the project 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 guidelines and market standards.
The role requires close collaboration with a large field sales team as well as small agencies and workshops.
- Develop new POS ideas for hospitality spaces (e.g., back counters, bar solutions, illuminated logos, displays)
- Visualize and present creative approaches
- Collaborate closely with the field team (80 people in sales)
- Support POS marketing with a strong focus on visibility and brand presence
- Execute projects in line with CI/CD guidelines and market standards
- Work with small agencies or workshops for implementation
IT project manager with knowledge in actuarial science (m/f/d)
- IT project manager activities
- Interface/bridging role between business area and technology, requiring solid subject matter knowledge.
New
Specialist for IT Test Strategy & Governance (m/f/d)
A company is looking for an experienced specialist for IT test strategy and governance who ensures compliance with IT test policy requirements and drives the further development of the framework for IT test governance. The goal of the project is to optimize IT test governance by defining and assessing maturity levels and collecting KPIs across all test types. The specialist will also advance the test policy and service portfolio.
Main tasks:
- Reviewing compliance with IT test policy requirements
- Defining and assessing maturity levels (including measurement points)
- Collecting KPIs across all test types, including test automation
- Further developing the framework for IT test governance, especially the test policy
- Advancing the IT test governance service portfolio
Technical Draftsman / Technical Product Designer / Technician (m/f/d)
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.
P2P / Purchase to Pay / Procure to Pay Expert (m/f/d)
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
New
SAP S/4 HANA O2C Process Consultant (m/f/d)
- 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)
Electrical Commissioning Engineer (m/f/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.
New
IT Administrator (m/f/d) – Windows/Linux/VMware | Veeam | Aruba
A leading company in non-destructive testing of metallic materials, metal detection, and magnetics is looking for temporary reinforcement for the IT department.
The project's goal is support in infrastructure management, especially in server environment administration, backup solutions, and networks. The administrator will work closely with the existing team and ensure structured documentation of the systems.
New
Project Manager for Approval Planning of High-Voltage Installations (m/f/d)
A company is looking for an experienced project manager for the approval planning of infrastructure projects.
- Management and coordination of the approval planning
- Technical support and coordination of all involved service providers (routing, land management, environmental, communications)
- Coordination of interfaces between departments and alignment with relevant stakeholders
- Preparation of regular project reports and continuous updating of project documentation
- Review and approval of deliverables from contracted service providers
- Ensuring compliance with legal and technical requirements
- Advising on the selection and hiring of specialist planners and experts
- Independently creating scope of work documents and evaluating offers
New
Business Development Manager (m/w/d) Defence & International Key Accounts
A leading technology company in defense engineering is looking for an experienced Business Development Manager to develop customized system solutions for international key accounts and drive sales in this sector. The ideal candidate has extensive experience in international defense technology sales and is skilled in developing and presenting complex proposals. This position offers the opportunity to work in an innovative environment and make a significant contribution to security and defense.
The company is a well-known tech firm specializing in the development and production of innovative power systems for safety-critical applications. With around 800 employees across multiple sites, it designs generators, electric motors, drives, power units, power electronics, and hybrid energy systems for the aerospace, security and defense, and rail industries. The company places great value on tailored solutions and offers comprehensive service concepts for various systems.
The project goal is to develop and present customized system solutions for international key accounts in defense engineering and to create complex, tailored proposals that take into account the customers' specific requirements.
- Develop and present customized system solutions for international key accounts in defense engineering.
- Create complex, tailored proposals that meet the customers' specific requirements.
- Monitor markets and competitors to derive targeted sales strategies for key accounts and regions.
- Lead the capture team in proposal development and target pricing, and develop competitive strategies.
- Clarify technical, organizational, and personnel requirements, and independently lead price and contract negotiations.
- Act as the primary contact for the international representative network and coordinate internal resources to optimally support sales activities.
- Continuously screen relevant markets and build a high-performing representative network.
- Represent the company at international trade shows, professional conferences, and customer events.
Frontend developer to HR platform with Angular experience
Reach out to us if you are interested in working with us on the project.
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 for X-Sell, Development & Retention
Industry
Telecommunication
Areas
Business Intelligence
Marketing
Project info
- Period01.08.2024 - 31.12.2024
- Capacityfrom 90%
- Daily rate750 - 850€
- LocationKarlsruhe, Germany
- Languages Essential:
- German(Advanced)
Desirable:- English(Advanced)
- German
- Remotefrom 99%
Description
Building daily up-to-date reports to control existing customer marketing (X-Sell, Development & Retention) across online channels (Control-Center App & Web).
When steering sales measures for existing customers in the online channel (Control-Center App & Web), new standard reports are introduced to measure the efficiency and accuracy of existing and new measures promptly and continuously. 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.
As part of this assignment, the following reports will be created:
Cross-channel: Daily Active Users in the channel including conversion rate in all business cases Here, the number of active customers who have been targeted for sales outreach is to be measured, as well as their shares in company-relevant segmentations (by product ownership, cancellation status, online activity, customer age). Furthermore, the conversion rate of sales successes is determined per active customer to assess and optimize the effectiveness of the outreach. This report is provided for a weekly steering committee with board participation.
X-Sell: Campaign/offer performance compared to plan, as well as concrete prioritization of offer deployment A standard report should be created for precise control of X-Sell campaigns in all products, starting with Small Screen. As technical input, a quantitative plan number per campaign or deployment will be provided and attributed as precisely as possible to actual orders to accurately control the performance of individual campaigns.
Development & Retention: For these business cases, a standard report should be created that, based on customer page movements in the existing customer shop, makes daily traffic, funnel depth, and final conversion evaluable across products.
How should the service be delivered?
The final reports should be provided in PowerBI on the client's reporting server and designed for regular and interactive use. Content relevant for steering committees should be offered in an easily exportable format in PowerPoint or Excel.
Data supply for the reports should be pulled 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 consultation with internal experts, and implemented (including in-code documentation) as regularly maintained queries. Data supply for page movements and funnels (especially in the BK funnel) comes from another, non-compatible data source, Adobe Analytics.
Beyond the above documentation, a documentation should be provided in the team's Confluence area that documents report usage for end users and exposes adjustment options and references to the data used for report maintainers.
Requirements
Where can the service be delivered from: The location can be freely chosen by the external resource; it can be remote or at the project site 76135 Karlsruhe, Hinterm Hauptbahnhof 3. For the first project phase of approx. 3 weeks, presence on site in Karlsruhe (Tuesday–Thursday) is strongly desired.
Required profile:
- Data Analyst or Data Scientist with practical understanding of online marketing and preferably telecom experience
MUST:
- SQL
- PowerBI
- Basic statistical knowledge
- Technical understanding of online platforms and telecommunications topics
Nice to have:
- Adobe Analytics
- Ad server
- Creation of standard online reports for channel control
English
Powered by FRATCH.IO GmbH