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 environment with a focus on innovation and teamwork.
- Why this job: Make an impact by shaping the data landscape with modern tools like Snowflake and dbt.
- Qualifications: Experience as a Data Engineer in insurance and expertise in SQL Server and data modelling.
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 in London employer: Arthur Recruitment
Contact Detail:
Arthur Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Engineer – Insurance - Snowflake, Dbt in London
✨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 interviews by brushing up on your SQL Server knowledge and data warehousing principles. Be ready to discuss your experience with ETL/ELT processes and how you've tackled data challenges in the past. Confidence is key, so practice makes perfect!
✨Tip Number 4
Apply through our website! We’re always on the lookout for talented individuals like you. Tailor your application to highlight your experience in the insurance sector and your familiarity with Azure technologies. Let’s get you that dream job together!
We think you need these skills to ace Senior Data Engineer – Insurance - Snowflake, Dbt in London
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 SQL Skills: Since deep knowledge of Microsoft SQL Server is key, don’t forget to include specific examples of how you've queried, optimised, and managed large datasets. This will help us see your problem-solving skills in action!
Highlight Collaboration: We love a collaborative spirit! Mention any experiences where you worked across teams to resolve user data challenges or troubleshoot discrepancies. It’s all about teamwork here at StudySmarter.
Apply Through Our Website: Don’t forget to apply 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 Mastery
Since deep knowledge of Microsoft SQL Server is crucial, prepare to demonstrate your SQL expertise. Think of examples where you've optimised queries or managed large datasets, and be ready to explain your thought process.
✨Understand Data Warehousing Principles
Familiarise yourself with data warehousing concepts like normalisation and denormalisation. Be prepared to discuss how you've applied these principles in past roles, especially in the context of the insurance sector.
✨Emphasise Collaboration and Problem-Solving
Highlight your collaborative approach to resolving data challenges. Prepare examples of how you've worked with cross-functional teams to troubleshoot discrepancies or performance issues, showcasing your problem-solving skills.