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.
#J-18808-Ljbffr