About Us
At Direct Line Group, insurance is just the start. Combining decades of industry experience with talented people in every field, we’re a customer-obsessed market powerhouse. And we all work together to be brilliant for customers, every single day.
Underwriting is a complicated world, where risk appetite, guidelines, and data meet talented Underwriters. Setting criteria and managing our footprint is a fine line between balancing our business goals and customer needs. That’s why our Underwriters are the best of the best. They reduce risk, have their fingers on the pulse and predict future events ensuring our business can continue to grow whilst each and every one of our customers gets the right outcomes.
Join us as an Underwriting Data Analyst in our Motor Underwriting Team: We’re looking for an enthusiastic and self-motivated team player to join our exciting team as we look to grow our brands and strengthen our presence in the Motor Insurance market.
What You’ll Be Doing
You will be responsible for the design, creation, and implementation of insights solutions for our Motor Underwriting Team to support the management of portfolios and influence change.
Your typical day could be focused on building an ETL process from an upstream data source and creating tables/views that can be used by a dashboard that you have designed and created. You may also be analysing outputs and presenting back insights from your analysis to various stakeholders, building on your Underwriting experience. You will implement creative approaches to solving complex problems with ambiguous paths to resolution. In addition to building new features, you will constantly be improving and expanding existing solutions to meet the needs of the Underwriting Team.
Your key responsibilities will include:
- Support the management of our Core Motor product portfolio, reviewing how we’re performing and identifying opportunities for improvement
- Consolidating data from various sources via ETL processes
- Iteration, expansion, and maintenance of the data warehouse/DataMart.
- SQL performance tuning
- Dashboard development is preferable in Tableau.
- Analysing data to help DLG get the most out of its data assets in both ad hoc and industrialised environments.
- Pro-actively identifying & solving business problems & bottlenecks.
- Developing solutions to collect and consolidate new data points
- Being responsible for projects throughout their lifespan; from conception, development, launch, and beyond
- Driving best practices and technical excellence
- Enacting and enhancing our underwriting controls through the use of dashboard reporting
- Working in collaboration with a multi-disciplined trading team
What You’ll Need
- Experience working with Tableau
- Deep understanding of SQL
- Strong knowledge of Database and Data Warehousing concepts
- Experienced ETL developer
- Strong Data Visualization skills
- Ability to present to senior stakeholders
- Excellent communication skills
- Exposure to AWS: (Redshift, Lambda, API Gateway, S3, Glue) is a plus.
- Experience of Underwriting in a General Motor Insurance role
- Ability to innovate & work in a fast-paced environment across a breadth of initiatives
Ways of working
Our hybrid model way of working offers a 'best of both worlds' approach combining the best parts of home and office-working, offering flexibility for everyone. When you'll be in the office depends on your role, but most colleagues are in 2 days a week, and we'll consider the flexible working options that work best for you.
This role is available in our London, Bristol, Leeds or Glasgow offices.
Read our flexible working approach here
What We’ll Give You
We wouldn’t be where we are today without our people and the wide variety of perspectives and life experiences they bring. That’s why we offer excellent benefits to suit your lifestyle and a flexible working model combining the best parts of home and office-working, varying with the nature of your role. Our core benefits include:
- 9% employer contributed pension
- 50% off home, motor and pet insurance plus free travel insurance and Green Flag breakdown cover
- Additional optional Health and Dental insurance
- Up to 10% bonus
- EV car scheme allows all colleagues to lease a brand new electric or plug-in hybrid car in a tax efficient way.
- 25 days annual leave, increasing each year up to a maximum of 28
- Buy as you earn share scheme
- Employee discounts and cashback
- Plus many more!
Being Yourself
Difference makes us who we are. We believe everyone should feel comfortable to bring their whole selves to work – that’s why we champion diverse voices, build workplaces that work for people, and invest in the things that matter. From senior leadership to inclusivity networks, adaptive working to inclusion training, we’ve made it our mission to give you everything you need to be authentically you. Discover more at directlinegroupcareers.com
Together we’re one of a kind.
