Data Analyst in Belfast

Founded in 2001, Reward is an industry leader transforming the world of customer engagement and commerce media. Operating in 15 countries across Europe, Middle East and Asia, Reward’s cloud-based API platform integrates content, advertising, and commerce to deliver exceptional experiences for consumers resulting in increased customer engagement, retention, and overall satisfaction. Reward’s Loyalty-tech platform is behind many award-winning bank loyalty programmes seen today from brands such as Visa, NatWest Group, Barclays, and First Abu Dhabi Bank to name a few. Reward also works with the world’s largest retailers such as McDonald’s, eBay, Deliveroo and Amazon.

Their leading commerce media platform fuses purchase insights with loyalty-tech, offering an unparalleled edge in digital advertising and performance marketing for retailers. Leveraging rich data and insights, the Reward platform provides a comprehensive view of consumer behaviour, empowering retailers to target marketing messages more effectively, resulting in independently verified sales uplift and long-term customer lifetime value. Beyond bridging the gap between content and commerce, Reward is a purpose driven business. Their mission is to make everyday spending more rewarding. During the last 5 years, Reward has proudly given back more than $1 billion in cashback rewards to consumers worldwide.

Most recently, Reward’s rapid growth was recognised in The Independent’s E2ETech100 list of fastest growing tech scale-ups in the UK. Reward, in conjunction with partners NatWest Group, was also awarded the Industry Achievement Award 2023 at the prestigious Card and Payments Awards.

Role Summary

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.

Requirements

• Ability to read and write Structured Query Language (SQL).
• Basic understanding of Object-oriented languages (mandatory 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.

Additional

• Hands-on experience of working with a significant size database.
• 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).
• 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.

Flexible working options: we are operating a hybrid working model with 3 days a week from the office.

Pension: Hargreaves Lansdown – 6% matched contribution.

Employee share scheme.

Generous family friendly cover.

Income protection.

Critical illness cover.

Life insurance cover.

Optical cover.

Yulife app for access to employee wellbeing and discounts.

Perks at Work, cashback/discount shopping site.

Salary sacrifice program which includes cycle to work scheme, electric car scheme and season ticket loans.

Company events i.e. Christmas party, all-company event and other social/hosted events during the year (we have an active social committee!).