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 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.

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.

About the Company

All Response Media is Europe’s leading performance media agency, providing clients with an “Unfair Competitive Advantage” since 1995, with offices in London, Leeds and Amsterdam

We are progressive, dynamic and a rewarding company where you can develop your skills and build a long-term career in advertising, as part of a highly talented and driven team of over 150 professionals. As a growing agency, you will be a part of a fast-paced, exciting and social company culture that truly enriches employee careers. We show a great level of passion and care for all we do, and our leaders appreciate that embedding a strong team culture is important to the success of ARM. As such, we are passionate about developing strong leaders from within the business.

We provide industry-leading media performance to a growing global client base and partner with some of the most innovative and established businesses to continue our mission to disrupt and innovate the advertising industry. Our success is achieved through the success of our clients, and we do this by cultivating strong working relationships through collaboration, innovation and integration which drives engagement, helping them build strong brands and performance.

We plan and buy across all media channels, on and offline. Our bespoke campaign measurement suite, ARMalytics®, gives us a competitive advantage and is at the core of our model, underpinning the data-led operations of our integrated client business teams and ARMlabs data and systems unit. We actively encourage integration across the agency, therefore those who join us soon find that they have a wealth of knowledge across all marketing disciplines.

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 story telling 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.