MI Analyst

CMS Law; West of England; Hybrid; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Flexible hybrid working

Generous bonus scheme

Private medical insurance

25 days holiday

Holiday exchange scheme

Enhanced parental leave

Job summary

CMS Law is seeking a proactive MI Analyst to join the Reporting & Analytics team. You will work with a wide range of business and financial data, helping deliver reporting, insights, and improvements across the firm.

You’ll produce reports and dashboards, analyse large datasets, support business users, and help improve reporting processes and data quality while building strong relationships with stakeholders at all levels.

Qualifications

• Essential MI, reporting, BI or data analyst experience.
• Strong Excel skills with advanced formulas and data manipulation.
• Experience with reporting tools such as BusinessObjects and Power BI.
• Ability to analyze and interpret large datasets.
• Strong stakeholder management and communication skills.
• Desirable: SQL, Python, Microsoft Fabric, Power BI, SSRS, Excel VBA, automation.

Responsibilities

• Develop and maintain daily, monthly, quarterly, and annual reports and dashboards.
• Produce client reports meeting specific content and formatting requirements.
• Analyse large datasets to identify trends, issues, and opportunities for improvement.
• Support data quality and data cleansing activities.
• Respond to ad hoc reporting and analysis requests from teams across the firm.
• Collaborate with Finance and Business Services to provide accurate information.
• Identify and implement process improvements to increase efficiency and reporting capabilities.
• Build strong relationships with colleagues and internal clients to deliver excellent service.

Tools

BusinessObjects

Power BI

SSRS

Excel VBA

SQL

Python

Microsoft Fabric

Job description

About the Role

We are looking for a proactive and analytical MI Analyst to join our Reporting & Analytics team. This is an excellent opportunity to work with a wide range of business and financial data, helping deliver reporting, insights, and improvements across the firm.

You’ll be responsible for producing reports and dashboards, analysing data, supporting business users, and helping improve reporting processes and data quality.

Key Responsibilities

• Develop and maintain daily, monthly, quarterly, and annual reports and dashboards.
• Produce client reports to meet specific content and formatting requirements.
• Analyse large datasets to identify trends, issues, and opportunities for improvement.
• Support data quality and data cleansing activities.
• Respond to ad hoc reporting and analysis requests from teams across the firm.
• Work closely with Finance, Business Services, and other stakeholders to provide accurate and timely information.
• Identify and implement process improvements to increase efficiency and enhance reporting capabilities.
• Build strong relationships with colleagues and internal clients to deliver an excellent service.

About You

You are an organised and detail-oriented analyst who enjoys working with data and solving problems. You are comfortable managing multiple priorities and building strong relationships with stakeholders at all levels.

Skills & Experience

Essential:

• Previous experience in an MI, reporting, business intelligence, or data analyst role.
• Strong Excel skills, including advanced formulas and data manipulation.
• Experience working with reporting tools such as BusinessObjects, Power BI, or similar.
• Ability to analyse and interpret large datasets.
• Strong communication and stakeholder management skills.

Desirable:

• SQL and Python experience.
• Experience with Microsoft Fabric and Power BI.
• SSRS report development experience.
• Knowledge of Excel VBA and process automation.

What We’re Looking For

• A proactive and adaptable approach.
• Strong analytical and problem-solving skills.
• Ability to learn quickly and work in a fast-paced environment.
• Excellent attention to detail.
• Confidence working independently and as part of a team.
• Graduate calibre or equivalent experience in a reporting, analytics, or business intelligence role.

#LI-LM1

What’s in it for you?

We want to reward you today and help you plan for tomorrow. We appreciate that everyone is different, therefore we have designed a benefits system that offers choice and flexibility based on individual needs and lifestyles. To name a few, these include:

• Competitive basic salary (reviewed annually)
• Flexible, hybrid working policy
• Generous bonus scheme
• Up to 25 days holiday (rising to 28 days with service)
• Holiday exchange scheme
• Private medical insurance
• Enhanced parental leave
• Reasonable adjustments and accommodation for disabled talent in accordance with the Equality Act 2010.

please visit our Rewards & Benefits page on our website.