At a Glance
- Tasks: Design and develop data architecture to support impactful decision-making.
- Company: Join a national charity dedicated to improving lives through data.
- Benefits: Flexible working hours, pension scheme, and various retail discounts.
- Other info: Collaborative environment focused on personal and professional growth.
- Why this job: Make a real difference by turning data into insights that improve services.
- Qualifications: 2+ years in BI/data development with strong SQL and Power BI skills.
The predicted salary is between 30000 - 40000 £ per year.
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 hour's 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.
- 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.
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:
- 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
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:
- 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.
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.
Business Intelligence Developer in Widnes employer: Community Integrated Care
At Community Integrated Care, we pride ourselves on being an exceptional employer, offering a flexible work environment that allows you to balance your professional and personal commitments. Our commitment to employee development is evident through tailored career growth opportunities, alongside a supportive culture that prioritises wellbeing and collaboration. Join us in Widnes, where your contributions will directly impact the lives of those we support, all while enjoying a range of benefits including retail discounts and a contributory pension scheme.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer in Widnes
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common BI questions and showcasing your SQL and Power BI skills. We recommend setting up mock interviews with friends or using online platforms to get comfortable with the process.
✨Tip Number 3
Showcase your projects! Create a portfolio that highlights your best work in data architecture and reporting. This will give you an edge and demonstrate your hands-on experience to potential employers.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in joining our mission to support people in living their best lives.
We think you need these skills to ace Business Intelligence Developer in Widnes
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Business Intelligence Developer role. Highlight your experience with T-SQL, Power BI, and any relevant projects that showcase your skills in data architecture and reporting.
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 your skills can help Community Integrated Care achieve its mission. Be genuine and let your personality come through.
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled complex data challenges in the past. We love proactive problem solvers, so share specific instances where your insights led to better decisions or improved outcomes.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we can’t wait to see what you bring to the table!
How to prepare for a job interview at Community Integrated Care
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be ready to discuss your experience with queries, functions, and stored procedures. You might even be asked to solve a problem on the spot, so practice some common SQL scenarios!
✨Show Off Your Power BI Skills
Prepare to showcase your Power BI expertise. Bring examples of reports you've created and be ready to explain your thought process behind the data models. If you can demonstrate how your insights have led to better decision-making, that’ll definitely impress them!
✨Understand Their Mission
Familiarise yourself with Community Integrated Care's mission and values. They’re all about improving lives through data-driven decisions, so think about how your skills can contribute to their goals. Showing genuine interest in their work will set you apart from other candidates.
✨Prepare Questions for Them
Have a few thoughtful questions ready to ask at the end of your interview. This could be about their current BI projects or how they envision the role evolving. It shows you're engaged and serious about the position, plus it gives you a chance to assess if it's the right fit for you!
