Data Analyst

Reporting to the Manager, Data Innovation you will join a growing team responsible for delivering data & insight projects for a broad range of clients across retail, property, charity and local government sectors. You’ll use data to analyse customer shopping behaviour at a macro and granular level, whether it’s helping a major food delivery brand understand their market share or helping a shopping centre understand where to open new stores.
You will need to manage client projects from beginning to final delivery, capturing requirements, extracting and cleaning data, creating dashboards and visualisations, QA and final delivery. The role is fast-paced and constantly evolving, often delivering multiple projects a week whilst maintaining high levels of accuracy and suggesting improvements to improve efficiency of delivery.
This role would be the ideal opportunity to anyone looking to further develop their technical data & analytics skills, whilst also providing great commercial experience with regular exposure to clients and partners.

Key Responsibilities

• Perform hands on analytical work including database querying, coding, report building, and statistical modelling, ensuring projects are delivered to schedule
• Perform research, verification and data matching tasks to maintain high data accuracy
• Prepare dashboards and other data visualisations for output to external clients and internal teams
• Work with Account Managers and external clients to understand analysis requirements and propose solutions
• Support other insight team members on project delivery and problem solving.
• Stay up to date with developments in data & analytics industry and identify new technologies and methodologies that can support the team achieving their goals

Skills Knowledge and Expertise

• Min 4+ years of hands-on experience of analytics work especially:
• Large scale
• Transactional Data e.g., credit/debit cards
• Mapping or geolocation projects
• Enjoys coding and using tools to analyse, summarise and present data
• Sound mathematical and logical reasoning. Able to bring structure to complex problems
• Commercial focus – a broad interest in business, economy, retail
• Able to communicate complex issues clearly in writing, and face to face
• Brings a methodical, organised approach to tasks, maintaining attention to detail under time pressure
• Able to manage own time. Understands the importance of hitting deadlines and managing client expectations in a fast-paced, deal-driven commercial environment
• Holds themselves to high standards in both quality and quantity of work

Technical Skills

Essential

• SQL: writing and troubleshooting queries involving complex joins, functions, aggregations, subqueries etc. (We use MS SQL Server, but experience in any version of SQL would be transferable).
• Excel: creating and adapting spreadsheet models including complex formulae, charts, pivots, array functions, lookups etc

Desirable

• Tableau: creating reports, dashboards. (We use Tableau, but experience with any visualisation tool such as MS PowerBI or Google Data Studio would be transferable)
• Python: experience with libraries for data querying, visualisation and statistical analysis
• AWS: Experience using Amazon web services especially S3 and Athena (also Glue or Lambda)
• Likely to be educated to degree level in a STEM subject, economics, operational research, or data science.
• Experience of retail & financial sector and in using card payments data.
• Ambition to develop and advance in a growing organisation.

Benefits

• 25 days annual leave increasing by one day a year to 30 days (plus public holidays)
• Pension with Hargreaves Lansdown – 4% matched contribution
• Company holiday between Christmas & New Year (extra 3 days)
• Private healthcare with Vitality for yourself and any nominated dependents.
• Early finish on the last Friday of the month (3pm)
• Ability to buy and sell holiday days as well as the ability to bank days (tenure dependent).
• Cashback/discount shopping site (Perks at Work)
• Flexible working options – we are operating a hybrid working model from our London office (to be agreed with your manager)
• Variety of social events throughout the year such as Christmas party, company away day, movie nights, beer and pizza nights to name but a few

About Reward

Helping design, build and operate the best customer engagement programmes in the world, around the world. We power the best customer engagement programmes in the world! We occupy a unique space between retailers and banks helping them to get closer to customers driving incremental sales and lasting loyalty.