Position: Data Analyst
Company: IDR
Category: Data Analyst
Experience required: no_exp
English level: fluent
Published: 2022-08-01T00:00:00+03:00

**Key Areas of Responsibility**
• Understand and access the available advertising and response data that is available from vendors we purchase media from on behalf of our clients (for example Google, Facebook, TheTradeDesk, and many other vendors)
• Understand and access available consumer behavior data coming from client websites (typically via Google Analytics), social pages and feeds and other consumer behavior data.
• Understand the way advertising campaigns are set up broken down by product, message, creative, placement, and other definitions
• Set up dashboards and spreadsheets that combine data elements from multiple sources to enable overall views of campaign effectiveness
• Create Tableau reporting dashboards accessible to agency and clients to give immediate insights into campaign performance matched to consumer behaviors via client data, or client platform data (Google analytics, etc)
• Create SQL queries to extract data from company servers for import into dashboards
• Create Powerpoint review presentations and write commentary on campaign dashboards detailing campaign performance in the presentations

**Key Skills**
• Required: SQL, Tableau, Excel, Powerpoint
• Required: Correlation and Regression modeling
• Required: Business English language
• Helpful but not essential: Python, R, large dataset analytics experience (Hadoop, Spark)
• Readiness to work in the office from 15:00 till 23:00 in order to have an optimal overlap of work hours with USA based teams

**We offer:**
• Great office location 3 minutes from Pecherska metro station and great office conditions;
• Comfortable working place;
• Medical insurance after the trial period ending;
• Team-building activities;
• 24 paid vacation days per year;
• 5 paid sick leave days per year.