Power BI Developer

Job Description

We are looking to add an experienced Power BI Developer to join our growing consulting team. You will work on client facing projects, so previous experience working in a consulting capacity is beneficial but not essential.

The role offers a diverse opportunity working with data across various domains, clients and projects. While your role will primarily involve Power BI development, you will also contribute and take responsibility for other data centric activity such as requirements capture, user research, data analysis, data engineering and BI environment administration.

We have an exciting and varied client list, that are located throughout the UK. Due to this, all applicants must be willing and able to travel and work away from home as part of this role. Our office is based in Milton Keynes but with remote and flexible working you can be based further afield!


Requirements of the role

As a Power BI Developer, you will be required to deploy production-ready reporting and dashboard solutions for our customers. The day to day varies greatly depending on the need of the customer. To give you a good understanding of the types of duties associated with this role, we have outlined the below:

  • Working with business analysts and clients to understand their data and reporting requirements
  • Playing an active role in and leading requirements gathering workshop sessions with clients
  • Working closely with key stakeholders to understand business logic and rules for reporting
  • Creating wireframes and PoCs to capture the imagination of the intended users whilst apply good data visualisation standards
  • Creating data models and datasets that can be used for both professional and self-service reporting
  • Creating reports and dashboards using reporting tools within the Microsoft stack (mainly Power BI)
  • Creating data visualisations to support the business in data storytelling
  • Documenting data models, data sets and report specifications
  • Working with data engineers and architects to ensure that underlying data repos reflect business need
  • Testing the accuracy and quality of underlying data repositories to ensure they meet required standards
  • Setup and administration of dashboards, reports and automated report refresh schedules
  • Train self-service BI users and support the business in promoting self-service BI and the overall data platform through communications, collateral and training material.

Essential Experience required

We would like to hear from people with the following:

  • Experience of developing reports and dashboards in Power BI
  • Experience of connecting to multiple data sources and building datasets in Power BI
  • Experience of using DAX to create custom data objects within Power BI
  • Experience of setting up workspaces, reports, dashboards and scheduled refreshes in Power BI
  • Experience of analysing data, generating insights and visualising data in support of business initiatives
  • Understanding of administrating the Power BI Service tenant at global level

Experience in the following areas would be beneficial to the role:

  • Familiarity with agile methodologies and working in an agile way on data projects
  • Knowledge of other data tools within the Microsoft stack i.e. SSIS, SSAS, SSRS and AAS
  • Experience of using other data visualisation and reporting tools such as Tableau and QlikView
  • Knowledge of SQL and using it to query databases in particular SQL Server databases
  • Familiar with the fundamentals of cloud computing in particular Azure
  • Knowledge of Azure data services components and the role they perform
  • Knowledge of Azure Data factory and using it for data orchestration would be a bonus


  • Competitive salary
  • Up to £100 per month allowance for your phone and broadband bills
  • 10% of basic salary in flexible benefits (to include death in service and critical illness cover as standard plus private healthcare, dental, pension etc.)
  • 25 days annual leave plus Bank Holidays (you will receive an additional day of annual leave for every 2 years of your employment)

We’re a small team working our way through lots of applications, so please bear with us. If you don’t hear from us within two weeks, we’re sorry that it’s not worked out this time. We’ll keep your details on file for any relevant roles that come up – to opt out of this, just drop us an email: crichmond@aiimi.com or Lawrence Tyler.

Aiimi is an Equal Opportunities employer and applicants are selected solely based on their relevant aptitudes, skills and abilities in line with the job they are applying for. No applicant shall receive less favourable treatment on the grounds of sex, marital status, civil partnership status, trans-gender status, pregnancy, maternity, race, nationality, ethnic origin, religion, belief, sexual orientation, disability, age. This is not an exclusive list.

Where did you find out about Aiimi and this opportunity?
Benefits & Perks

What you can look forward to

Flexible benefits. Including death in service and critical illness cover from day one, plus 9% pension contribution and full private health care upon passing probation

Aiimi Team Meetings every month - via Zoom or in-person

25 days annual leave plus bank holidays (and an additional day for every 2 years of employment with us)

Flexible hours and flexible working

Mental wellbeing support. Including paid private counselling, a 24/7 helpline, and regular Aiimi Cares workshops. We also have 16 fully-trained Mental Health First Aiders in our team.

Up to £100 per month allowance towards your mobile phone and broadband bills

Aiimi Logo