Data Engineer

Job Description

THE COMPANY:
Meddbase is an online digital healthcare framework which has been designed and developed by Medical Management Systems Ltd.

In 2004, we created a comprehensive healthcare web-application that runs all aspects of a medical practice, from GP practices up to large hospitals groups. Our product enables single and multiple location private medical practices to connect securely to their data from any location worldwide. The business is thriving and we are proudly the leading online medical management system on the UK market.

Purpose of the role:
The majority of new Meddbase customers have pre-existing data that needs to be migrated into our platform. These can be in-house bespoke systems created by the customer or off the shelf solutions.

We have recently updated our approach to data migrations to take advantage of advances in industry-standard data tools and technologies. You will be working on a daily basis with Python, PySpark, Synapse, SQL and Azure tools and services, as well as developing a deep understanding of our proprietary data schemas and product features.

Beyond the technology, a successful data migration depends on regular, high-quality communication with clients, transparency and rigour in our processes, documentation and auditing. In a growing team you’ll be expected to contribute positive ideas and feedback on the process to help us constantly get better.

Each data migration will follow a standard process, as we aim to provide predictable delivery to project managers and clients. You’ll work with clients and the project manager to analyse, map, define and sometimes clean their data and propose solutions to issues that arise. You’ll write defensive, repeatable transformation notebooks that ensure integrity and lineage of the transformed data. Together with the Project Manager and clients, you’ll help to estimate and break down the work into manageable chunks. Finally, you’ll see the data through testing and sign off to its destination in a live system supporting health professionals in the delivery of excellent care.

Key responsibilities:
Project responsibilities
Liaise with clients to take receipt of their data.
Work with client to define their data.
Provide data integrity reports and propose solutions for issues.
Estimation and time management.
Regular updates to all stakeholders on progress and blockers.
Assuring the quality of a data migration.
Providing guidance to clients on performing successful UAT.
Establish robust data pipelines from source data to curated data.
Post-import hyper-care.
Ensuring the security and privacy of their data throughout.

Team responsibilities
Maintain standard schemas for the Meddbase product and transformers for commonly migrated source systems.
Building and maintaining common tools.
Support QA with test suites, data sets, automation and the raising of data import related defects in the application.
Building and maintaining documentation and user guides to streamline the data migration process.

Key kills & Qualifications:
Willingness and ability to engage with advanced background checks including police vetting. Non-Police pVetting Level 3 NPPV3.
Expertise in ETL.
Expertise in data investigation, rationalising, and manipulation.
Expertise in version control.
Expertise in Azure tool and services.
Expertise in PySpark, Python, SQL 5.
Client-facing experience.
Healthcare experience.
Understanding of data governance and compliance standards.
Data Engineering Certificates, such as Azure Data Engineer Associate (DP-203).

Salary information:
Salary for this role is £40,000 - £45,000 per annum.

Note to applicants:
Suitable candidates applying for this role MUST be living in the UK for a minimum of 3 years to be eligible for NPPV3 clearance to access our high security environment.

Working at Meddbase:
Our working environment is genuinely friendly, inclusive and comfortable.

Our London office is located minutes from Fenchurch Street Station, whilst our Southampton office is minutes from Southampton Central Station. Both offices have excellent bike storage and shower facilities.

We operate a flexi-hours scheme between 8.30am – 6.00pm with an hour for lunch. You will not be expected to work extremely long hours, as so often happens in software companies. We prefer the approach of ‘it’s a marathon not a sprint’, so we actively discourage working gruelling hours. Meddbase creates opportunities for everyone to socialise and spend time together informally. We offer a few different clubs, including a technical book club and a 5km running club. Additionally, our employee-led MeddLife committee arranges charity events, quizzes and other fun events across the year.

We provide breakfast cereals daily, as well as beverages and fruit.

Company Benefits:
We offer competitive salaries for all our roles and have a comprehensive benefits package. Our benefits include:

25 days of annual leave, plus bank holidays
Subsidised gym membership
Life assurance
Access to an Employee Assistance Programme
Private healthcare insurance for dental, medical and optical (length of service conditions apply)
Enhanced maternity and paternity pay
Sabbatical leave
Eye test vouchers
Flexi-hours

Development & Support:
Once you join our team, we will ensure you benefit from a thorough on-boarding programme. Aside from regular 121s, appraisals and informal check-ins, all employees have access to training and professional development opportunities.

Compliance:
Medical Management Systems is ISO 27001:2013 accredited and maintains various other standards to ensure best practice and DPA2018/GDPR compliance. As part of your role, you will be expected to undertake information security training on an annual basis. Furthermore, you will need to maintain awareness of and follow company policies on secure information handling.

Diversity:
Meddbase is an equal opportunities employer. All applicants will be considered for employment without attention to race, colour, religion, sex, sexual orientation, gender identity or disability status.