Data Engineer

This role is largely remote with the occasional across sites when required

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.

You will be responsible for building data product to the specification, and need good knowledge in multiple business data (Strata, Kingfisher, CDL classic, OGI, Marketing, Wholesale, TM1, MISL etc) as well as data exchange to internal and external systems.

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 analysts and stakeholders to translate business requirements into technical solutions
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
Private medical health care 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