We have an exciting opportunity for a Data Engineer to join our Business Intelligence Team within our IT Directorate here at The London Clinic. The ideal candidate will possess a deep understanding of healthcare data, advanced SQL skills, and extensive experience in Azure and cloud data management. This role is based at our head office in Central London with remote working available, and we are offering a competitive salary up to 48,000 per annum.
Established in 1932, The London Clinic is one of the UK's largest independently owned non-profit hospitals, with state-of-the-art facilities located on Harley Street. We have circa 1300 employees, a total of 8 premises, and we are dedicated to providing the best, personalised healthcare with a breadth of surgical and medical expertise.
Job Description
As the Data Engineer you will work within the Business Intelligence team delivering transformation projects. You will assist in the planning, design, development, testing and implementation of complex healthcare services this will also include reports, visualisations, dashboards, database(s) including healthcare and financial systems source data.
- Job Type: Full Time, permanent position.
- Hours: 37.5 hours per week; Mon – Fri within the core hours of 9am – 5.30pm.
- Location: The London Clinic Head Office – NW1 4LJ (Remote working available).
- Benefits package: We offer a comprehensive package including a contributory pension scheme (total annual contribution up to 20%), Private Medical Healthcare, 33 days annual leave (inclusive), as well as a wide range of other benefits. We also offer excellent career development opportunities.
Duties & Responsibilities
- Apply your knowledge of healthcare systems to manage, analyse, and interpret complex data sets, ensuring compliance with healthcare regulations and standards.
- Utilise advanced SQL coding skills for database management and employ ETL tools to transform and load data efficiently.
- Implement, manage, and maintain data solutions on Azure and other cloud platforms, ensuring robustness and scalability.
- Implement, manage and maintain MS Fabric Platform
- Implement, maintain CI/CD and Source Control Technologies.
- Implement, maintain Power Platform and support creation of Power Apps
- Clearly articulate ideas, solutions, and data insights to both technical and non-technical stakeholders. Prepare and present detailed documentation and reports.
- Conduct in-depth data analysis to inform decision-making. Manage and execute data migration projects with precision and attention to detail.
- Proactively identify problems and devise effective data-driven solutions. Present and implement these solutions to improve data management and operations.
- Design and implement automated systems for data processes, enhancing efficiency and accuracy.
- Apply strong problem-solving skills to tackle complex data challenges, focusing on data cleansing, reconciliation, creating value and optimizing performance.
- Develop comprehensive documentation for data processes and systems. Prepare reports and presentations for internal use and compliance purposes.
Be central to the creation and evolution of design, and architecture of new and existing products and product components.
- Work closely with the relevant teams to identify gaps in the current application landscape and document the existing architecture.
- Support the Business Intelligence & Engineering Team with Migration Projects and support tasks.
- Data Modelling of new and existing databases and BI Solutions ensuring best practises are always followed.
- Be involved in end-to-end development, full lifecycle projects including delivering of reporting solutions.
Skills & Experience
- Experience of Relational Database implementation, operations and/or solution deployment in Microsoft SQL Server.
- Proficiency in Azure and other cloud data services.
- Excellent understanding of SQL Server and the Microsoft development stack, with Cloud Solutions experience using tools such Azure, Data Factory, Fabric, Power Platform.
- Experience in implementing and maintain CI/CD and Source Control Solutions.
- Experience in data architecture as well as working with data warehouses, data modelling techniques, tabular models, security, GDPR and PII data handling principles.
- Profound knowledge of healthcare data, including privacy and compliance regulations
- Proven experience in ETL processes, Database Automation Tools, Data Quality and Master Data Management and Power BI Integration and deployment.
Wherescape Red Experience is an advantage. - Proven experience in Power BI Visualisations, Dashboards and Dax.
- Experience in a data engineering role, preferably within the healthcare sector
- Excellent communicator, both verbally & written, and self-motivated with the ability to work independently and under pressure with good problem-solving skills.
- Experience in creating automated data solutions and system designs.
- Detail-oriented with strong analytical and problem-solving abilities.
- Ability to work independently and collaboratively in a team environment
The London Clinic has a supportive and warm working culture where your contribution is valued, and you can help us provide the best, personalised healthcare, and deliver our three core values of; Caring, Inspiring and Pioneering. We are an organisation that has charitable status and this helps us to drive forward our mission of reinvesting our income to deliver better patient outcomes.
The London Clinic is proud of its diverse workforce and is committed to building a team that represents a variety of backgrounds, perspectives, and skills. We absolutely welcome applicants from underrepresented groups; if you think you have the skills and experience for the job, please apply – we would love to hear from you regardless of your background.
