Data Engineer

The London Clinic; Greater London; Hybrid; GBP 50,000 - 60,000; Full time

Job summary

A leading healthcare provider in Greater London seeks a Data Engineer to support the Business Intelligence team. This full-time role involves managing and analyzing complex data sets within healthcare services, utilizing SQL and Azure for robust data solutions. Responsibilities include data migration, compliance with regulations, and effective stakeholder communication. The ideal candidate will have extensive knowledge of healthcare data, cloud services, and excellent problem-solving abilities. Join a diverse and dedicated team committed to improving patient care.

Benefits

Contributory pension scheme

Private Medical Healthcare

33 days annual leave

Career development opportunities

Qualifications

• Proficient in Azure and cloud databases.
• Experience in managing complex data sets.
• Strong problem-solving skills and attention to detail.

Responsibilities

• Manage and analyze complex healthcare data sets.
• Utilize SQL for database management and ETL processes.
• Implement solutions on Azure ensuring scalability.
• Present data insights to technical and non-technical stakeholders.
• Manage data migration projects with precision.

Skills

Relational Database implementation

Azure and cloud data services

SQL Server expertise

Data architecture

Healthcare data regulations

ETL processes

Power BI Integration

Tools

Microsoft SQL Server

Azure Data Factory

Power BI

Job description

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, 33days 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.
• 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.
• 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 charitable status which is fundamental to our identity and how we operate, enabling our teams to invest in treatments, technology and facilities that benefit our patients, staff and the wider community.

We are committed to safeguarding and protecting all adults at risk, children and young people by implementing robust safer recruitment practices during our selection process. Pre-employment checks are undertaken in accordance with industry standards and regulations, and successful applicants may be required to undertake an Enhanced Disclosure via the Disclosure and Barring Service (DBS). If you would like further information about our safer recruitment policy then please contact a member of our recruitment team.

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;