At a Glance
- Tasks: Design and build data pipelines on Snowflake, collaborating with diverse teams.
- Company: Join Tokio Marine HCC, a leading Specialty Insurer with a dynamic culture.
- Benefits: Competitive salary, employee benefits, and opportunities for professional growth.
- Other info: Be part of a rapidly growing team that values creativity and innovation.
- Why this job: Make a real impact in the insurance industry while working with cutting-edge technology.
- Qualifications: Experience in data engineering, especially with Snowflake and dbt Cloud.
The predicted salary is between 63000 - 77000 £ per year.
Reporting to: Head of Data Design and Engineering
Product Team Alignment: Underwriting Performance Team
Position Type: Permanent, minimum 3 days in the office per week.
Overview:
Why Tokio Marine HCC?
Standing still is not an option in the current world of Insurance. TMHCC are one of the world’s leading Specialty Insurers. With deep expertise in our chosen lines of business, our unparalleled track record and a solid balance sheet, TMHCC evaluates and manages risk like no one else in the industry. Looking beyond profit, empowering our people and delivering on our commitments are at the core of our customer values, and so is a desire to grow and provide creative and innovative solutions to our clients.
Job Purpose:
To work as the Data Engineer embedded within the Underwriting Performance (UWP) product team, designing, building and supporting high-quality data pipelines and data products on TMHCC’s Snowflake data platform. The role is seconded to UWP day to day while remaining part of the Data Design & Engineering (DD&E) function, reporting to the Head of Data Design and Engineering. The post-holder works to UWP priorities for delivery, and to DD&E for engineering quality, design consistency and platform standards. They help both sides find the right solution when priorities and standards pull in different directions, which enables consistent, trusted analytics and insight across the organisation.
Key Responsibilities:
- Design, develop and maintain data pipelines ingesting data from internal and external sources into Snowflake
- Build, test and document data models and data products using dbt Cloud, in line with TMHCC data standards and Medallion Architecture principles
- Work closely with the UWP product team, underwriters, actuarial, operations and other business stakeholders to understand product priorities and shape data requirements into well-defined, deliverable work
- Constructively challenge requirements that are unclear, insufficiently justified or inconsistent with the platform architecture, offering pragmatic alternatives
- Champion the data platform’s standards within the product team, reusing shared and conformed models and avoiding product-specific workarounds, and bring design decisions with wider impact to DD&E design governance
- Manage stakeholder expectations on scope, priority and timelines through transparent estimation and clear explanation of trade-offs
- Take an active part in agile ceremonies (refinement, planning, reviews and retrospectives) and contribute to the UWP data product roadmap
- Ensure data quality through the implementation of tests, validations and monitoring
- Support the operation and reliability of production data pipelines, including investigating and resolving data issues
- Contribute to version control, CI/CD pipelines and peer code reviews, with attention to Snowflake performance and cost
- Maintain clear technical documentation for data models, pipelines and processes
- Adhere to data security, governance and regulatory requirements at all times
Performance Objectives:
- Become a trusted data engineering partner to the UWP team, helping shape the technical direction of its data backlog
- Independently deliver production-ready data products and dbt models that meet DD&E design and engineering standards
- Improve delivery predictability by making sure requirements are well understood and agreed before build begins
- Build trust with UWP and wider stakeholders by providing reliable, well-documented data assets
- Contribute to engineering practice and standards across DD&E, sharing knowledge beyond the UWP team
Skills and Experience Specification:
Essential:
- Substantial data engineering experience, having delivered through multiple full project lifecycles from discovery and requirements to production and ongoing support
- Strong practical experience building production data pipelines and models on Snowflake
- Commercial experience with dbt Cloud, including models, tests, macros, incremental strategies, snapshots, environments and jobs
- Strong data engineering fundamentals: advanced SQL, dimensional modelling, handling of slowly changing data, and layered architectures such as Medallion
- Experience working in agile delivery teams, ideally with a data product mindset
- Strong stakeholder management skills, with the confidence to challenge and refine requirements constructively
- Experience working within an embedded or matrix model while maintaining shared engineering standards
- Experience using Git, pull requests, code reviews and CI/CD for data
- Sound understanding of data quality, testing and data governance principles
Desirable:
- Experience working with insurance, ideally specialty or London Market underwriting data, or other regulated industries
- Familiarity with data from core insurance systems (e.g. policy administration, claims and billing platforms)
- Experience supporting analytics or BI tools (e.g. Power BI, Tableau, Looker)
- Knowledge of data security and access control patterns in Snowflake
- Snowflake certification (e.g. SnowPro Core or Advanced)
- Experience mentoring or supporting other engineers
What We Offer:
The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefit package. We are a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals.
The Tokio Marine HCC Group of companies is an equal opportunity employer.
Your success is our priority. In a world that is rapidly changing, TMHCC enables you to take on opportunities with confidence. At Tokio Marine HCC, we pride ourselves on hiring the smartest, most conscientious people, who want to make a difference no matter their background. And then we give them the support and trust they need. We’re always looking for curious, creative transformative thinkers who want to change the status quo and have a passion for doing the right thing. If this is you, then we want you on our team.
Data Engineer in London employer: Tokio Marine HCC – A&H Group
Tokio Marine HCC is an exceptional employer that fosters a culture of integrity, empowerment, and collaboration, making it a great place for professionals to thrive. With a competitive salary and benefits package, including generous paid time off, flexible work schedules, and opportunities for advancement, employees can enjoy a rewarding work-life balance in the vibrant city of Boston. The company's commitment to innovation and employee growth ensures that every team member can make a meaningful impact while being part of a dynamic and rapidly growing organization.
Contact Details:
Tokio Marine HCC – A&H Group Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Tokio Marine HCC – A&H Group!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at Tokio Marine HCC – A&H Group.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Tokio Marine HCC – A&H Group.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at Tokio Marine HCC – A&H Group, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Tokio Marine HCC – A&H Group, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Tokio Marine HCC – A&H Group. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Tokio Marine HCC – A&H Group
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Tokio Marine HCC – A&H Group!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.