Data Validation-Liquidity

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 responsible to handle various queries raised by Reporting Ops and drive the UAT sign off discussions for a successful liquidity release implementation

Key accountabilities include:

• Review Finance wide manual adjustments and EUC’s including recommending automated solutions in order to minimise operational risk and time

• Presenting Validation dashboards to relevant stakeholders and provide status update on their data accuracy and completeness

• Gather requirements from business users on data validations, reconciliations and data elements

• Supporting FotC Data Lead in planning and tracking progress of data work stream

• Supporting wider Finance data related initiatives, including resolution of upstream data initiatives, investigation and prioritisation of data issues, liaising with IT teams to support delivery of data sourcing changes

• Working with DMU to resolve Global Data Quality issues and creating a Data Operating Model

• Provide worldwide sites with effective communication of data issues in order for them to improve their data quality

• Work closely with diverse Business and IT teams, to ensure test issues and defects are successfully resolved Be conversant with the principles of Finance data production and reporting, and understand the functions of relevant Business stakeholder areas

• Facilitate issue resolution to ensure that the schedule of each work stream remains on track and that any issues are resolved through appropriate, agreed solutions

• Perform Data Gap analysis and raise data sourcing requirements to relevant teams

• Work with dynamic plans in a fast moving environment, continually assessing priorities and progress and adjusting course where necessary, being sure to maintain alignment with other programme work streams

• Support the internal and external audit where required. Ensure the relevant controls are met.

Technical Skill Requirements

• 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)