About Manuel
I am a Analytics Engineer with extensive experience across the entire analytics stack, from web tracking to data warehousing and reporting. I have worked with both older legacy systems and have set up complete data analytics stacks for startups. I enjoy tackling technical challenges and understanding business models to identify new KPIs for process improvement. My experience includes the following:
- Tracking Systems: Set up a new tracking system in Google Tag Manager and Google Analytics. Developed a measurement plan as a clear implementation strategy and collaboration tool for product managers and frontend developers. Implemented a GDPR-compliant cookie banner using CookieBot.
- Data Warehousing: Implemented a data warehouse in Google BigQuery, using Stitch as the ELT service and dbt for data engineering workflows. The data warehouse included a three-layer system with a staging layer (cleaning), core layer (Data Vault), and reporting layer (facts and dimensions). Utilized Tableau as the visualization tool.
- Legacy Systems: Worked with legacy data warehouse systems (PostgreSQL) and employed a reverse engineering approach to understand business processes. Structured new fact and dimension tables on top of the existing data warehouse and built Tableau reports based on them.
- API Supervision: Collaborated with requirement engineering teams to supervise and test API connections to banks, ensuring accurate data transmission and reception.
I am always interested in new and exciting projects and am eager to learn and test new tools and methods. If you are interested or just want to have a quick chat about data in general, feel free to drop me a line!
German
Native or bilingual
English
Fluent
French
Basic
Remote only
Primarily works remotely
Experience
- O'Donnell MoonshineHead of OnlineAGRICULTUREMay 2020 - December 2023 (3 years and 8 months)Berlin, GermanyOverall Responsibilities:
- Division Leadership: Established and managed the Online Division, focusing on eCommerce management in Shopify and performance marketing. Optimized and drove growth for four online shops (DE, UK, AT, NL).
- Team Leadership: Led a team of four, overseeing a significant ad spend.
- Data Protection: Ensured compliance with data protection regulations for the entire company.
Technical Responsibilities:- Tracking and Analytics: Developed compliant Google Analytics and conversion tracking for the webshop using Google Tag Manager and Cookiebot.
- Loyalty and Reviews: Implemented Yotpo as a loyalty and reviews module for Shopify shops.
- Newsletter and CRM: Integrated Klaviyo for newsletters and CRM management for Shopify shops.
- Data Infrastructure: Created a marketing data warehouse incorporating data from Shopify, Klaviyo, Facebook Ads, and Google Ads.
- Tech Stack: Utilized BigQuery, dbt, and Stitch for data management and integration.
Marketing Responsibilities:- Performance Marketing: Managed Google Ads and Facebook Ads campaigns for all four stores.
- eCRM Flows: Set up eCRM flows in Klaviyo based on customer segments to enhance engagement and retention.
- Nist GmbHData Analyst / Analytics EngineerBANKING AND INSURANCESeptember 2018 - April 2020 (1 year and 8 months)Berlin, GermanyTechnical Key Responsibilities:Tracking and Analytics Setup: Configure and manage tracking in Google Tag Manager and Google Analytics to capture essential data.Data Infrastructure Setup: Establish and maintain a robust data infrastructure:
- Data Integration: Utilize Stitch for seamless data integration.
- Data Warehouse: Implement and manage BigQuery as the central data warehouse.
- Data Modeling: Apply Data Vault methodology for data modeling, including Staging, Core, Business, and Reporting layers.
- Modeling Language: Use SQL and dbt for effective data modeling.
Reporting: Develop insightful reports in Tableau and Google Sheets.Analytics Support for Various Departments:- C-Level / Investor: Provide key insights and analytics to support executive decision-making and investor relations.
- Performance Marketing: Analyze marketing performance data to optimize campaigns and strategies.
- Product: Deliver product analytics to guide development and enhancement decisions.
- Sales: Generate sales analytics to support sales strategies and operations.
- smava GmbHData AnalystSOFTWARE PUBLISHINGJuly 2016 - August 2018 (2 years and 2 months)Berlin, GermanyKey Responsibilities:
- Database: Utilize PostgreSQL to develop reports and enhance business processes.
- Data Visualization: Create comprehensive reports in Tableau for various stakeholders, including Key Account, Finance, Product, IT, and Management teams.
- Automation: Write scripts in Python to automate routine tasks, increasing efficiency and accuracy.
- Data Modeling: Design and implement data marts (facts and dimensions) for a new data warehouse structure to support advanced analytics.
- Requirement Engineering: Collaborate with requirement engineering teams to understand bank APIs, and develop alerting systems in Tableau to monitor and address inconsistent data.
- Data Quality: Developed and maintained processes to ensure database consistency.
Recommendations
Be the first to recommend Manuel
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
- Bachelor of Science in Volkswirtschaftslehre/EconomicsUniversität Köln2011
- Bachelor's degree (not finished), Computer ScienceHumboldt-Universität zu Berlin2013Courses in: - Programming - Software Engineering - Databases - Machine Learning - Math
Certifications
- 6.431x: Probability - The Science of Uncertainty and DataedX2020
- Data Manipulation at Scale: Systems and AlgorithmsCoursera2017