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

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.

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

As part of your role, you will interface with the Mace project team and occasionally stakeholders from other organizations, 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.

You’ll be responsible for:

• 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.
• You will work autonomously in all scenarios, taking sole responsibility for the end-to-end delivery of solutions. You may supervise 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.
• 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 must be able to elicit and document requirements and translate to a technical specification that underpins development activity for yourself and others.
• You will be expected to communicate clearly with all stakeholders, providing updates on timeliness and quality of delivery, as well as raising, managing and helping to resolve issues.

You’ll need have:

• A minimum of 5 years’ experience with Power BI is expected.
• 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.
• Uses advanced ETL techniques such as query folding and dataflows to optimize 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.
• Highly proficient in DAX. Uses variables and filter context to optimize expressions.
• Can create and manage Row Level Security roles, setting up a data model to meet security filtering requirements.
• Understands relational data modelling and can design and produce an efficient schema drawing together data from a range of sources.
• Deploys knowledge of different table types to optimize model performance.

You’ll also have:

• 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 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.

Mace is an inclusive employer and welcomes interest from a diverse range of candidates. Even if you feel you do not fulfil all the criteria, please apply as you may still be the best candidate for this role or another role within our organization.

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

Apply now for a confidential discussion.

#LI-Hybrid