MI Analyst

Geo Underwriting; Remote; GBP 40,000 - 55,000; Full time

Job summary

A leading insurance firm is seeking a home-based MI Analyst to join their dynamic team. You will produce and analyze reports, develop ETL solutions, and create self-service dashboards using Power BI. Ideal candidates will have in-depth knowledge of the insurance market, advanced Excel skills, and experience with the Microsoft BI Stack. This role demands strong analytical skills, attention to detail, and the ability to communicate effectively with various stakeholders. Join a high-performing MI team and contribute to our growth.

Qualifications

• Develop self-service reporting apps through Power BI.
• Produce detailed reports summarizing business performance.
• Optimize SQL server queries for data retrieval.

Responsibilities

• Analyze individual business data and recommend performance improvements.
• Create ETL solutions to capture data from multiple sources.
• Manage queries from Senior Stakeholders and Power BI Licence Holders.

Skills

Power BI Experience

Microsoft BI Stack (SSRS, SSIS, Visual Studio)

Advanced Excel

Knowledge of general insurance market

Knowledge of insurance terms

Knowledge of insurance broker operations

Experience with MI Reporting and data analysis

Education

Minimum 5 GCSEs (A-C) or equivalent

Job description

We have an exciting opportunity for a home-based MI Analyst to join us within our MGA business. You will support our continued growth by providing comprehensive MI and Reporting and will ensure that all reporting aligns with our current strategies and future goals, playing a key role in our ongoing success.

What You Will Do As An MI Analyst

This is an overview and not an exhaustive list of responsibilities. Collaborating with your Line Manager, you will develop your own objectives but focus on all the following and more.

• Produce reports and analysis summarising the performance of offices, branches and regions.
• Analyse individual business data and make recommendations to improve performance.
• Creating ETL solutions to capture data from multiple sources and map / structure into either QVD files or SQL databases depending on the solution required.
• Optimize SQL server queries to efficiently and quickly retrieve data.
• Development of key transactional reports using SSRS, both data from the PAS and Data Warehouse.
• Creating self-service reporting apps through Power BI.
• Provide ongoing monthly reporting within a timely manner for exec pack production.
• Collate, manage and respond to queries from Senior Stakeholders and Power BI Licence Holders.
• Understand and be able to explain the reporting infrastructure used in the production of Power BI reporting and be able to apply this knowledge to arrive at the desired outcome.
• Interpret MI requirements and produce varying reports depending on the target end user.

What We Are Looking For In Our MI Analyst

• Power BI Experience at a development level
• Experience using the Microsoft BI Stack (SSRS, SSIS, Visual Studio)
• Advanced Excel and Reporting Capabilities
• Knowledge of the general insurance market and general insurance products
• Knowledge of the insurance terms and their meaning e.g. Gross Written Premium
• Knowledge of how an insurance broker operates
• Minimum 5 GSCE’S (A-C) or equivalent qualifications
• Experience with MI Reporting and data analysis

This is an opportunity for an individual who wants to be part of a highly skilled MI team with strong communication and presentation skills across all mediums and can tailor information to their audience. You will need to have excellent attention to detail with a focus on accuracy and quality whilst being able to work at a fast pace without compromising on quality.

#AIB #GEO

Everywhen is an equal opportunities employer, with a growing and thriving diversity, equity and inclusion strategy; we are committed to a working environment that is free from discrimination, is inclusive, and empowers our people to bring their whole self to work and reach their full potential.

If your application is successful, we will conduct relevant employment checks prior to you commencing employment with us. These will include verifying your recent employment, address, credit history and a standard criminal record check.

Please note : We may close a vacancy prior to the publish end date if the required quality or number of applications has been received.

Note to recruiters and employment agencies : We will not pay for unsolicited CVs from recruiters and employment agencies unless we have a signed agreement and have requested assistance, in writing, for a specific opening.