Assistant Vice President, Regulatory Reporting Support Analyst - London, United Kingdom - MUFG Securities EMEA plc

Description

Assistant Vice President, Regulatory Reporting Support Analyst page is loaded Assistant Vice President, Regulatory Reporting Support Analyst
Apply locations London time type Full time posted on Posted 7 Days Ago job requisition id WD Do you want your voice heard and your actions to count?
Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 7th largest financial group in the world. Across the globe, we're 160,000 colleagues, striving to make a difference for every client, organization, and community we serve.

We stand for our values, building long-term relationships, serving society, and fostering shared and sustainable growth for a better world.

With a vision to be the world's most trusted financial group, it's part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility.

This means investing in talent, technologies, and tools that empower you to own your career.
360 years of heritage. It's no surprise that MUFG has grown to become one of the top five banks in the world. Our services include commercial banking, trust banking, securities, credit cards, consumer finance, asset management, and leasing. MUFG offers stability in an ever-changing market, providing services to high-profile clients worldwide.
To become the world's most trusted financial group. You'll help us achieve it.
Please visit our website for more information - mufgemea.

Finance Technology resides within Middle Office, Risk & Back Office Technology which is responsible for providing support and development for MUFG Securities and MUFG Bank EMEA.

Corporate Technology's Finance-IT team is involved with the development and support of the bank's Capital Management and Liquidity risk systems.

MUFG Securities is regulated by the PRA and the EBA and as the regulatory environment continually evolves the bank requires a skilled developer to assist with support, testing and enhancements to the main regulatory platform, Moody's Risk Authority (RAY).

As a regulatory reporting support analyst you will be instrumental in delivering functionality around Capital and Liquidity reporting using the Moody's Risk Authority (Moody's RAY) application.

This role requires a skilled developer with regulatory reporting experience who can undertake day-to-day support and technical development activities on an Oracle database servicing a number of regulatory reporting regimes including Capital, Liquidity and Stress Reporting

This role is a 'hands-on' role involving ensuring Capital Adequacy reporting [CoREP], Liquidity Risk reporting [LCR], [ALMM], [NSFR] and [PRA110], and Financial Reports [FINREP] are accurately processed by the IT systems and meet the SLA schedules and accuracy expected by the business.

You will work directly with the front line business community, other technical developers and business analysts helping to ensure that reporting questions are answered, that the reports adhere to the regulation, work on new requirements and enhancements as well as opportunities longer term projects pipelines.

Develop efficient ETL routines using stored procedures and external tables to load the bank's data into the Moody's RAY datamart
Build batch processes using schedule software such as Control-M
Provide support on the overnight batch and develop enhancements and improve efficiency where required.
Collaborate with Business Analysts helping to define the solution, testing strategies and ensuring technical requirements have been incorporated into Functional Design Documents
Work as part of the Finance Technology team providing day-to-day support of the Moody's Risk Authority investigating issues and resolving defects in a timely manner
Work closely with the Regulatory Reporting team, Finance and Treasury to help answer adhoc queries/questions

Have experience around regulatory reporting, BASEL III / IV regulation and appreciate components such as Liquidity Coverage Ratio, Counterparty Credit Risk, ALMM, PRA110 etc.

Work closely with IT team on technical specifications & delivering software to the business. Carry out testing running end of day processing in Moody's Risk Authority to produce regulatory reports and work closely with end users in interpreting and validating test results
Ensure change is compliant with strict change control policies and system changes are subjected to rigorous testing
Work with the wider Technology support teams and ensure best practices are followed in design and architecture
Help define test strategy and undertake unit and systems integration testing. Assist UAT testing and helping the user base to complete their tests and provide any summary or management KPI's
Test functionality using Moody's RAY software and Control-M ensuring due diligence has been carried out prior to engaging user acceptance testing
Work with BaU teams to ensure project changes are released to live in a co-ordinated manner
Provide a level of post live support and remediate changes
You will be working within Technology working alongside a number of IT teams and supporting the application. Worked with Oracle databases and be considered an expert in this field
A strong understanding of database languages including SQL*Plus & PL/SQL
Experience of working in investment banking with an understanding of trade and instrument data
In-depth knowledge of performance tuning Oracle database queries and processes
Prior experience working with Moody's Risk Authority (RAY) or Fermat is preferred but not essential.
Experience with other regulatory application software such as Axiom, Vermeg, Abacus 360 etc
Experience of working on scheduling software such as Control-M, Autosys, Tivoli etc
Manage enhancement requests through writing specifications for the technical development team
Test the software either through Systems Integration Testing or through working with the business on User Acceptance Testing. This includes all phases of the test cycle including writing test scripts, executing tests, capturing defects, re-testing etc...
Have experience working with interfaces, understanding the challenges around data flow, transformation, transportation, reconciliation etc...
Understand the project life cycle with a clear appreciation of scope and be adept at understanding the different approaches and methodologies used to deliver large scale change in manner which minimises business disruption
Understanding of the BASEL regulatory framework including COREP reporting and Liquidity reporting.
Have been involved with project implementations with a solid understanding of the project life cycle and different implementation techniques
Have experience working on test strategies, test plans, test scripts and documenting test cases used to ensure software is rigorously tested and fit for release to production

Previous knowledge and understanding of Moody's RAY platform which includes a basic understanding of the underlying database tables used in Capital and Liquidity reporting.

Previous experience of working on databases deployed in the Cloud
Excellent time management with strong organisational skills with the ability to prioritise tasks and manage a busy workload
A flexible approach to working tasks and hours
We are open to considering flexible working requests in line with organisational requirements.

MUFG is committed to embracing diversity and building an inclusive culture where all employees are valued, respected and their opinions count.

We support the principles of equality, diversity and inclusion in recruitment and employment, and oppose all forms of discrimination on the grounds of age, sex, gender, sexual orientation, disability, pregnancy and maternity, race, gender reassignment, religion or belief and marriage or civil partnership.

At MUFG, our colleagues are our greatest assets.