Data Engineer, Leeds

As part of our digital transformation, Medical Protection Society is seeking a talented Data Engineer to join the Data and Analytics Team to develop data products and services and integrate them into our systems and business processes. You will be responsible for analysing raw data to build and manage the datasets on our data platform, enabling wider consumption of data by the end users and will play a key role in the transformation of data into models that can be used for analytics and reporting

As our new Data Engineer, you will also:

• Embrace change management processes (projects or small change) and partner with the appropriate teams and business analysts to make business recommendations to assist in delivering reporting, insight, process improvements, or strategies that support MPS in delivering its vision, values, and purpose.
• Implement data flows to connect operational systems, data for analytics and business intelligence
• Document source-to-target mappings
• 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 scripts and code to ensure optimal performance in the ETL process
• Produce relevant data models
• Plan, design, manage, execute and report tests, using appropriate tools and techniques.
• Understand and document risks associated with deployment

We are looking for:

• Proven experience working in a Data Engineer role within a data platform environment
• Strong experience in data modelling, including structured, semi-structured, and unstructured data
• Experience developing and maintaining data dictionaries and data catalogues
• Solid understanding of data integration principles, including exposing data via APIs, linking data across multiple systems, and delivering streaming data services
• Hands-on experience with Microsoft Azure, including Azure Data Factory, Azure SQL Database, Data Lake Gen2, Synapse Analytics, and related data modelling tools
• Experience with Databricks is highly desirable
• Ability to reverse engineer data models from live/legacy systems
• Experience using Azure DevOps and Git repositories for version control and collaboration
• Strong proficiency in Microsoft SQL Server, including query writing, stored procedures, and performance tuning
• In-depth knowledge of ETL design, processes, strategies, and architecture

We welcome applicants from all backgrounds, and we encourage you to apply even if you feel you do not match 100% of the technical requirements. We celebrate diversity, promote inclusivity and strive to create a work environment which ensures everyone can be heard.

• Discretionary on-target bonus of 10%. Up to a max 20% based on performance
• 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. Flexible public holidays and option to buy/sell additional leave
• Private Medical Cover
• Car Salary Sacrifice scheme
• 6x salary death in service
• Holistic health and wellbeing support package
• A truly flexible hybrid-working arrangement
• A culture that promotes inclusivity, wellbeing and rewards hard work