Data Analyst

McNally Recruitment Ltd; Greater London; Hybrid; GBP 45,000 - 70,000; Full time

Job summary

McNally Recruitment Ltd in London is seeking a Data Analyst to join a Financial Services client, based at the London branch with a maximum of 2 days per week, offering hybrid working arrangements.

You will manage the analysis of complex securitisation data, provide analytical input to develop innovative processes, and mentor junior analysts across banking and technology teams. Strong SQL/Excel skills and data governance focus are essential.

Qualifications

• Experience as a Data Analyst or hybrid Data and Business Analyst in financial services and securitisation technology.
• Strong securitisation and structured finance knowledge, with understanding of asset classes and data flows.
• Advanced SQL and Excel skills to analyse large datasets and reconcile data.
• Experience translating business needs into data requirements and technology solutions.
• Strong analytical and problem-solving skills focused on data quality and process improvement.
• Excellent stakeholder management and communication across business and technology teams.

Responsibilities

• Support delivery of high-quality business solutions and data extraction, storage, manipulation, processing and analysis.
• Translate business challenges into data-driven requirements with cross-functional teams.
• Analyse securitisation data using SQL and Excel to identify trends and insights.
• Perform data profiling, mapping, and quality analysis to improve data accuracy and governance.
• Collaborate with Product Owners, Business Analysts, and Engineering during design, testing and implementation.
• Produce reporting and analytical outputs to support decision-making and performance.

Skills

Data analysis

SQL

Excel

Stakeholder management

Mentoring

Securitisation

Tools

SQL

Excel

Job description

We are working in collaboration to source a DATA ANALYST (Securitisation Technology) for a Financial Services client. You will be based in the London branch, working a maximum of 2 days per week.

• You’ll manage the analysis of complex bank, franchise or function data to identify business issues and opportunities
• Provide high-quality analytical input to help develop and implement innovative processes and resolve problems across the bank. This is a hands-on role in which you’ll hone your data analysis expertise and gain valuable experience in a dynamic area of our business

What you’ll do

you’ll be supporting the delivery of high-quality business solutions, performing data extraction, storage, manipulation, processing and analysis, alongside developing and performing standard queries to ensure data quality and identify data inconsistencies and missing data.

• Partner with Securitisation, Treasury, Risk, Finance, Operations, and Technology teams to translate business challenges into data-driven solutions and requirements
• Analyse complex securitisation data using SQL and Excel to identify trends, investigate issues, and generate actionable insights
• Gather, document and validate business and data requirements to support technology change and regulatory initiatives
• Perform data profiling, mapping, lineage, and quality analysis to improve data accuracy and governance
• Collaborate with Product Owners, Business Analysts, and Engineering teams throughout design, testing, and implementation activities
• Produce reporting, management information, and analytical outputs to support decision-making and operational performance
• Mentor junior analysts and promote best practices in data analysis, stakeholder engagement, and continuous improvement

The skills you’ll need

We’re looking for someone with experience of using data analysis tools and delivering data analysis in a technology or IT function. You’ll also demonstrate:

• Experience as a Data Analyst, or hybrid Data and Business Analyst within financial services and Securitisation Technology.
• Strong securitisation and structured finance knowledge, with an understanding of asset classes, transaction lifecycles, and associated data flows
• Advanced SQL and Excel skills, with the ability to analyse, reconcile, and interpret large and complex datasets
• Experience translating business needs into data requirements and technology solutions
• Strong analytical and problem-solving skills, with a focus on data quality, root cause analysis, and process improvement
• Excellent stakeholder management and communication skills, with the ability to work effectively across business and technology teams
• Experience coaching or mentoring colleagues and contributing to a collaborative, high-performing team environment

The salary range INCLUDES 10% for Benefits-in-Cash and 10% Discretionary Bonus!