Business Intelligence Analyst

Air IT Limited
Nottingham
1 month ago
Create job alert

Job Title: Business Intelligence Analyst
Responsible to: Head of Data and Power Platform
Location: Nottingham
Contract Type: 6 month Fixed Term Contract - Full-time

Overview

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. 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.

Duties and 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, Knowledge and Experience
  • GCSE Maths and English or equivalent
  • 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)
Skills, Abilities and Competencies
  • 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
Why Join Us?
  • Be part of a knowledgeable, forward-thinking data team within a data-first business
  • Work on impactful projects for a range of internal and external stakeholders
  • Drive innovation in a collaborative and empowering environment
  • Continuous learning and development opportunities
  • Supportive culture with the freedom to explore new ideas

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

What’s In It for You?

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.

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


#J-18808-Ljbffr

Related Jobs

View all jobs

Business Intelligence Analyst

Business Intelligence Analyst

Business Intelligence Analyst

Business Intelligence Analyst

Business Intelligence Analyst

Business Intelligence Analyst

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.