Insurance IT Data Analyst
IT Data Analyst - Sevenoaks
About The Company:
Specialist home and motor insurer committed to providing tailored products and solutions to those clients who may have difficulty finding what they need within the general market.
About The Role:
Have a granular understanding of all databases and their content to enable production of Tableau Dashboards, Crystal Reports and ad-hoc data extractions from Microsoft SQL Server and presentation in Microsoft Excel. This includes close liaison with the Data Analytics Team in the Underwriting Division to enhance the Group MI as a whole.
·Collect, interpret and analyse claims data to produce accurate high quality Management Information and business insights. Interpret trends and patterns in claims data to enable growth and quantitative increase predictions.
·Production and Maintenance of MI Dashboards using Tableau Desktop v10 and Tableau Server.
·Oversight, development and production of Weekly and Monthly MI Packs as well as the quarterly Client Update pack.
·Extraction of data for Ad-Hoc requests from Microsoft SQL Server using native SQL commands/functionality.
·Analysis of Claims Data to produce trend analysis and predicted growth triangulations.
·Project lead MI performance analysis.
·Liaison with Underwriting Data Analysts to enhance overall Group MI.
·Liaise with External Suppliers to acquire relevant data for MI Production.
·Maintenance and migration of existing Crystal Reports.
·Contribute to Continual Improvement within the IT Department and Company
Essential Skills Required:
·Prior experience of Data Analytics, production and presentation of resultant data and findings using Tableau Desktop and Server products.
·Ability to use Microsoft SQL Server native language to extract data where appropriate.
·Sufficient experience Microsoft SQL Management Studio to be able to retrieve data using T-SQL statements, produce SQL Views and database/table design.
·Extensive knowledge and experience of using Microsoft Excel.
·Attention to details with high level of numeracy and literacy competence to ensure all data/MI produced is accurate and of sound integrity.
·Strong interpersonal skills to be able to effectively understand requests for MI as well as report back findings.
·Insurance or specifically Claims related experience preferred.