Job Details

Click here to become a registered jobseeker.

Data Analyst (Insurance)

City, London, United Kingdom, £ £ 35000.00-40000.00 Annual Annual, Permanent


Manage monthly load processes to ensure the delivery of accurate and timely data to key stakeholders
Support the collection and maintenance of pricing/reserving data
Support exposure and accumulation control methodologies. Download, refresh, query and integrate third party peril data sets
Provide support to underwriting teams on data queries and enhancements. Recommend initiatives to enhance underwriting profitability. Measure impact of underwriting actions, rate change, renewal retention, new and lost business
Provide support to team members when SQL expertise is required
Develop/maintain ETL (SSIS) packages to load data into SQL databases to ensure the delivery of accurate, clean data to key stakeholders
Recommend initiatives to enhance and streamline existing processes
Ensure accuracy, timeliness, reporting and documented procedure for workflow management
Keep abreast of industry initiatives, new visualisation methods and best practice
Develop/enhance new/existing dashboards using PowerBI platform or similar
Optimise database integrity, scalability and security
Ensure data quality is to the highest standard, reconciled and fit for purpose
Identify opportunities that can improve efficiency of business processesTechnical Knowledge

Experience SSIS (essential).
Strong competence working with SQL Server databases.
Strong T-SQL skills (DMDL, DDL, use of system and inbuilt T-SQL functions, UDF, Stored Procedures, variables)
Good knowledge of MS Office especially Excel.
Knowledge around PowerBI Reporting tool (would be advantageous).
Competence developing data models and semantic layers to support analytics.
Ability to translate business requirements into practical solutions
Able to communicate effectively with key stakeholders
Strong analytical and problem solving skills
Ability to manage large data sets

Job Details

Not Specified
City, London, United Kingdom
£ £ 35000.00-40000.00 Annual Annual