Reporting Analyst

£55000 - £65000 per annum



Role Purpose

  • The GBM Europe MI & Planning function engages closely with the GB&M businesses and sites in Europe, as well as cross functionally to provide meaningful analysis to senior management. The team is responsible for delivering monthly business performance (Flash and Actuals) for Europe, quarterly reporting including the disclosure, the Stress Testing program for GBM Europe, planning and forecasting cycles and all reporting/planning/modelling requirements in readiness for the creation of the Non-Ring-Fenced Bank (NRFB) and Brexit.

Key Accountabilities

  • The responsibilities of the role are very broad in scope involving supporting the GBM Europe Business Performance Manager to successfully deliver the following:

  • WD3/4 Flash
  • timely agreement between LOB’s and the site submissions to enable delivery of the Flash on WD4
  • prepare the cost estimate ensuring we have a robust estimate with minimal (<$5m) variation in the Actuals vs Flash for costs especially direct costs; ensure we understand the month on month drivers of cost movement
  • support in preparation of Flash materials which are 100% aligned to Global outputs for the same process; ensure crisp and commercial messaging
  • WD6 Actuals submissions by GBM Europe sites
  • Analysis to demonstrate LOB’s are in agreement with the outputs from UK Clearview for both P&L and BS
  • Actual vs Flash variances for the P&L are fully analysed and explained
  • Work closely with UK Financial Control to deliver analysis on Other GBM Revenue – to cleanse this on a monthly basis so that we minimise Other Other category
  • Support in the preparation of the Actuals (EMR) pack for GBM Europe aligned to Global output but which also delivers region specific requirement for example more detailed walks on revenue and costs (ensuring messaging is crisp and commercial)
  • Analysis to demonstrate the LOB’s agree with L&A and Deposits split by business (and work with UK Financial Control to raise journals for correction where necessary)
  • Support business performance manager on requirements to cleanse RWAs for entity 3607 by business and resolve the Other category plug which currently is being reported within GBM overall entity RWAs for the UK
  • Support in the preparation of RoTE reporting pack for GBM Europe aligned to Global output; ensuring we understand all the components including P&L adjustments and underlying Tangible equity and the tangible equity allocation on RWAs
  • Quarterly external reporting requirements
  • work closely with HBEU External reporting on GBM commentary ensuring this is consistent with our understanding of the business results
  • deliverables to Group/HBEU finance provided on a timely basis e.g. Chairman’s Schedules, and backup supporting the disclosures
  • RWA reporting requirements for GBM Europe
  • Monthly analysis working closely with LOB’s on LOB RWAs to understand drivers by business & entity
  • Monthly Reporting
  • Europe (EMR pack) walk
  • Risk Appetite Statement reporting
  • BSRC/ALCO RWA walk
  • RWA Forecast analysis to explain gaps in the forecast to AOP
  • Supervise, develop and provide feedback on the performance of the offshore team

Knowledge and Experience

  • ACA/CIMA or similar qualification
  • Strong financial services knowledge, including Markets and Investment Banking products
  • Experience in financial control would be an advantage
  • Thorough understanding of TM1 and strong Excel skills
  • Strong analytical and problem solving ability
  • Strong interpersonal and negotiating skills
  • Ability to build excellent relationships with stakeholders
  • Strong verbal and written communication skills
  • Ability to deliver change and process improvement
McGregor Boyall is an equal opportunity employer and do not discriminate based on race, religion, gender, age, sexuality, gender identification, or physical ability.
  • SSRS Developer
    £450 - £500 per day

    SSRS Developer

    Our client, a Tier 1 investment banking group is seeking an experienced SSRS Developer to join the team based in the London.

    Main duties and purpose of the role:

    • To analyse user requirements and produce detailed functional and technical designs.
    • To work closely with users to develop reports
    • Work within the development framework, making use of existing components and practices where available.
    • Ensure the quality of solutions with appropriate unit and system testing.
    • To adhere to agreed standards of development and release/deployment.
    • Support users as required.

    Preferred experiences:

    • Excellent SQL Server 2012, TSQL and Stored Procedure Development Experience
    • 2012 SSRS Reporting Services Development Experience
    • Distribution of reports via subscriptions
    • Performance Tuning of database stored procedures

    McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.

  • Lawyer - Commerical

    We have an exciting new opportunity with a financial services securities firm, who are looking for a Lawyer to join them covering commercial and IT matters. It is a permanent position based in London.

    The role is looking for a NQ – 2 years PQE lawyer who is looking for a varied and challenging role. The role will additionally focus on data protection to assist the organisation with its compliance and GDPR policy.

    A candidate will ideally have some financial service, regulatory or data protection experience however this is not a requirement as they will provide training and support.


    • Qualified lawyer (NQ – 2 years PQE)
    • Ideally previously experience in financial services however this is not necessary.
    • Ideally experience working as a regulatory/commercial lawyer either in-house or private practice, or knowledge of regulatory law
    • Excellent written and oral communication, with good organisation skills
    • Strong academics from a leading university

    McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.

  • Collaboration Specialist - AV / Cisco Video Conferencing / #

    Communication Collaboration Specialist - AV / Cisco Video Conferencing - Crestron API's - #Programming

    Permanent - Excellent package

    Global financial services client is looking for a Collaboration Specialist to who will be the key technical engineer supporting Audio Visual and Video conferencing within the organisation. You should have demonstrable experience of working in a large global organisation and have specific support and implementation experience.

    Key Responsibilities:

    • Leading the video conference estate
    • Enhancements to that estate
    • Integration of different AV and video systems through the use of modern APIs
    • Capacity planning and the management and monitoring of the estate

    Key skills required:

    • Crestron APIs especially Simple# programming
    • Cisco video conferencing equipment and systems – Codecs, TMS, CMS, CUCM and Expressway servers
    • Polycom video conferencing equipment and systems – Codecs, DMA, RMX and RPAD servers
    • Call routing, call admission control, management and capacity planning
    • Common video conferencing protocols such as SIP and h.323
    • Immersive telepresence systems
    • API based control on codecs and systems
    • Interoperability between room and desktop video systems
    • Crestron room control systems
    • Crestron Fusion device management
    • Network and systems management experience
    • IPTV systems

    If this is of interest and you have the required skills, please submit your CV over for immediate consideration.

    McGregor Boyall is an equal opportunity employer and do not discriminate on any grounds.