About Lisa
German
Native or bilingual
English
Fluent
Experience
- DocMorris N.V.Analytics Engineering & BI Solutions for Logistics & Business TeamsE-COMMERCEMarch 2025 - Today (1 year and 3 months)Berlin, GermanyGOALS & 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 performance2. dbt model restructuring and clean-up of 20+ models-> Reduce dbt model complexity and interdependencies, improving maintainability, execution performance, and overall pipeline reliability3. 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 sourcesTASKS:
- Designed and implemented a ZIP-code-to-region and shipping carrier distribution center mapping, enabling geospatial performance visualization and network analysis
- 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
- Deliver analytics on high-volume datasets across core business domains, processing millions of records from Order, Sales, Product, and Marketing systems
- Work in close collaboration with stakeholders across all tasks and initiatives
- Nays GmbHRe-Order Alarm DashboardE-COMMERCEJuly 2025 - September 2025 (2 months)Berlin, GermanyGOAL & SUCCESS:-> Development of a Reorder Alarm Dashboard in Tableau to improve forecasting of required product quantities and optimal reorder timingTASKS:
- Analysed current inventory levels including pre-orders and backorders using SQL
- Calculated item-specific reorder thresholds to optimize replenishment timing
- Developed a Tableau dashboard with reminder logic and a traffic-light system to highlight items requiring reorder
- Solaris SERefinement and implementation of a 50+ KPI external reporting setupBANKING AND INSURANCEMay 2024 - Today (2 years)Berlin, GermanyGOAL & 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 agreementsTASKS:
- 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
Recommendations
Be the first to recommend Lisa
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master of ScienceUniversität Leipzig2015Master of Science (M.Sc.), Atmosphärische Wissenschaften und Meteorologie
Certifications
- Data Modeling in Power BIMicrosoft2025
- Extract, Transform & Load Data in Power BIMicrosoft2024