Senior Data Engineer

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

• Managing the SQL Server estate, ensuring high availability in our production environment, including backups, indexing, query optimization and all aspects of the MS SQL DBA role
• Proactively working with our Engineering teams to advise on database design and best practices, along with reviewing pull requests and release scripts
• Building ADF pipelines and enhancing our Snowflake environment
• Assessing business requirements in order to design and build effective BI/MI reporting solutions to meet business needs
• Building and maintaining solid working relationships across the business, to help understand metrics and associated data requirements
• Creating reporting solutions in line with standards, architectural principles and practices working in an agile, proactive manner, delivering high quality solutions
• Conducting relevant testing and provide fit for solutions ensuring that adequate steps are in place to protect data
• Managing the development and build of ETL/ELT processes, data lakes, data warehouse models
• Liaising with 3rd party suppliers to maintain effective relationships and ensure that SLA’s are adhered to
  

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
• 3 + years as a MS SQL Server DBA including installation, maintenance, patching, backups and restores
• Performance tuning, query optimization, query plan analysis and indexing
• 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.
  

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!