Position: Power BI Developer / Data Analyst
Category: Data Analyst
English level: upper
Years of experience: 5


July 2021 - June 2023
Power BI analyst - WhaleApp LTD

• created a report for operational monitoring of key project metrics, which made it possible to reduce costs for ineffective marketing campaigns;
• created a dashboard with notifications that enabled quick response and elimination of errors in the raw data, on the basis of which reports are built;
• optimized existing Power BI reports, which reduced the time of updating visualizations and accelerated interaction with them;
• combined the main reports into one report, which allowed the management to reduce the time for making business decisions;
• created reports for comprehensive analysis of marketing effectiveness, which allowed finding ways to improve the effectiveness of advertising networks;
• described documentation on existing reports and procedures;

September 2018 - July 2021
Marketing analyst - METINVEST-SMC LLC


Skills:

Power BI:
• ability to create reports based on various sources (Excel, SQL Server, PBI data sets, REST API), publish them and administer the workspace;
• knowledge of DAX language, understanding of filter and row contexts;
• working with external tools — Tabular Editor, DAX Studio, Analyze in Excel, Performance Analyzer;
• basic knowledge of the M language.

SQL:
• knowledge of DDL and DML commands, CTE , window functions, subqueries;

AppsFlyer:
• work with data sources to build a full-fledged monitoring system of marketing metrics (DataLocker, Pull API, CohortAPI, MasterAPI, COST ETL, SKAN);
• working with web tools of the service – Overview Dashboard, Cohort Dashboard, Protect360, Pivot.

Excel:
• ability to write macros for process automation (VBA);
• ability to create and operate data models (Power Query);
• knowledge of VLOOKUP, INDEX, MATCH formulas and Pivot Tables.