MI Analyst

Job Type:

Permanent

Build a brilliant future with Hiscox
 

Position: MI Analyst

Reporting to: Senior MI Analyst

The role

As an MI Analyst you’ll play a crucial role in the MI team, focusing on writing complex SQL queries to interrogate both a conformed reporting database as well as raw source databases. This role is essential for providing accurate and timely data analysis to identify and support system and process defects, ensuring both the business and customers are well-supported.

Key Responsibilities:

• Develop and maintain complex SQL queries to extract and analyse data from various databases.

• Interrogate reporting databases and source databases to identify and impact assess system and process defects.

• Provide insights and data-driven recommendations to support process improvements.

• Compile daily, weekly, and monthly reports highlighting system and process defects for operational leaders.

• Develop accurate data models to aid in defect analysis and resolution.

• Identify and analyse trends and patterns in defects to help with business planning and risk mitigation.

• Work closely with IT and other business partners to design and provide reports from new systems.

Communication:

• Develop strong relationships and work closely with teams across the business.

• Present findings to both technical and non-technical audiences, emphasising the impact of defects on business and customer support.

Our must haves:

• Proficiency in writing complex SQL queries.

• Intermediate Excel knowledge (vlookup, sumifs, tables, pivot tables, etc.).

• Experience in creating reports and documents to support multiple people/processes.

• A passion for building a career in data.

• Willingness and ability to learn technical disciplines in both traditional and practical settings.

Our nice to haves:

• Experience with data visualization tools such as Power BI.

• Knowledge of database management and data warehousing concepts.

• Strong analytical and problem-solving skills.

• Excellent communication and interpersonal skills.

Diversity and flexible working at Hiscox 

At Hiscox we care about our people. We hire the best people for the job and we’re committed to diversity and creating a truly inclusive culture, which we believe drives success.
We have also learned over the past few years that working life doesn’t always have to be in the office, and now it is safe to do so we have introduced hybrid working to encourage a healthy work life balance.

We anticipate the successful candidate for this role will be in the office 2 days per week hybrid.

This hybrid working model is set by the team rather than the business to enable you to manage your own personal work-life balance. We see it as the best of both worlds; structure and sociability on one hand, and independence and flexibility on the other.

#LI-LP1

#LI-Hybrid

Work with amazing people and be part of a unique culture