Business Intelligence 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 Newcastle upon Tyne seeks an MI Analyst to transform raw data into actionable reports. The successful candidate will develop Power BI dashboards and perform data analysis using SQL. Strong analytical skills and effective communication are essential. This role plays a critical part in delivering valuable insights to support business decisions. Commitment to diversity and equal opportunities is emphasized.

Qualifications

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

Responsibilities

• Create and develop Power BI dashboards and MI reports.
• Write SQL queries to extract data for reporting.
• Use Microsoft Fabric for scalable reporting solutions.
• Collaborate with stakeholders to capture reporting needs.
• Perform data profiling and quality checks.

Skills

MI reporting or data analysis

Power BI dashboard development

SQL for querying databases

Data management and analysis

Analytical and problem-solving skills

Organisational skills

Familiarity with data transformation tools

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.