At a Glance
- Tasks: Design and implement insights solutions for the Motor Underwriting Team.
- Company: Direct Line Group is a customer-focused insurance powerhouse with decades of industry experience.
- Benefits: Enjoy flexible hybrid working, 25 days annual leave, and a 9% employer pension contribution.
- Why this job: Join a dynamic team, solve complex problems, and make a real impact in the insurance market.
- Qualifications: Experience with Tableau, SQL, ETL processes, and strong data visualisation skills required.
- Other info: Work from London, Bristol, Leeds, or Glasgow with a focus on inclusivity and diverse voices.
The predicted salary is between 36000 - 60000 £ per year.
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.
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.
Together we’re one of a kind.
Underwriting Data Analyst employer: Direct Line Insurance Group plc
Contact Detail:
Direct Line Insurance Group plc Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Underwriting Data Analyst
✨Tip Number 1
Familiarise yourself with the latest trends in data analytics and underwriting. Understanding how data influences decision-making in the insurance sector will help you stand out during discussions with the hiring team.
✨Tip Number 2
Network with professionals in the insurance and data analytics fields. Attend industry events or webinars to connect with potential colleagues and learn more about the company culture at Direct Line Group.
✨Tip Number 3
Brush up on your SQL and Tableau skills. Since these are crucial for the role, consider taking online courses or working on personal projects that showcase your ability to create dashboards and perform data analysis.
✨Tip Number 4
Prepare to discuss your experience with ETL processes and data warehousing. Be ready to share specific examples of how you've used these skills to solve complex problems in previous roles, as this will demonstrate your fit for the position.
We think you need these skills to ace Underwriting Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the Underwriting Data Analyst role. Emphasise your proficiency in SQL, ETL processes, and data visualisation tools like Tableau.
Craft a Compelling Cover Letter: Write a cover letter that showcases your enthusiasm for the role and the company. Mention specific projects or experiences that demonstrate your ability to solve complex problems and work collaboratively within a team.
Showcase Your Technical Skills: In your application, clearly outline your technical skills, especially your experience with SQL, data warehousing concepts, and any exposure to AWS services. Provide examples of how you've used these skills in previous roles.
Prepare for Potential Questions: Think about how you would answer questions related to your experience in data analysis and underwriting. Be ready to discuss specific challenges you've faced and how you approached them, as well as your understanding of the insurance industry.
How to prepare for a job interview at Direct Line Insurance Group plc
✨Showcase Your Data Skills
As an Underwriting Data Analyst, you'll need to demonstrate your proficiency in SQL and data visualisation tools like Tableau. Be prepared to discuss specific projects where you've used these skills to solve complex problems or improve processes.
✨Understand the Underwriting Process
Familiarise yourself with the underwriting process in the motor insurance sector. Being able to articulate how data influences underwriting decisions will show your understanding of the role and its impact on the business.
✨Prepare for Stakeholder Engagement
Since you'll be presenting insights to various stakeholders, practice explaining complex data findings in a clear and concise manner. Think about how you can tailor your communication style to different audiences.
✨Demonstrate Problem-Solving Abilities
The role requires innovative thinking to tackle ambiguous challenges. Prepare examples of past experiences where you've identified issues and implemented effective solutions, highlighting your analytical and creative problem-solving skills.