Building of end-to-end analytics, analytic architecture and infrastructure: collecting data from internal databases, AppsFlyer API, SKAdNetwork, advertising systems and external sources by Python. Data warehouse - Google BigQuery managed by dbt. Metrics calculation, business Intelligence by SQL and PowerBI. Administrating of analytical server. Web site tracking, pixels and events, mobile apps analytics. Implementation of Server-Side Google Tag Manager.

Data warehouse and data mart developing. Collecting data from CRM and marketing platforms. Developing analytical reports on key aspects of the company's activities for the marketing department, sales department, financial department, and recruiting team. Technology stack: Power BI, Google BigQuery, Python, Fivetran.

Built end-to-end analytics, complex project analytics: analytical reports, analytics of marketing activities, product analytics, tools analytics, sales analysis. Collected and validated data from more than 10 development teams (Data warehouse - BigQuery). Marketing and Product Analytics. Reported by PowerBI, Google Data Studio, Google SpreadSheets. Tracked web sites, pixels, and events. Worked with Google Tag Manager and unsampled data in Google Analytics (OWOX streaming to… Show more Built end-to-end analytics, complex project analytics: analytical reports, analytics of marketing activities, product analytics, tools analytics, sales analysis. Collected and validated data from more than 10 development teams (Data warehouse - BigQuery). Marketing and Product Analytics. Reported by PowerBI, Google Data Studio, Google SpreadSheets. Tracked web sites, pixels, and events. Worked with Google Tag Manager and unsampled data in Google Analytics (OWOX streaming to BigQuery).Implemented a uniform terminology for colleagues from different departments. Forming a team of analysts (hiring, training, managing). Trained a customer care department. Show less

- Search Engine Optimization (On-page optimization, keyword research, internal link structures, site architecture, content categorization, assist with copywriting and editing, working with SEO exchanges and aggregators);- Setup and ongoing optimization and management of PPC/digital advertising campaigns (AdWords, Yandex Direct, MyTarget, VK);- Monitor and analyze the performance of digital marketing campaigns, searching for new digital marketing channels and the way how to create more… Show more - Search Engine Optimization (On-page optimization, keyword research, internal link structures, site architecture, content categorization, assist with copywriting and editing, working with SEO exchanges and aggregators);- Setup and ongoing optimization and management of PPC/digital advertising campaigns (AdWords, Yandex Direct, MyTarget, VK);- Monitor and analyze the performance of digital marketing campaigns, searching for new digital marketing channels and the way how to create more revenue;- Research market share and competitors, websites audit, provide feedback to clients;- Improve the usability, provide recommendations for website design, Android applications and other products. Develop design prototypes in Axure RP, Pencil;- Leading a marketing department: training, adaptation, motivation, control, planning, hiring, firing, interviewing, test assignments. Show less

PHP, Smarty, JavaScript, AJAX, MySQL, Apache HTTP Server