Data Analyst (LON)

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

Job summary

McNally Recruitment Ltd is coordinating a Data Analyst role for a Financial Services client in London. The position requires strong securitisation knowledge, advanced SQL/Excel, and experience turning business needs into data solutions. Hybrid work setup with up to 2 days in the office.

You will partner with multiple teams to deliver data-driven insights, perform data profiling, and contribute to governance and continuous improvement while mentoring junior analysts.

Qualifications

• 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 data flows.
• Advanced SQL and Excel skills, able to analyse, reconcile, and interpret large datasets.
• Experience translating business needs into data requirements and technology solutions.
• Strong analytical and problem-solving skills, with a focus on data quality and process improvement.
• Excellent stakeholder management and communication skills across business and technology teams.
• Experience coaching or mentoring colleagues and contributing to a collaborative team environment.

Responsibilities

• Partner with Securitisation, Treasury, Risk, Finance, Operations, and Technology teams to translate business challenges into data-driven solutions.
• 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 through 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 and stakeholder engagement.

Skills

Data analysis

SQL

Excel

Stakeholder management

Mentoring

Analytical thinking

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 in the office.

• 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 rolein which you'll honeyour 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

PLEASE NOTE THE SALARY INCLUDES 10% of Basic Salary as Benefits-in-cash & 10% (approx.) discretionary Bonus!