Financial Systems and MI Analyst

IQUW Property Insurance; City Of London; On-site; GBP 40,000 - 65,000; Full time

Job summary

A leading insurance company seeks an analytical professional to provide reporting support and data analysis for various business needs. The position involves collaboration with finance, marketing, and underwriting teams to develop insights that drive strategic decision-making. The ideal candidate will have strong skills in Excel, SQL, and Power BI, with a proven track record in analysis within the insurance industry.

Benefits

Competitive Benchmarked Salary

25 days holiday

Discretionary bonus scheme

Employee assistance programme

Annual holiday buy (up to 3 extra days)

Salary sacrifice benefits

Annual benefits reviews

Professional qualifications and study support

Qualifications

• Experience in insurance methods and trading.
• Strong experience with data analysis and strategic decision-making.
• Knowledge of regulatory and compliance provisions in insurance.

Responsibilities

• Develop reports for financial and business needs.
• Collaborate with Finance and Marketing teams for performance analysis.
• Support in-depth financial analysis and forecasting.

Skills

Excel

SQL

Power BI

Data analysis

Financial analysis

Tools

IBM Planning Analytics (TM1)

Dataiku

Microsoft Office

Job description

Overview

The role

The role provides front-line analytical and reporting support to Syndicates 218 and 1856, as well as to the Financial Planning and Analytics team, focusing on decision support, report development, and data analysis. It involves daily collaboration with Underwriters and Product Managers across Syndicate 218, advancing reporting outputs and actionable insights. The position supports the creation of self-serve dashboards and reporting solutions for various business functions, ensuring consistent access to key metrics.

It also covers the production of scheduled, business-as-usual reports for Syndicate 218. A key part of the role includes partnering with the Sales & Marketing team to develop analysis that supports market performance and strategic targeting, while also engaging with Finance teams to enhance cross-functional reporting capabilities.

Key responsibilities

• Support Finance Business Partners and Financial Planning and Analytics team in the production and delivery of recurring senior management and Executive reporting together with specific granular business area reports (e.g., performance & exceptions packs).
• Support the wider Business MI team functions, particularly Finance Systems - Decision Support, working collaboratively with line management, to balance resource, demands and priorities accordingly.
• Design, develop and produce reports to meet Finance and business needs
• Gather relevant financial and operating information to support further in-depth analysis.
• Co-ordinate and collate responses from the business in support of commentary information and findings for report delivery.
• Identifying key trends and areas of opportunity highlighting them to business partners.
• Support requirements gathering and handle ad-hoc queries and in-depth financial and business analysis. Source and collate third party information.
• requirements.
• Support forecast and budget activity.
• Provide analysis and evidence to inform decisions.
  • Provide insight on strategic challenges and opportunities.
• Use of Excel, PowerPoint, Power BI, and limited SQL (if required).

The above duties and responsibilities are not an exhaustive list and you may be required to undertake any other reasonable duties compatible with your experience and competencies. This description may be varied from time to time to reflect changing business requirements.

Essential qualifications, skills and experience

• Experience and knowledge of Insurance methods of trading, industry operational practices and procedures.
• Understanding of data structures and experience of extracting and utilising data to drive key strategic decisions, including the production of insightful analysis.
• Appreciation of the industry and market legal, regulatory and compliance provisions and the broker channels to market.
• Strong Excel (to macro level).
• SQL language and knowledge of SQL databases
• Power BI

Preferred but not essential:

• IBM Planning Analytics (TM1)
• Python programming experience
• SSAS cube structured reporting
• MS Report Builder / Reporting Services

Microsoft Office products.

• Dataiku

Benefits

• Competitive Benchmarked Salary
• 25 days holiday
• Discretionary bonus scheme
• Employee assistance programme
• Annual holiday buy (up to 3 extra days)
• Salary sacrifice benefits
• Annual benefits reviews
• The option for professional qualifications and study support

Additional Information

A full job description can be seen here.