QA Engineer – ON-SITE

Job Overview

About The Role
Let’s grow together!A Platinum Investors in People employer and an award-winning UK bank, focused on growth. Our customers include savers and businesses across the UK and, working
together, we use our specialist expertise to help them achieve their ambitions and build a sustainable future.
If you’re an experienced Senior Data Engineer looking for an opportunity to grow in a friendly environment,
we’re looking for you!
We’re flexible, inclusive, committed to your wellbeing and passionate about you reaching your potential. Let’s grow together …
Purpose of the roleThis role sits within the Data Warehouse team. The team is responsible for developing and maintaining the SQL Data Warehouse, which holds key loan by loan data from the core servicing platforms for the
entire range of the Bank’s loan and savings portfolios. This data is updated on a daily basis and the warehouse is designed to facilitate analysis and fulfil all the Bank’s reporting and Business Intelligence requirements.
The Senior Data Engineer will be responsible for designing, implementing and supporting ETL processes, monitoring performance, building efficiencies and producing ‘proof of concept’ reports.

Duties and responsibilitiesDesign and develop automated solutions to assist the business in its operation, utilising the Microsoft SQL Server suite of productsUtilise the groups available software suite to reduce/remove
manual processes for example automation of data acquisition tasks via Microsoft Power suite (Power Apps, Power Automate, Power Query)Use data engineering skills to transform and prepare data for use in analytical and visualisation
modelsFully document and maintain working procedures of ETL processesSupport wider team Projects which impact the Data Warehouse environmentsDevelop and maintain Data Quality checks and processesInvestigate and remediate
issues arising in the overnight processesAnalysing trends in the performance and behaviour of the Group’s loan assets based upon historical dataOngoing reconciliation and validation of account dataProducing analysis and
insight to understand performance over timeWorking in adherence to the Data Governance FrameworkDevelop a good understanding of the Bank’s core IT servicing platforms and loan portfolios, with the longer-term aim of rebuilding
the Data Warehouse to incorporate advanced data modelling techniquesResponsibility for testing new SQL code to ensure correct results are achieved before being incorporated into the ‘Live’ warehouseApplying GDPR standards
to dataCoaching junior team members
About You
SkillsEssential:Ability to develop new solutions using methodologies consistent with current solutionsStrong commercial acumenAnalytically focussed and detail consciousExcellent
written and verbal communication skillsAbility to work as part of a teamAbility to self-teach and keep abreast of technological advances
Qualifications and experienceStrong SQL background with experience of T-SQL & SSIS is required, as well as experience of designing and developing data warehouse solutions and analysing and reporting on large/complex
datasets.
A numeric or technical based degree (STEM or Computer Science) would be desirable. The ideal candidate would also have experience within the Financial Services Industry and using a database source control solution
About UsEven if you don’t meet all the criteria, we encourage you to apply. At Paragon, we value diversity and we’re excited to hear from passionate individuals like you! If you’re ready to contribute to the team,
please apply.Further information on the role can be found in the Purpose and Performance Profile (PPP), which is downloadable on this page.
Working hours37.5 hours per week, Monday to Friday, 8.30am to 5.00pm (one hour for lunch) – hybrid role.
InclusionAs a Disability Confident Employer, we want to ensure that our vacancies are accessible for everyone.
If you have a disability, long term health condition or are neurodiverse and need us to adjust our recruitment process please get in touch with our recruitment team.
What can we offer you?Generous Holiday Allowance: Starting from 25 days and climbing to 30, you also get to enjoy a day off for your birthday, Christmas Eve, and New Year’s Eve. You can also buy or sell up to a week’s
leaveShare Save Scheme: Annually, you have the opportunity to buy shares in Paragon at a discounted rateProfit Related Pay: We share some of our annual profit with our eligible employeesPension Plan: We contribute up to
10% of your annual salary towards your pensionFamily Friendly policies: We offer enhanced parental pay and paid time off for fertility treatmentEmployee Discounts: Enjoy exclusive discounts on entertainment, travel, shopping,
motoring and moreVolunteering Day: Contribute to causes you care about with one volunteering day per yearLife Assurance and Personal Accident Cover
Be flexibleWe promote flexibility around how and where we work so that you can achieve a healthier work-life balance. We operate hybrid working, splitting our week between the office and home.
Be yourselfAs an equal opportunities employer, we welcome diversity and care about inclusion. That’s why we want you to be your whole self at work. We believe an inclusive workplace is good for each of us, great for our
customers and better for our business. Our Equality, Diversity and Inclusion Network meets regularly to share challenges, experience, and ideas to build a more equal, diverse, and inclusive business.
Be heardWe listen to your point of view, with our People Forum and regular employee surveys making sure you can use your voice and influence our future.
Be wellWe will give you access to a range of tools and resources to support your wellbeing. This will include a digital GP service via our free Employee Assistance Programme, access to our Wellbeing team to connect you
with the help you need to get more out of life and our Vitality at Work programme to provide you with discounted gym membership, fitness equipment and another multitude of wellbeing services.
Be betterWe want you to reach your potential and, as a Platinum Investors in People employer, we’ll encourage you to learn and develop by building a personalised development plan together with your manager.