Power BI Developer in Birmingham

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

Our Values Shape The Way We Construct, 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.

You’ll Be Responsible For:

• Taking responsibility for the end-to-end delivery of solutions.
• Taking responsibility for the quality and timeliness of deliverables produced by yourself and other members of the team.
• 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.
• An understanding of the Power BI stack, including dataflows and paginated reports.
• An 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.
• An understanding of working in an Integrated Project Team 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 supporting knowledge or experience of 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.