At a Glance
- Tasks: Join a leading Broker to design and deliver scalable data solutions.
- Company: Well-known Broker in the insurance sector with a collaborative culture.
- Benefits: Hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Dynamic role with a focus on problem-solving and collaboration.
- Why this job: Make an impact by shaping the data landscape with modern tools.
- Qualifications: Experience as a Data Engineer with expertise in Snowflake and dbt.
The predicted salary is between 60000 - 80000 £ per year.
We’re looking for a talented Data Engineer to join a well-known Broker that designs, builds, and delivers robust, scalable data solutions. You’ll collaborate across teams, work with modern data tooling, and help shape the data landscape that underpins our business. Hands-on expertise with Snowflake and dbt is key for this role.
This position is hybrid and based in the London City office, with two days onsite each week.
How You’ll Make an Impact- SQL Server Expertise
- Deep knowledge of Microsoft SQL Server and SQL
- Ability to query, optimise, and manage large datasets
- Data Warehousing & Modelling
- Strong understanding of data warehouse principles
- Skilled in modelling concepts including normalization/denormalization
- ETL / ELT Processes
- Experience building and maintaining pipelines across varied data sources
- Problem-Solving
- Comfortable troubleshooting discrepancies and performance issues
- Collaborative approach to resolving user data challenges
- Security & Compliance
- Awareness of data governance, GDPR, and secure data handling practices
- Industry Understanding
- Experience working with data in the insurance sector
You’ll bring:
- Previous experience as a Data Engineer in insurance
- Hands-on expertise with Snowflake, dbt, Fivetran, Dataiku, and ideally Collibra
- Working knowledge of Azure technologies such as Synapse and DevOps
- Experience with Microsoft SQL Server stack including MDS, SSIS, SSAS, and SSRS
- Familiarity with programming languages like Python and C# (preferred)
Senior Data Engineer – Insurance - Snowflake, Dbt employer: Arthur Recruitment
Join a forward-thinking personal lines insurer that values innovation and creativity in its pricing team. With a strong emphasis on employee growth, you will have the opportunity to develop your skills in a collaborative environment while working on cutting-edge pricing methodologies. Enjoy a supportive work culture that encourages curiosity and offers meaningful career advancement opportunities in a dynamic sector.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer – Insurance - Snowflake, Dbt
✨Tip Number 1
Network like a pro! Reach out to your connections in the insurance and data engineering sectors. Attend meetups or webinars, and don’t be shy about asking for introductions. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your projects with Snowflake, dbt, and any other relevant tools. This is your chance to demonstrate your hands-on expertise and problem-solving abilities. Make it easy for potential employers to see what you can bring to the table.
✨Tip Number 3
Prepare for those interviews! Research common questions for Data Engineers, especially in the insurance sector. Brush up on your SQL Server knowledge and be ready to discuss your experience with ETL/ELT processes. Confidence is key, so practice makes perfect!
✨Tip Number 4
Apply through our website! We’ve got a range of opportunities that could be perfect for you. Tailor your application to highlight your relevant experience and skills, and don’t forget to mention your familiarity with data governance and compliance. Let’s get you that dream job!
We think you need these skills to ace Senior Data Engineer – Insurance - Snowflake, Dbt
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your hands-on expertise with Snowflake and dbt. We want to see how your previous experience as a Data Engineer in the insurance sector aligns with what we're looking for.
Showcase Your Skills:Don’t just list your skills; demonstrate them! Use specific examples of how you've optimised large datasets or built data pipelines. This will help us see your problem-solving abilities in action.
Be Clear and Concise:When writing your application, keep it clear and to the point. We appreciate straightforward communication, so avoid jargon unless it's relevant to the role. Make it easy for us to see your fit!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity in our London City office.
How to prepare for a job interview at Arthur Recruitment
✨Know Your Tools Inside Out
Make sure you brush up on your Snowflake and dbt skills before the interview. Be ready to discuss specific projects where you've used these tools, as well as any challenges you faced and how you overcame them.
✨Showcase Your SQL Server Expertise
Prepare to demonstrate your deep knowledge of Microsoft SQL Server. Think of examples where you've optimised queries or managed large datasets, and be ready to explain your thought process during those tasks.
✨Understand Data Warehousing Principles
Familiarise yourself with data warehousing concepts, especially normalisation and denormalisation. Be prepared to discuss how you've applied these principles in past roles, particularly in the insurance sector.
✨Emphasise Collaboration and Problem-Solving
Highlight your collaborative approach to resolving data challenges. Share specific instances where you've worked with teams to troubleshoot discrepancies or performance issues, showcasing your problem-solving skills.
