Data Engineer

IPRS Health; Ipswich; Hybrid; GBP 38,000 - 45,000; Full time

Job summary

A healthcare service provider is seeking a Data Engineer to design and maintain a new Data Warehouse. This hybrid role involves engaging with stakeholders and using Microsoft Fabric to enhance data infrastructure. Responsibilities include developing data pipelines and ensuring data integrity. The ideal candidate will possess strong SQL skills and experience in database administration. Competitive salary and benefits included.

Benefits

Flexible Working

Professional Development Opportunities

Employee Assistance Programme

High-street discounts

25 days annual leave plus bank holidays

Company pension scheme

Recruit a Friend bonus scheme

Free Eye Tests

Free annual Flu-Vaccination

Qualifications

• Experience of MS Fabric as a Data Warehouse.
• Experience with backups, restores and recovery models.
• Knowledge of cloud-based data warehouses.

Responsibilities

• Designing and building data infrastructure.
• Developing and maintaining data pipelines.
• Troubleshooting and resolving data issues.

Skills

Microsoft Fabric

Database Administration

SQL Skills

Data Analysis

Communication Skills

Attention to Detail

Problem Solving

Education

Degree in Mathematics/Statistics or related subject

Higher education qualification in computer-related subject

Tools

Power BI

SQL Server

Job description

IPRS Health are an award-winning provider of physiotherapy & mental health services, putting patients at the heart of everything we do, ensuring a smooth and successful journey to recovery. We work for a diverse range of clients, including the NHS with our services having a huge impact into improving the lives of thousands of people every year.

We are looking for a Data Engineer to play a pivotal role in designing, building and maintaining our new Data Warehouse as well as putting DBA best practices in place against systems. With senior stakeholder engagement across the business, now is a really exciting time to join IPRS!

This position is for HYBRID working where you will be required to attend our office in Claydon, Suffolk IP6 0FU.

Position:

As our new Data Engineer for IPRS Health you will play a critical part in the success of the Data Warehouse project in Microsoft Fabric. Utilising the appropriate technologies and best practice methodologies, you will be our subject matter expert on database creation, cleansing, ETLs, ingestion and ongoing maintenance. (70%).

You will also have responsibility for taking over the lite aspects of the Database Administrator (DBA) role; You will be responsible for the performance, integrity, and security of our in-house software databases, including monitoring database performance, troubleshooting issues and helping maintain backup and recovery strategies. (30%).

This is a cross-team role, primarily reporting into the Data Analytics Manager, with a dotted line to the Development Team Lead.

Because of this, you will be expected to work a hybrid model, attending our Suffolk Head Office based in Claydon, 4 times a month / once a week.

You will be working within a highly collaborative environment and dealing with stakeholders at all levels and across teams within the business. Whilst you will be supported across both the Data and Development Teams, you will be given the autonomy to take ownership of this new role and really showcase the art of possible.

With innovation, quality, flexibility and clinical focus at the heart of everything we do, it really is an exciting time to join the team, where you are given real opportunity to see the difference that you're making.

Your success will enhance IPRS's current data offering; creating a future-focused BI platform for both internal and external customers and support our vision of becoming an industry leading data analytical organisation.

As a Data Engineer for IPRS Health, you will be responsible for designing, building and maintaining the data infrastructure of IPRS Health, including:

• Designing and building data infrastructure
• Developing and maintaining data pipelines
• Ensuring data quality and consistency
• Collaborating with other teams
• Building and maintaining data tools
• Troubleshooting and resolving data issues
• Monitoring and optimizing data pipelines
  
  

Requirements:

Who We Are Looking For

We are looking for our new Data Engineer to be a team player, with excellent communication skills, ability to demonstrate strong attention to detail, experience in Microsoft Fabric and database administration are essential, with a strong and wide ranging understanding of various database methodologies, a desire to expand on their skillset, be curious and innovative, and to be motivated to contribute to helping thousands each year.

To be seriously considered for this role, please have the following:

Qualifications:

Minimum of higher education qualification (A-Levels, BTEC National Diploma, Higher National Diploma) in a computer related subject (E)

Degree in Mathematics/Statistics or related subject which includes formal training in data analysis (D)

Experience:

Experience of MS Fabric as a Data Warehouse (E)

Experience with backups, restores and recovery models (E)

Experience with Dashboarding Packages, specifically Power BI (E)

Strong SQL Skills (E)

Knowledge:

Knowledge MS Windows and SQL Server Administration (E)

Strong Understanding of Relational Database Design (E)

Strong understanding of data warehouse design, ETL processes and tools, and various data modelling concepts (E)

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server (E)

Working Understanding of SQL Server Integrated Services and SQL Server Agent Jobs (E).

Knowledge of additional programming language (R, Python etc) (D)

Knowledge of cloud based data warehouses (D)

Skills:

Ability to demonstrate excellent attention to detail.

Logical decision making and a hands-on approach.

Desire to expand skills.

Ability to manage time to meet agreed deadlines in a demanding environment.

Ability to communicate effectively across technical and non-technical stakeholders and colleagues.

Confident with the ability to operate in a changing environment.

Ability to work under minimum supervision and on own initiative.

Problem solving.

Other information:

Salary: £45.000 per annum

Location: Hybrid working mix of Home and Office (Claydon IP6 0FU)

Hours: Full time 40 hours per week Mon-Fri (Standard working pattern, although happy to facilitate and review compressed/flexible work requests )

Position: Permanent full-time contract

Benefits

Colleagues are essential to IPRS Health, which is why we give so much in return for their hard work. In addition to a competitive salary, we offer a range of benefits, including:

Flexible Working

Professional Development Opportunities

Employee Assistance Programme including free confidential counselling

High-street discounts

25 days’ annual leave plus 8 days’ bank holidays; increasing with completed years’ service & opportunity to purchase additional leave

Moving Day Leave

Membership of the Company pension scheme

Recruit a Friend bonus scheme – up to £1,500

Environmental Initiatives

Westfield Health Cash Plan

Free Eye Tests every 2 years

Free annual Flu-Vaccination