Position: Product / Web Analyst
Category: Marketing
English level: pre
Years of experience: 11

Building a DWH on BigQuery and Google Cloud Platform for marketing, product and cross-channel analytics.

Sources of data for the DWH include:
    - GA4
    - Firebase
    - AppsFlyer
    - Google Ads
    - Facebook Ads
    - Microsoft Azure

Creating data marts for building analytical reports in DataStudio (Looker Studio) and Power BI.
QUALIFICATIONS:
    Over 10 years of experience working with website analytics and over 2 years of experience with mobile app analytics
    8 years of experience leading an internet marketing department with 8 employees
    Proficient in Python, JavaScript, SQL, HTML, CSS
    Experience working with APIs of various services, including Google
    Experience writing scripts for automating work processes, writing parsers for search engines and websites, and working with Selenium
    Excellent knowledge of web technologies, allowing effective communication with developers, accurate task assignment, and result monitoring

ANALYTICS:
    Accurate setup of Google Analytics to collect data for informed decision-making, including the setup of GA4 with data streaming in BigQuery.
    Professional implementation and setup of Google Tag Manager, from setting up event tracking on websites to content replacement on specific pages based on predefined conditions, and setting up Enhanced Ecommerce, including for GA4. Proficient in JavaScript, HTML, and CSS, allowing most data collection tasks to be handled without involving developers.
    Working with raw data in BigQuery and writing analytical SQL queries.
    Identification of the most effective conversion channels for optimization, monitoring of traffic acquisition channels based on analytical data, redirecting resources to more effective advertising channels.
    Analysis of search engine optimization efficiency.
    Building funnels and optimizing them, working with conversions.
    A/B testing, setting up server-side experiments for Google Optimize.
    Obtaining large, unsampled data volumes from Google Analytics using Python/R and working with them.
    Working with Search Console API.
    User segmentation, RFM analysis.
    Building end-to-end analytics, enabling conversion tracking not only for leads but also for paying users and making more accurate decisions on traffic channel optimization based on revenue.
    Creating reports in Power BI and GDS.
Ищу частичную занятость на 15 - 20 часов в неделю.