Power BI Consultant

Location: Flexible working with occasional travel to Aldermaston, Reading, or Paddington

Clearance Requirement: UK Sole National – SC clearance preferred or eligibility to obtain

Company Description

Anvil Analytical is a disruptive SaaS provider addressing complex issues within strategic sourcing and supplier management. Our solutions are utilised by businesses across various sectors to enhance third-party spend management and measure carbon footprints. Founded on January 1st, 2022, as the technology wing of 4C Associates, Anvil's tools have transitioned from supporting consulting projects to becoming full-fledged SaaS offerings. Recognised by Gartner Peer Insights as the top platform for Procurement Analytics in September 2023, we are acclaimed for our value, feature depth, quick implementation, superior service, and advanced data analytics.

Role Description

This is a contract hybrid role for a Power BI Consultant, located in the London Area, United Kingdom, with some work-from-home flexibility. We are seeking a highly capable and motivated Power BI Specialist to join our data and analytics function. This role is ideal for someone with a strong background in Power BI development, data transformation, and integration, preferably with exposure to regulated sectors such as defence, government, or public services. You must be willing and eligible to obtain Security Clearance. You will be responsible for managing and enhancing a portfolio of Power BI dashboards, gathering reporting requirements, and delivering automated, scaleable reporting solutions that support strategic decision-making.

• Manage and maintain the existing suite of Power BI dashboards.
• Gather and analyse future reporting requirements from stakeholders.
• Design, develop, and deploy new Power BI dashboards and reports.
• Automate data pipelines to streamline data refresh and reporting processes.
• Create and maintain documentation including user guides and technical specifications.
• Plan and prioritise future reporting needs in collaboration with business units.
• Engage with stakeholders to ensure reporting solutions align with business goals.
• Apply Agile project management principles to deliver iterative improvements.
• Support ML metadata extraction and integration into reporting workflows.
• Use scripting languages (e.g., DAX, M, Python, PowerShell) to support data transformation and automation.

Qualifications

• Minimum 3 years of industry experience in a BI or data analytics role.
• Advanced Power BI skills, including DAX, Power Query (M), and custom visuals.
• Strong experience in data transformation and modelling.
• Proven ability in data integration across multiple sources (Snowflake, SQL, APIs, Excel, etc.).
• Experience working in or with the defence, government, or public sector is highly desirable.
• Knowledge of Data Warehousing concepts and practices.
• Familiarity with Agile methodologies and tools (e.g., Jira, Azure DevOps).
• Excellent communication and stakeholder management skills.
• Ability to work both independently and collaboratively in a hybrid work environment.
• Experience with ML metadata extraction and scripting languages is a plus.
• Experience in the procurement or supply chain industry is a nice to have.
• Bachelor's degree in Computer Science, Information Systems, or related field.