Position: Data analyst
Category: Data Analyst
English level: upper
Years of experience: 11

created Data Lake from available industry data
 changed the Excel and PPT reporting to the Power Bi dashboards
 developed algorithms for estimating the advertising market and created a universal report "Competitive analysis of advertising investments", the main purpose was to optimize a development media strategy
 developed a business process with assessments of sponsorship inventory and interaction of the sponsorship sales department with the Group's TV channels
 developed marketing module in 1C (commercial proposals, plan-facts, project shooting schedules)
Hi! My name is Oksana. I have been working for the biggest Ukrainian TV groups for 10 years (Inter Media Group, Media Group Ukraine) in the sponsorship selling department and full-cycle advertising agency. Unfortunately, I had to leave home and relocate to UK. Now I'm looking for a remote job related to data analysis.

My responsibilities:
-analytical support for all departments of the company
-creating and maintaining analytical materials and reports (analysis of TV indicators, analysis of the competitive environment, analysis of the impact of sponsorship on project performance)
-implementing of systems for visualization of analytical materials and reporting in the company's business processes (Power BI)
-searching for insights, their interpretation, and proof by analytical research
-participating and analytical support in the development of
communication and media strategies, other strategic decisions for current and potential clients
-maintaining, filling, and organizing of existing databases, development of concepts of new databases
-forecasting and planning of indicators of TV projects, channels of the Group
-managing a team of researchers

Softs:
Excel (Power Query, Pivot), Power Bi, DAX, Tableau,  T-SQL, My SQL, BigQuery, PowerPoint, 1C, MMW / YUMI (markdata), bigdatarating (TV), Galileo (TNS), Similarweb, CMetr, Gemius Audience, Gemius Adreal, PharmXplorer, Asana