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. With senior stakeholder engagement across the business, now is a really exciting time to join IPRS
As a new Data Engineer for IPRS Health, you will play a critical part in the success of the Data Warehouse project. Utilising the appropriate technologies and best practice methodologies, you will be our subject matter expert on database creation, cleansing, ETLs, ingestion and maintenance.
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 also 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 IPRS 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.
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. With senior stakeholder engagement across the business, now is a really exciting time to join IPRS
The Role
As our new Data Engineer for IPRS Health you will play a critical part in the success of the Data Warehouse project. Utilising the appropriate technologies and best practice methodologies, you will be our subject matter expert on database creation, cleansing, ETLs, ingestion and maintenance.
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 also 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 IPRS team where you are give 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.
Responsibilities
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
We are looking for our new Data Engineer to be a team player, with excellent communication skills, ability to demonstrate attention to detail, 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 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.

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 (We would consider applications from those wishing to condense their hours)
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