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 business we harness our unique combination of leading-edge practical expertise and project delivery 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 Power BI developer at Mace, 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: Working as part of a project team, taking responsibility for a particular deliverable or area of delivery. 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. Gathering basic requirements and create a task list to manage your own deliverables, including maintaining regular contact with direct stakeholders. Sharing knowledge with others, including creating documentation and learning materials. Keeping your knowledge of Power BI up to date through self-directed learning and independent exploration of new tools and functionality. You’ll need to have: Minimum of 2 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 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. Additionally, the following knowledge and skills are sought: 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. 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. Knows and uses a diverse range of DAX expressions. 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, is able to explain the concept of normalisation and how this might apply to a real-world data set. 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-On-site