Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to create impactful BI solutions and support data-driven decision-making.
- Company: Be part of a forward-thinking, data-first organisation that values innovation and collaboration.
- Benefits: Enjoy hybrid working, 25 days leave, ongoing learning, and perks like tech vouchers and volunteer days.
- Why this job: This role offers a chance to drive real business impact in a fast-paced, intellectually curious environment.
- Qualifications: GCSE Maths and English, advanced SQL, DAX, Power Query skills, and a passion for solving data problems.
- Other info: Valid UK driving licence required for client visits; Microsoft certifications are a plus.
The predicted salary is between 36000 - 60000 £ per year.
Job Title: Business Intelligence Analyst
Responsible to: Head of Data and Power Platform
Responsible for: N/A
Location: Hybrid (2 days in Nottingham Office)
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:
- 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)
- Valid UK driving licence (essential for client visits, where applicable)
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 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
#J-18808-Ljbffr
Business Intelligence Analyst employer: Air IT Limited
Contact Detail:
Air IT Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Analyst
✨Tip Number 1
Familiarise yourself with Power BI and its advanced features, especially DAX and Power Query. Being able to demonstrate your expertise in these areas during discussions will show that you're not just a candidate, but a potential asset to our team.
✨Tip Number 2
Engage with current trends in business intelligence and data analytics. Showing that you’re up-to-date with the latest tools and methodologies can set you apart from other candidates and highlight your passion for the field.
✨Tip Number 3
Prepare to discuss your experience with stakeholder engagement and translating technical concepts into layman's terms. This is crucial for the role, and demonstrating your ability to communicate effectively will be key in impressing us.
✨Tip Number 4
Showcase any relevant projects or case studies where you've successfully implemented BI solutions. Real-world examples of your work can provide us with insight into your problem-solving skills and your approach to delivering impactful results.
We think you need these skills to ace Business Intelligence Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the Business Intelligence Analyst role. Focus on your proficiency in Power BI, SQL, DAX, and any experience with data architecture and dashboard design.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data and problem-solving. Mention specific projects where you've successfully engaged stakeholders and delivered BI solutions, showcasing your ability to translate technical concepts into plain English.
Showcase Your Technical Skills: Include examples of your advanced SQL skills, DAX calculations, and Power Query transformations. If you have experience with Microsoft Fabric or AI tools, be sure to mention this as it aligns with the job requirements.
Highlight Soft Skills: Don't forget to emphasise your communication skills and ability to work in a consultative environment. The role requires strong client-facing skills, so provide examples of how you've successfully managed stakeholder relationships in the past.
How to prepare for a job interview at Air IT Limited
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Power BI, SQL, DAX, and Power Query. Bring examples of past projects where you successfully built BI solutions, as this will demonstrate your technical expertise and problem-solving abilities.
✨Understand the Business Context
Research the company and its data-driven initiatives. Be ready to explain how your skills can help them achieve their business goals, especially in terms of stakeholder engagement and delivering impactful insights.
✨Communicate Clearly
Practice translating complex technical concepts into simple language. This is crucial for engaging with non-technical stakeholders, so be prepared to demonstrate your ability to communicate effectively during the interview.
✨Demonstrate a Collaborative Mindset
Highlight your experience working in teams and your ability to contribute ideas and innovations. Show that you are proactive and eager to learn from others, which aligns with the company's supportive culture.
