Administrator, Static Data and STP

Job Description

OverviewThe purpose of this role is to provide key support for the start of day , intra-day and end of day processes that are critical to the successful running of the Treasury Operations Functions. This is to include the upload and download of internal and externalsystem files and the monitoring of applications to ensure they have loaded/run successfully as well as interacting with our banking partners to ensure the correct opening of client bank accountsKey Accountabilities and Main Responsibilities

• Support existing Access Databases ensuring the code/data integrity are maintained to ensure the solutions are performing as required
• Support various Excel Spreadsheets and VBA Macros (functions, pivot tables, charts)
• Support Fiserv Accurate Reconciliation Software ensuring that the solution performs to the highest standards:-
• Creating/Amending existing match rules, data feeds and validation rules
• Support Xceptor Data Hub processes to aid the automation of processes
• Support SharePoint solutions
• Support Crystal Report outputs
• Create/Amend reports from Accurate via Crystal Reports
• Automate reports via Business Objects
• Support the Static Data Team by regularly assisting in the BAU/Start of Day/End of Day processes to ensure that the system are streamlined and accurate.
• Ensure the opening and closing of client bank accounts is actioned correctly based on instruction and product type
• Show a high level of risk awareness
• Provide assistance where required on all ad hoc business requests and projects

Experience & Personal AttributesEssential

• Microsoft Office 2010+
• Intermediate or Above in MS Excel VBA
• Writing Macros, Advanced Formulas, Pivot Tables
• Desirable
• Crystal Reports/Business Objects
• Report Builder 3.0/SSRS
• SQL Server 2008/MYSQL
• SharePoint 2010+
• InfoPath Forms
• SharePoint Designer
• Good level of IT Skills (Inc. Excel & MS office package)
• Excellent communication skills
• Attention to detail
• Highly numerate
• Flexible to meet the demands of team working