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:
1. Engage with internal stakeholders and external clients to capture business intelligence requirements and translate these into effective technical solutions.
2. Consult on data architecture and dashboard design, delivering intuitive and insightful reports using Power BI.
3. Build end-to-end BI solutions including data ingestion via Power BI Dataflows, modelling, visualisation and app deployment.
4. Monitor and maintain internal KPIs and dashboards to support decision-making.
5. Support and troubleshoot Power BI service issues, including access requests, gateway problems, refresh failures and performance optimisation.
6. Design, write and optimise advanced DAX calculations and Power Query (M) transformations to ensure robust, high-performing models.
7. Design and maintain efficient SQL queries to extract, transform and load data from source systems into Power BI dataflows and models.
8. Develop and deploy automated workflows using Power Automate and custom solutions with Power Apps to support end-to-end reporting and process improvement.
9. Translate technical concepts into clear, plain English for non-technical stakeholders.
10. Contribute ideas, innovations and technical insight to the team; act as a knowledge sharer and problem-solver.
11. Work to project deadlines with professionalism and attention to detail.
12. Ensure all deliverables align with our information security standards and governance processes.
Qualifications, Knowledge and Experience:
Essential:
13. GCSE Maths and English or equivalent
14. Significant experience in end-to-end Power BI development:
15. Power BI Desktop, Dataflows, Datasets, Reports, Dashboards, Apps
16. Managing Permissions, Audiences, Subscriptions, Refreshes and Gateways
17. Advanced SQL skills (preferably using Microsoft SQL Server)
18. Advanced DAX and Power Query (M code) skills
19. Good understanding of the Microsoft Power Platform, especially Power Automate
20. Strong understanding of analytical principles, data modelling and business KPIs
21. Experience working with APIs (reading/writing data)
22. Demonstrable passion for solving business problems using data
23. Strong client-facing skills and comfort working in a consultative environment
Desirable:
24. Experience working in or with an IT Managed Service Provider (MSP)
25. Familiarity with Microsoft Fabric and broader Power Platform (e.g. Power Apps)
26. Knowledge of Power BI REST API and/or embedding solutions
27. Experience using AI tools or interest in integrating AI into BI processes
28. Some practical Python skills (e.g., for Fabric Notebooks, data cleansing, or API integration)
29. Awareness of Azure AD/Entra ID for managing permissions, user access and service principals
30. Basic understanding of OAuth 2.0 for connecting to secure APIs
31. Relevant Microsoft certifications (e.g. PL-300, DP-600, or similar Power Platform, Azure or SQL Server qualifications)
32. Valid UK driving licence (essential for client visits, where applicable)
Skills, Abilities and Competencies:
Essential:
33. Outstanding problem-solving and analytical skills
34. Excellent written and verbal communication skills
35. High attention to detail and strong organisational abilities
36. Capable of working independently and as part of a high-functioning team
37. Comfortable managing multiple workstreams and shifting priorities
38. Able to thrive in an agile, fast-paced, innovation-driven environment
39. Strong Microsoft Excel and SharePoint skills
40. A proactive and collaborative mindset with a hunger to learn
Why Join Us?
41. Be part of a knowledgeable, forward-thinking data team within a data-first business
42. Work on impactful projects for a range of internal and external stakeholders
43. Drive innovation in a collaborative and empowering environment
44. Continuous learning and development opportunities
45. 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:
46. Hybrid working options for a better work-life balance
47. 25 days annual leave plus bank holidays
48. Ongoing learning and development opportunities
49. Cycle to work scheme and technology vouchers
50. Enhanced family leave
51. Celebration day - an additional day off each year to celebrate an occasion important to you
52. Salary sacrifice pension
53. 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
54. Company social events and competitions
55. Discount and Cashback Scheme
56. Group Income Protection
57. Life Insurance
58. EAP and Virtual GP Service
Apply Now
Details
Type
Permanent - Full Time
Location
Sandiacre, Nottinghamshire
Job Function
Business Intelligence
Apply Now