Liquidity Reporting- data analyst

Capco; India; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Capco is seeking a Liquidity reporting Compliance professional to support the LIQ_PBR data Analyst workstream. The role focuses on data discovery, documentation, and testing across upstream trading systems to downstream liquidity reporting platforms.

Key duties include data flow architecture collaboration, test case formulation, and resolving data quality issues, with collaboration across global Finance teams to ensure traceability, lineage and controls for liquidity data elements.

Qualifications

• Experience in finance-related projects is essential.
• Proficient in SQL queries and VBA.
• Strong requirements analysis and data analysis skills.
• Experience in Liquidity-related projects is essential.
• Ability to work with diverse stakeholders across regions.

Responsibilities

• Gather, clarify and manage business requirements, including data analysis on large datasets.
• Translate requirements into test cases and document data flows.
• Define design options that comply with Finance design principles.
• Execute functional and business testing and support User Acceptance Testing.
• Support data traceability and data quality remediation activities.
• Coordinate with upstream RTB teams and data providers.

Skills

SQL queries

VBA

Requirements analysis

Liquidity projects

Stakeholder management

Influencing skills

Communication skills

Problem solving

Job description

Job title: Liquidity reporting Compliance

Finance has mobilised a multi-year Integrity of Regulatory Reporting (IRR) programme to ensure that Regulatory

Reporting across the Group is fit for purpose; accurate, timely and complete. The IRR programme is responsible for

overseeing the design and implementation of a set of standards and control outcomes that will be consistently applied

across the end-to-end Regulatory Reporting Process. IRR will drive the interconnectivity across various strategic

transformation programs to ensure linkages and dependencies are well understood and aligned to the IRR standards and

control outcomes.

The Liquidity Product Based Review (LIQ_PBR) workstream is part of the overall data controls framework for Liquidity

Regulatory Reporting. Product Based Reviews enable Finance to develop key assurance that the end to end data flow for

Business Data Elements (“BDE’s”), from upstream Primary Booking Systems to downstream Reporting data warehouses

(including the Liquidity Reporting Finance Data Application / Platform) complies with the applicable group data standards

and controls (‘DMOV’ and ‘DUSE’), is complete and valid for the production of key Liquidity reports and metrics and that

data quality or completeness issues discovered through the PBR process are appropriately logged, reported, escalated and

managed to resolution.

The LIQ_PBR Data Analyst contributes to Global Finance, supporting data flow discovery and documentation, from

upstream primary trading and booking systems (PTS) to downstream Liquidity reporting platforms. The role holder will

support the Liquidity PBR workstream to undertake quantitative and qualitative data documentation, test case

formulation, data test execution and results tabulation, in order to provide the necessary assurance for management with

regards to the traceability, lineage, transformation and controls on Liquidity business data elements from source systems

to reporting. In this regards, the LIQ PBR data analyst will work with Liquidity SMEs to document BDEs that require to be

traced from upstream sources, liaise with upstream data source RTB teams to develop a data flow architecture for the

movement of data, further request sample transactional and other data to test the data per test cases developed to ensure

that transformation logic is per expectation, and present the results to management with appropriate follow through in

case of exceptions and non-expected findings. The LIQ_PBR data analyst will also document and test the data handling

and transformation controls applicable at stage of the data flow from source systems to downstream reporting platforms.

The Liquidity Business Analyst will:

• Apply approaches, tools and techniques for gathering, clarifying and managing business requirements, including data

analysis on large datasets

• Support colleagues to define, develop and translate requirements at specific stages of the project lifecycle, developing

an understanding of different types of requirements and how these translate into test cases

• Based on the data and requirements analysis & understanding, define the design options that will comply with Finance

design principles, contributing to building functionality into Finance target architecture

• Execute functional and business testing of requirements – and support the users through the User Acceptance Testing

phases

• Support data traceability projects
• Support Data quality remediation acitvities including upstream root cause analysis
• Support implementation phases (e.g. dress rehearsals / parallel runs)
• Day to day running of requirement management systems, change control and document standards.
• Work in alignment with the Change Framework.
• Stakeholder management
• Invest in training more junior members of the team
• Engage and establish good communications with upstream data provider systems (Run the bank) RTB teams in order

Finance has mobilised a multi-year Integrity of Regulatory Reporting (IRR) programme to ensure that Regulatory

Reporting across the Group is fit for purpose; accurate, timely and complete. The IRR programme is responsible for

overseeing the design and implementation of a set of standards and control outcomes that will be consistently applied

across the end-to-end Regulatory Reporting Process. IRR will drive the interconnectivity across various strategic

transformation programs to ensure linkages and dependencies are well understood and aligned to the IRR standards and

control outcomes.

The Liquidity Product Based Review (LIQ_PBR) workstream is part of the overall data controls framework for Liquidity

Regulatory Reporting. Product Based Reviews enable Finance to develop key assurance that the end to end data flow for

Business Data Elements (“BDE’s”), from upstream Primary Booking Systems to downstream Reporting data warehouses

(including the Liquidity Reporting Finance Data Application / Platform) complies with the applicable group data standards

and controls (‘DMOV’ and ‘DUSE’), is complete and valid for the production of key Liquidity reports and metrics and that

data quality or completeness issues discovered through the PBR process are appropriately logged, reported, escalated and

managed to resolution.

The LIQ_PBR Data Analyst contributes to Global Finance, supporting data flow discovery and documentation, from

upstream primary trading and booking systems (PTS) to downstream Liquidity reporting platforms. The role holder will

support the Liquidity PBR workstream to undertake quantitative and qualitative data documentation, test case

formulation, data test execution and results tabulation, in order to provide the necessary assurance for management with

regards to the traceability, lineage, transformation and controls on Liquidity business data elements from source systems

to reporting. In this regards, the LIQ PBR data analyst will work with Liquidity SMEs to document BDEs that require to be

traced from upstream sources, liaise with upstream data source RTB teams to develop a data flow architecture for the

movement of data, further request sample transactional and other data to test the data per test cases developed to ensure

that transformation logic is per expectation, and present the results to management with appropriate follow through in

case of exceptions and non-expected findings. The LIQ_PBR data analyst will also document and test the data handling

and transformation controls applicable at stage of the data flow from source systems to downstream reporting platforms.

The Liquidity Business Analyst will:

• Apply approaches, tools and techniques for gathering, clarifying and managing business requirements, including data

analysis on large datasets

• Support colleagues to define, develop and translate requirements at specific stages of the project lifecycle, developing

an understanding of different types of requirements and how these translate into test cases

• Based on the data and requirements analysis & understanding, define the design options that will comply with Finance

design principles, contributing to building functionality into Finance target architecture

• Execute functional and business testing of requirements – and support the users through the User Acceptance Testing

phases

• Support data traceability projects
• Support Data quality remediation acitvities including upstream root cause analysis
• Support implementation phases (e.g. dress rehearsals / parallel runs)
• Day to day running of requirement management systems, change control and document standards.
• Work in alignment with the Change Framework.
• Stakeholder management
• Invest in training more junior members of the team
• Engage and establish good communications with upstream data provider systems (Run the bank) RTB teams in order

Required Skills:

• Experience working in Finance-related projects essential
• Proficient in interrogating databases via SQL queries, VBA skills
• Excellent requirements analysis, functional design & data analysis skills
• Experience in Liquidity related projects is essential
• Experience of building relationships with a variety of stakeholders including technology/ technical
• Experience of supporting the development of business-facing material
• Excellent influencing, negotiating and interpersonal skills to all levels
• Strong written and oral communication skills
• Creative approach to problem solving and outcome-focused approach
• Ability to work effectively under pressure with competing and rapidly changing priorities
• The ability to work with diverse and geographically dispersed business teams
• A highly motivated and pro-active self-starter with a positive attitude
• Flexible worker who demonstrates adaptability
• Keeping calm under pressure is a must
• Ability to communicate at all levels and across countries/regions/cultures is essential
• Ability and willingness to get involved in analysis activities and documentation
• Good understanding of encumbrance logic and source&uses
• Exposure to Custodian statements to enable gathering custodian reconciliation data requirements