Power BI Developer

London, England, United Kingdom

12/19/2024

At Mace, our purpose is to redefine the boundaries of ambition. We believe in creating places that are responsible, bringing transformative impact to our people, communities and societies across the globe. To learn more about our purpose, culture, and priorities, visit our strategy site.

Within our consult business, we harness our unique combination of leading-edge practical expertise and project delivery consultancy to unlock the potential in every project.

The project

Our growing Digital Centre of Excellence team is responsible for enabling and enhancing project delivery through the development of Digital tools, processes and reports that enable data-driven decision making.

As part of your role, you will interface with the Mace project team and occasionally stakeholders from other organisations, if working on a joint venture project or directly for a client. You will be part of the Digital Centre of Excellence community, sharing knowledge and experience with other BI & Data professionals. This is an excellent opportunity to learn from and amongst experienced practitioners and further develop your technical skill set.

You will be expected to work with Microsoft’s ‘low code’ Power Platform suite, principally with Power BI, as well as SharePoint, Teams and the M365 Office suite. There is an opportunity to grow your role into other Power Platform applications such as Power Apps, Power Automate and Fabric should you choose to.

Any knowledge or experience of supporting BI & data analytics software and languages such as Python, JSON, R, JavaScript, SQL, etc. would be a benefit but is not a requirement.

The Successful Candidate Must Demonstrate

• Knowledge of good data structure and development processes
• Awareness of data security and role-based permissions
• Understanding of the capabilities of Power BI and supporting tools & platforms and an ability to make decisions or recommendations about the best tool(s) for the job
• Understanding of working in a consultancy environment and management of stakeholders including clients, project managers and data owners
  
  

Key Responsibilities

• As a Power BI Developer, you will work autonomously on smaller or low complexity projects, or as part of a larger project team responsible for a particular deliverable or area of delivery.
• The principal responsibility of the role is to contribute to the development of digital tools, processes and outputs, including interactive Power BI reports, that support the wider project team and enable better delivery of projects for our clients.
• You will be expected to adhere to a structured development lifecycle that includes requirements definition, design, development and testing, user acceptance testing, deployment, handover and post-implementation support.
• You should be able to gather basic requirements and create a task list to manage your own deliverables, including maintaining regular contact with direct stakeholders. You will be expected to attend all training and other sessions organised by the Centre of Excellence, contributing through presentation of sessions or content aligned to your interests.
• You must take responsibility for keeping your knowledge of Power BI up to date through self-directed learning and independent exploration of new tools and functionality.
  
  

You’ll Also Have

• Knowledge of good data structure and development processes
• Awareness of data security and role-based permissions
• Understanding of the capabilities of Power BI and supporting tools & platforms and an ability to make decisions or recommendations about the best tool(s) for the job
• Understanding of working in a consultancy environment and management of stakeholders including clients, project managers and data owners
  
  

Visual Layer

• Creates effective visual layers, making use of techniques such as bookmarks, tooltips and drill-through to provide an impactful UI/UX.
• Demonstrates understanding of effective visual layering, selecting the right visuals for the type of information displayed.
  
  

ETL

• Proficient with ETL processes. Creates efficient queries by following good query hygiene principles.
• Structures data appropriately for reporting, loading only the fields and records required.
  
  

Data Modelling

• Knows and uses basic DAX. Uses the CALCULATE() function to create context-based calculated measures.
• Demonstrates working knowledge of star and snowflake schemas, relationships, and query joins.
• Understands fact and dimension tables, can explain the concept of normalisation and how this might apply to a real-world data set.
• Able to create a functional semantic model independently.
• Mace is an inclusive employer and welcomes interest from a diverse range of candidates. Even if you feel you do not fulfil all of the criteria, please apply as you may still be the best candidate for this role or another role within our organisation.
  
  

We are also open to discussing part-time, flexible, and hybrid working options if suitable within the role.