Business Intelligence Analyst

Job Title: Business Intelligence Analyst

Responsible to: Head of Data and Power Platform

Location: Remote (however on occasion must be able to attend meetings at any Air IT Office Locations)

Contract Type: Full-time

Job Purpose:

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:

Essential:

• 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

Desirable:

• 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)

Skills, Abilities and Competencies:

Essential:

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

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