At a Glance
- Tasks: Design and develop data architecture, create impactful Power BI reports, and support evidence-led decision making.
- Company: Join a national charity dedicated to improving lives through social care.
- Benefits: Flexible working hours, pension scheme, retail discounts, and career development opportunities.
- Other info: Collaborative environment with a focus on personal growth and wellbeing support.
- Why this job: Make a real difference by turning complex data into clear insights for better services.
- Qualifications: Minimum 2 years in BI/data development with strong T-SQL and Power BI skills.
The predicted salary is between 35000 - 45000 € 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.
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.
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
Business Intelligence Developer 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 and a supportive culture that prioritises wellbeing, ensuring you can thrive both in and out of the workplace. Join us in our mission to make a meaningful impact in the lives of those we support 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
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at industry events. We all know that sometimes it’s not just what you know, but who you know that can help you land that Business Intelligence Developer role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects and Power BI reports. This will give potential employers a taste of what you can do and how you can contribute to their mission of improving lives.
✨Tip Number 3
Prepare for interviews by practising common BI questions and scenarios. We recommend doing mock interviews with friends or using online resources to boost your confidence and ensure you can articulate your experience effectively.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are genuinely interested in joining our mission at Community Integrated Care.
We think you need these skills to ace Business Intelligence Developer
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, don’t just list your technical skills—share examples of how you've solved complex problems in previous roles. This will demonstrate your proactive approach and ability to deliver high-quality results.
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 this exciting opportunity to make a difference!
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 prepared to discuss your experience with queries, functions, and stored procedures. You might even be asked to solve a problem on the spot, so practice writing out some common SQL queries.
✨Showcase Your Power BI Skills
Since this role heavily involves Power BI, come ready to talk about your past projects. Bring examples of reports you've created and be ready to explain your thought process behind the data models. If possible, have a portfolio or screenshots handy to visually demonstrate your work.
✨Understand the Business Context
Research Community Integrated Care and understand their mission and values. Think about how your role as a Business Intelligence Developer can contribute to their goal of improving lives. This will show your genuine interest in the organisation and help you align your answers with their objectives.
✨Prepare for Stakeholder Interaction
This position requires collaboration with various stakeholders, so be ready to discuss how you've gathered BI requirements in the past. Prepare examples of how you've communicated complex data insights to non-technical audiences, as this will highlight your ability to bridge the gap between data and decision-making.
