As our new Data Engineer, you will also:
* Embrace change management processes (projects or small change) to make recommendations to improve delivery.
* Implement data flows to connect operational systems, data for analytics and business intelligence.
* Re-engineer manual data flows to enable scaling and repeatable use.
* Develop data services that are fit for purpose, resilient, scalable, and future proof, to meet user needs.
* Write ETL (extract, transform, load) scripts and code to ensure the ETL process performs optimally.
* Produce data models and understand where to use different types.
* Work with the data services administrators to develop the data objects and data models to support data services in service-oriented data platform.
* Collect and catalogue data and metadata that maintains value over time, is useful and findable to help make insight and analyses – a key strength of the data platform.
* Optimise the code to ensure processes perform optimally.
* Plan, design, manage, execute and report tests, using appropriate tools and techniques.
* Risks associated with deployment are adequately understood and documented.
* Undertake other duties and tasks that from time to time may be allocated to the role holder that are appropriate to the level or role.
The Ideal Candidate
We are looking for:
* Knowledge of industry-recognised data modelling patterns and standards.
* Proficiency in troubleshooting and debugging application Microsoft Azure Experience using Azure Data Factory, Azure SQL DB, Data Lake Gen 2, Synapse (desirable) and any other data modelling tools.
* Experience in using Azure Dev Ops with Git Repository.
* Expert level knowledge of MS SQL Server (writing queries, stored procedures, performance tuning, etc.), ETL design, processes, strategy and architecture.
* Ability to utilise strong data management or data standards concepts for efficient data mapping and curation.
* Experience in a data engineer role as part of data platform.
* Experience in modelling structured, semi-structured and non-structured data.
Please view the role profile for the full list of essential and desirable criteria.
Package Description
Alongside a competitive salary as stated above, you will also receive:
* Up to 15% discretionary annual bonus.
* Annual performance-related pay review.
* 11% pension contribution (3% from you, 8% from us – optional additional matched 3% contributions, e.g. 6% from you, 11% from us).
* 25 days annual leave plus flexible bank holidays (option to buy/sell additional 5 days).
* Private Medical Cover.
* Career development and progression opportunities.
* A truly flexible hybrid-working arrangement (take a look at below to find out more about how we work).
* A culture that promotes inclusivity, wellbeing and rewards hard work.
* Car Salary Sacrifice scheme.
* 6x salary death in service.
* A personal GP service enabling you to get a video consultation with a NHS-registered private GP.
* Employee Assistance Programme.
* A range of shopping discounts from major high-street retailers.
About the Company
About the Team
Technology is at the heart of our organisation. It empowers our colleagues to deliver the best-in-class service to our members, whether that be through our systems, platforms and architecture or robust data insights to help influence business decisions.
It is a very exciting time to get involved in our Member Experience, Digital and Data (MEDD) division, as the team are currently developing new Cloud-based architecture, introducing a new CRM system that will allow for better cross-team collaboration and re-defining our platforms and environments.
How MEDD work
We offer a truly-flexible hybrid working arrangement that is centred around our colleagues’ work-life balance. Technology allows us to collaborate effectively regardless of location, but we know sometimes you can’t beat being with your team in-person and our team tends to come on-site once or twice a month. However, we expect this can fluctuate throughout the year depending on our projects and current work.
Who We Are
Medical Protection Society (MPS) is the world’s leading protection organisation for Doctors, Dentists and healthcare professionals. We protect and support the professional interests of almost 300,000 Members around the world.
We are a not-for-profit organisation, meaning our Members’ premiums are kept safe should our Members require support for complaints or claims arising from professional practice, or invested into bettering the organisation, our colleagues and our products.
Our philosophy is to support safe practice in medicine and dentistry by helping to avert problems in the first place. We also actively campaign for regulatory and legal reforms that benefit Members and the wider healthcare professions.
To do this, we need exceptional colleagues who are trusted and supported to deliver their best work, so we can continue to provide the most trusted, valued and expert protection to members when they need us the most.
Next Steps
If you are interested in finding out more, looking for a new role and want to join an organisation that truly values its employees, take a look at the role profile to find out more about the role to apply.
Our Talent Acquisition team are always on hand should you have any questions, are having any technical issues or wish to understand how MPS can support you with your application and interview. You can contact our friendly Talent Acquisition team by emailing careers@medicalprotection.org
#J-18808-Ljbffr