power bi developer
22 days ago
Manchester
Power BI Developer \n\nManchester\n\n6 month contract\n\nInside ir35\n\nPurpose of the Role\n\nThe 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.\n\nKey Objectives\n\nEstablish a governed, trusted Data Pillar with certified datasets, semantic models, and defined data lineage.\nDevelop innovative Power BI-to-ServiceNow integrations for surfacing dataset health, ownership, and automated workflows.\nAssess and improve resilience of key BI assets, including data quality, refresh reliability, performance, and access controls.\nStandardise tooling (templates, DAX libraries, CI/CD, documentation, testing) to support consistent and governed development.\nEnable Gen AI and Co pilot Studio adoption by producing AI ready datasets and identifying opportunities for automation, anomaly detection, and forecasting.\nOptimise BI workflows by leveraging AI for documentation, requirements capture, DAX optimisation, and natural language querying. \n\nKey Responsibilities\n\nDesign and optimise Power BI data models, schemas, relationships, and calculated fields.\nBuild high performance, scalable datasets in Power BI Service. \n\nReport & Dashboard Development\n\nDevelop interactive dashboards and paginated reports with strong usability, accuracy, and visual clarity. \n\nDAX & Data Transformation\n\nWrite efficient DAX measures for KPIs, time intelligence, and complex business logic.\nDeliver robust data transformations using Power Query (M) and SQL-based pipelines. \n\nData Integration & Gen BI\n\nIntegrate Power BI with Co pilot Studio and prepare models for AI agent consumption.\nBuild workflow automation using Power Automate. \n\nPower BI Service Administration\n\nManage datasets, workspaces, refresh schedules, usage monitoring, and performance optimisation. \n\nStakeholder Engagement & Documentation\n\nGather business requirements and translate them into scalable BI solutions.\nCollaborate with data engineers, SMEs, and product teams.\nDocument data lineage, business logic, and model architecture. \n\nEssential Skills & Experience\n\nStrong expertise in Power BI Desktop, Power Query (M), DAX, and Power BI Service.\nSolid SQL skills (joins, CTEs, window functions) and experience with SQL Server.\nStrong understanding of dimensional modelling and data warehouse principles.\nExperience building and maintaining ETL pipelines.\nExcellent analytical, problem solving, and troubleshooting skills.\nStrong communication skills, able to translate complex data concepts for non technical audiences. \n\nDesirable Skills\n\nExperience with Atlassian tools (JIRA, Confluence).\nFamiliarity with ServiceNow GRC and related data structures. \n\nBehaviours & Mindset\n\nCustomer-focused, delivering intuitive and value-driven reporting.\nDetail oriented, ensuring strong governance and accuracy.\nCollaborative and responsive, working effectively across teams.\nProactive and improvement-driven, seeking opportunities to simplify and automate. \n\nIf you believe you have the experience required, please apply with your CV now for instant consideration!\n\nTO APPLY - PLEASE APPLY WITH AN UP-TO-DATE CV\n\nCandidates will ideally show evidence of the above in their CV in order to be considered.\n\nPlease 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.\n\n*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.\n\nWe 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