11.11.2025 aktualisiert
Premiumkunde
100 % verfügbarData Analyst / BI-Consultant / Business Analyst / AI-Consultant
Rheine, Deutschland
Deutschland
Business Management in the Health Sector (B.A.)Skills
IBM WatsonAgile MethodologieKünstliche IntelligenzData AnalysisApple MacConfluenceJiraAutomatisierungMicrosoft AzureBusiness IntelligenceBusiness Process Model And NotationBusiness AnalysisCloud ComputingCloud-SpeicherIt-BeratungDatenbankenBeratungData IntegrationETLData MigrationData WarehousingElasticsearchSpssPostgresqlMicrosoft Visual StudioSql AzureMysqlPowerpivotScrumPower BiProzessautomatisierungRisikoanalyseSap HanaSqliteStakeholder ManagementUMLVirtualizationWorkflowsChatbotsLarge Language ModelsSnowflakeIndexerPowerqueryFigmaBetriebssystemeReporting-ToolsAzure Service FabricRisikomanagementAirtableKpi-BerichterstattungDatabricksVmware
Data Analytics & Business Intelligence
- Tools & Platforms: MS Power BI, Excel (Power Query, Power Pivot), IBM SPSS, Lime Survey, Databricks, Matillion, Snowflake, Azure Data Flows, DWH, MS Access, Airtable
- Practices: Data preparation, transformation, modeling, exploration, visualization
- Dashboards & Reporting: KPI definition, interactive dashboards, publishing reports, automated reporting
- Advanced Analytics: Case distribution analysis, ABC analysis, time analysis, risk analysis, patient movement evaluation
AI & Automation
- Platforms & Tools: n8n, dify, LLM-based chatbots, IBM Watson
- Automation: Workflow design and implementation, process automation, data migration pipelines
- Search & Data: ElasticSearch for intelligent retrieval and indexing
Project & Business Analysis
- Methodologies: Agile, Scrum, MVP workshops, As-Is Analysis, BPMN, UML
- Tools: Jira, Confluence, Figma, Azure DevOps
- Practices: Requirements gathering, backlog prioritization, process modeling, team coordination, risk management, budget control, scope definition, reporting
Databases & Storage
- Relational: MySQL, MS Access, PostgreSQL, SQLite, Azure SQL
- Cloud & DWH: Snowflake, Azure Blob Storage, Azure DWH
- Data Integration: automation of data pipelines
Platforms & Tools
- Operating Systems: Windows, Mac
- Microsoft & Development Tools: MS Office, MS Visual Studio, MS Fabric, Azure Cloud Flows
- Virtualization & Enterprise Systems: VMware, SAP S4/HANA, Aidbox
Soft Skills & Leadership
- Communication: Stakeholder management, facilitating workshops, translating business needs into technical solutions
- Leadership: Team coordination, mentoring users and junior analysts, guiding adoption of BI and reporting tools
- Problem Solving: Project recovery, optimization of reporting workflows, analytical troubleshooting
Sprachen
DeutschMutterspracheEnglischverhandlungssicher
Projekthistorie
Project Overview
Working for a major industrial retailer to optimize the supplier and manufacturer portfolio across the product range. The project focuses on developing a scoring system for manufacturers, suppliers, and product groups to support data-driven decisions for portfolio management and supplier prioritization. The role involves analyzing ERP and historical data, defining KPIs, and transforming insights into actionable dashboards for business stakeholders.
Key Responsibilities
- Gather requirements and define KPIs for supplier, manufacturer, and product group scoring
- Develop a scoring methodology based on business rules, historical data, and performance metrics
- Extract, transform, and load data from Infor M3 ERP, SQL databases, and Excel sources
- Build Power BI dashboards and visualizations to support decision-making and portfolio management
- Collaborate with business users to validate scoring criteria and optimize analytics workflows
- Document methodologies, assumptions, and maintain transparent processes
Technologies
Power BI, Analysis Services, SQL Server, Excel, Infor M3 ERP, Microsoft Forms, Figma
Achievements / Impact
- Developed a robust, scalable scoring system for suppliers, manufacturers, and product groups
- Enabled data-driven decision-making for portfolio optimization and supplier prioritization
- Improved visibility into supplier performance and product group profitability
- Streamlined analytics workflows, reducing manual reporting effort and enhancing reporting accuracy
Project Overview
Consulted and developed an AI-driven solution for a small HR company to optimize vacancy search and reduce manual workload. The tool integrates automation workflows, chatbots, and large language models (LLMs) to accelerate candidate search and matching, cutting process time from around one hour to just 5–15 minutes. From a consulting perspective, the focus was on understanding business processes, identifying automation potential, and ensuring adoption of AI and data-driven solutions across the organization.
Key Responsibilities
- Analyzed business requirements and modeled HR processes to identify automation opportunities
- Acted as liaison between stakeholders and technical team, translating business needs into AI/automation workflows
- Designed and configured automation pipelines using n8n and dify
- Implemented chatbot prototypes to support vacancy search and candidate communication
- Guided stakeholders on AI adoption, integration strategy, and best practices for workflow optimization
- Produced documentation and provided training to ensure smooth handover and organizational adoption
Technologies
n8n, dify, ElasticSearch, Jira, Confluence, LLM
Achievements / Impact
- Reduced vacancy search and processing time by 80–90%
- Enhanced data accessibility and search quality with ElasticSearch-powered retrieval
- Introduced AI-driven workflows that significantly lowered manual workload for HR teams
- Provided strategic consulting to enable a sustainable AI adoption roadmap
Project Overview
Served as Project Manager and BI Consultant for the creation of an MVP energy management solution for a German EMS provider. The focus was on coordinating the development team, facilitating stakeholder communication, and identifying the most valuable KPIs and datasets to be integrated into the platform. Additionally, designed and validated dashboard concepts to provide real-time insights into energy consumption, efficiency, and performance metrics.
Key Responsibilities
- Defined project scope, created schedules, and coordinated agile workflows (Scrum methodology)
- Communicated with stakeholders to align requirements and KPIs with business goals
- Managed risks, budget, and resource utilization to keep the project within scope and cost constraints
- Facilitated process modeling with BPMN to map workflows and data flows
- Led efforts in data visualization and dashboard prototyping for business and technical stakeholders
- Maintained comprehensive project documentation and reporting in Jira and Confluence
Technologies
Agile (Scrum), Jira, Confluence, BPMN
Achievements / Impact
- Successfully delivered MVP scope within budget and timeline constraints
- Established clear KPIs and dashboard metrics to support data-driven decision-making
- Improved collaboration between stakeholders and development team through structured process modeling and agile practices
- Provided a scalable foundation for further EMS product development