Data Engineer

Company Description

About us

We are part of PFG, a leading specialist bank for the millions of people in the UK who are not well served by mainstream lenders. Our purpose is to help put people on a path to a better everyday life with our clear and responsible approach to lending; an approach built on over 141 years of experience.

PFG is a unified group made up of two brands: Vanquis (cards and loans) and Moneybarn (vehicle finance). While they offer different products and services, they share the common purpose and customer-centric values at the heart of our group. We understand our customers are real people with varied life experiences, so everything we do from our products to our customer experience is designed with this in mind.

Job Description

You and Your Team:

As a Data Engineer, you will be reporting to the Senior Data Engineer. You’ll be part of the data Delivery function to enable data services for analytics, regulatory reporting and BI through the Group through the capture, storage and modelling of data from source systems.

In your day-to-day role, as a Data Engineer you will:

• Data visualisation: Establishes the purpose and parameters of the data visualisation. Provides overall control, to ensure appropriate use of data visualisation tools and techniques. Formats and communicates results, using textual, numeric, graphical and other visualisation methods appropriate to the target audience. Advises on appropriate use of data visualisation for different purposes and contexts to enable requirements to be satisfied. Develops plans showing how the identified user needs will be met. Leads exploration of new approaches for data visualisation.
• Data management: Devises and implements master data management processes, including classification, security, quality, ethical principles, retrieval and retention processes. Derives data management structures and metadata to support consistency of information retrieval, combination, analysis, pattern recognition and interpretation, throughout the organisation. Plans effective data storage, sharing and publishing within the organisation. Independently validates external information from multiple sources. Assesses issues which might prevent the organisation from making maximum use of its information assets.
• Requirements definition and management: Assists in the definition and management of requirements. Uses standard techniques to elicit, specify, and document requirements for simple subject areas with clearly-defined boundaries. Assists in the creation of a requirements baseline and in investigating and applying authorised requests for changes to base-lined requirements, in line with change management policy.
• Systems design: Designs components using appropriate modelling techniques following agreed architectures, design standards, patterns and methodology. Identifies and evaluates alternative design options and trade-offs. Creates multiple design views to address the concerns of the different stakeholders of the architecture and to handle both functional and non-functional requirements. Models, simulates or prototypes the behaviour of proposed systems components to enable approval by stakeholders. Produces detailed design specification to form the basis for construction of systems. Reviews, verifies and improves own designs against specifications.
• Data modelling and design: Investigates corporate data requirements, and applies data analysis, design, modelling, and quality assurance techniques, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). Provides advice and guidance to database designers and others using the data structures and associated components.
• Database Design: Develops and maintains specialist knowledge of database and data warehouse concepts, design principles, architectures, software and facilities. Assesses proposed changes to object/data structures, in order to evaluate alternative options. Implements physical database designs to support transactional data requirements for performance and availability. Implements data warehouse designs that support demands for business intelligence and data analytics.

Qualifications

What you will bring to the team:

• Data migration, storage and modelling experience
• SSIS / ADF or equivalent ETL tool
• Cloud based database / data warehouse experience
• Experience of working with large datasets
• Experience of working in data orientated projects either waterfall or agile
• Strong understanding of unit testing and support testing documentation

Desirable

• Experience working within Financial Services Sector
• Experience in iterative/agile development methodologies (SCRUM, XP, RUP etc)

Additional Information

On top of all this, we will give you a package including:

• Discretionary annual bonus
• Hybrid working considered
• Up to 30 days holidays in addition to bank holidays
• Pension Scheme with matched company contributions up to 5%
• Private Medical Insurance
• Extensive opportunities for personal and career development
• Opportunity to grow, develop and learn
• Colleague Perks at Work discount platform
• Season ticket loan
• 1 paid day to ‘give back’ to local communities or chosen charity

Inclusion & Diversity Statement

We strive to constantly improve the way we look after our people and have created an environment where everyone feels valued and can be themselves. We know that by having a better, more inclusive culture and a diverse group of colleagues, we can support our customers and each other in the best way possible. We also believe this goes a long way to helping us live our purpose and defines why we’re here in the first place: to help put people on a path to a better everyday life.

We’re an equal opportunities employer and we want people to join us no matter how they identify, their sexual orientation, marital or civil partner status, race, colour, nationality, ethnic or national origin, religion or belief, disability, or age.

We want to attract and retain the best people. So, we make sure that, if people need it, they’re given all the extra support and reasonable adjustments to take part in any part of our application or interview process. We’ve also got lots of colleagues who choose to work flexibly, so please feel free to talk to us about how you prefer to work at any time.