Über Lisa
Deutsch
Muttersprachlich oder zweisprachig
Englisch
Verhandlungssicher
Projekt- und Berufserfahrung
- DocMorris N.V.Analytics Engineering & BI Solutions for Logistics & Business TeamsE-COMMERCEMärz 2025 - Heute (1 Jahr und 3 Monate)Berlin, DeutschlandGOALS & 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-COMMERCEJuli 2025 - September 2025 (2 Monate)Berlin, DeutschlandGOAL & 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 setupBANKEN & VERSICHERUNGENMai 2024 - Heute (2 Jahre)Berlin, DeutschlandGOAL & 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
Empfehlungen
Sei die erste Person, die Lisa empfiehlt
Teile Deine Erfahrung aus der Zusammenarbeit mit diesem Freelancer.
Diese Freelancer passen auch zu Ihren Kriterien
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
Ausbildung und Abschlüsse
- Master of ScienceUniversität Leipzig2015Master of Science (M.Sc.), Atmosphärische Wissenschaften und Meteorologie
Zertifizierungen
- Data Modeling in Power BIMicrosoft2025
- Extract, Transform & Load Data in Power BIMicrosoft2024