Senior Power BI Developer

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 construct business, we harness our unique combination of leading-edge practical expertise and project delivery consultancy to unlock the potential in every project. 

The role is for a BI developer specialising in the Microsoft technology stack. It is a client-facing role supporting fee-earning projects and programmes.

Mace is a forward-thinking construction consultancy that can offer you the opportunity to contribute to some of the nation's largest and most exciting construction projects across a range of industries and sectors, including transport, healthcare, education, government and nuclear.

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 and data professionals. This is an excellent opportunity to learn from and amongst experienced practitioners and further develop your technical skill set.

Our values shape the way we consult and define the people we want to join us on our journey, they are:

• Safety first - Going home safe and well
• Client focus - Deliver on our promise
• Integrity - Always do the right thing
• Create opportunity - For our people to excel

As a senior Power BI developer, 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.

You'll be responsible for:

• Taking sole responsibility for the end-to-end delivery of solutions.
• Supervising junior colleagues on larger projects, taking responsibility for the quality and timeliness of deliverables produced by other members of the team as well as your own.
• Contributing 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.
• Adhering to a structured development lifecycle that includes requirements definition, design, development and testing, user acceptance testing, deployment, handover and post-implementation support.
• Eliciting document requirements and translate to a technical specification that underpins development activity for yourself and others. 
• Communicating clearly with all stakeholders, providing updates on timeliness and quality of delivery, as well as raising, managing and helping to resolve issues.
• Sharing knowledge with others, including creating documentation and learning materials.
• Taking online management of one or more direct reports.

You'll need to have:

• Minimum of 5 years' experience with Power BI.
• Knowledge of good data structure and development processes.
• Sound knowledge of all elements of the Power BI stack, including dataflows and paginated reports.
• Understanding of the capabilities of Power BI and supporting tools & platforms, including particularly Microsoft Fabric and SharePoint.
• Ability to express how each of the elements of a solution interact and make recommendations on overall solution architecture based on experience and industry guidance.
• Understanding of working in a consultancy environment and management of stakeholders including clients, project managers and data owners.
• Additionally, the following knowledge and skills are sought:
• Visual layer- Visual layer is always of high quality, adhering to standards and best practices of UI/UX and accessibility. 
• Draws on experience to recommend best visuals, layouts and interactions to showcase the required data.
• ETL- Uses advanced ETL techniques such as query folding and dataflows to optimise data load processes. Understands the order of query operations to elicit the most efficient outcome. 
• Has a sound knowledge of the M query language and the advanced Editor. Able to design and build model policies such as incremental refresh and hybrid tables, where appropriate.
• Data modelling- Highly proficient in DAX. Uses variables and filter context to optimise expressions. Can create and manage row level security roles, setting up a data model to meet security filtering requirements. 
• Understanding relational data modelling and can design and produce an efficient scheme drawing together data from a range of sources. Deploys knowledge of different table types to optimise model performance.

You'll also have:

• The ability to work collaboratively as part of a team.
• A willingness to share knowledge and support the development of others.
• The confidence to ask questions, make suggestions and challenge the status quo.
• Excellent written and oral communication skills (in English) and presentational skills.
• A commitment to working inclusively.
• An aptitude for problem-solving.
• Good interpersonal skills.
• Any knowledge or experience of supporting BI and data analytics software and languages such as Python, JSON, R, JavaScript, SQL, etc. would be a benefit but is not a requirement.

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.

#LI-Hybrid