Job Introduction

MPS provide the most expert, trusted and valued protection to our members globally which allows them to continue to provide healthcare around the world. We are seeking a talented Data professional to help continue innovation and best practice within our IT services.

Role Responsibility

• Take the lead role in the design, build and management of a dimensionally-modelled data warehouse for a rapidly evolving and growing company
• Define standards for the data warehouse, the integration/migration strategy for data, and data structure conventions
• Assess and recommend changes / improvements too proposed database technologies or options
• Leverage the company’s Microsoft-based BI solutions to deliver automated segmentation and analysis capability
• Work with data services administrators to develop the data objects and data models to support data services in service-oriented architecture
• Formulate and deliver a data warehouse strategy consistent with the requirements of MPS’ business objectives
• Create and provide an optimal and best-in-class analytics and reporting capability with the right distribution channels with the right actionable insights
• Validation routines, developed in conjunction with data analysts, to ensure the accuracy of data and its appropriate use relative to specific compliance issues.

   

The Ideal Candidate

• Microsoft SQL Server Experience, including SQL Server 2012 and ideally up to SQL Server 2016/17, with knowledge of differences in all versions and across all SQL Server editions
• In-depth understanding of database security during their design and deployment
• Expert level knowledge of MS SQL Server (writing queries, stored procedures, performance tuning, etc.), ETL design, processes, strategy and architecture
• At least 5 years’ experience in SQL development
• Proven experience developing bespoke Data Warehouses/Databases throughout the full development lifecycle
• Knowledge of SSRS, SSIS and SSAS
• Data Warehouse, Data Management, Business Intelligence, and Dashboard background, Share Point, Performance Point Server, Power Pivot and Power View, and Microsoft Office2013/16

Package Description

• 12% company pension contribution (3% from the individual)
• Annual bonus scheme up to 10% (for permanent roles)
• Private Medical Insurance
• Health Care Cash Plan
• 25 days annual leave, plus bank holidays

About the Company

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 more than 300,000 members around the world, in countries as diverse as the United Kingdom, South Africa and Hong Kong.
We strive to be much more than a last line of defence by being at our members’ side at every step, offering support, advice and world-class defence. Membership provides access to expert advice and support together with the right to request indemnity for complaints or claims arising from professional practice.
We continue to invest in our team to ensure that we are delivering the best possible service for members. This was recognised in 2016 when we were awarded an Investors in People Silver award.

Medical Protection Society