Jobs

Data Analyst


Job details
  • Reward
  • Belfast
  • 2 weeks ago
Applications closed

Description

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

  • Annual Leave: 25 days + bank holidays
  • Ability to buy and sell holiday days as well as the ability to bank days (tenure dependent) 
  • 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
  • Private healthcare - Bupa 
  • Income protection
  • Critical illness cover
  • Life insurance cover
  • Dental cover
  • Optical cover
  • Yulife app for access to employee wellbeing and discounts 
  • Perks at Work, cashback/discount shopping site
  • Employee referral scheme 
  • Salary sacrifice program which includes cycle to work scheme, electric car scheme and season ticket loans
  • Volunteering program
  • Company events i.e. Christmas party, all-company event and other social/hosted events during the year (we have an active social committee!)
  • Team socials
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. 

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Data Analyst Apprentice - Halifax

Please note, this site is only for external candidate applications. If you currently work for Lloyds Banking Group please apply via the internal career site.Please note: In order to complete an apprenticeship there needs to be a significant learning ; You need to consider your previous qualification...

Lloyds Banking Group Halifax

Data Analyst - £32,000 - £37,000 – Blackburn

Data Analyst - £32,000 - £37,000 – BlackburnPython | File transfer | Bash | Power shell | Scripting | Data Analytics | Cryptography | MTF | Managed File Transfer | Retail | Documentation |Are you a Data Analyst who wants to join a company that take progression and development seriously?...

Opus Recruitment Solutions Blackburn

Data Analyst

Data Analyst – PythonLondon£35,000 - £40,000 + 25 Days Holiday + Private Healthcare + L&D BudgetMy client is an ambitious start-up dedicated to revolutionising the repo market through data-driven strategies.With major financial backing this start-up collaborates with top-tier banks, asset managers, and hedge funds to develop groundbreaking data solutions aimed...

Opus Recruitment Solutions London

Data Analyst

Delegated Authority / Data Analyst / Insurance / Bordereaux / ExcelPerm role, hybrid working, salary up to £50k + bonus & benefitsKEY SKILLS:Strong data analysis / data quality experience gained within the London Market insurance sectorKnowledge of delegated authority and bordereaux dataExcellent IT skills, in particular Microsoft ExcelTHE ROLE:The Data...

RED10 London

Data Analyst (Tech) Apprentice

Job Title Degree Apprentice Data Analysis A Digital Technology and Solutions Professional Degree apprenticeship involves working and learning alongside experienced practitioners. It combines spending periods of time at University, where you will acquire an Honours Degree, with time working on real projects, enhancing the skills necessary to develop a long...

BAE Preston

Data Analyst

Data Analyst | Investment Product Experience Essential | 6-Month Contract | Hybrid | Central London | Circa £600-£700/dayWe are currently partnered with a long-standing Investment client, looking to source for them 2 outstanding Data Analysts. They are looking for strong analysts with experience in SQL, Python, Excel and other tools...

Practicus London