Senior Data Engineer

Senior Data Engineer

Full-Time 44595 - 54505 £ / year (est.) On-site
Royal Marsden

At a Glance

  • Tasks: Join our team to develop and maintain a cutting-edge data ecosystem for cancer research.
  • Company: The Royal Marsden NHS Foundation Trust, a world-leading cancer centre.
  • Benefits: Flexible working, competitive salary, professional development, and a supportive team environment.
  • Other info: Dynamic workplace with opportunities for career growth and learning.
  • Why this job: Make a real impact in cancer care while advancing your data engineering skills.
  • Qualifications: Degree-level education and experience with Microsoft SQL data warehouses required.

The predicted salary is between 44595 - 54505 £ per year.

The Royal Marsden NHS Foundation Trust is a centre of excellence for research, education, and care in the treatment of Cancer. The Trust has an outstanding reputation for information and has recently implemented a new digital health record, data warehouse and business intelligence solutions. The information team currently support management and clinicians throughout the organisation by providing information and analysis for planning, decision making, quality assurance and improvement. We are further developing our analytical tools and capabilities to rapidly increase the utilisation of anonymised clinical data to support research and to maximise the use of clinical data to increase understanding of the disease and treatment outcomes.

We are looking for motivated experienced data engineer to join our team, to play a pivotal role supporting the Information Development Manager to shape, develop, and maintain the Trusts new data ecosystem. You will be educated to degree level and have experience and expertise in developing and maintaining Microsoft based SQL data warehouses and producing technical documentation to support a wide range of users. You must be self-motivated and possess excellent interpersonal skills and the ability to establish effective working relationships with all levels of staff within and external to the organisation.

Main duties of the job:

  • To develop, maintain and support the corporate data warehouse and Trusted Research Environment. This will include and is not limited to data engineering tasks, data pipeline development, and resolving performance issues.
  • To work with our cloud hosting provider to ensure effective resource utilisation and consumption patterns.
  • To develop complex data structures, data models and Extract Transformation and Load processes using Azure Synapse Analytics and related Azure services to support the trust Data warehouse at the direction of the Database Architect and Data Infrastructure Manager.
  • To apply data engineering techniques including data wrangling, cleansing, transformation and integration to ensure high-quality data pipelines and datasets.
  • Develop, implement, and assist in the maintenance of a data asset catalogue to facilitate data discovery.

Working for our organisation:

The Royal Marsden NHS Foundation Trust is a world-leading cancer centre. Our role is to offer our patients the best cancer care available anywhere in the world, and to continue to make a global contribution to finding better ways of diagnosing and treating cancer. We employ over 4,500 staff in a diverse range of careers including nursing, medical, science, radiography, pharmacy, occupational therapy, finance and administrative services. We have two hospitals – one in Chelsea, London, and one in Sutton, Surrey – as well as a Medical Daycare Unit in Kingston Hospital. At The Royal Marsden, we deal with cancer every day, so we understand how valuable life is. When people entrust their lives to us, they have the right to demand the very best. That's why the pursuit of excellence lies at the heart of everything we do.

At the heart of the hospital is our dedicated team. We offer a stimulating and dynamic working environment, a wide range of staff benefits, learning and development opportunities and clear career pathways. There are opportunities to work flexibly across a range of areas and specialities and we welcome flexible working requests from point of hire to support employees work life balance. We are looking for employees who aspire to excellence, share our values and can play a crucial role in our on-going achievements.

Detailed job description and main responsibilities:

  • To work as part of the Information Development team to develop, support, and enhance the corporate data warehouse environment.
  • Support the integrity of the data warehouse and contribute to the design and implementation of adequate back-up solutions.
  • Contribute to business continuity and disaster recovery planning.
  • Maintain an in-depth knowledge of Microsoft Azure Synapse Analytics, and related Azure data services, and provide expert advice regarding their application, act as a point of escalation for investigation and resolution of complex technical issues.
  • Lead the development and implementation data pipelines using Synapse Pipelines and other ETL/ELT tools to ingest, transform and load data from various sources.
  • Act as the SME for data engineering, providing authoritative input on schema design, data quality, and interoperability.

Person specification:

Education/Qualifications:

  • Educated to degree level (or equivalent qualification/experience)
  • Evidence of on-going professional development
  • Microsoft certified: Azure Fundamentals, Data Fundamentals, Database Administrator, Designing & implementing DevOps Solutions

Experience:

  • Significant experience in a database developer role in a multi-professional organisation
  • Evidence of having developed complex database systems
  • Evidence of having administered Azure data warehouses including but not limited to: SQL Server including SSIS, T-SQL, Data Factory/ Synapse Pipelines, Azure DevOps, including Repos & Test Plans, Azure Data Catalogue, Serverless application development
  • Knowledge and understanding of modern data analytics platforms including but not limited to: Python, R, PowerBI, Office 365
  • Experience of working within an Agile and Continuous Integration environment
  • Knowledge and experience of working with sensitive information within the NHS
  • Knowledge and understanding of Machine Learning data pipelines

Skills Abilities/knowledge:

  • A strong commitment to customer service delivery and excellent organisational skills
  • Ability to evaluate and respond to rapidly changing operational situations, often under pressure and with changing and sometimes conflicting priorities
  • Excellent communication skills especially when dealing with complex technical information and colleagues who have limited IT knowledge and understanding
  • Ability to document technical procedures/standards
  • An in depth understanding of schema creation for databases & management of permissions
  • Well-developed technical troubleshooting, problem solving and analytical skills
  • Ability to create data transformations and data pipelines
  • Data ingestion (unstructured, semi-structured and structured data) from various sources
  • Scripting experience and experience of working with Azure data factory
  • Administration of Azure Active Directory
  • Data modelling techniques & processes
  • Ability to negotiate with senior leaders and provide alternative solutions to complex issues as means to find a mutual agreement.
  • Highly motivated with the ability to influence and inspire others
  • Willingness and ability to develop self by learning new technologies and applications in relation to the needs of the role

The Royal Marsden values diversity and is committed to the recruitment and retention of underrepresented minority groups. We particularly welcome applications from Black, Asian and minority ethnic candidates, LGBTQ+ candidates and candidates with disabilities. As a Disability Confident Employer, we are working to create a workplace that enables all staff to reach their full potential. We are committed to this because we know that greater diversity and inclusion will lead to an even greater positive impact for the people we serve.

Due to the high volumes of applications we receive, we reserve the right to close any adverts before the published closing date once we have received a sufficient number of applications. We advise you to submit your application as early as possible to prevent disappointment. Please ensure your information is accurate to avoid errors with processing your application. All applicants will be contacted by email to the address supplied on your application. Applicants are advised to check their email accounts regularly and to ensure that email filters are set to allow our emails.

Flu Vaccination – What We Expect of our Staff:

At The Royal Marsden we have an immune compromised patient population who we must protect as much as we can against the flu virus. Each year, seasonal flu affects thousands of people in the UK. Occurring mainly in winter, it is an infectious respiratory disease capable of producing symptoms ranging from those similar to a common cold, through to very severe or even fatal disease. The wellbeing of our staff and patients is of the upmost importance to us, and it is the expectation of The Royal Marsden that all patient-facing staff have an annual flu vaccination, provided free of charge by the Trust.

Senior Data Engineer employer: Royal Marsden

The Royal Marsden NHS Foundation Trust is an exceptional employer, offering a collaborative work culture that prioritises innovation and excellence in clinical genomics. Employees benefit from comprehensive professional development opportunities, a supportive environment, and the chance to contribute to groundbreaking research in a prestigious institution located in Sutton and Chelsea, renowned for its commitment to advancing cancer care.

Royal Marsden

Contact Details:

Royal Marsden Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data Engineer

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Royal Marsden!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Data Engineer at Royal Marsden.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Royal Marsden.

✨Apply Directly through Our Website

When you find a suitable opening like Senior Data Engineer at Royal Marsden, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace Senior Data Engineer

Python
Data Engineering
Problem-Solving Skills
Communication Skills
Data Pipeline Development
Data Governance
Data Quality Assurance

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at Royal Marsden, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Royal Marsden. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at Royal Marsden

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Royal Marsden!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.