Business Intelligence Developer

Build the data foundation behind life‑changing services

At Community Integrated Care, we’re a national, not‑for‑profit social care charity supporting 3,500 people and employing over 5,500 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?

• 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.
• Pension: contributory pension scheme
• Benefits: retail discounts, holiday discounts, cycle to work scheme and travel discounts through our benefits app
• 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
• Development: We'll work with you to develop your career or to learn and experience new things. We're passionate about developing our people!
• 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

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:

• Develop and maintain SQL reporting databases and the wider reporting architecture
• Design and build efficient ETL processes using T‑SQL (extract, transform, load)
• Create and maintain Power BI semantic models and reporting solutions that meet business needs
• Integrate and interface data between core systems and reporting platforms (e.g., Azure Data Factory, web services/APIs)
• Optimise database performance (indexes, stored procedures, tuning, monitoring)
• Produce clear technical documentation using defined templates and standards
• Investigate, analyse, and document defects and work collaboratively with application support
• Provide guidance across the business to improve data visibility, insight, and data quality

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:

• T‑SQL (queries, functions, stored procedures, triggers, indexes)
• Power BI / Power BI Desktop (data models + report development)
• DAX
• Data warehouse methodologies
• APIs / web services
• Database design and administration (SQL Server 2008–2016 incl. SSMS, security, user admin)
• Performance tuning & monitoring
• Azure SQL Server
• JSON / XML

Desirable

• Knowledge/experience of .NET and C#
• Experience using Azure Data Factory for pipelines and integrations

Qualifications

• IT degree (or similar—Computer Science / Software Engineering / Data Analysis)
• 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.

Interested and want to know a bit more?

To find out more about our charity check out: https://www.youtube.com/watch?v=Z-zYkoj7x8s

We’re really proud to be a Hive HR Employee Voice Certified organisation, a recognition that confirms our commitment to creating a culture where our colleagues are not only encouraged to share their thoughts, but where this feedback is actively sought and acted upon to drive positive change at every level.

In our 2025 Colleague Engagement Survey, 59% (nearly 3,800) of our people shared their feedback and insights, giving us an incredible Employee Net Promoter Score of +34.

The Employee Net Promoter Score is a measure of how willing our colleagues are to recommend us as a good place to work to their loved ones – and a score of +34 is considered a Very Good score when compared to global benchmarks set by hundreds of other organisations.