Data Validation-Liquidity

<p>Job title: Data Validation</p> <p>&nbsp;</p> <p></p> <p>Role Purpose (overall high level summary of the role)</p> <p>Finance has mobilised the first phase of a five year programme to transform the Finance operating model by leveraging</p> <p>cloud technology. Finance Cloud Transformation will rationalise operational processes, automate data and report</p> <p>production, to deliver comprehensive data to our internal and external stakeholders for analysis and reporting. The</p> <p>programme will entail migration of core Finance data and processes to the cloud, with an initial phase to implement a</p> <p>standard global operating process for Finance actuals report production, followed closely by forecast data and report</p> <p>production. The vision for the Finance on the Cloud Programme is “to deliver standardised global processes that leverage</p> <p>a single dataset for reporting, analysis and forecasting.” Key programme outcomes are to deliver a singular automated</p> <p>data production processing capability for actuals and forecasting, correction of data once for all downstream calculations,</p> <p>reports and outputs, introducing automated preventative and detective controls, significantly reduce manual activity in the</p> <p>run-time actuals process to allow the production of all actuals outputs by working day 5 for a monthly process The Data</p> <p>Analyst will be expected to support the delivery of data related activities within the FotC programme. Various aspects may</p> <p>include data validation, solution functionality validation, data gap analysis, reconciliation, user tooling or automation</p> <p>testing activities.</p> <p>&nbsp;</p> <p>• The role holder will be responsible to functionally understand and test our liquidity core release requirements</p> <p>• He/ She is required to perform a detailed data validation to ensure the data reflects accurately across all liquidity returns</p> <p>for all applicable regulations - PRA/EBA/HKMA/US FED etc.</p> <p>• He/She needs to furnish UAT dashboards and walkthrough the Reporting Ops of the changes introduced by liquidity</p> <p>core release requirements</p> <p>• He/She is responsible to handle various queries raised by Reporting Ops and drive the UAT sign off discussions for a</p> <p>successful liquidity release implementation</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>Key accountabilities include:</p> <p>· Review Finance wide manual adjustments and EUC’s including recommending automated solutions in order to</p> <p>minimise operational risk and time</p> <p>· Presenting Validation dashboards to relevant stakeholders and provide status update on their data accuracy and</p> <p>completeness</p> <p>· Gather requirements from business users on data validations, reconciliations and data elements</p> <p>· Supporting FotC Data Lead in planning and tracking progress of data work stream</p> <p>· Supporting wider Finance data related initiatives, including resolution of upstream data initiatives, investigation and</p> <p>prioritisation of data issues, liaising with IT teams to support delivery of data sourcing changes</p> <p>· Working with DMU to resolve Global Data Quality issues and creating a Data Operating Model</p> <p>· Provide worldwide sites with effective communication of data issues in order for them to improve their data quality</p> <p>· Work closely with diverse Business and IT teams, to ensure test issues and defects are successfully resolved Be</p> <p>conversant with the principles of Finance data production and reporting, and understand the functions of relevant</p> <p>Business stakeholder areas</p> <p>· Facilitate issue resolution to ensure that the schedule of each work stream remains on track and that any issues are</p> <p>resolved through appropriate, agreed solutions</p> <p>· Perform Data Gap analysis and raise data sourcing requirements to relevant teams</p> <p>· Work with dynamic plans in a fast moving environment, continually assessing priorities and progress and adjusting</p> <p>course where necessary, being sure to maintain alignment with other programme work streams</p> <p>· Support the internal and external audit where required. Ensure the relevant controls are met.</p> <p>&nbsp;</p> <p>&nbsp;</p> <p></p> <p>Technical Skill Requirements</p> <p>&nbsp;</p> <p>· Exposure to Liquidity Risk reports – PRA LCR, PRA NSFR PRA110 and ILM</p> <p>· Able to understand regulations on liquidity risk and write requirements required for remediating adjustments</p> <p>· An understanding of the principles of Finance data and report</p> <p>· Proficient in interrogating databases via SQL queries</p> <p>· An understanding of systems delivery lifecycles and testing principles</p> <p>· Proficient in the use of test tools (such as Quality Centre) and test processes (e.g. defect management)</p> <p>· Be able to formulate test strategies and confident in running a successful test phase</p> <p>· An appreciation of systems and data architectures</p> <p>· Proficient in Microsoft Office applications (Word, Excel, Visio, PowerPoint, Project)</p> <p></p> <p></p>