Position: Data Analyst / Web Analyst
Category: Data Analyst
English level: upper
Years of experience: 6

• remade web-analytics structure of large company without losses (it was hard not to affect something used by colleagues);
• build LTV forecasting model with Excel :);
• set up A / B tests considering the information in the database, which made it possible to draw the most accurate conclusions about tests’ success;
• set up automated data export from advertising accounts on Pytthon (it was previously unloaded manually by PPCs);
• developed an event architecture for 2 large mobile apps (one of them - E-com).
• developed a mini-CRM system in Google Sheets what reduced the marketing budget by 25% and simplify the work of team.
Analyst with 5 years of experience serving local and international clients, small and large business. Currently working for a successful product company.

Skilled in configuring web-analytics services via GTM, working up with API of marketing tools on Python, data extraction using SQL, and creating dashboards in BI systems. Have experience as a key Web Analyst for a large Top-3 marketing agency in Ukraine. Supervised developers and coordinated the work of the team in a small startup. Worked with Scrum/Agile and with OKR. Know the basics of statistics and the theory of probability, which allows me to draw statistically significant conclusions for the business.

I have experience in solving the following tasks:

• setting up web-analytics from scratch;
• configuration and support web-analytics services (via GTM or technical requirements);
• setting up E-commerce, end-to-end analytics;
• LTV forecasting;
• writing SQL queries and working with large data sets;
• creating dashboards in Google Data Studio, Power BI and Tableau for clients and for management (from drawing up the structure of the database to full visualization);
• working up with the API of various tools, settting up custom connectors for advertising accounts in Python or R;
• performing of A / B tests using Google Optimize;
• working with analytics of SPA site;
• monitoring, analysis and forecasting of the income and main KPIs (CTR, CPC, CPL, ROMI);
• describing the events architecture in mobile apps and helping set up Firebase for mobile analytics;
• creation custom funnels based on raw data.
• the possibility to work with foreign projects;
• interesting and challenging tasks for professional development.