Specialist in analytics and reporting in Beverly Hills Company

We are Beverly Hills Company — leaders in setting up targeted and contextual media advertising in Ukraine. We have been working in this field for more than 4 years, and during this time our movement is directed exclusively forward and upward, and even in the conditions of war we are actively developing and expanding.
Our experience has shown that the main resource of a company that has a claim for development - these are people who are ready for change, also want to develop, move the niche, and set the direction of the industry.
These postulates have become acorporate mission, which unceasingly carries us forward. we do not have invisible employees. We are looking for active people who want to be part of something big, make a statement, help Ukraine through our charity fund and become better.
If you want to join our driving team -to us.

Duties:

• Development and support interactive reports in Google Sheets and Excel.
• Automation of data collection and processing using Google Forms and scripts.
• Creating and optimizing PivotTables and data models in PowerPivot.
• Using DAX to development of complex calculations and analytical functions.
• Building and improving mathematical and financial models to support business processes.
• Development of relational data models to optimize analytics.
• Collaborate with other departments to ensure accuracy and timeliness of reporting.

Requirements:

• Confident use of Google Sheets, including Google Query and Array Formulas.
• Experience with Google Forms, including scripting.
• High proficiency in Microsoft Excel, including Power Query, PivotTables, PowerPivot, DAX.
• Basic knowledge of JavaScript will be an advantage.
• Understanding the basic principles of finance and economics.
• Experience in building mathematical and financial models.
• Experience with relational data modelsх.
• Ability to work in a team and independently.
• High level of responsibility and organization.

We offer:

• Office in the city of Kyiv (remote work is not provided);
• Work schedule: 5/ 2, from Monday to Friday, from 9:00 a.m. to 6:00 p.m.;
• Paid vacation;
• English language courses;
• Corporate psychologist;
• Acting exercises;
• Music festivals;
• Training at company expense;
• Loyal management and friendly team of professionals;
• Unforgettable events — from unique corporate events to exciting team building and football championships.