Is Business Intelligence your passion ? Community Integrated Care is looking to recruit an experienced Business Intelligence Developer to join our data and process team on a full time permanent basis. The successful candidate will ideally be based anywhere in the North West, and must be available to travel to our head office in Widnes at least once a week. What is The Deal for you? Flexibility You can work your full time hours over 4 days and enjoy a long weekend, or work over 5 days to accommodate your other commitments. Hybrid Working Do you like to work from home? Or do you prefer being in an office? With this role you have the option of working from home or from our head office in Widnes - or a blend between the two Benefits: retail discounts, holiday discounts, cycle to work scheme and travel discounts through our benefits app. Purpose: You'll be working for an award-winning values-led charity that is is passionate about ensuring our colleagues and the people we support lead the best lives possible. Development: We'll work with you to develop your career or to learn and experience new things. We're passionate about developing our people Learning: Access to our amazing online training platform where you can upskill taking a variety of courses and qualifications. 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. This role designs, develops, and maintains data architecture. It involves implementing data transformation techniques and data warehouse solutions in SQL to build a core organisational data layer. Responsibilities include delivering quality reporting solutions that meet business needs. The role also requires gathering BI requirements from stakeholders, offering improvements, and following best practice for delivering high-quality, accurate analysis. Day to Day (list not exhaustive see attached job description) Develop and maintain the organisation’s SQL reporting databases whilst implementing best practice Design and build data extract, transformation and load processes for efficient data preparation to support our reporting and data analysis architecture using T-SQL. Develop and maintain interfaces of data between CIC’s core business systems and the reporting architecture using industry techniques such as SSIS and web services. Create and maintain technical documentation using defined technical templates throughout project lifecycles. To provide a holistic view of data across the company and give guidance to improve data visibility, insight, and quality Support the design and creation of Power BI reporting solutions which meet the needs of the business Monitoring Support Ticket system and liaising with colleagues to resolve user queries Our ideal Candidate Skills And Experience IT degree or similar (e.g. Computer Science / Software Engineering/Data Analysis or similar) Microsoft Certification in any T-SQL Practical experience of any data analytics tools, such as Power BI, Tableau etc. Competencies, Skills And Attributes Minimum of 2 Years of industry experience Demonstrable knowledge of: T-SQL Knowledge of the design and execution of SQL queries, functions, stored procedures, triggers and indexes Data Warehouse methodologies Experience of Web services (APIs) and Azure Data Factory Knowledge of database design and administration Producing reports from transactional or cube data Knowledge of Microsoft Power BI and Power BI Desktop and advantage Experience of JSON SQL 2008 -2016 database administration (SSMS) including security and user administration Database tuning and performance monitoring Excellent attention to detail 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?vZ-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 2023 Colleague Engagement Survey, 56% (over 3,300) of our people shared their feedback and insights, giving us an incredible Employee Net Promoter Score of 28. This is a measure of how positively our colleagues talk about us - and 28 is an excellent score compared to other organisations