power bi developer

Power BI Developer

Manchester

6 month contract

Inside ir35

Purpose of the Role

The role is responsible for designing high quality Power BI datasets, developing scalable data models, and delivering insightful dashboards that support critical business processes. The position also leads the establishment of a resilient BI data foundation, integration with ServiceNow, and uplift of AI ready reporting capabilities across the organisation.

Key Objectives

• Establish a governed, trusted Data Pillar with certified datasets, semantic models, and defined data lineage.
• Develop innovative Power BI-to-ServiceNow integrations for surfacing dataset health, ownership, and automated workflows.
• Assess and improve resilience of key BI assets, including data quality, refresh reliability, performance, and access controls.
• Standardise tooling (templates, DAX libraries, CI/CD, documentation, testing) to support consistent and governed development.
• Enable Gen AI and Co pilot Studio adoption by producing AI ready datasets and identifying opportunities for automation, anomaly detection, and forecasting.
• Optimise BI workflows by leveraging AI for documentation, requirements capture, DAX optimisation, and natural language querying.

Key Responsibilities

• Design and optimise Power BI data models, schemas, relationships, and calculated fields.
• Build high performance, scalable datasets in Power BI Service.

Report & Dashboard Development

• Develop interactive dashboards and paginated reports with strong usability, accuracy, and visual clarity.

DAX & Data Transformation

• Write efficient DAX measures for KPIs, time intelligence, and complex business logic.
• Deliver robust data transformations using Power Query (M) and SQL-based pipelines.

Data Integration & Gen BI

• Integrate Power BI with Co pilot Studio and prepare models for AI agent consumption.
• Build workflow automation using Power Automate.

Power BI Service Administration

• Manage datasets, workspaces, refresh schedules, usage monitoring, and performance optimisation.

Stakeholder Engagement & Documentation

• Gather business requirements and translate them into scalable BI solutions.
• Collaborate with data engineers, SMEs, and product teams.
• Document data lineage, business logic, and model architecture.

Essential Skills & Experience

• Strong expertise in Power BI Desktop, Power Query (M), DAX, and Power BI Service.
• Solid SQL skills (joins, CTEs, window functions) and experience with SQL Server.
• Strong understanding of dimensional modelling and data warehouse principles.
• Experience building and maintaining ETL pipelines.
• Excellent analytical, problem solving, and troubleshooting skills.
• Strong communication skills, able to translate complex data concepts for non technical audiences.

Desirable Skills

• Experience with Atlassian tools (JIRA, Confluence).
• Familiarity with ServiceNow GRC and related data structures.

Behaviours & Mindset

• Customer-focused, delivering intuitive and value-driven reporting.
• Detail oriented, ensuring strong governance and accuracy.
• Collaborative and responsive, working effectively across teams.
• Proactive and improvement-driven, seeking opportunities to simplify and automate.

If you believe you have the experience required, please apply with your CV now for instant consideration!

TO APPLY - PLEASE APPLY WITH AN UP-TO-DATE CV

Candidates will ideally show evidence of the above in their CV in order to be considered.

Please be advised if you haven't heard from us within 48 hours then unfortunately your application has not been successful on this occasion, we may however keep your details on file for any suitable future vacancies and contact you accordingly.

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.

We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention.