Skip to content

Reward

You’ll be an enthusiastic database professional with an ability to write and read good-quality SQL code. 

You will work with a multitude of business stakeholders, both technical and non-technical, to scope and build data solutions and exports. This will include database table design, stored procedure design, code review, documentation, progress reports and peer support. You will develop quality assurance (QA) processes and provide a range of regular and ad hoc deliverables to support the business needs and operations. 

You will be able to propose and implement improvements to the existing processes to support the wider business strategy and help shape the future of our data products. 
You’ll have the ability to respond and adapt to a fast-paced working environment and be able to maintain a logical and systematic approach to the solution design of database tasks and projects. 

Key Responsibilities

  • Assess, design, implement and document robust procedures for managing the integrity of data flows 
  • Assist in the development of Reward’s data warehouses to allow access to an ever-growing pool of data in an efficient and scalable manner  
  • Seek practical solutions to reduce time and cost through automation of operational procedures 
  • Carry out systematic data cleansing and enhancement exercises   
  • Undertake regular and ad hoc activities including data provision, report development and exploratory data analysis 
  • Understand and operate the end-to-end campaign selections process, and suggest and implement improvements 
  • Deliver reporting and data extracts to analyse the effectiveness of retailer campaigns 

Skills Knowledge and Expertise

Required 
  • Ability to read and write Structured Query Language (SQL)  
  • Basic understanding of Object orientated languages (preferably Python) 
  • Understanding of logical relational database concepts (e.g. including data types, joins, sub queries, primary and foreign keys, normalisation).  
  • Ability to translate requirements sourced from non-technical clients into effective technical specifications  
  • Ability to produce process documentation that is logically structured and accurate 
  • Experience of working with common data file formats (e.g. csv, fixed width), importing and exporting data, compression, encryption software (e.g. WinZip) and FTP clients. 
  • High attention to detail 
Bonus points for any of the following:  
  • Hands on experience of working with a significant size database 
  • Experience of Microsoft SQL Server (2012 or higher) 
  • Experience of Microsoft SQL Server (2012 or higher) Reporting Services and / or Integration Services 
  • Experience of using a BI reporting tool (Tableau, PowerBI, Qlikview) to create dashboards and reports 
  • Experience using a cloud provider (AWS, Google Cloud, Azure) 
  • Advanced knowledge of MS Excel including complex formulae, advanced charting, lookups, PowerPivot and VBA 
  • Business process concepts including, for example, data flows, batch control, validation rules, exception reporting, audit trail and reconciliation 
  • Domain expertise in any of the following: retail, personal banking, direct marketing, digital marketing, CRM, loyalty programmes 
  • Educated to degree level in a quantitative subject 

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

Our vision is to be a global leader in customer engagement, helping brands to create customers of the future. How do we achieve this? By making everyday spending more rewarding, we make every interaction count, delivering billions in rewards. 

To apply for this job please visit rewardinsight.pinpointhq.com.