Job Summary

• With all the exciting changes happening due to business growth, were on the lookout for a talented and experienced BI Developer working remotely to build and maintain ETL (Extract, Transform and Load) processes on SQL Server using T-SQL and SQL Server Integration Services (SSIS) to achieve project goals, with the ultimate aim of providing better care for our patients!

This is a fixed term role until July 2025, with occasional travel to our regional offices. Main duties of the job

Your main responsibilities will include-

• Building and maintaining ETL processes on SQL Server using T-SQL and SSIS to achieve project goals

• Designing and creating facts and dimensions in the Data Warehouse

• Interpreting complex business requirements and converting into robust data solutions

• Assisting with BAU tasks such as contractual Data Submissions to NHS England and NHS Digital

• Design and creation of relational databases and dimensional models

• Understand Health and Social Care data and the respective reporting requirements in order to perform collection, analysis, and submission of data.

• Understand the configuration and use of clinical and non-clinical systems used within the organisation.

• Provide input to projects and programs to ensure alignment with the data management principles, data models and procedures.

About us

About The Company

We change lives by transforming health and care.

Established in 2006, we are one of the UKs leading independent providers of community health and care services, working with health and care commissioners and communities to transform services with a focus on experience, efficiency and improved outcomes. We deliver and transform adult and children community health services, primary care services including urgent care, sexual health, dermatology and MSK services as well as adult social care and wellbeing services.Across England, we support communities of many millions and directly help more than half a million people each year - guided by our simple values: we care, we think, we do.

Were committed to equal opportunities and welcome applications from a broad, diverse range of people who want to join our team. Were a Disability Confident Committed company, so we work to provide facilities, work environment adjustments and technical solutions to be as inclusive of everyone.

While it doesnt happen often, sometimes a role is very popular, and well need to close it earlier than the date weve shown here. If youre keen to join our team, wed love to hear from you so please apply as soon as you can.

To find out more about HCRG Care Group, please visit https://www.hcrgcaregroup.com/about-us-2

Date posted

04 November 2024

Pay scheme

Other

Salary

£45,000 to £50,000 a year

Contract

Fixed term

Duration

12 months

Working pattern

Full-time

Reference number

HCRGCG/TP/1580/12302

Job locations

HCRG Care Group

Coventry

West Midlands

CV7 7NG

Job Description

Job responsibilities

As a BI Developer at HCRG Care Group you will be appreciated for your efforts and have access to exclusive rewards and benefits, including-

• Salary of between £45,000.00 to £50,000.00 with group pension

• Free tea and coffee at your base location

• Membership of My Reward Hub, giving you access to discounts on every day purchases like grocery shopping as well as cashback and voucher offers for treats for you and those special to you

• Access to your wages as you earn them to help cover lifes emergencies and avoid overdraft fees or high interest rates

• Online and face to face help with your mental and physical wellbeing from healthy recipes and activity challenges through to post trauma support, legal, debt and life management help, as well career coaching and counselling

• Access to eLearning, bespoke career pathways and opportunities for continuing professional development through our Outstanding learning and development team, The Learning Enterprise

• An open, just culture where youre encouraged to have and implement ideas which can help us deliver our purpose- changing lives through transforming health and care backed up by at least £100,000 of ringfenced innovation funding each year

• The pride of working for an organisation committed to the highest clinical and quality standards- with a majority of our rated services holding good or outstanding ratings from the Care Quality CommissionThe Ideal Candidate Ideally we are looking for a passionate self-starter with demonstrable experience of the following-

• Degree in a relevant field or equivalent work experience.

• 5+ years of experience with SQL Server including advanced use of T-SQL

• 5+ years of experience developing solutions using SQL Server Integration Services (SSIS)

• Experience of using APIs to pull data

• Strong knowledge of data warehousing using facts and dimensions

• Experience with using reporting tools such as SSRS or Tableau

• Demonstrable ability to understand business requirements, data definitions and produce data management solutions that meet the needs of the business

• Self-motivated, enthusiastic, ability to work under pressure and prioritise workload in order to meet deadlines

Desirable

• Experience of working with NHS data

• Experience of using Azure DevOps

• Experience of using Redgate, Devart or similar tools

Job description Job responsibilities

As a BI Developer at HCRG Care Group you will be appreciated for your efforts and have access to exclusive rewards and benefits, including-

• Salary of between £45,000.00 to £50,000.00 with group pension

• Free tea and coffee at your base location

• Membership of My Reward Hub, giving you access to discounts on every day purchases like grocery shopping as well as cashback and voucher offers for treats for you and those special to you

• Access to your wages as you earn them to help cover lifes emergencies and avoid overdraft fees or high interest rates

• Online and face to face help with your mental and physical wellbeing from healthy recipes and activity challenges through to post trauma support, legal, debt and life management help, as well career coaching and counselling

• Access to eLearning, bespoke career pathways and opportunities for continuing professional development through our Outstanding learning and development team, The Learning Enterprise

• An open, just culture where youre encouraged to have and implement ideas which can help us deliver our purpose- changing lives through transforming health and care backed up by at least £100,000 of ringfenced innovation funding each year

• The pride of working for an organisation committed to the highest clinical and quality standards- with a majority of our rated services holding good or outstanding ratings from the Care Quality CommissionThe Ideal Candidate Ideally we are looking for a passionate self-starter with demonstrable experience of the following-

• Degree in a relevant field or equivalent work experience.

• 5+ years of experience with SQL Server including advanced use of T-SQL

• 5+ years of experience developing solutions using SQL Server Integration Services (SSIS)

• Experience of using APIs to pull data

• Strong knowledge of data warehousing using facts and dimensions

• Experience with using reporting tools such as SSRS or Tableau

• Demonstrable ability to understand business requirements, data definitions and produce data management solutions that meet the needs of the business

• Self-motivated, enthusiastic, ability to work under pressure and prioritise workload in order to meet deadlines

Desirable

• Experience of working with NHS data

• Experience of using Azure DevOps

• Experience of using Redgate, Devart or similar tools

Person Specification

General Requirements Essential

• Click Apply for this job above to view the Job Description on our career site

Desirable

• Click Apply for this job above to view the Job Description on our career site

Person Specification General Requirements Essential

• Click Apply for this job above to view the Job Description on our career site

Desirable

• Click Apply for this job above to view the Job Description on our career site

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

HCRG Care Group

Address

HCRG Care Group

Coventry

West Midlands

CV7 7NG

Employer's website

https://www.hcrgcaregroup.com/ (Opens in a new tab)