Liquidity Reporting- data analyst

Job title: Data Validation Role Purpose (overall high level summary of the role) Finance has mobilised the first phase of a five year programme to transform the Finance operating model by leveraging cloud technology. Finance Cloud Transformation will rationalise operational processes, automate data and report production, to deliver comprehensive data to our internal and external stakeholders for analysis and reporting. The programme will entail migration of core Finance data and processes to the cloud, with an initial phase to implement a standard global operating process for Finance actuals report production, followed closely by forecast data and report production. The vision for the Finance on the Cloud Programme is “to deliver standardised global processes that leverage a single dataset for reporting, analysis and forecasting.” Key programme outcomes are to deliver a singular automated data production processing capability for actuals and forecasting, correction of data once for all downstream calculations, reports and outputs, introducing automated preventative and detective controls, significantly reduce manual activity in the run-time actuals process to allow the production of all actuals outputs by working day 5 for a monthly process The Data Analyst will be expected to support the delivery of data related activities within the FotC programme. Various aspects may include data validation, solution functionality validation, data gap analysis, reconciliation, user tooling or automation testing activities. • The role holder will be responsible to functionally understand and test our liquidity core release requirements • He/ She is required to perform a detailed data validation to ensure the data reflects accurately across all liquidity returns for all applicable regulations - PRA/EBA/HKMA/US FED etc. • He/She needs to furnish UAT dashboards and walkthrough the Reporting Ops of the changes introduced by liquidity core release requirements • He/She is

Role Description *** Technical Skills:** Exposure to Liquidity Risk reports – PRA LCR, PRA NSFR PRA110 and ILM Able to understand regulations on liquidity risk and write requirements required for remediating adjustments An understanding of the principles of Finance data and report Proficient in interrogating databases via SQL queries An understanding of systems delivery lifecycles and testing principles Proficient in the use of test tools (such as Quality Centre) and test processes (e.g. defect management) Be able to formulate test strategies and confident in running a successful test phase An appreciation of systems and data architectures Proficient in Microsoft Office applications (Word, Excel, Visio, PowerPoint, Project) ** Personal & Professional Skills:** Educated to minimum of post graduate degree level or equivalent Personal Skill Requirements** Ability to professionally and effectively present information Proficiency in problem solving A self-starter with excellent written/verbal communication skills Desire and commitment to make a difference Experience Financial Services Test Experience across both internal reporting and regulatory requirements Experience in testing, driven by IT systems implementation or enhancement, across a large organisation Experience of working in a large banking organisation preferred The role holder will be responsible to functionally understand and test our liquidity core release requirements He/ She is required to perform a detailed data validation to ensure the data reflects accurately across all liquidity returns for all applicable regulations - PRA/EBA/HKMA/US FED etc. He/She needs to furnish UAT dashboards and walkthrough the Reporting Ops of the changes introduced by liquidity core release requirements He/She is responsible to handle various queries raised by Reporting Ops and drive the UAT sign off discussions for asuccessful liquidity release implementation *** Experience:** Financial Services Testing: Experience in tes

Job Title: Test Manager [Financial Services or Regulatory] About Us “Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount . With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery. WHY JOIN CAPCO? You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry. MAKE AN IMPACT Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services. #BEYOURSELFATWORK Capco has a tolerant, open culture that values diversity, inclusivity, and creativity. CAREER ADVANCEMENT With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands. DIVERSITY & INCLUSION We believe that diversity of people and perspective gives us a competitive advantage. Job Description: Job Title: Tester Location: India Role purpose Own and execute data-focused manual UAT, ensuring end-to-end processing integrity across UI, database layers, interfaces, and downstream operational reporting. Drive the transition of UAT management from Excel-based tracking to Jira, producing audit-ready evidence and clear release readiness recommendations. Key responsibilities · Perform strong SQL-driven data testing and reconciliation across multiple systems/sources, evidencing outcomes with repeatable queries and extracts. · Validate end-to-end processing using database reconcil

Job Title: Liquidity - BA Reporting Applying predefined regulatory rules and mappings to support regulatory submissions under guidance/supervision. Basic variance analysis and reconciliation activities Understanding and applying documented procedures for regulatory reporting. Regulatory impact assessments and benchmarking activities using predefined methodologies, with interpretation performed under supervision. Strong understanding of regulatory reporting frameworks (PRA, EBA, ECB, Basel, Liquidity, Capital, IRRBB) Solid grounding in finance, accounting, balance sheet & RWAs. Proven experience working in large, global financial institutions Documenting business and functional requirements.. Experience in project governance, RAID/status reporting, steerco delivery, and coordinating across BA/IT/testing workstreams. Exposure to controls frameworks, audit readiness, and issue remediation within regulatory reporting environments. Familiarity with collateral management, intraday liquidity, or supply chain management reporting domains. Experience with reporting remediation, communications delivery, or governance within regulatory change programmes Desirable: Provides subject matter expertise and judgement to assess and resolve complex, ambiguous, or emerging regulatory reporting requirements (e.g. PRA, ECB), where established procedures or precedents may not exist

This role sits as part of a first line compliance function to ensure that functionality, processes and reporting outputs built for Reporting Ops meet the regulatory criteria as documented by the relevant regulatory instructions, regulations and policies. This role will involve close liaison with both Finance Change colleagues as well as colleagues in Reporting Operations interacting with the Reporting Owner for the Liquidity Regulatory Reports. Role Profile and Description of Responsibility Build and lead a BAU compliance function to ensure that the Regulatory Reporting functionality built and released quarterly under various change epics delivered by Finance Change comply with the reporting requirements as detailed under the Reporting Instructions and Reporting Regulations from the local or group regulator, as well as any additional Policy Interpretations provided by Group Reg. Policy or local policy representatives. The role will involve close liaison with the Product Owner for Liquidity Reporting in identifying the epics delivered in the previous release to be tested for compliance; documenting the test cases required for compliance testing by reference to required instructions, regulations and policy; managing test execution by a small team of dedicated testers; analyse test results for compliance with the testers; flag any items which require further investigation; identify any cases of non-compliance back to stakeholders including Reporting Ops and Report Owners; provide rapid feedback to the build team in cases of re-build required for compliance. Required Skill Set Deep subject matter knowledge and expertise in liquidity reporting constructs (for example LCR, NSFR, Maturity Ladders, etc). Knowledge of core regulatory requirements including reporting instructions, regulations (for example CRR), and internal policies for liquidity reporting Documentation capability to document test cases for testing whether delivered build output complies with reg & policy

Role purpose This role is within the Design capability for Finance on the cloud under Transformation Family. Requirement Analysis & Design team is a team formed under change delivery and this role is expected to support Finance in the cloud design & implementation work India. The team consist of 30-40 Business analysts who are Design business analyst with techno-functional skills and subject matter experts in Liquidity reporting/ ALCM domain. There are quarterly/monthly releases planned for the current production system and the Requirement & design team is involved in requirement analysis, functional solution design, requirements translation into deliverables, delivery tracking during the release and support the program/project manager. Governance and Committee Memberships NA Principal Accountabilities and Responsibilities The principal responsibility of the Business Analysis job category is to manage and execute analysis activity for one or more projects, programmes of Liquidity Reporting. The role holder may be in a variety of areas of HSBC, they may be in projects as well as in established BAU teams. It is possible that the Business Analyst will work on multiple projects, programmes or value streams simultaneously. Primary responsibilities & accountability includes the following- · Lead cloud requirements (L1 & L2- Mandatory regulatory requirement, system enhancements, output requirements) · Work on finding the optimal design solution of the requirements by interacting with different stakeholders. · Ensuring all the requisite project documents (functional designs, L2 solution, technical design, etc) are prepared & maintained. · Involved in the various stages of Change Delivery cycle (design, testing, implementation). · Engage with stakeholders to en