Data Engineer

This role is largely remote with the occasional travel.

We are seeking an experienced Data Engineer who is skilled in all toolsets in data platforms including Azure SQL, data lake, Databricks and data factory, and specialised in building high performance, highly scalable and cost-effective data solution within time and budget.

We are looking to improve and centralise data and you will be responsible for tactical and strategic improvements to data flows across the Pricing and Underwriting department. This role will sit within Data Science and Machine Learning, but with close relationship with the wider Data Engineering team.

Key Accountabilities & Responsibilities:

Develop, maintain, and document high-quality data products using Databricks, ensuring code is performant and written to a high standard
Collaborate closely with business stakeholders, data architects and the Machine Learning team to translate business requirements into technical solutions
From a tactical perspective, improve the useability of data in the business: access and consolidation of data from different systems, loading of missing data, fixing of inconsistent data items, and creating a useable gold layer
Implement data pipelines for business use cases, such as geographic or vehicle data updates
Monitor, troubleshoot, and resolve data issues to ensure reliability and performance
Support team delivery to ensure projects are completed on time
Work with modern development lifecycle tools and practices, including test automation and Continuous Delivery
Communicate complex technical concepts clearly to non-technical audiences
Act as a positive, approachable technical lead and support other team members
Maintain robust data dictionaries and dimensional data models
Apply strong analytical thinking and stay up to date with existing and emerging technologies
Demonstrate expertise in SQL, data warehousing, dimensional modelling, Databricks, Data Lakes, and knowledge of CDL Kingfisher, Classic data, OGI, and main PAS data sources

Skills, Experience & Knowledge:

Development experience in SQL programming and systems integration
Strong knowledge of SQL, data modelling, data warehousing concepts, and Kimball methodology
Experience within Insurance or Broking (preferred)
Proven experience building and maintaining Databricks notebooks
Solid understanding of the Azure data environment
Experience with Python for scripting and data processing
Strong project management skills, including managing multiple requests and senior stakeholders
Ability to understand and translate business needs into clear technical and functional requirements
High level of commercial and operational awareness of data
Comfortable working in a demanding, fast-paced environment
Up-to-date knowledge and hands-on experience with modern data technologies and delivery methods

Why us?

Markerstudy Insurance Services Limited (MISL) is one of the largest Managing General Agents in the UK. With a strong presence in the UK motor insurance market, we specialise in niche motor cover, where our solid market knowledge and experience enables us to create highly targeted products.

Our success is underpinned by our underwriting strategy to identify and apply special risk factors to the customers’ advantage. That, and our skilled underwriting technicians who are friendly, accessible and empowered to make decisions.

We only transact business through professional UK insurance intermediaries and we take pride in fostering excellent working relationships. Our products feature prominently on Aggregators' sites, such as Confused.com, Go Compare and Compare the Market, via our broker partners.

What we offer in return?

A collaborative and fast paced work environment
Health care cash plan
24 days annual leave plus Bank Holidays and the ability to buy additional leave (annual leave also increases with service)
A benefit scheme that offers discounts and cashback on shopping, restaurants, travel and more
Life Assurance 4x annual salary