Position: Data analyst
Company: abz.agency
Experience required: 1y
English level: upper

**Updated on 7th of September 2022**. First two weeks will be a traineeship period. 1 position vacant.

Our company is looking for a data analyst with work experience (at least 1 year) for a long-term project from one of our best clients. Project is in production for a couple of years already and now the team needs a dedicated Data Analyst colleague with prior experience in this field. You will work as part of a dedicated team. This is an interesting and complex project with good media buying budgets and solid traffic (~3 million unique visitors per month and constantly growing).

Link to the test task by request. (1)

By clicking on the link (company name) in the vacancy header, you can find brief information about our company, video, photos, contacts of the HR manager and a link to our website.

**Working conditions**
- Full work load of 160−200 hours per month and hourly rate ensuring all (extra) hours are paid;
- Revision of the rate every six months by 5−50%;
- Hourly rate in $, traineeship period paid as fixed monthly payment in UAH;
- Quarterly bonus, project performance based;
- English classes 2 times per week (groups of two people, after work hours);
- MacBook Pro 13/16, 4K monitor, stand, mouse, keyboard, headphones, comfortable chair, company branded T-shirt and mug;
- 75% of the salary is also paid for «bench». «Bench» means standby time — when you don’t have project and you work on your IDP or other personal/internal tasks to improve your knowledge and skills;
- Working day from 8:00 to 17:00***;
- Lunches and other things in the kitchen at the expense of the company (coffee, tea, cookies, sweets, yogurts and drinks in the refrigerator);
- Work in one of two offices: 7 minutes from Osokorki metro station: 8 minutes from Lybidska metro station or 15 minutes from Kontraktova Square metro station.

**Requirements**
- Working in strict accordance with company regulations;
- English (good listening and reading skills);
- Solid knowledge of SQL (PostgreSQL is currently used in the project);
- Advanced excel/google sheets knowledge;
- Knowledge of a scripting programming language (Python is preferred);
- Expertise in business analysis tools (Tableau, Power BI or similar) for business metrics analysis.

**Would be a plus**
- Basic understanding of media buying (Adsterra, PropellerAds, Adcash etc.);
- Basic experience with various ad formats (display, pop-up, native and interstitial ads);
- Understanding of working with partner trackers (Voluum, RedTrack, Binom, etc.)
- Basic experience with successful traffic optimization for products/services, according to customer/business requirements.

**Responsibilities**
- Conducting research and data analysis;
- Preparation of statistics, analytical requests, ad hoc requests;
- Evaluation of the system performance;
- Building reports and dashboards using BI tools (currently Tableau is used);
- Development of scripts for analytics/reports automation.

(1) The Company may, at its sole discretion, not provide applicants with the reason for being rejected and technical details of the test completed.

(2) The plan for the day is made at the stand-up meeting and must be accomplished (considering common sense) within the day according to the checkpoints. After accepting the work, the PM closes the working day.