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 planning and buying teams at All Response Media by way of data wrangling, analysis and basic 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 is a 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.
Your key responsibilities will include:
- 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
- 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
- Assist with finding innovative ways to systemise and streamline processes
Requirements
- BSc in Maths, Statistics or Econometrics, or level 4 Data Analyst Apprenticeship.
- Basic data manipulation skills in Excel/R (or Python)
- Basic timeseries econometric regressions experience (Python/R/etc.)
- Advanced MS Excel Skills (VLOOKUP's, etc.)
- Strong number orientation through abilities in maths, accounting, statistics.
- Good communication skills
- Good storytelling with data skills
- MS SQL 2012+ experience (preferred)
- Media experience (preferred)
- Eligible to work in the UK
Benefits
- Competitive salary and bonus
- 25 days annual leave + bank holidays
- Annual company away day and socials - we're all about the socials!
- Daily drinks fridge, free fruits, breakfast on Mondays and lunch on Fridays
- Private healthcare with Vitality (50% off at Virgin Gyms!) and eye test
- Flexi Fridays and time off on your birthday
- Long term service rewards up to £10k and sabbaticals to travel the globe!
- Life cover 4x your annual salary, enhanced sick pay, income protection
- Perkbox and Wellbeing programme
- Season ticket loan and cycle to work scheme
- Media, technical and managerial training, including LinkedIn Learning!
- Progression and development
Accelerate and fast-track your career with All Response Media.
#J-18808-Ljbffr