Willi Ziegenhagel
Data Analyst
Experience
Sep 2023 - Present
1 year 11 monthsFrankfurt, Germany
Data Analyst
- Project: Process analysis and optimization (Industry: Banking)
- Technologies: SQL, Celonis
- Analysis of process data
- Data preparation with SQL
- Development of reports & dashboards in Celonis
May 2023 - Aug 2023
4 monthsLeipzig, Germany
Dashboard Designer and Power BI Expert
- Project: Dashboard development for web and app analytics (Industry: Insurance)
- Technologies: Power BI, DAX, RLS
- Design of target-group specific dashboards
- Development of data models, DAX
- Development of reports & dashboards in Power BI
- Implementation of row-level security
Oct 2022 - May 2023
8 monthsHamburg, Germany
Interim BI Manager & Product Owner
- Project: Building data platform (Industry: E-Commerce)
- Technologies: AWS Redshift, Python, Power BI, DAX, RLS
- Support in developing a data strategy
- Product Owner for multiple data products
- Development of data models, reports, DAX, RLS in Power BI
- Development of SQL views for data preparation
Mar 2022 - Oct 2022
8 monthsZeven, Germany
BI Consultant
- Project: Building marketing reporting platform (Industry: Baby products)
- Technologies: Microsoft Power Platform, Power BI
- Development of data model and loading processes
- Development of reports and dashboards with Power BI and integration into marketing reporting platform.
Mar 2022 - Oct 2022
8 monthsRegensburg, Germany
Data Consultant
- Project: Implementation of a new CRM (Industry: E-Commerce)
- Technologies: Microsoft Dynamics CRM, Azure Data Factory
- Responsible for the data migration stream.
- Gathering and systematizing business requirements and dependencies.
- Breaking down work packages into sensible functional and technical units.
Mar 2020 - Feb 2022
2 yearsStuttgart, Germany
Senior Analytics Consultant
Kaiser X Labs GmbH
- Project: Data strategy consulting (Industry: Insurance)
- Technologies: Power BI, Oracle, MicroStrategy, Adobe Analytics
- Responsible for identifying, prioritizing and implementing analytical use cases.
- Gathering and systematizing business requirements and dependencies.
- Breaking down work packages into sensible functional and technical units.
- Competent contact person for analytics topics.
- Analysis of customer behavior with the goal of improving products.
- Development of key metric models to guide teams.
Oct 2018 - Feb 2020
1 year 5 monthsWolfsburg, Germany
Business Analyst & Scrum Master
Hexad GmbH
- Project: Development of an application for predicting machine failures (Industry: Automotive)
- Technologies: Jira, Postman, PowerPoint
- Responsible for the Scrum process and its correct implementation.
- Advising the Product Owner on formulating requirements.
- Facilitating Scrum rituals (Daily, Planning, Review, etc.).
- Removing obstacles for the development team.
Dec 2017 - Sep 2018
10 monthsWolfsburg, Germany
Scrum Master / Requirements Manager / BI Analyst
Hexad GmbH
- Project: Development of a sales cockpit (Industry: Automotive)
- Technologies: OpenText Analytics Studio, Oracle 11.1, Atlassian Jira
- Responsible for the Scrum process and its correct implementation.
- Advising the Product Owner on formulating requirements.
- Facilitating Scrum rituals (Daily, Planning, Review, etc.).
- Analyzing requirements for feasibility (data analysis).
- Designing data architecture and models.
Jan 2017 - Nov 2017
11 monthsHeilbronn, Germany
BI Consultant
mayato GmbH
- Project: Building an internal corporate planning (Industry: Retail)
- Technologies: IBM TM1, Exasol
- Requirements management, design and implementation of an application for internal corporate planning (cost center and cost type planning), including management dashboard and interface for adjusting permissions.
Jul 2015 - Dec 2016
1 year 6 monthsBraunschweig, Germany
BI Consultant
mayato GmbH
- Support in project management for creating a data lake pilot in the project 'Building a data lake for consolidating global enterprise data' (Auto bank, Braunschweig).
- Requirements management, design and consulting in the context of Big Data technologies (Hadoop, Cloudera tools, Impala, Hive, Spark, Oozie, Sqoop) for the same project.
- Building a data warehouse for risk management in SAP BW in the project 'Building an analytical data warehouse for risk management' (Auto bank, Braunschweig).
- Focus on development and quality assurance of delivered solutions for the data warehouse project.
- Technologies used included Hadoop (Cloudera tools, Impala, Hive, Spark, Oozie, Sqoop) and SAP BW.
Mar 2014 - Jun 2015
1 year 4 monthsPaderborn, Germany
BI Consultant
mayato GmbH
- Project: Modernization of corporate planning (Industry: Food industry)
- Technologies: SAP BW, SAP BW-IP
- Development of a planning application for sales and demand planning.
Summary
- Focus on data analysis and visualization
- Several years of experience in business intelligence projects
- Certified data strategy consultant
- Certified Data Analyst (Microsoft Power BI Data Analyst)
- Industry experience in automotive, insurance and retail
- Tools: Power BI, Tableau, SQL, R, Python
Languages
German
NativeEnglish
AdvancedFrench
Elementary Education
Mar 2010 - Feb 2014
Hanover University of Applied Sciences and Arts
Business Informatics · Hanover, Germany
Sep 2005 - Jul 2008
Deutsche Telekom AG
IT Systems Sales Specialist
Certifications & licenses
Data Strategy Consultant
datentreiber.de
Microsoft Power BI Data Analyst
Microsoft
Professional Scrum Master
Scrum.org
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.