What makes Community Integrated Care a great place to work: 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?
1. 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.
2. 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!
3. Benefits: retail discounts, holiday discounts, cycle to work scheme and travel discounts through our benefits app.
4. 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.
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. Learning: Access to our amazing online training platform where you can upskill taking a variety of courses and qualifications.
7. 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: 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)
8. Develop and maintain the organisation’s SQL reporting databases whilst implementing best practice
9. Design and build data extract, transformation and load processes for efficient data preparation to support our reporting and data analysis architecture using T-SQL.
10. 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.
11. Create and maintain technical documentation using defined technical templates throughout project lifecycles.
12. To provide a holistic view of data across the company and give guidance to improve data visibility, insight, and quality
13. Support the design and creation of Power BI reporting solutions which meet the needs of the business
14. Monitoring Support Ticket system and liaising with colleagues to resolve user queries
Your values: Our ideal Candidate Skills and Experience
15. IT degree or similar (e.g. Computer Science / Software Engineering/Data Analysis or similar)
16. Microsoft Certification in any T-SQL
17. Practical experience of any data analytics tools, such as Power BI, Tableau etc.
Competencies, skills and attributes
18. Minimum of 2 Years of industry experience
19. Demonstrable knowledge of: T-SQL
20. Knowledge of the design and execution of SQL queries, functions, stored procedures, triggers and indexes
21. Data Warehouse methodologies
22. Experience of Web services (APIs) and Azure Data Factory
23. Knowledge of database design and administration
24. Producing reports from transactional or cube data
25. Knowledge of Microsoft Power BI and Power BI Desktop and advantage
26. Experience of JSON
27. SQL - database administration (SSMS) including security and user administration
28. Database tuning and performance monitoring
29. 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.