BI Developer

HCRG Care Group; Runcorn; Remote; GBP 45,000 - 50,000; Full time

Job summary

An innovative healthcare organization is seeking a skilled BI Developer to enhance data management and reporting processes. This remote role focuses on building and maintaining ETL processes using SQL Server and SSIS, with opportunities to impact patient care positively. The ideal candidate will have extensive experience in SQL Server, data warehousing, and reporting tools, and be passionate about transforming health and care services. Join a forward-thinking team dedicated to improving community health outcomes and enjoy a supportive work environment with numerous benefits.

Benefits

Group pension

Free tea and coffee

Discounts on everyday purchases

Access to wages as you earn

Support for mental and physical wellbeing

Access to eLearning and professional development

Inclusive culture encouraging ideas

Qualifications

• 5+ years of experience with SQL Server and advanced T-SQL.
• Strong knowledge of data warehousing and reporting tools.

Responsibilities

• Build and maintain ETL processes on SQL Server using T-SQL and SSIS.
• Design and create facts and dimensions in the Data Warehouse.

Skills

T-SQL

SQL Server Integration Services (SSIS)

Data Warehousing

APIs

Reporting Tools (SSRS, Tableau)

Business Requirements Analysis

Self-Motivation

Education

Degree in a relevant field

Tools

Azure DevOps

Redgate

Devart

Job description

Job Introduction

With all the exciting changes happening due to business growth, we’re 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 role is home-based with the requirement to travel to the Runcorn Head office when needed.

Main Responsibilities

Your main responsibilities will include:

1. Building and maintaining ETL processes on SQL Server using T-SQL and SSIS to achieve project goals
2. Designing and creating facts and dimensions in the Data Warehouse
3. Interpreting complex business requirements and converting them into robust data solutions
4. Assisting with BAU tasks such as contractual Data Submissions to NHS England and NHS Digital
5. Design and creation of relational databases and dimensional models
6. Understanding Health and Social Care data and the reporting requirements for data collection, analysis, and submission
7. Understanding the configuration and use of clinical and non-clinical systems within the organization
8. Providing input to projects and programs to ensure alignment with data management principles, data models, and procedures

Please see the attached job description for the full list of responsibilities.

The Ideal Candidate

We are looking for a passionate self-starter with demonstrable experience in the following:

Essential:

• 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 reporting tools such as SSRS or Tableau
• Ability to understand business requirements, data definitions, and produce data management solutions that meet business needs
• Self-motivated, enthusiastic, able to work under pressure and prioritize workload to meet deadlines

Desirable:

• Experience working with NHS data
• Experience using Azure DevOps
• Experience with Redgate, Devart, or similar tools

Package Description

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 between £45,000 and £50,000 with group pension
• Free tea and coffee at your base location
• Membership of My Reward Hub for discounts on everyday purchases, cashback, and vouchers
• Access to wages as you earn them to help cover emergencies
• Support for mental and physical wellbeing, including recipes, activity challenges, trauma support, legal, debt, and life management help, career coaching, and counselling
• Access to eLearning, career pathways, and professional development through The Learning Enterprise
• An open, inclusive culture encouraging ideas to help deliver our purpose of transforming health and care
• Working for an organization committed to high clinical and quality standards, with many services rated 'good' or 'outstanding' by the CQC

About The Company

We change lives by transforming health and care. Established in 2006, we are a leading independent provider of community health and care services in the UK, working with health and care commissioners and communities to improve services and outcomes. We support millions across England and directly help over half a million people annually, guided by our values: we care, we think, we do.

We are committed to equal opportunities and welcome applications from diverse backgrounds. We are a Disability Confident employer, providing inclusive facilities and adjustments. We prioritize safeguarding and safer recruitment practices, including criminal record checks.

By applying, you agree to our processing of your information as detailed in our privacy policy.