LinkedIn

- Leverage LinkedIn’s unique data to create innovative, custom analyses and tools to address business challenges
-  Write SQL and Python queries to extract necessary data, analyze the results to generate actionable insights and present the findings either in Tableau, Excel or PowerPoint
-  Understand LinkedIn’s marketing ecosystem and bring new ideas in social media analytics and measurement to market that help end-clients make better marketing decisions
- Collaborate closely with the sales, marketing, product and insights teams to provide analysis, reporting and tool-building capabilities that inform our key stakeholders
- Build cross-functional relationships and partner effectively with other teams for collaborative opportunities
- Develop scalable and repeatable playbooks/narratives for internal and external stakeholders
- Develop custom analyses narratives to help our clients and prospects better understand the value of LinkedIn data as related to digital marketing
- Serve as a strategic advisor to internal and external stakeholders as it pertains to data usage, insights, and measurement

Senior Insights Analyst and Data Storyteller

Media-Saturn Marketing GmbH

- internal analytics consultant for proof of concepts and pilots of new data and machine learning driven software initiatives
 analyst for multi touch attribution project (data integration/pipelines) with an external service provider
- Conception, implementation and distribution of a category managment analytics project (i.e. product attach analytics, data driven customer decision trees) 
- Building an ecommerce assortment optimization tool and project on the Google Cloud Plattform (GCP) through application of various internal (sales, stock, pricing...) and external data sources (Google, GfK, crawling)
- Extensive work on the google cloud plattform especially with Google Big Query

Expert Data Analyst / Scientist - Analytics Lab

o responsible for international supplier cooperation project to monetize CRM data from the analytics side. Heavy involvement with internal (business) and external (brands/suppliers) stakeholders as the data expert
o concept, support and implementation of dedicated supplier direct marketing campaigns (targeting, reporting). Application of statistical methods such as building propensity models to identify customers most likely to respond.
o concept and implementation of insight sharing reports and analysis to our suppliers
o Concept and programming of a scoring engine (SAS based) to automatically generate propensity models to drive personalization and campaigning within the customer loyalty program
o Responsible for next best product recommendation algorithm
o internal development of standard analytics tools/products for the central and national CRM teams
o innovate/find new application for CRM loyalty data to support decisions across MediaMarkSaturn, i.e. by application of propensity modeling, product segmentations via machine learning i.e. clustering and intensive cooperation with internal departments

Expert CRM Customer Analytics

PAYBACK

o Supporting potential and actual New Markets for the PAYBACK Coalition (USA and others) for Analytics in pitches, for internal international departments
o support,consult and respond to analytics requests from internal international departments and local analytics and CRM/marketing/controlling departments of existing international markets + Germany
o exchange of best practices, knowledge and analytics products across countries
o Adaptation and standardization of analytics products across countries

International Analytics Consultant

Topics: Multi Channel Couponing (Online,Mobile,Print), PB Deals, Campaign Management Analytics, Reporting,
o Consult, support and fullfill analytical requests for and of a broad range of internal departments such as directmarketing (On- and offline), affiliate business, controlling, permission marketing, onlinemarketing, strategic planning
o ad hoc analytics requests, reporting conception, implementation and operation, business cases and simulations for operational and tactical decisions
o completed a variety of analytics projects such as modelling Customer Value, propensity models (Scorecards), customer profiling
o worked intensively with Oracle SQL, SAS, Adobe Analytics, advanced excel features

Database Marketing Analyst

emnos

o in analytics responsible for topics Multi Channel Couponing, PB Deals, Online  / Onsite
o support in campaign management and operation (selection, testing) 
o campaign reporting (i.e. couponing, newsletter)
o variety of ad hoc requests in campaign performance, online/onsite

Werkstudent

Vodafone

Internship

Deutsche Post DHL Inhouse Consulting

Mitsubishi Fuso Truck and Bus Corporation

Nestlé S.A.

Supply Chain Management - Demand Planning

Supply Chain Management - Demand Planning and Forecasting

Enthusiastic, creative and innovative data science professional with strong passion to bridge the gap between data and business. Love to enable business users by consulting on and building data based products.
Strong analytical background in database marketing and omnichannel retail.
Enjoy helping (not only) marketing folks with customer and data insights and number crunching.
Passionate about exchanging ideas, new experiences and learning especially in the context of applied data science and analytics. 

Taplio

Stefan Kirschnick's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Stefan Kirschnick's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Stefan Kirschnick's Linkedin Analytics