Junior Data Analyst

This is a fantastic opportunity at a progressive and successful media agency where you will provide support to the ARMLabs team and media planner buyers at All Response Media by way of data wrangling, analysis and econometrics. You will be joining a passionate and supportive team of economists who crave answers, enjoy learning, and thrive off working on multiple tasks and projects ranging from data extraction through SQL/Snowflake to analysing the impact of advertising campaigns using time series econometrics models. This a is great opportunity for newcomers to the data analytics world. You will be trained by the senior members of the team, who will soft manage you on a day-to-day basis, but you will report to the head of data science. There are many opportunities within the role to gain responsibility and develop creative thinking through actionable insight. A BSc in Maths, Statistics or Econometrics, or successful completion of a level 4 Data Analyst Apprenticeship is required to be considered for this role., * Access, investigate and extract data as needed (using Snowflake and SQL)

• Manipulate data (format, remove and add data and tables)
• Test data for completeness and correctness
• Format client reports and data extracts (mainly in Excel and R)
• Create own visualisation and dashboards and maintenance of dashboards using an advanced suite of visualisation tools
• Manage the log of weekly requests from the ARM teams
• Provide web tag data to ARM teams
• Assist ARM team with queries regarding the bespoke ARM RAPS system
• Assist ARM teams with client setup and configuration on the RAPS system
• Analyse Direct Response advertising effectiveness
• Compile and report on competitor insights
• Run simple econometric regressions in R
• Econometrics modelling to answer questions about the effect of advertising
• Maintain GDPR compliance with regards to handling of first- and third-party data
• Troubleshoot data problems that extend to attribution queries
• Identify areas of opportunity with regards to automation and streamline processes
• Contribute to further development around wider industry research and use cases

Python, Vlookup, Econometrics, Statistics, Communication Skills, R, * BSc in Maths, Statistics or Econometrics, or level 4 Data Analyst Apprenticeship.

• Data manipulation skills in R (or Python)
• Timeseries econometric regressions experience (Eviews/SAS/R/etc.)
• Advanced MS Excel Skills (VLOOKUP's, etc.)
• Strong number orientation through abilities in maths, accounting, statistics .
• Good communication skills
• Good story telling with data skills
• MS SQL 2012+ experience (preferred)
• Media experience (preferred)
• Eligible to work in the UK