MI Coordinator

DAC Beachcroft; Bristol; On-site; GBP 30,000 - 40,000; Full time

Job summary

A leading law firm is seeking an MI Coordinator in Bristol to support claims handlers by coordinating and delivering MI and BI returns, ensuring data accuracy, and assisting with client reporting. The ideal candidate will have advanced Excel skills, strong analytical abilities, and experience with BI tools like Power BI. This is a permanent position with opportunities for professional growth.

Qualifications

• High standard of data accuracy and attention to detail.
• Excellent relationship and client handling skills.
• Ability to work to deadlines and prioritise workload.
• Strong oral and written communication skills.
• High analytical skills to identify data relationships.
• Commitment to continuous improvement.

Responsibilities

• Compile MI report submissions to clients.
• Identify data errors prior to reporting.
• Support MI reconciliation and data integrity checks.
• Create data dashboards and visualisations.
• Assist with strategic projects and change management.

Skills

Data accuracy

Advanced Excel skills

Relationship management

Analytical skills

Communication skills

Continuous improvement mindset

Teamwork

SQL knowledge

Power BI skills

Tools

SQL

SSRS

Power BI

Case management system

Finance systems

Job description

MI Coordinator

Department: Professional and Commercial Risk

Employment Type: Permanent

Location: Bristol

Description

Reporting to the Business Process Manager, supporting Claims Handlers and Solicitors in meeting Client Management Information and Business Intelligence requirements. Co-ordinating and delivering required MI and BI returns.Working to meet agreed internal and external KPIs within the Insurance Sector.

Work with the MI and IT teams to ensure that systems and reports continue to be fit for purpose.Specifying any changes required through to live release and ongoing review.

Continually analyse data to highlight trends and insights to clients and to help improve business performance and data quality.Creating clear visualisations to communicate the trends and insights effectively.

The Team:

You will play an active role in the continued growth and success of the Professional & Commercial Risk and Global clusters both in the UK and internationally, supporting client partners to deliver market leading reporting and analysis to our Insurance clients.

Liaising with other clusters across the LLP and the wider firm which client requirements demand this.

Key Responsibilities

Role Responsibilities:

• Compiling MI report submissions to clients.
• Identifying any data errors and anomalies prior to reporting.
• Feeding back any data issues to the appropriate Supervisor or Client Relationship Partner to help ensure databases are maintained and kept up to date.
• Supporting MI reconciliation.
• Supporting the development of data capture screens and data integrity checks.
• Creating data dashboards, graphs and visualisations.
• Providing any MI related ad–hoc administrative services, as required.
• Supporting Client on boarding.
• Ad-Hoc Reporting, including: Complex MI production, KPI's, billing and general data analysis and data to support tender submissions and client queries.
• Analysing data to help improve business success and performance.
• Providing assistance to the Business Process Manager in strategic projects.
• Providing assistance to the Business Process Manager in reviewing existing systems and processes for improvements - Including database functions and reporting.
• Assisting with the implementation of change management for continuous improvement and data quality: Liaising with technical and non-technical professionals, key stakeholders, clients and administrators to deal with requirements, compiling report request specifications and compiling change request specifications.
• Working closely with the IT department to ensure that the data collection and storage systems are secure and robust.
• Collaborating and supporting IT when migrating data into our databases.
• Supporting IT in maintaining our client portal.
• Providing regular support, guidance and training of the MI capture tool.

Skills, Knowledge & Expertise

Key Skills:

• High standard of data accuracy, attention to detail and IT skills including ability to create and maintain spreadsheets – Advanced Excel skills preferred.
• Excellent relationship and client handling skills. Able to deal confidently and professionally with senior internal clients on day to day issues.
• Able to work to deadlines, prioritise own workload and meet conflicting demands and seek guidance and input from others where appropriate.
• High standard of written and oral communication skills, as gathering, understanding and clarification of requirements is essential.
• Strong analytical skills, including the ability to identify data relationships and potential issues.
• Commitment to continuous improvement, with the tenacity and motivation to actively seek and implement more efficient business practices.
• Able to follow brand guidelines and firm standards to make sure that all outputs follow the correct design patterns.
• Team oriented and collegiate with a willingness to share knowledge with and support other members of the team.
• A high level of personal compliance with DAC Beachcroft Group protocols, business operations and procedures.
• Experience of database structures and data mapping preferred.
• Experience of SQL and SSRS advantageous but not essential.
• Experience of using a case management system preferred but not essential.
• Experience of finance systems preferred.
• Familiarity with Business Intelligence tools – Power BI skills preferred.
• Any legal industry or Insurance sector exposure would be an advantage.