Analytics and reporting specialist in Beverly Hills Company

We Beverly Hills Company are 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 changes, also want to develop, move the niche, and set the direction of the industry.
These postulates have become a corporate mission that relentlessly carries us forward.
People work with us for a long time, they build careers with us, we don't have invisible employees. We are looking for active people who want to be a part of something big, make a statement, help Ukraine through our charity fund and become better. br/>

Responsibilities:

• Development and maintenance of interactive reports in Google Sheets and Excel.
• Automation data collection and processing using Google Forms and scripts.
• Creation and optimization of pivot tables and data models in PowerPivot.
• Using DAX to develop complex calculations and analytical functions.
• Build and improve mathematical and financial models to support business processes.
• Develop relational data models to optimize analytics.
• Collaborate with other departments to ensure accuracy and timeliness of reporting.< /li>

Requirements:

• Confident use of Google Sheets, including Google Query and Array Formulas.
< li>Experience with Google Forms including scripting.
• High proficiency in Microsoft Excel including Power Query, Pivot Tables, PowerPivot, DAX.
• Basic knowledge of JavaScript would be an advantage.< /li>
• 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 foreseen);
• Working 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 training;
• Music festivals;
• li>Training at the expense of the company;
• Loyal management and a friendly team of professionals;
• Unforgettable events - from unique corporate parties to exciting team building and football championships.