What makes Community Integrated Care a great place to work:
Build the data foundation behind life‑changing services At Community Integrated Care, we’re a national, not‑for‑profit social care charity supporting 3, people and employing over 5, colleagues—all working together so people can live their best lives possible.
We’re now looking for a Business Intelligence Developer to help shape and strengthen our organisation-wide data layer—designing robust SQL data architecture, developing high-impact Power BI reporting, and enabling stakeholders to make confident, evidence-led decisions.
If you love turning complex data into clear insight—and you care about building systems that genuinely improve outcomes—this could be the role for you. This is a full time permanent role with attendance at our head office in Widnes at least once a week so our ideal candidate will be based within an hours commute of Widnes. What is "The Deal" for you?
1. Flexibility: You can work your 37.5 hours over 4 days and enjoy a long weekend, or split the hours over 5 days to accommodate your other commitments.
2. Pension: contributory pension scheme
3. Benefits: retail discounts, holiday discounts, cycle to work scheme and travel discounts through our benefits app
4. Best Lives Possible: You'll be working for an award winning charity who is passionate about ensuring our colleagues and the people we support lead the best lives bolder
5. Development: We'll work with you to develop your career or to learn and experience new things. We're passionate about developing our people!
6. Support: From our Employee Assistance Programme (available 24/7), financial support options, and wellbeing fund you'll have the support available to lead an easier (financial) life
Who you’ll be supporting & more about the role:
You’ll design, develop and maintain our data architecture, implementing data transformation and data warehousing solutions within a SQL environment to build a core organisational data layer. You’ll also support the ongoing delivery of reporting solutions that meet business needs—ensuring quality, accuracy, and timeliness throughout.
Working closely with key stakeholders, you’ll gather BI requirements, recommend improvements, and follow data best practice to deliver high-quality analysis that drives better decisions and better services. In this varied and high-profile role, you will:
7. Develop and maintain SQL reporting databases and the wider reporting architecture
8. Design and build efficient ETL processes using T‑SQL (extract, transform, load)
9. Create and maintain Power BI semantic models and reporting solutions that meet business needs
10. Integrate and interface data between core systems and reporting platforms (e.g., Azure Data Factory, web services/APIs)
11. Optimise database performance (indexes, stored procedures, tuning, monitoring)
12. Produce clear technical documentation using defined templates and standards
13. Investigate, analyse, and document defects and work collaboratively with application support
14. Provide guidance across the business to improve data visibility, insight, and data quality
Your values:
Our ideal candidate:
You’ll be a proactive problem solver who enjoys collaborating with stakeholders and taking ownership of high-quality delivery. You’ll bring a strong technical BI skill set and the curiosity to keep learning and improving. Essential Minimum 2 years’ industry experience in BI / data development Strong hands-on experience with:
15. T‑SQL (queries, functions, stored procedures, triggers, indexes)
16. Power BI / Power BI Desktop (data models + report development)
17. DAX
18. Data warehouse methodologies
19. APIs / web services
20. Database design and administration (SQL Server – incl. SSMS, security, user admin)
21. Performance tuning & monitoring
22. Azure SQL Server
23. JSON / XML
Desirable
24. Knowledge/experience of .NET and C#
25. Experience using Azure Data Factory for pipelines and integrations
Qualifications
26. IT degree (or similar—Computer Science / Software Engineering / Data Analysis)
27. Microsoft Certification in a SQL or Power BI pathway
Ready to apply?
If you’re excited by the chance to build modern BI capability that supports an organisation doing meaningful work every day, we’d love to hear from you.
Please note, if you are interested in this role, we welcome your application as soon as possible! Depending on the volume of applications received, the vacancy may be closed before the expected advertising end date.