RWA Reporting and Analysis Manager - Fixed Term Contract

Lloyds Banking Group; Cardiff; Hybrid; GBP 65,000 - 80,000; Full time

Job summary

Lloyds Banking Group is recruiting a RWA Reporting and Analysis Manager on a 12-month Fixed Term Contract in a hybrid role with offices in Cardiff, Edinburgh or Bristol. You will lead CCR, Leverage, and RWAs reporting, using SQL, Python and Power BI to deliver insights and robust controls.

The role requires a strong finance background with a professional qualification (ACCA/CIMA/ACA/ICAS) and 1 year post-qualification experience, ideally in regulatory capital and PRA frameworks.

Qualifications

• Fully accredited Finance qualification (ACCA/CIMA/ACA/ICAS).
• Minimum 1 year post qualified experience, preferably in applying and understanding RWA rules and calculations.
• Background in Financial Services or large accountancy practice is advantageous.
• Data Analytics: proficient in Excel for data manipulation, analysis, and automation.

Responsibilities

• Perform accurate calculation of CCR, Leverage and RWAs and ensure compliant reporting.
• Maintain understanding of adjustment methodologies and link to internal policies and external requirements.
• Produce and validate daily Leverage and monthly RWA and Leverage Returns across portfolios.
• Analyse period movements, identify anomalies and provide business commentary.
• Deliver internal and external regulatory reporting and support audits.
• Build and maintain SQL/Python scripts and enhance Power BI dashboards for MI.
• Collaborate with IT and data teams to improve data quality and integrity.

Skills

Finance background

SQL

Python

Power BI

Excel

Power Apps

Data warehousing

ETL

Education

ACCA/CIMA/ACA/ICAS

Tools

SQL

Python

Power BI

Power Apps

Job description

JOB TITLE: RWA Reporting and Analysis Manager - 12-month Fixed Term Contract.

SALARY: 65,385 to £79,915pa plus an extensive benefits package.

LOCATIONS: Edinburgh, Bristol or Cardiff.

HOURS: Full-time.

WORKING PATTERN: Our work style is hybrid, which involves spending at least two days per week, or 40% of our time, at one of our office sites. Colleagues with disabilities can be supported with workplace adjustments including hybrid working expectations in line with our Flexibility Works policy.

The Risk Weighted Asset (RWA) Reporting & Analysis team within Central Finance is responsible for calculating, reporting and providing valuable insight over the Group's RWA and other regulatory capital information. This 12-month FTC offers an exciting opportunity within the Capital Planning and Regulatory community with technical support available to upskill if you've no prior regulatory experience!

Why Lloyds Banking Group?

If you think all banks are the same, you'd be wrong. We're an innovative, fast-changing business that's shaping finance as a force for good. A bank that's empowering its people to innovate, explore possibilities and grow with purpose.

Your Key Accountabilities Will Include:

RWA Reporting & Analysis

• Perform accurate and timely calculation of Counterparty Credit Risk (CCR), Leverage and Settlement Risk exposures and RWAs - including the effective use of the Moody's Ray calculator.
• Maintain a strong understanding of adjustment methodologies, ensuring accurate implementation within the RWA calculator, and the ability to effectively link these to relevant internal policies and external regulatory requirements. Provide informed challenge where appropriate to ensure robustness and compliance.
• Produce and validate daily Leverage and monthly RWA and Leverage Returns across, derivatives and SFT portfolios, ensuring compliance to the rules and regulations.
• Analyse period on period movements, trends, identify anomalies, and provide Business commentary.
• Deliver regulatory and internal reporting requirements.
• Support the business in delivery of New Products and Strategic Transactions.
• Maintain effective control frameworks to ensure robust outputs.

Technical Development & Automation

• Build and maintain SQL/Python scripts for data extraction, transformation, and analysis to drive and support Finance data transformation.
• Build and enhance Power BI dashboards to deliver intuitive and interactive MI to internal customers.
• Utilise Power Apps to improve MI, Checks and Analysis
• Collaborate with IT specialists and our core analysis team and our Data leads to improve data quality and ensure data integrity.
• Find opportunities for automation and process improvement across reporting workflows.

Stakeholder Engagement

• Work closely with Risk, Finance, and business teams to understand reporting needs and deliver actionable insights.
• Present findings and recommendations to Leadership and Business.
• Delivery of internal and external audit and assurance reviews when required, ensure all process have clear documentation and data traceability.

We're investing billions in our people, places and tech to change the way we meet the needs of our 28 million customers. We're growing, and we'd love you to be part of the journey.

What we're looking for?

• Strong finance background and experience required, with a Fully accredited Finance qualification (ACCA/CIMA/ACA/ICAS).
• Minimum 1 year of post qualified experience, preferably with experience in applying and understanding RWA rules and calculations, including interpreting PRA frameworks (such as UK CRR/Basel 3.1, EMIR) across Credit Risk, Securitisations, and Counterparty Credit Risk, or at least 1 year post qualified experience in Accountancy or Audit, applying statutory accounting standards such as IFRS.
• Background experience in Financial Services or trained with a large accountancy practice is advantageous.
• Data Analytics: Proficient in excel for data manipulation, analysis, and automation.
• Hands-on experience with SQL and/or Python, or a clear enthusiasm for learning and building capability in these tools.
• Visualisation: Power BI skills for dashboard creation and MI delivery.
• Data Management: Experience with SQL, data warehousing, and ETL processes.

This is a place for you:

Our ambition is to be the leading UK business for diversity, equity and inclusion supporting our customers, colleagues and communities, and we're committed to creating an environment in which everyone can thrive, learn and develop.

We were one of the first major organisations to set goals on diversity in senior roles, create a menopause health package, and a dedicated Working with Cancer Initiative.

We offer reasonable workplace adjustments for colleagues with disabilities, including flexibility in office attendance, location and working patterns. And, as a Disability Confident Leader, we guarantee interviews for a fair and proportionate number of applicants who meet the minimum criteria for the role with a disability, long-term health or neurodivergent condition through the Disability Confident Scheme.