Junior Data Analyst London, England
Job description
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.
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 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
Requirements
- 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
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.
Job Type: Apprenticeship
