Job summary
- Main area
- Business Intelligence
- Grade
- Band 6
- Contract
- Fixed term: 12 months (Maternity Cover)
- Hours
- Full time
- Flexible working
- Home or remote working
- Job ref
- 448-SUPPS-7586271
- Employer
- Cambridgeshire Community Services NHS Trust
- Employer type
- NHS
- Site
- CCS Head Office
- Town
- St Ives
- Salary
- £38,682 - £46,580 per annum, pro-rata
- Salary period
- Yearly
- Closing
- 16/11/2025 23:59
- Interview date
- 27/11/2025
Employer heading
Business Intelligence Developer
Band 6
Driven by our Trust values: Honesty, Empathy, Ambition, Respect; the Trust's vision is to provide high quality care to the diverse communities we serve to make their lives better.
We are passionate about creating an inclusive workplace that promotes and values diversity. Our cultural diversity, long term conditions and disabilities, and LGBTQIA+ staff networks are a key part of this commitment, creating positive change and helping build an inclusive culture across the Trust.
Different ideas, experiences and backgrounds make us stronger and more creative and applications from all walks of life are welcomed - our processes ensure that all applicants are treated fairly at every stage of the recruitment process.
Options for flexible working are considered for all roles within CCS, including job share opportunities, compressed hours, annualised hours, tailored working patterns and more. If you are interested in flexible working, please talk to the recruiting manager for this vacancy.
Please note, the selection processes at Cambridgeshire Community Services are in place to ensure we recruit candidates with the right values and skills. Please be advised that the use of AI in applications are monitored, we remain watchful of candidates who misuse these tools to generate an application that doesn’t accurately reflect their skills.
Job overview
Are you passionate about data storytelling and excited by the opportunity to shape how insight is delivered in a modern NHS data environment?
We’re recruiting a Business Intelligence Developer on a 12-month fixed-term basis to cover maternity leave. This role is ideal for someone who enjoys turning data into accessible, visually compelling outputs aligned to clinical, operational and strategic priorities. You’ll lead the development of high-quality dashboards and reusable data models that support data-informed decision-making across the Trust.
This is a hands-on Power BI development role focused on both designing effective data models and delivering impactful visualisations. You’ll help shape how datasets are prepared and structured for reporting, working alongside engineers, analysts and service teams to produce outputs that are trusted, consistent and meaningful.
The role is primarily remote, but occasional in-person meetings and team activities are expected throughout the year. Applicants should be based within a reasonable distance of our Trust sites to enable occasional travel for in-person meetings or team activities, as required.
'If we receive a high number of applications we reserve the right to close this vacancy at any point after 07-11-2025'.
Main duties of the job
As a Business Intelligence Developer, you’ll be responsible for creating and maintaining dashboards that help teams across the Trust make sense of their data. You’ll gather reporting requirements, design effective data models, and build clear, reliable visual outputs in Power BI.
You’ll work closely with colleagues and clinical teams to ensure reporting is based on accurate, trusted data. You’ll also support the migration of legacy reports, helping to streamline and standardise outputs across the organisation.
The role requires strong Power BI skills, an eye for detail and the ability to manage your own workload from specification to release. Familiarity with SQL or similar languages is essential to support data validation and troubleshooting. You’ll contribute to team discussions, promote good practice in reporting and play an active role in improving how insight is delivered across the Trust.
Working for our organisation
Rated ‘Outstanding’ by the Care Quality Commission, we are proud to provide high quality innovative services across most of the east of England that enable people to receive care closer to home and live healthier lives.
There’s one reason why our services are outstanding – and that’s our amazing staff who, for the seventh year running, rated us incredibly highly in the national staff survey.
If you share our passion for innovative and high-quality care delivery, then please submit your application and join us on our exciting journey as a leading-edge specialist community provider. All are welcome to apply and our promise to you is a culture which prioritises staff engagement and development.
Detailed job description and main responsibilities
As a Business Intelligence Developer, you will:
Design, build and maintain Power BI data models and reporting outputs using curated, governed datasets.
Create clear, interactive dashboards that highlight trends, performance and variation.
Act as a subject-matter resource in Power BI, supporting colleagues with design and functionality queries.
Gather and interpret user requirements to ensure reports meet operational and strategic needs.
Identify emerging trends or performance issues using defined KPIs and metrics.
Work with data engineers and data scientists to align reporting with trusted data sources and models.
Support the migration of legacy reports into consistent, reusable formats.
Apply Agile and DevOps-aligned delivery practices using Azure DevOps and Jira.
Test, validate and document reports to ensure reliability and transparency.
Design reports with appropriate data access, performance and usability in mind, ensuring outputs are secure, scalable and aligned with organisational standards.
Contribute to team knowledge sharing, peer review and small-scale process improvements.
Communication
Proactively engage with team members and other stakeholders to gather data requirements and support the development of effective working relationships, verbally and in writing.
Attend various internal and external meetings on behalf of the team where appropriate.
Promote and communicate BI developments with other team members.
People Management
Maintaining own professional development and requirement to take part in appraisal and KSF process.
Research & Development
Keeping up to date with Power BI releases and updates.
Ensure own personal and professional development through keeping up to date with latest technologies, systems and processes within the business intelligence field.
Clinical and Practice Governance
Observe and maintain strict confidentiality with regards to any information in line with the requirements of the Data Protection Act.
Any data that is must be undertaken with regard to the Trust Information Governance and Information Security policies.
The post holder must adhere to the Trust risk assessment and risk management processes.
The post holder must adhere to infection control policies and procedures.
Undertake mandatory training and any other training relevant to the role as required by Cambridgeshire Community Services NHS Trust.
The post holder must participate in clinical and safeguarding audits as required.
The post holder is required to participate in relevant emergency preparedness process for their team.
Person specification
Qualifications and Training
Essential criteria
- Degree in a numerate discipline or Proven workplace experience in a related role.
Desirable criteria
- Microsoft Certifications
- Power BI training
Experience
Essential criteria
- Using Microsoft Power BI in a development role
- Leading the design and delivery of new reporting requirements
- Using DAX and Power Query
- Background in a related field
Desirable criteria
- Experience with Azure Synapse Analytics or Azure Data Factory
- Production of guidance documentation.
Knowledge and Skills
Essential criteria
- Skilled in Power BI, including data modelling & DAX
- Knowledge of SQL or other languages
- Understands principles of secure and scalable reporting, including access control, performance and usability
- Clear communicator, confident in presenting data and insights to varied audiences
- Builds strong, collaborative relationships across technical and operational teams
Desirable criteria
- Agile delivery and DevOps tools
- Awareness of data governance, security, and access control in reporting
- Understanding of NHS datasets and information standards.
Employer certification / accreditation badges
Applicant requirements
This post will require a submission for Disclosure to be made to check for any unspent criminal convictions.
Documents to download
Further details / informal visits contact
- Name
- Samantha Clarke
- Job title
- Data Warehouse Manager
- Email address
- [email protected]
List jobs with Cambridgeshire Community Services NHS Trust in Administrative Services or all sectors