Senior Data Engineer (12 Month FTC)

Team IT, IT & Change

Location Holborn Office

County Central London

Ref # 20456

Closing Date 24-Oct-2023

We have been awarded the “Most Loved Workplace”! At Metro Bank, people come first – our culture is all about bringing the best out in our colleagues, and making sure everyone feels valued, respected, seen and included. We strongly believe in a diverse and inclusive workplace and to find the very best person for the job, we always look across a wide range of diverse communities.   

 What you will do:
 

•   Working in our diverse and friendly data team, you will be leading on the assessment of business requirements and the design and build of effective BI/MI reporting solutions to meet business needs

•   Building and maintaining solid working relationships across the business, to help understand metrics and associated reporting requirements

•   Managing the development and build of ETL/ELT processes, data lakes, data warehouse models 

•   Creating complex reporting solutions in line with standards, architectural principles and practices working in an agile, proactive manner and delivering high quality solutions

•   Conducting relevant testing and provide fit for purpose dashboards and reporting outputs and ensure that adequate steps are in place to protect data

•   Coaching and mentoring of more junior members of the Data Team to contribute to their personal development and the successful delivery of the function’s objectives

•   Liaising with 3rd party suppliers to maintain effective relationships and ensure that SLA’s are adhered to

•   Developing your own knowledge of relevant Consumer Finance products, processes, regulatory frameworks, service standards and systems relating to data engineering

 And... we are a bank so risk is a part of everything we do. We love people who take responsibility, do the right thing for customers, colleagues and Metro Bank and have the ability to call out any concerns.

 What you will need: 
 

•   Understand the risks associated with your job and what that means for you, Metro Bank and all our stakeholders

•   The ability to deal directly with business functions and interpret their requirements into successful solutions

•   Strong analytical mind-set with the ability to develop complex BI/MI solutions using the required toolsets

•   MS SQL Server Development

•   Experience with or a good understanding of SQL server Availability Groups

•   T-SQL, SSIS, source control (TFS or GIT)

•   Database design and data modelling, ideally with data warehousing experience 

Nice to haves….

We don’t expect you to have all of these skills, but these are the technologies we work with, so even if you don’t have the experience but are keen to learn, please get in contact! 

•    Microsoft Azure Data Factory (ADF)

•    Snowflake

•    Power BI

•    Azure SQL Databases

•    Python

•    SSRS/SSAS

•    Familiarity with cloud technologies such as Microsoft Azure

•    Financial industry experience

 

Our promise to you…
 

•    We will make sure that you are well-rewarded by providing you with a competitive salary, discretionary annual bonus, and a wide range of benefits, including generous holiday allowance, attractive pension scheme, healthcare, life assurance, and a number of colleague discounts! 

•   We will give you the training to ensure you succeed in your role and plenty of internal opportunities to progress your career (around 40% of our recruitment comes from internal promotions!). 

•   We are also all about balance so most of our jobs offer the opportunity for hybrid working built around your role and home life, wherever possible.

Important Footnote

Diverse teams really are the best teams. We know that candidates (especially women, research tells us) may be put off applying for a job unless they can tick every box.  We also know that ‘normal’ office hours aren’t always doable, and while we can’t accommodate every flexible working request we are happy to be asked.  So if you are excited about working with us and think you can do much of what we are looking for but aren’t sure if you are 100% there yet… why not give it a whirl? Please note that sometimes we may close a job earlier for applications if we are inundated with amazing candidates.. Good luck!