06.01.2026 aktualisiert

**** ******** ****
Premiumkunde
20 % teilweise verfügbar

Data Analytics & Project Consultant

Berlin, Deutschland
Weltweit
Master of Science - Meteorologie
Berlin, Deutschland
Weltweit
Master of Science - Meteorologie

Profilanlagen

Resume_LH_Jan_2026_ENG.pdf
Resume_LH_Jan_2026_DEU.pdf

Über mich

I am a Data Analytics & Project Consultant with over 9 years of experience. My expertise lies in data visualization, analytics, and managing data-driven projects from conception through execution. I am passionate about turning complex datasets into actionable and impactful insights.

Skills

Apache AirflowAmazon Web ServicesData AnalysisAnalyse von FinanzdatenArchitekturAtlassian ConfluenceAtlassian JiraBankingBig DataBusiness AnalysisUnternehmensreportingETLDatenmodellRelationale DatenbankenDialektisch-Behaviorale TherapieGitHubPostgreSQLProjektmanagementVisualisierungMicrosoft Power BISQLStakeholder ManagementSalesforce TableauTechnische DatenGoogle Data StudioSnowflakeGitLabDatenanalytikLooker AnalyticsKpi-Berichterstattung
Leadership
  1. Skilled in leading and coordinating project teams
  2. Expertise in stakeholder management and engagement
  3. Proven ability to oversee cross-functional projects within small focused teams

Working Style
  1. Consistently organized in fulfilling all project requirements
  2. Strongly committed to approaching tasks with analytical precision
  3. Always accurate and reliable

Technical
  1. Data Mesh Architecture
  2. Relational Databases
  3. ETL Processes
  4. SQL
  5. PostgreSQL
  6. Snowflake
  7. dbt
  8. AWS Athena
  9. Airflow
  10. GitHub/GitLab
  11. Confluence
  12. Jira
  13. MS Excel

Visualization
  1. Tableau Desktop
  2. Tableau Server
  3. Looker Studio
  4. MS Power BI
  5. Sisense

Erfahrung

Berufserfahrung5 - 10 Jahre
Freelancer seit2024

Sprachen

DeutschMutterspracheEnglischverhandlungssicher

Projekthistorie

Analytics Engineering & BI Solutions for Logistics & Business Teams

DocMorris N.V.

Konsumgüter und Handel

250-500 Mitarbeiter

GOALS & SUCCESSES:
1. Development of a Shipping Carrier Dashboard for the internal Logistics Team
→ Improved transparency of carrier performance metrics, enabling data-driven carrier negotiations and the implementation of corrective measures (e.g. pre-sorting) to measurably enhance delivery performance
2. dbt model restructuring and clean-up of 20+ models
→ Reduce dbt model complexity and interdependencies, improving maintainability, execution performance, and overall pipeline reliability
3. GA4 data-based Dashboard migration from Looker Studio to Tableau
→ Conduct detailed analysis of GA4 field usage and redesign the data layer in dbt to provide performant, Tableau-ready data sources

TASKS:
  1. Designed and implemented a ZIP-code-to-region and shipping carrier distribution center mapping, enabling geospatial performance visualization and network analysis
  2. Conduct an in-depth analysis of existing dbt models and dependencies, refactoring the model layer by removing redundant models, reworking existing ones, and introducing new models where required
  3. Deliver analytics on high-volume datasets across core business domains, processing millions of records from Order, Sales, Product, and Marketing systems
  4. Work in close collaboration with stakeholders across all tasks and initiatives

SKILLS USED:
Stakeholder & Project Management, SQL, Snowflake, dbt, Tableau, Looker Studio, GitLab, Confluence, Jira

Freelancer - Data Analytics & Project Consultant

Lisa Hellner - Data Microbe Consulting
Offering services with main focus on:
  • Data Visualization
  • Analytic & Analysis
  • Management of data related projects

Re-Order Alarm Dashboard

Nays GmbH

Konsumgüter und Handel

10-50 Mitarbeiter

GOAL & SUCCESS:
→ Development of a Reorder Alarm Dashboard in Tableau to improve forecasting of required product quantities and optimal reorder timing

TASKS:
  1. Analysed current inventory levels including pre-orders and backorders using SQL
  2. Calculated item-specific reorder thresholds to optimize replenishment timing
  3. Developed a Tableau dashboard with reminder logic and a traffic-light system to highlight items requiring reorder
SKILLS USED:
MySQL, Relational Databases, Tableau

Refinement and implementation of a 50+ KPI external reporting setup

Solaris SE

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

GOAL & SUCCESS:
Complete the implementation of a comprehensive 50+ KPI reporting landscape within just four months
→ Delivered a fully operational reporting framework covering 600K+ customers and their card transactional data by the beginning of Q4 2024
→ Achieved successful validation and approval by all internal and external stakeholders
→ Secured the bank’s contractual guarantee agreements
TASKS:
  1. Effectively managed internal and external key stakeholders to gather, document, and oversee all KPI requirements
  2. Translated 50+ KPI specifications into SQL code, ensuring readiness for testing and seamless report integration
  3. Processed over 600K customer records and 1.7M+ card transaction data points using Snowflake
  4. Developed dbt models to integrate the reporting framework into the internal data infrastructure, enabling a fully automated monthly process
SKILLS USED:
Stakeholder & Project Management, SQL, Snowflake, dbt, Github, Confluence, Jira

Analysis of domain name registration data

dotBerlin Gmbh & Co. KG in Berlin

Internet und Informationstechnologie

10-50 Mitarbeiter

GOAL & SUCCESS:
→ Successfully analysed 10 years of semi-structured legacy data on domain name registrations, creating a concise report to support forecasting of future registrations
TASK:
Analysed a decade of domain name registration data to identify trends and predict future registrations
SKILLS USED:
PostgreSQL, Relational Databases, MS Excel

Planning and preparation for founding of “Data Microbe Consulting” business

Lisa Hellner - Data Microbe Consulting

Domain Lead – Growth Analytics

Solaris SE

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

  • Conducting company key projects and leading them to success, e.g.
    - integration of Deposit Guarantee Scheme (DGS) reporting layer
    - Development and lead on customer uniqueness calculation project
    - Supporting data warehouse migration from AWS Athena to Snowflake
  • Management of all Growth-related requests involving request prioritization, planning resources and stakeholder communication
  • Leading Growth Analytics tasks as vertical layer across different Data Team functions and involvement in important decision making
  • Applying principles of Data Mesh as decentralized data architecture and foster data product driven company culture

Principle Data Analyst

Solaris SE

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

  • Management of cross-functional projects and teams as well as coordination of needs by stakeholders across the company
  • Gathering, refinement and documentation of requirements for large reporting and dashboard projects, including funnel views, product monitoring and customer analysis
  • Development of novel KPIs for Business Units, analysis for product integrations
  • Providing Tableau expertise inside and outside the Data Team
  • Supporting Analytics Platform Team with development of dbt models for data warehouse in Snowflake
  • Applying substantial knowledge of banking processes and products

Senior Data Analyst

Solaris SE

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

  • Leading primary projects of core banking system migration:
    - Regulatory reporting (e.g. 24C, Bista)
    - AML monitoring integration and migrating to new reporting systems
    - Refinement and adjustment of related processes
  • Development of datasets used for internal and regulatory reporting
  • Creation of meaningful and insightful dashboards with Tableau Desktop and Tableau Server
  • Onboarding of new team members and supervising working students
  • Database querying with AWS Athena

Data Analyst

Solaris SE

Banken und Finanzdienstleistungen

500-1000 Mitarbeiter

  • Generation and automation of recurring reports for internal stakeholders
  • Development of dashboards using Sisense and Tableau for internal reporting
  • Owning and overseeing the invoicing process of partners within the Data Team
  • Database access with PostgreSQL

Business Intelligence Analyst

MiNODES GmbH

Internet und Informationstechnologie

10-50 Mitarbeiter

  • Using Tableau Desktop to visualize and analyze data
  • Drawing useful insights for clients by creating interactive dashboards and analysis and publishing them via Tableau Server
  • Day-to-day development on various products
  • Quality assurance and testing processes
  • Database access and maintenance with PostgreSQL

Scientist

Leibniz Institute for Tropospheric Research

Energie, Wasser und Umwelt

50-250 Mitarbeiter

  • Designing and supervising experimental assemblies for ice nucleation experiments

Student Scientific Assistant at the cloud laboratory

Leibniz Institute for Tropospheric Research

Energie, Wasser und Umwelt

50-250 Mitarbeiter

  • Performance of experiments on hygroscopic growth and activation of cloud droplets as well as immersion freezing behavior of various aerosol particles at LACIS (Leipzig Aerosol Cloud Interaction Simulator)

Zertifikate

Data Modeling in Power BI

Microsoft

2025

Extract, Transform & Load Data in Power BI

Microsoft

2024

Tableau Desktop 10 Qualified Associate

Tableau Software

2017

R Programming

Coursera - Johns Hopkins University

2016


Bewertungen


Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden