MI Analyst

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

Job summary

A leading MGA organization in the United Kingdom is seeking an Entry-level MI Analyst to support growth through comprehensive MI and reporting. This role involves producing performance reports, developing SQL queries, and utilizing Power BI for self-service reporting. The ideal candidate should have strong analytical skills and knowledge of the general insurance market. Full-time employment with opportunities in a diverse and inclusive environment is offered.

Qualifications

• Power BI development experience is required.
• Experience with the Microsoft BI stack including SSRS and SSIS is necessary.
• Knowledge of insurance terms like Gross Written Premium is essential.

Responsibilities

• Produce reports summarizing office and branch performance.
• Analyze data and make performance recommendations.
• Develop key transactional reports using SSRS.

Skills

Power BI Experience

MS BI Stack Knowledge

Advanced Excel Skills

Knowledge of General Insurance Market

Data Analysis Skills

Education

Minimum 5 GCSEs (A–C) or equivalent

Tools

SQL

SSRS

ETL Solutions

Job description

Direct message the job poster from Geo Underwriting

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

• 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 GCSEs (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.

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.

Seniority level

Entry level

Employment type

Full‑time

Job function

Information Technology

Industries

Insurance