Job Title: / MI Lead / Line Manager / Management Information Delivery Director
Business Unit: / Information Technology / Location / Bournemouth / Direct Reports:
JOB PURPOSE
The MI Lead is to assist with daily reporting, development of new reports and data extraction processes whilst implementing and supporting solutions.
KEY ACCOUNTABILITIES/DELIVERABLES(please complete)
- Work across all stages of BI project work (requirements and logical design, physical design, implementation, testing and deployment).
- Data gathering, research and analysis so as to develop insightful conclusions and generate solutions to address user needs
- Create written communication materials that effectively summarize findings and support recommendations
- Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
- Assessing, monitoring, troubleshooting, maintaining and enhancing existing reporting structures
- Providing data extracts to support all business areas. Involving analysis, data mapping, documentation, and crucially, the building, testing and deployment of SQL scripts
- Analysing, developing & maintenance of data cleansing (ETL) routines to ensure that data is consistent, valid and processed according to business requirements
- Designing and building reports from user requirements
- Creating and maintaining Information System documentation
- Maintaining and carrying out routine data maintenance activities on a number of MS SQL Server and other systems
- Providing technical support for existing databases, Management Information Systems and any other reporting structures required by the business
- Working with developers to test and implement changes to corporate Management Information System
Carry out duties following internal policies and procedures in accordance with applicable laws, rules, regulations, good governance and Gallagher’s shared values, in particular, putting clients at the heart of our business.
Carry out duties following internal policies and procedures in accordance with applicable laws, rules, regulation, good governance and Gallagher’s shared values, in particular, putting clients at the heart of our business.
Take all reasonable steps to ensure the part of the business for which you are accountable for demonstrably complies with applicable laws, rules, regulation, good governance and Gallagher’s shared values, in particular, putting clients at the heart of our business. If shortcomings are identified take responsibility for remedial action planning, and action in conjunction with the relevant experts within the firm.
PERSON SPECIFICATION(please complete)
Qualifications
A detailed and organised individual who is able to analyse and challenge data and information supplied to them. You will need to demonstrate good communication skills in order to deal with all levels of the business and experience in insurance and call centre data would be advantageous.
Technical knowledge and understanding(please complete)
Desirable Competencies:
- Experience of the General Insurance sector
- Hands-on exposure to MySQL
Experience(please complete)
- At least 3 years’ experience of data analysis using SQL in an RDBMS environment
- Fully competent in writing complex procedural SQL
- Formal experience using MS SQL Server 2000/2005
- DTS package design
- Job scheduling
- SQL Server Reporting Services
- Advanced MS Access skills
- Complex queries
- Reports
- VBA
- Integration with SQL Server, Excel
- Building Forms and Small Business Solutions
- Experience in data manipulation, interpretation and analysis
- Excellent communication skills with assertive and questioning approach
- Excellent and proven analytical and problem solving skills
Behavioural Competencies
AJG Competencies / please tick all relevant competencies
Client Excellence
- Understands the client
- Conflict management
Innovation & Resourcefulness
- Innovation
- Drive for results
Teamwork & Interpersonal Skills
- Managing teams
- Communication
Expertise
- Business Acumen
- Functional Excellence
Integrity
- Integrity and trust
Leadership
- Vision and strategy
- Change management
- Develops talent
Other
The MI Lead must have a willingness to travel as you will be responsible for at least Three UK sites.
HR Use Only
Job Code
Job Architecture Title
Benefits Band
Level