Data Engineer

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