[Name on request] has ten years of experience in data roles at Google and startups focusing on customer and marketing analytics.
Aktualisiert am 31.07.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 12.06.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Business Intelligence
Data Analyst
Datawarehouse
ETL
Datawarehouse
SQL
GitHub
Business Reporting
BI-Reporting
Google Analytics
AdWords
Dashboard
Data Analyst
Google Cloud
Datenanalyse
E-Commerce
Big Data Analytics
German
Muttersprache
English
Verhandlungssicher

Einsatzorte

Einsatzorte

Hamburg (+200km)
Deutschland
möglich

Projekte

Projekte

1 year 1 month
2023-09 - now

implementing data infrastructure

Founder
Founder
  • A fractional data team for media agencies.
  • We use data, insights, and automation to increase client stickiness, save time for your revenue-driving teams, and enable your executives to make data-driven decisions.
  • By implementing data infrastructure that you own and we manage you get a new business asset for your agency.
Hamburg, Germany
6 months
2024-01 - 2024-06

Implementation of BI setup for media agency

Project Lead Business Intelligence Big Data Analytics Automation ...
Project Lead
  • Assessed the needs of the agency in terms of customer insights, self-service dashboards, and data automation
  • Centralized the marketing data of the >200 agency clients in a centralized data warehouse, owned by the agency
  • Created self-service dashboards for the client teams to quickly identify industry trends, client challenges, and upsell opportunities
  • Automated insights to pro-actively give client teams insights instead of having to build presentations and extensively prepare for client calls manually 
  • Increased efficiency of client teams significantly by cutting down the invested time per client per week by 62%
BigQuery Fivetran dbt Looker Studio Google Sheets Google Slides
Business Intelligence Big Data Analytics Automation Dashboard
Remote
2 years 3 months
2021-10 - 2023-12

Managed embedded analysts across CPG account management teams

Data & Insights Lead
Data & Insights Lead
  • Managed embedded analysts across CPG account management teams to empower sellers, specialists, and clients with scaled insights, data tools, and training.
  • Shaped the team strategy by defining roles & responsibilities, project scopes, resource priorities, and team setup.
  • Hired new technical and non-technical team members and interns to accommodate the defined responsibilities.
CPG
Hamburg, Germany
1 year 1 month
2022-06 - 2023-06

Re-structuring of data team

Project/Team Lead Projektmanagement/Projektleitung Strategieplanung Business Intelligence
Project/Team Lead

  • Managed embedded analysts across CPG account management teams to empower sellers, specialists, and clients with scaled insights, data tools, and training.
  • Shaped the team strategy by defining roles & responsibilities, project scopes, resource priorities, and team setup.
  • Hired new technical and non-technical team members and interns to accommodate the defined responsibilities.

Projektmanagement/Projektleitung Strategieplanung Business Intelligence
Google
5 months
2023-01 - 2023-05

Rollout of marketing analytics for omnichannel retailer

Analytics Engineer Business Intelligence Datawarehouse Dashboard ...
Analytics Engineer
  • Gathered necessary project requirements from all stakeholders, such as C-Levels and directors as well as marketing and sales teams.
  • Centralized digital marketing channel (Google Ads, Meta Ads, Google Analytics, etc.) and sales channel (from brick & mortar store and online store) data in a data warehouse to create one source of truth.
  • Created self-service data dashboards for the marketing teams and executives to allow critical business decisions to be data-driven. 
  • Dashboards included insights such as ROI, ROAS, profit margins, and more per marketing and sales channels
BigQuery Looker Fivetran dbt
Business Intelligence Datawarehouse Dashboard Big Data Analytics
Remote
2 years
2019-10 - 2021-09

Built a scalable cloud data platform

Senior Analytical Consultant
Senior Analytical Consultant
  • Built a scalable cloud data platform on Google Cloud for CPG clients (with a combined annual revenue of $635M) to fuel their business intelligence needs with dashboards, data tools, and automated insights narratives.
  • Managed a data project with C-Levels clients showing the path-to-purchase for consumers offline and online. The outcome was used by sales teams across seven countries.
  • Created an automated insights tool for account management, and marketers to uncover advertising opportunities in untargeted consumer segments. This resulted in a $21M incremental revenue opportunity for Google.
Healthcare
Hamburg, Germany
2 years 6 months
2017-04 - 2019-09

Built extraction, loading, transformation, and reporting layer

Analytical Consultant
Analytical Consultant
  • Built extraction, loading, transformation, and reporting layer for an externally available dashboard showing brand awareness based on search interest for online retailers. Scaled the dashboard across 5 client industries.
  • Created an interactive automated data app to forecast necessary client budgets to achieve a certain advertising reach. Was used by Google sales teams to pitch >$70m in Google Ads investments.
Healthcare
Hamburg, Germany
2 years 9 months
2014-07 - 2017-03

Annual revenue impact

Account / Industry Manager
Account / Industry Manager
  • Annual revenue impact of more than $30MM.
  • Consulted clients on Google's various advertising tools (Search, Display, YouTube, Analytics).
  • Organized and facilitated 4 thought leadership and networking events with >90 participants.
Startups, Retail
Dublin, Ireland
1 year 2 months
2012-09 - 2013-10

Developed a customer segmentation (RFM) model

Project Manager / Business Analyst
Project Manager / Business Analyst
  • Developed a customer segmentation (RFM) model for the >40.000 customer database, making it possible to target customers more individually in email campaigns.
  • Created a tool to analyze and report on the relationship between TV campaigns and online marketing KPIs.
  • Designed a KPI report to track the efficiency of all online marketing efforts, enabling a target/performance comparison.
mymuesli
Berlin, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

2011 ? 2013

International Marketing and Management, M.Sc.

Copenhagen Business School, Copenhagen, Denmark


2007 ? 2011

Business Administration and Economics, B.Sc.

University of Passau, Germany

Kompetenzen

Kompetenzen

Top-Skills

Business Intelligence Data Analyst Datawarehouse ETL Datawarehouse SQL GitHub Business Reporting BI-Reporting Google Analytics AdWords Dashboard Data Analyst Google Cloud Datenanalyse E-Commerce Big Data Analytics

Produkte / Standards / Erfahrungen / Methoden

Profile

He has ten years of experience in data roles at Google and startups focusing on customer & marketing analytics. Embedded in revenue teams and with a marketing background, he prioritizes bottom-line impact. He always considers the business challenge and opportunity first before looking for a technical solution. With experience in building data teams and hands-on implementations, he is particularly well-suited for any zero-to-one data project.


Data Focus Areas

  • Retail, Ecommerce (Omnichannel) and Paid Media
  • Marketing Analytics & Customer Insights (e.g. ROI analysis, revenue forecasting, customer segmentation, advertising opportunities)
  • Data Education (Enabling others to translate data into business decisions and revenue)


Data Tools & Technologies

  • BigQuery
  • Looker Studio
  • SQL
  • dbt
  • ELT
  • GitHub
  • Data Warehouse Modelling

Branchen

Branchen

  • D2C
  • E-commerce
  • Retail
  • Data Analytics

Einsatzorte

Einsatzorte

Hamburg (+200km)
Deutschland
möglich

Projekte

Projekte

1 year 1 month
2023-09 - now

implementing data infrastructure

Founder
Founder
  • A fractional data team for media agencies.
  • We use data, insights, and automation to increase client stickiness, save time for your revenue-driving teams, and enable your executives to make data-driven decisions.
  • By implementing data infrastructure that you own and we manage you get a new business asset for your agency.
Hamburg, Germany
6 months
2024-01 - 2024-06

Implementation of BI setup for media agency

Project Lead Business Intelligence Big Data Analytics Automation ...
Project Lead
  • Assessed the needs of the agency in terms of customer insights, self-service dashboards, and data automation
  • Centralized the marketing data of the >200 agency clients in a centralized data warehouse, owned by the agency
  • Created self-service dashboards for the client teams to quickly identify industry trends, client challenges, and upsell opportunities
  • Automated insights to pro-actively give client teams insights instead of having to build presentations and extensively prepare for client calls manually 
  • Increased efficiency of client teams significantly by cutting down the invested time per client per week by 62%
BigQuery Fivetran dbt Looker Studio Google Sheets Google Slides
Business Intelligence Big Data Analytics Automation Dashboard
Remote
2 years 3 months
2021-10 - 2023-12

Managed embedded analysts across CPG account management teams

Data & Insights Lead
Data & Insights Lead
  • Managed embedded analysts across CPG account management teams to empower sellers, specialists, and clients with scaled insights, data tools, and training.
  • Shaped the team strategy by defining roles & responsibilities, project scopes, resource priorities, and team setup.
  • Hired new technical and non-technical team members and interns to accommodate the defined responsibilities.
CPG
Hamburg, Germany
1 year 1 month
2022-06 - 2023-06

Re-structuring of data team

Project/Team Lead Projektmanagement/Projektleitung Strategieplanung Business Intelligence
Project/Team Lead

  • Managed embedded analysts across CPG account management teams to empower sellers, specialists, and clients with scaled insights, data tools, and training.
  • Shaped the team strategy by defining roles & responsibilities, project scopes, resource priorities, and team setup.
  • Hired new technical and non-technical team members and interns to accommodate the defined responsibilities.

Projektmanagement/Projektleitung Strategieplanung Business Intelligence
Google
5 months
2023-01 - 2023-05

Rollout of marketing analytics for omnichannel retailer

Analytics Engineer Business Intelligence Datawarehouse Dashboard ...
Analytics Engineer
  • Gathered necessary project requirements from all stakeholders, such as C-Levels and directors as well as marketing and sales teams.
  • Centralized digital marketing channel (Google Ads, Meta Ads, Google Analytics, etc.) and sales channel (from brick & mortar store and online store) data in a data warehouse to create one source of truth.
  • Created self-service data dashboards for the marketing teams and executives to allow critical business decisions to be data-driven. 
  • Dashboards included insights such as ROI, ROAS, profit margins, and more per marketing and sales channels
BigQuery Looker Fivetran dbt
Business Intelligence Datawarehouse Dashboard Big Data Analytics
Remote
2 years
2019-10 - 2021-09

Built a scalable cloud data platform

Senior Analytical Consultant
Senior Analytical Consultant
  • Built a scalable cloud data platform on Google Cloud for CPG clients (with a combined annual revenue of $635M) to fuel their business intelligence needs with dashboards, data tools, and automated insights narratives.
  • Managed a data project with C-Levels clients showing the path-to-purchase for consumers offline and online. The outcome was used by sales teams across seven countries.
  • Created an automated insights tool for account management, and marketers to uncover advertising opportunities in untargeted consumer segments. This resulted in a $21M incremental revenue opportunity for Google.
Healthcare
Hamburg, Germany
2 years 6 months
2017-04 - 2019-09

Built extraction, loading, transformation, and reporting layer

Analytical Consultant
Analytical Consultant
  • Built extraction, loading, transformation, and reporting layer for an externally available dashboard showing brand awareness based on search interest for online retailers. Scaled the dashboard across 5 client industries.
  • Created an interactive automated data app to forecast necessary client budgets to achieve a certain advertising reach. Was used by Google sales teams to pitch >$70m in Google Ads investments.
Healthcare
Hamburg, Germany
2 years 9 months
2014-07 - 2017-03

Annual revenue impact

Account / Industry Manager
Account / Industry Manager
  • Annual revenue impact of more than $30MM.
  • Consulted clients on Google's various advertising tools (Search, Display, YouTube, Analytics).
  • Organized and facilitated 4 thought leadership and networking events with >90 participants.
Startups, Retail
Dublin, Ireland
1 year 2 months
2012-09 - 2013-10

Developed a customer segmentation (RFM) model

Project Manager / Business Analyst
Project Manager / Business Analyst
  • Developed a customer segmentation (RFM) model for the >40.000 customer database, making it possible to target customers more individually in email campaigns.
  • Created a tool to analyze and report on the relationship between TV campaigns and online marketing KPIs.
  • Designed a KPI report to track the efficiency of all online marketing efforts, enabling a target/performance comparison.
mymuesli
Berlin, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

2011 ? 2013

International Marketing and Management, M.Sc.

Copenhagen Business School, Copenhagen, Denmark


2007 ? 2011

Business Administration and Economics, B.Sc.

University of Passau, Germany

Kompetenzen

Kompetenzen

Top-Skills

Business Intelligence Data Analyst Datawarehouse ETL Datawarehouse SQL GitHub Business Reporting BI-Reporting Google Analytics AdWords Dashboard Data Analyst Google Cloud Datenanalyse E-Commerce Big Data Analytics

Produkte / Standards / Erfahrungen / Methoden

Profile

He has ten years of experience in data roles at Google and startups focusing on customer & marketing analytics. Embedded in revenue teams and with a marketing background, he prioritizes bottom-line impact. He always considers the business challenge and opportunity first before looking for a technical solution. With experience in building data teams and hands-on implementations, he is particularly well-suited for any zero-to-one data project.


Data Focus Areas

  • Retail, Ecommerce (Omnichannel) and Paid Media
  • Marketing Analytics & Customer Insights (e.g. ROI analysis, revenue forecasting, customer segmentation, advertising opportunities)
  • Data Education (Enabling others to translate data into business decisions and revenue)


Data Tools & Technologies

  • BigQuery
  • Looker Studio
  • SQL
  • dbt
  • ELT
  • GitHub
  • Data Warehouse Modelling

Branchen

Branchen

  • D2C
  • E-commerce
  • Retail
  • Data Analytics

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.