MI Analyst: Power BI & SQL Reporting (Hybrid)

ExamWorks Investigation Services Limited; Bolton; Hybrid; GBP 35,000 - 50,000; Full time

Job summary

ExamWorks Investigation Services Limited is seeking an MI Analyst to join a hybrid team based near Horwich, Bolton. You will develop data marts and robust reports, delivering BAU and ad hoc insights to support business decisions.

You will work with Power BI (Fabric) and SSRS, manage multiple data sources, and mentor junior colleagues while driving improvements to governance and automation.

Qualifications

• Experience building reports in Power BI (Fabric preferred).
• Experience with SSRS reporting.
• Working knowledge of SQL Server (2016+) and T-SQL.
• Experience working with multiple data sources and platforms.
• Previous experience in an MI/BI reporting role.
• Advanced Excel skills.
• Strong understanding of relational databases.
• Excellent stakeholder engagement skills.
• Strong analytical and problem-solving abilities.
• Ability to manage multiple priorities and deliver to deadlines.

Responsibilities

• Delivery & BAU Reporting.
• Produce weekly and monthly reports for internal and external stakeholders.
• Create and maintain ad hoc reports.
• Balance project work with day-to-day reporting to meet deadlines.
• Review existing reporting to reduce duplication and improve efficiency.
• Develop and maintain data marts and warehouses using SQL Server.
• Build and maintain reporting solutions in Power BI (Fabric) and SSRS.
• Lead automation and scheduling of standardised reporting.
• Ensure outputs align with team and company standards.
• Troubleshoot and resolve production issues quickly and effectively.
• Gather and document business requirements.
• Engage stakeholders using workshops, interviews and other methods.
• Promote MI capabilities across the business.
• Build and maintain relationships with stakeholders.
• Provide guidance and support to stakeholders on reporting solutions.
• Support and mentor junior team members.
• Stay up to date with industry tools, techniques and trends.
• Recommend and implement improvements.

Skills

Power BI

SSRS

SQL Server

T-SQL

Excel

Stakeholder engagement

Analytical thinking

Data modelling

Multisource data

MI reporting

Education

GCSE English/Maths

Degree (desirable)

BCS Diploma in IT/DBD

Microsoft certifications (PL-300, DP-600)

Tools

Power BI (Fabric)

SSRS

Azure Data Factory

Power Automate

Job description

ExamWorks Investigation Services Limited is seeking an MI Analyst to join a hybrid team based near Horwich, Bolton. You will develop data marts and robust reports, delivering BAU and ad hoc insights to support business decisions.

You will work with Power BI (Fabric) and SSRS, manage multiple data sources, and mentor junior colleagues while driving improvements to governance and automation.