At a Glance
- Tasks: Join our team to develop and maintain a cutting-edge data ecosystem for healthcare.
- Company: The Royal Marsden NHS Foundation Trust, a leader in cancer treatment and research.
- Benefits: Competitive salary, supportive work environment, and opportunities for professional growth.
- Other info: Be part of a Disability Confident employer committed to inclusivity.
- Why this job: Make a real difference in healthcare by optimising data for research and patient outcomes.
- Qualifications: Degree-level education and experience with Microsoft SQL data warehouses required.
The predicted salary is between 37338 - 44962 £ per year.
Role Overview
The information team currently supports management and clinicians throughout the organisation by providing information and analysis for planning, decision making, quality assurance and improvement. We are further developing analytical tools and capabilities to rapidly increase the utilisation of anonymised clinical data to support research and improve understanding of disease and treatment outcomes. We are looking for a motivated data engineer to join our team to play a pivotal role supporting the Information Development Manager in shaping, developing and maintaining the Trust's new data ecosystem.
Responsibilities
- Maintain and manage the corporate data warehouse and Trusted Research Environment; monitor databases, resolve performance issues, test system upgrades and patches.
- Pro‑actively optimise environment performance in collaboration with the cloud hosting provider, exploring and recommending cost‑reduction opportunities.
- Develop complex data structures, data models and ETL processes to support the Trust data warehouse under the direction of the Database Architect.
- Develop, implement, and assist in the maintenance of a data asset catalogue to facilitate data discovery.
- Work with information analysts, performance managers and data quality managers to develop data models that enable self‑service analytics in a controlled and governed way.
- Build, manage, monitor and develop the corporate data warehouse environment.
- Ensure data warehouse integrity, design and build adequate backup solutions.
- Contribute to business continuity and disaster recovery planning.
- Maintain an in‑depth knowledge of Microsoft Azure and SQL Server, and act as a point of escalation for complex technical issues.
- Review requirements and specifications for implementation, testing, deployment and maintenance of new data models.
- Monitor service component capacity and resource costs, initiating actions to resolve shortfalls according to agreed procedures.
Qualifications
- Degree‑level education.
- Experience and expertise in developing and maintaining Microsoft‑based SQL data warehouses.
- Ability to produce technical documentation supporting a wide range of users.
- Self‑motivated with excellent interpersonal skills and the ability to establish effective working relationships with staff at all levels, both within and outside the organisation.
Disability Confident
A Disability Confident employer will generally offer an interview to any applicant who declares they have a disability and meets the minimum criteria for the job as defined by the employer. In certain recruitment situations such as high‑volume, seasonal and high‑peak times, the employer may limit the overall number of interviews offered to both disabled and non‑disabled people.
Data Engineer | The Royal Marsden NHS Foundation Trust in Belmont employer: The Royal Marsden
The Royal Marsden NHS Foundation Trust is an exceptional employer, offering a collaborative work culture that prioritises innovation and professional growth. As a key player in the healthcare sector, employees benefit from meaningful work that directly impacts patient care, alongside opportunities for continuous learning and development in a supportive environment. Located in a prestigious institution, the Trust fosters a commitment to diversity and inclusion, ensuring all staff feel valued and empowered.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer | The Royal Marsden NHS Foundation Trust in Belmont
✨Tip Number 1
Network like a pro! Reach out to current employees at The Royal Marsden NHS Foundation Trust on LinkedIn. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Prepare for the interview by brushing up on your SQL and Azure skills. We recommend doing some mock interviews with friends or using online platforms to practice common data engineering questions.
✨Tip Number 3
Showcase your projects! If you've worked on any relevant data models or ETL processes, be ready to discuss them in detail. We love seeing real-world applications of your skills.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the team.
We think you need these skills to ace Data Engineer | The Royal Marsden NHS Foundation Trust in Belmont
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Engineer role. Highlight your experience with Microsoft SQL and any relevant projects you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our team at The Royal Marsden. Keep it engaging and personal.
Showcase Your Technical Skills:Don’t forget to mention your technical skills, especially around Azure and SQL Server. We love seeing specific examples of how you've used these technologies in past roles or projects.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates!
How to prepare for a job interview at The Royal Marsden
✨Know Your Data Inside Out
Make sure you brush up on your knowledge of Microsoft Azure and SQL Server. Be prepared to discuss your experience with data warehouses and ETL processes, as well as any specific projects you've worked on that relate to the role.
✨Showcase Your Problem-Solving Skills
Think of examples where you've resolved performance issues or optimised database environments. Be ready to explain your thought process and the steps you took to achieve successful outcomes.
✨Understand the Trust's Mission
Familiarise yourself with The Royal Marsden NHS Foundation Trust's goals and how your role as a data engineer can contribute to improving patient care and research. This will show your genuine interest in the position and the organisation.
✨Prepare for Technical Questions
Expect to face technical questions related to data modelling, backup solutions, and disaster recovery planning. Practise explaining complex concepts in simple terms, as you'll need to communicate effectively with various stakeholders.
