My Vita

FREELANCING PROJECTS

05/2024 - 02/2025

Refinement and implementation of a 50+ KPI external reporting setup

CLIENT: Solaris SE in Berlin | Financial Services & Banking Industry

 

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:

  • Effectively managed internal and external key stakeholders to gather, document, and oversee all KPI requirements
  • Translated 50+ KPI specifications into SQL code, ensuring readiness for testing and seamless report integration
  • Processed over 600K customer records and 1.7M+ card transaction data points using Snowflake
  • 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

09/2024

Analysis of domain name registration data

PERMANENT EMPLOYMENT

CLIENT: dotBerlin Gmbh & Co. KG in Berlin | Domain and Internet Services

 

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

 

08/2022 - 09/2023

Domain Lead – Growth Analytics

Solaris SE in Berlin |Financial Services & Banking Industry 

  • Conducting company key projects and leading them to success, e.g.
          - integration of Deposit Guarantee Scheme (DGS) reporting layer
          - Customer Uniqueness calculation logic
          - 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

07/2021 – 07/2022

Principle Data Analyst

Solaris SE in Berlin |Financial Services & Banking Industry 

  • 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

09/2020 – 06/2021

Senior Data Analyst

Solaris SE in Berlin |Financial Services & Banking Industry 

  • 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

10/2017 – 08/2020

Data Analyst

Solaris SE in Berlin |Financial Services & Banking Industry 

  • 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

11/2016 – 09/2017

Business Intelligence Analyst

08/2016 – 10/2016

 Business Intelligence Analyst Intern

MiNODES GmbH in Berlin | Marketing Technology (MarTech) Industry

  • 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

06/2015 – 07/2016

 Scientist

Leibniz Institute for Tropospheric Research in Leipzig | Scientific Research Industry

  • Designing and supervising experimental assemblies for ice nucleation experiments

03/2014 – 05/2015

Student Scientific Assistant at the cloud laboratory

Leibniz Institute for Tropospheric Research in Leipzig | Scientific Research Industry

  • 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)

© Data Microbe - Lisa Hellner. Alle Rechte vorbehalten.

Wir benötigen Ihre Zustimmung zum Laden der Übersetzungen

Wir nutzen einen Drittanbieter-Service, um den Inhalt der Website zu übersetzen, der möglicherweise Daten über Ihre Aktivitäten sammelt. Bitte überprüfen Sie die Details in der Datenschutzerklärung und akzeptieren Sie den Dienst, um die Übersetzungen zu sehen.