At a Glance
- Tasks: Create impactful Power BI dashboards to enhance public services and drive better outcomes.
- Company: Join a dynamic council's Data Insights team in Islington, London.
- Benefits: Competitive pay, hybrid work model, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on data governance and compliance.
- Why this job: Make a real difference in the public sector through innovative data solutions.
- Qualifications: Experience with Power BI, DAX, SQL, and strong stakeholder management skills.
The predicted salary is between 55000 - 65000 £ per year.
Location: Islington, London (hybrid - 2 days in office, 3 days remote) | Contract Type: Interim | Hours: Full time | Rate: PAYE £26.26 per hour | Limited/Umbrella £34.29 per hour
Opportunity
We are looking for an experienced Power BI Developer / Analyst to join a growing central Data Insights team, playing a key role in delivering a council-wide data strategy. This is an exciting opportunity to shape how data is used across a large public sector organisation, rolling out impactful Power BI dashboards that help drive better services and outcomes for residents. You will sit within the corporate insight team and be part of a wider networked analytical community, working across multiple service areas and with a broad range of stakeholders.
Key Responsibilities
- Data Analytics & Insight
- Lead the development of dashboards for specific service areas, defining key metrics and building accurate, performant calculations and measures across large datasets.
- Set up data ingestion processes from a variety of sources and perform transformations using Power Query, M‑code and DAX.
- Design and optimise navigation features in Power BI to guide users through clear, compelling data stories.
- Collaborate with data engineers to produce documentation and SQL scripts for data transformation.
- Create insightful, interactive and visually engaging reporting solutions.
- Manage dashboards, data sources, security, schedules, extracts and workspaces.
- Work with data within an Azure data platform.
- Training & Upskilling
- Support the wider data analyst community with Power BI dashboard development.
- Manage Power BI forums for developers and analysts.
- Set and maintain best practice standards for dashboard development.
- Develop and disseminate quality assurance procedures across the analytical community.
- Provide technical support and guidance to new Power BI users.
- Communication & Stakeholder Management
- Gather and document analytical requirements from a range of stakeholders and validate data prior to visualisation to ensure accuracy and trust in outputs.
- Champion data visualisation and the wider data platform across the organisation, promoting automation and resident value.
- Work effectively with senior management across multiple departments.
- Data Governance & Compliance
- Develop reports and dashboards that are fully GDPR and Data Protection compliant.
- Work with Information Governance colleagues to ensure dashboards are deployed with appropriate access controls and aligned with organisational policies.
What We're Looking For
Essential
- Significant experience of Power BI, including end‑to‑end reporting and deployment, preferably in a public sector setting.
- Proven track record of designing and delivering Power BI dashboards.
- Solid data modelling capabilities within Power BI.
- Fluency in DAX and strong SQL query writing skills.
- Professional Power BI certification (e.g., PL‑300: Microsoft Power BI Data Analyst).
- Experience of WCAG 2.1/2.2 accessibility compliance in reporting.
- Strong stakeholder management and requirements‑gathering skills.
- Excellent analytical and problem‑solving ability.
- Experience managing projects, prioritising workloads and meeting tight deadlines.
- Sound knowledge of information governance and data security best practice.
Required at Submission
- Eligibility to work in the UK.
- Up‑to‑date CV.
- 2 years of references/work history.
If you are a skilled Power BI professional looking to make a real difference through data in a high‑profile public sector environment, we’d love to hear from you.
Power BI Developer employer: Vermillion Analytics
Contact Detail:
Vermillion Analytics Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Power BI Developer
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even local events related to Power BI. You never know who might have a lead on your next opportunity or can give you insider tips on landing that dream job.
✨Show Off Your Skills
Create a portfolio showcasing your best Power BI dashboards and projects. This is your chance to shine! Share it during interviews or even on LinkedIn to grab the attention of potential employers. We love seeing what you can do!
✨Ace the Interview
Prepare for common interview questions related to Power BI and data analytics. Practice explaining your thought process when developing dashboards and how you handle stakeholder requirements. Confidence is key, so let your passion for data shine through!
✨Apply Through Us
Don’t forget to check out our website for the latest job openings! Applying directly through us not only gives you access to exclusive roles but also shows your commitment to joining our community. Let’s get you that Power BI Developer role!
We think you need these skills to ace Power BI Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your Power BI experience and any relevant projects you've worked on. We want to see how your skills align with the role, so don’t be shy about showcasing your achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about data and how you can contribute to our Data Insights team. Keep it engaging and relevant to the job description.
Showcase Your Technical Skills: Since this role requires solid Power BI and SQL skills, make sure to mention specific tools and techniques you’ve used. We love seeing examples of your work, so if you have a portfolio or links to dashboards, include them!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Vermillion Analytics
✨Know Your Power BI Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with end-to-end reporting, dashboard design, and DAX fluency. Prepare examples of past projects where you've successfully delivered impactful dashboards.
✨Understand the Public Sector Context
Since this role is within a public sector organisation, it’s crucial to understand the unique challenges and requirements of this environment. Familiarise yourself with how data can drive better services for residents and be prepared to discuss how your work can contribute to that goal.
✨Showcase Your Stakeholder Management Skills
This position involves working with various stakeholders, so be ready to share examples of how you've gathered requirements and validated data in the past. Highlight your communication skills and how you’ve built trust with different teams to ensure successful project outcomes.
✨Prepare for Technical Questions
Expect some technical questions related to SQL, data modelling, and compliance with GDPR. Brush up on your knowledge of data governance and be ready to explain how you ensure data security in your projects. This will show that you’re not just a Power BI whiz but also understand the bigger picture.