MI Analyst

Core-Asset Consulting Ltd; Newcastle upon Tyne; On-site; GBP 35,000 - 50,000; Full time

Job summary

A leading financial services firm in the UK seeks an MI Analyst to transform raw data into actionable reporting. The ideal candidate will have extensive experience in MI reporting and data analysis, along with strong Power BI and SQL skills. Responsibilities include developing dashboards, querying data, and working closely with stakeholders to deliver insightful reports. This role offers an opportunity to play a key part in data-driven decision-making.

Qualifications

• Previous experience in MI reporting or data analysis.
• Experience using Power BI to develop dashboards.
• Solid working knowledge of SQL for data extraction.

Responsibilities

• Create and develop Power BI dashboards and MI reports.
• Create SQL queries to extract data for reporting.
• Use Microsoft Fabric for efficient reporting solutions.
• Work with stakeholders to capture reporting needs.
• Complete data profiling and quality checks.
• Maintain reusable datasets for consistency.
• Log reporting logic and data definitions.
• Present reports to stakeholders.

Skills

MI reporting or data analysis

Power BI dashboard development

SQL for data querying

Ability to manage large datasets

Analytical skills

Problem-solving skills

Accuracy in reports

Strong communication skills

Organisational skills

Familiarity with data transformation programs

Tools

Microsoft Fabric

Power BI

SQL

Job description

Job Description

We are working on a new opportunity for an MI Analyst to join the team at a leading financial services firm based in Newcastle. In this role, you will play a vital part in transforming raw data to deliver reporting needs to support the business.

Skills/Experience

• Previous experience in MI reporting or data analysis
• Experience using Power BI with an ability to develop dashboards and visualisations within Microsoft Fabric.
• Solid working knowledge of SQL for querying and extracting data from relational databases.
• Ability to manage and analyse large datasets
• Analytical and problem-solving skills
• Accuracy when delivering tactical reporting
• Strong communication and organisational skills with ability to prioritise projects and meet deadlines
• Familiarity with data transformation or analytics programmes (desirable)

Core Responsibilities

• Create and develop Power BI dashboards and MI reports to support the business operations and decision-making
• Create SQL queries to extract data for reporting
• Use Microsoft Fabric (including Lakehouses and Direct Lake mode) to deliver scalable and efficient reporting solutions.
• Work closely with stakeholders to capture the required reporting needs and create structured MI outputs
• Complete tasks such as data profiling and quality checks to ensure accuracy in reports
• Support the creation and maintenance of reusable datasets and semantic models to ensure consistency across reporting outputs.
• Log reporting logic, data definitions and sources
• Present reports to stakeholders across the business to highlight KPIs and patterns

Core-Asset Consulting is an equal opportunities recruiter and we welcome applications from everyone irrespective of age, disability, gender, gender identity or expression, race, colour, ethnic or national origin, sexual orientation, religion or belief, marital/civil partner status or pregnancy.

Job reference: 16285

To apply for this vacancy applicants must be eligible to work in the UK in accordance with the Immigration, Asylum and Nationality Act 2006.

At Core-Asset, we're committed to protecting and respecting your privacy. Our privacy statement explains when and why we collect personal information about people who engage with our services, how we use it, the conditions under which we may disclose it to others, and how we keep it secure. We may change this policy from time to time, so please check this policy occasionally to ensure that you're happy with any changes.

By engaging with us (either by applying for a job we're advertising, registering through our website, or getting in touch with our business) you're agreeing to be bound by this policy.

Core-Asset Consulting is committed to protecting the privacy of our candidates, clients and website users. For further information, please refer to our full Privacy Statement available on our website http://www.core-asset.co.uk/about-core-asset/privacy-statement

Core-Asset Consulting offers specialist recruitment services to asset management, accounting & finance, asset servicing, legal and the wider financial services sector in Scotland.