Description
Senior MI Analyst - SQL, Excel, RISK, SAP HR, Business Objects, Web Intelligence
Role overview
The Structural Reform Programme is working on the Bank's response to the global regulatory bodies requirements to segregate the Front Office elements so that the failure of one will not mean the failure of all. This is essentially means that the business elements will be split in separate Legal Entities. From an HR point of view this means that all employees and the associated non permanent workforce will need to be aligned to the correct entity. The planning, implementation, and support of this work requires a significant amount of data. This role will be central in the supply, review and presentation of this data. The role will be associated and report into the HRMI team to take advantage of the existing knowledge and data
- In conjunction with the project lead and the HR MI lead ensure high quality and timely delivery of the projects HR Data requirements.
- Lead the SRP MI Analyst team.
- Maintain project plan for the MI elements of the project, track, action escalate the Risk Assumptions, Issues and Dependencies (RAID) for the project.
- Engage with the senior stakeholders to understand all elements of the projects and how the team can add value. Support the team with stakeholder conversations.
- Recognised as a SME in their own area of specialist expertise and knowledge of others
- Takes the lead and co-ordinates the team delivery preventing duplication of tasks and efficiency of operation.
- Liaise with the HRMI team leads to make most effective use of the existing resources and processes.
Key Accountabilities
- Illicit data requirements from stakeholders at all levels and document requirements.
- Discuss and agree the criteria/approach for identifying populations
- Engage with the relevant stakeholders to understand data rules to identify populations.
- Extraction, analysis and presentation of information using the HRMI tools both Strategic (MyHR Dashboard/MyHR Toolkit) and Legacy (SQL server/SAP Adhoc).
- Ability to use a available tools (excel, access or SQL Server) to create data models to support organisation wide iterative scenario modelling.
- Maintain these models and feedback data integrity issues to the relevant stakeholders for resolution in the source systems.
- Provide subject mater expertise to the wider project regarding HR data related questions
- Utilise the wider bank tools to identify associated population costs and lead due diligence pilots
Essential
- MS Excel (Minimum of Intermediate Level) including: Pivot Tables, Look-Ups, Graphs & Charts, Functions and Formulae
- Knowledge of Business Objects Web Intelligence designer (knowledge of the latest version BO4 desirable)
- Knowledge of SAP HR or other human resources management system preferable, with experience of using the HR system extraction/reporting tools.
- Proven stakeholder management skills at all levels of an organisation
- Communication skills both written and oral. Confident in communicating and influencing at all levels. The role will require developing an excellent good working relationship with HR Business Partners, HR Specialists, and Technology partners at all levels, therefore, experience in stakeholder management would be helpful
- Ability to build SQL queries in tools for Data Analysis/Datamodelling
- Understanding of database structures (tables, views, joins)
- High degree of accuracy and attention to detail
- Presentation skills are critical