Data Analyst
Department: Technology
Employment Type: Permanent
Location: Belfast
Reporting To: William Allen
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 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-oriented languages (preferably Python).
* Understanding of logical relational database concepts (e.g. including data types, joins, subqueries, 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.
#J-18808-Ljbffr