Data Analyst / Analytics Engineer / Data Engineer

• Jul 2022 - Present

Data Analyst

• Nov 2019 - Jun 2022

• Main Mixpanel partner representative on the Russian market.• Building ELT pipelines and models with dbt and Google Cloud Platform.• Building source-of-truth data marts and user-friendly automated dashboards in Power BI and Google Data Studio.• Conducting A/B tests and hypothesis testing to drive KPIs.• Auditing data collection and designing measurement plans.• Marketing, CRM and product tools integration and onboarding.• Anomaly detection and KPI forecasting.• Post-click and post-view analysis of media advertising campaigns.• Implementing event tracking and single source-of-truth documentation. Show less

Paid Search Specialist

• Nov 2017 - Nov 2019

Our team’s core activity was performance marketing automation for e-commerce clients. In addition, I had a lot of hands-on experience in Google Ads, Yandex Direct and Facebook Ads with monthly budgets from $15 000 to $300 000 with e-commerce, job boards, fashion and FMCG clients.Achievements• YoY growth of B2B customers by 41% for the top-priority client• Over 700 000 automated SKUs across paid search and display network• 40+ saved hours each month by auto updated dashboards in Power BI and scripts in Google Ads and Yandex Direct• 9 lectures about SEM for our interns and junior specialistsResponsibilities• Helped the team build great relationships with clients by taking on calls, responding to emails, taking part in presentations & attending face-to-face meetings.• Day to day planning, management and analysis of paid search channels (Google, Yandex, Bing), and social media channels (Facebook, Vkontakte, MyTarget) to achieve and exceed target KPIs, drive conversions and maintain profitability.• Built automated dashboards in Power BI, Tableau and Google Data Studio to help analyze accounts performance and find data-driven insights.• Ensured best practices and innovation in all paid search activities, by applying alpha and beta instruments from Google and Yandex.• Analyzed websites and apps traffic in Google Analytics, Yandex Metrica and AppMetrica.• Conducted forecasting for annual and monthly budgets. Show less

Marketing Research Analyst Intern

• Jun 2015 - Aug 2015

• Gathered marketing data from Google Analytics and CRM databases. • Data analysis in Excel and SPSS. Presented the results within the team. • Social Paid Advertising (created campaigns for news promotions). • Gathered marketing data from Google Analytics and CRM databases. • Data analysis in Excel and SPSS. Presented the results within the team. • Social Paid Advertising (created campaigns for news promotions).