Business Intelligence Analyst

Air IT; Sandiacre; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading IT services provider is seeking an experienced Business Intelligence Analyst to join their Data & Power Platform team. In this critical role, you will manage the lifecycle of BI solutions, providing insights and supporting clients and stakeholders while contributing to a data-driven culture. This position offers competitive pay, a hybrid work model, and numerous professional growth opportunities.

Benefits

Hybrid working options

25 days annual leave plus bank holidays

Ongoing learning and development opportunities

Cycle to work scheme

Enhanced family leave

Celebration day off

Salary sacrifice pension

2 paid volunteer days

Company social events

Discount and Cashback Scheme

Qualifications

• Significant experience in end-to-end Power BI development.
• Advanced SQL skills (preferably using Microsoft SQL Server).
• Good understanding of the Microsoft Power Platform.

Responsibilities

• Engage with stakeholders to capture BI requirements.
• Build end-to-end BI solutions including dashboards.
• Design and maintain SQL queries for data extraction.

Skills

Problem-solving

Analytical skills

Communication skills

Organisational abilities

Education

GCSE Maths and English or equivalent

Job description

1 day ago Be among the first 25 applicants

Direct message the job poster from Air IT

We are looking for an experienced Business Intelligence Analyst to join our high-performing Data & Power Platform team. This is a critical role in a data-led organisation, working across both internal and client-facing projects.

About the Role

You will be responsible for owning the end-to-end lifecycle of BI solutions — from engaging stakeholders and understanding requirements, through to developing advanced Power BI reports, dashboards and models, and supporting BAU service issues and access requests. This is a fantastic opportunity for a skilled BI professional seeking a challenging and varied role in a fast-paced, intellectually curious environment where your ideas and technical input will drive real business impact.

Responsibilities

• Engage with internal stakeholders and external clients to capture business intelligence requirements and translate these into effective technical solutions.
• Consult on data architecture and dashboard design, delivering intuitive and insightful reports using Power BI.
• Build end-to-end BI solutions including data ingestion via Power BI Dataflows, modelling, visualisation and app deployment.
• Monitor and maintain internal KPIs and dashboards to support decision-making.
• Support and troubleshoot Power BI service issues, including access requests, gateway problems, refresh failures and performance optimisation.
• Design, write and optimise advanced DAX calculations and Power Query (M) transformations to ensure robust, high-performing models.
• Design and maintain efficient SQL queries to extract, transform and load data from source systems into Power BI dataflows and models.
• Develop and deploy automated workflows using Power Automate and custom solutions with Power Apps to support end-to-end reporting and process improvement.
• Translate technical concepts into clear, plain English for non-technical stakeholders.
• Contribute ideas, innovations and technical insight to the team; act as a knowledge sharer and problem-solver.
• Work to project deadlines with professionalism and attention to detail.
• Ensure all deliverables align with our information security standards and governance processes.

Qualifications

• GCSE Maths and English or equivalent
• Significant experience in end-to-end Power BI development: Power BI Desktop, Dataflows, Datasets, Reports, Dashboards, Apps
• Managing Permissions, Audiences, Subscriptions, Refreshes and Gateways
• Advanced SQL skills (preferably using Microsoft SQL Server)
• Advanced DAX and Power Query (M code) skills
• Good understanding of the Microsoft Power Platform, especially Power Automate
• Strong understanding of analytical principles, data modelling and business KPIs
• Experience working with APIs (reading/writing data)
• Demonstrable passion for solving business problems using data
• Strong client-facing skills and comfort working in a consultative environment
• Experience working in or with an IT Managed Service Provider (MSP)
• Familiarity with Microsoft Fabric and broader Power Platform (e.g. Power Apps)
• Knowledge of Power BI REST API and/or embedding solutions
• Experience using AI tools or interest in integrating AI into BI processes
• Some practical Python skills (e.g., for Fabric Notebooks, data cleansing, or API integration)
• Awareness of Azure AD/Entra ID for managing permissions, user access and service principals
• Basic understanding of OAuth 2.0 for connecting to secure APIs
• Relevant Microsoft certifications (e.g. PL-300, DP-600, or similar Power Platform, Azure or SQL Server qualifications)
• Valid UK driving licence (essential for client visits, where applicable)

Required Skills

• Outstanding problem-solving and analytical skills
• Excellent written and verbal communication skills
• High attention to detail and strong organisational abilities
• Capable of working independently and as part of a high-functioning team
• Comfortable managing multiple workstreams and shifting priorities
• Able to thrive in an agile, fast-paced, innovation-driven environment
• Strong Microsoft Excel and SharePoint skills
• A proactive and collaborative mindset with a hunger to learn

Pay range and compensation package

We offer a competitive salary, professional development opportunities, and the chance to work in a collaborative and innovative environment. With us, you’ll play a pivotal role in shaping the future of IT services while growing your career in a high-energy, rewarding role. Joining our team comes with its perks:

• Hybrid working options for a better work-life balance
• 25 days annual leave plus bank holidays
• Ongoing learning and development opportunities
• Cycle to work scheme and technology vouchers
• Enhanced family leave
• Celebration day - an additional day off each year to celebrate an occasion important to you
• Salary sacrifice pension
• 2 paid volunteer days - We believe in the power of giving back to our communities and want to actively support employees efforts to make a positive impact
• Company social events and competitions
• Discount and Cashback Scheme
• Group Income Protection
• Life Insurance
• EAP and Virtual GP Service

Equal Opportunity Statement

This description is not intended to establish a total definition of the job, but an outline of the duties.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Air IT by 2x

Nottingham, England, United Kingdom 3 weeks ago

Nottingham, England, United Kingdom 1 week ago

Nottingham, England, United Kingdom 2 days ago

Newark-On-Trent, England, United Kingdom 1 week ago

Commercial Business Analyst - Global Pricing

West Bridgford, England, United Kingdom 1 week ago

Nottingham, England, United Kingdom £375 - £450 11 hours ago

Nottingham, England, United Kingdom 4 weeks ago

Rocester, England, United Kingdom 4 days ago

Leicester, England, United Kingdom 5 hours ago

Nottingham, England, United Kingdom 1 week ago

Ashby-De-La-Zouch, England, United Kingdom 3 weeks ago

Rocester, England, United Kingdom 5 days ago

SAP Senior MM Functional Business Analyst

Rocester, England, United Kingdom 5 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.