The Opportunity

Shawbrook is a new type of specialist financial services company, combining the relentless focus on customer service and innovation you would expect from a fintech with the expertise and certainty of a bank. Shawbrook is driven by a purpose to solve complex problems that unlock opportunity for its rapidly growing customer base of over 300,000 UK consumers and businesses.

Our success would not have been possible without our Team. Our people differentiate us from the competition through their deep sector knowledge, they are the life force of our business.

Join Shawbrook because you:

Want to help us deepen our industry sector knowledge, combining technology alongside the best banking brains.
Want to build a bank for the future and be part of our digital transformation journey that will enable customers & businesses to thrive
Want to continue to grow professionally. We encourage you to grow and be the best version of yourself.
Care about sustainability? We want to be better for our people, environment and society.
Bring passion and enjoyment to your work. You’ll work hard but you’ll have fun too.

The Role & Responsibilities

In this role, you will collaborate with a Senior DBA and a team to design, develop, and document solutions for both on-premise OLAP systems using SQL Server and cloud-native data stores in Azure, such as Data Lake Gen 2, Azure SQL Clusters, and Azure Synapse SQL pools.

Your responsibilities will involve:

Designing and implementing Azure OLAP solutions, which include creating data models, cubes, dimensions, measures, and calculations.
Working closely with Data Engineering and SQLDEV teams to ensure smooth integration of data from Azure Data Lakes into databases on Azure.
Monitoring and optimizing the performance of environments, both on-premises and in Azure, by identifying and addressing performance bottlenecks.

Additionally, you'll contribute to enhancing data pipeline architecture and performance, auditing and improving the performance of databases and data lakes, and advancing tools, automation, and monitoring capabilities.

You will also stay informed about emerging trends in database technologies, analyzing both SMP and MPP databases, various Data Lake table formats, and Data Lake-based analytics to identify opportunities for the organization.

Your role will involve advocating for Infrastructure as Code practices through standardized deployments, scaling, and teardowns using technologies like ARM templates and PowerShell modules. Event-driven monitoring and alerts will be part of your responsibilities as well.

You will play a crucial role in establishing the organization's Data Catalog, which will extract information from the Data Lake and other downstream systems to provide data lineage, metadata, and master data insights across the entire bank.

Additionally, you'll maintain lower environment (test, dev) data in synchronization with production environments while ensuring that personally identifiable information (PII) is masked. Your role will also involve automating data deletion and anonymization tasks to align with GDPR regulations.

The Person

SQL Server: In order to provide valuable, business lead insights, you’ll be using SQL to build databases whilst you query, manage and manipulate vast amounts of data.

Python: Your role will involve close collaboration with the Data Engineering team during the integration of pipelines, which are predominantly written in Python a basic level of understanding would be required.

Azure Cloud: Given the significant migration activities underway within Azure, it's crucial to have a strong command of the environment, particularly concerning monitoring and optimizing performance.

Best Practices: We want this individual to drive and implement the Azure best practices across the team. This includes being an SME and documenting the implementation changes.

PowerShell: Proficiency in PowerShell is essential for the role, as it serves as a key tool for driving automation within the database team.

Reward

Your Wellbeing - We take your health and well-being very seriously by providing a range of benefits to give you and your family peace of mind. These include:

Market leading family friendly policies such as access to our Maternity, Adoption and Paternity policies from Day 1 of your employment
Free access to Headspace, a mindfulness & meditation digital health app
Free access to Peppy digital health app that offers personalised support through fertility treatment becoming a parent or menopause
EAP (Employee Assistance Programme) - Offering you support on a wide range of subjects including financial concerns, mental wellbeing and more general queries around family, work, housing, and health
Cycle-to-work scheme
Discounts on gym membership
Contributory pension scheme & death in service

Your Lifestyle - It’s important you strike the right balance between your work and personal life. We provide benefits to support you when at work and when you’re enjoying your leisure time.

Minimum of 25 days holiday per year
Option to buy or sell holiday days through our flexi-holiday scheme
Discounts on gym membership nationwide
Access to discounts on a range of high street and online brands
Community support and charitable giving

Your Contribution - We’re focused on rewarding those that go the extra mile in helping us achieve our goals.

Participation in our annual discretionary bonus scheme designed to reward your contribution to our success
Proudly Shawbrook recognition scheme focused on recognising our role models and thanking our colleagues for a job well done

Post Jobs Online Apply Job