The days of putting people into boxes are over as far as we’re concerned. There are 8 billion people on this planet, and every single one is unique. So that’s how we treat each of our customers - as a living, breathing individual, not just a number.

We celebrate and support the beautiful complexity of real life. And instead of doing things how they’ve always been done, we do what’s best for our people and our customers, right now and into the future.

Our passion is to create the best products, services and experiences for customers and partners. That’s why we won’t compromise. If we don’t love it, we don’t do it.

So welcome to Real Life Lending. Welcome to The Mortgage Lender.

The main objectives are:

• Reporting to the Data and Reporting Director, they will play a key role in the maintenance, manipulation and dissemination of key information around the business.
• Becoming part of a small team assisting the Data and Reporting Director in the provision of data and reporting to a diverse group of internal and external stakeholders.
• Supporting the administration of the data warehouse.
• Liaising directly with representatives of various business areas to understand their requirements and then working from raw data through visualization to distribution of the reports.

Specific responsibilities include the following:

• Gain a detailed understanding of the database structure, processes and interactions with the system front-end.
• Building and maintaining essential SQL queries.
• Development of reports using SQL, Visual Studio, SSRS and Power BI. Liaison with the report users to ensure that these reports are suitable for purpose.
• Assisting in the upkeep of SQL Server databases.
• Provision of timely and accurate reports to senior management and other stakeholders.
• Using Excel to manipulate and present the extracted data into a form which best suits the intended use of the specific stakeholders.
• Project work to enhance and evolve the reporting environment as and when required.
• Identifying opportunities to build efficiencies, integrations and automations then developing them through to realization.

• Advanced SQL skills. Power BI and Visual Studio beneficial.
• Proven experience with the maintenance and upkeep of relational databases, including knowledge of best practice.
• Proven experience in financial services.
• Microsoft Office suite, specifically advanced Excel, ideally with VBA.
• Excellent communication skills, both verbally and written.
• Can work well under pressure, using their own initiative with minimum oversight.
• A positive attitude and a desire to drive themselves and the business forward. Setting an excellent example for more junior analysts, providing them with guidance when needed.

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.

• Competitive Salary
• 25 day’s annual leave
• Pension and healthcare
• Flexible working hours
• Hybrid Working
• Modern offices in Glasgow
• Positive and supportive environment

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