Insurance Business Intelligence Report Developer

Job Term:
South West, London
Legal IT/Systems
Salary Description:
Competitive Salary Offered
Job Ref:

The Role


The BI Report Developer will reside within IT and will be responsible for developing reporting to support the strategy and operations of the Insurance Group.

Working in partnership with Business Services teams and Legal Teams, you will be responsible for the design and build of quality reporting solutions for both internal and external clients.

The role requires a high degree of technical reporting capability and excellent communication skills to deliver the highest quality business solutions. The successful candidate will need to demonstrate a sound understanding of report design using Microsoft SSRS and T-SQL.

The successful applicant must have experience within a professional services environment. It is essential that the successful candidate possess excellent IT skills, particularly in Microsoft BI applications, SSRS, T-SQL and experience working with Insurance data is essential.


Purpose of the role

The primary purpose of the role is to support the Insurance Group through the production and maintenance of SSRS reporting solutions.  This role will assist in updating our current SSRS reports to utilise new features, developing additional reports and dashboards, and conducting ad-hoc data mining exercises.


Duties and Responsibilities:

•           Construct reports and use related SQL tools consistent with the objective of stated reporting or data analysis goals;

•           Create test cases for ensuring reports meet stated business objectives

•           Continually work on improving performance of queries and reports using industry standard methodologies for SQL generation and data analysis;

•           Recommend procedural improvements

•           Supports the development of reporting through the use of best-practice techniques

•           Successfully engages in multiple initiatives simultaneously

•           Responsible for the production and on-going maintenance of technical and functional report specifications.

•           Responsible for conformance with RPC brand and style templates

•           Validate reporting output to ensure accuracy and integrity of results

•           Work in conjunction with the Client Services/MID/IT teams to identify root cause problems affecting reporting outputs

•           Work with the Client Services team to establish requirements and design/delivery of next generation business facing financial reporting

•           Responsible for compliance with key business processes including change control, maintenance of issues, risks and decision logs

•           Provide ad-hoc modelling and analysis to support decision making


Essential Skills


•           SSRS Development experience including data-set design, visualisation, KPI's and Dashboards

•           Key experience with SQL Query development, SSRS report distribution

•           Experience utilising SQL Server to conduct data mining exercises

•           Design, build, and maintain complex reports and data

•           Develop SQL stored procedures, views and functions

•           Knowledge of sub-reports, writing complex formulas and conditional formatting

•           Experience creating financial reporting models and consolidation dashboards

•           Experience of large-scale data loads, unload, backup and recovery procedures

•           Ability to build accurate and efficient data sets and stored procedures

•           Previous experience with Insurance data schema is essential

•           Excellent organisation and time management skills

•           Works well under pressure and able to meet strict deadlines

•           Ability to work effectively as part of a team and work unsupervised, managing many tasks


Desirable Skills


•           Positive and flexible approach

•           Numerate with keen attention to detail

•           Highly IT literate with strong systems skills; SQL and Excel required

•           Knowledge of the Microsoft enterprise BI stack

Closing Date:

You may return to your current search results by clicking here.

Latest Job Listings