Data Engineer

Data Engineer - London
To £80,000 + Bens

About us: As an international specialist insurer, we are far removed from the world of mass insurance products, selectively focusing on key areas of expertise and strength, all of which is underpinned by a culture that encourages us to challenge convention and always look for a better way. Defined by our strong moral fibre, we prioritise above all else the principle of doing what we say we will. Insuring the unique and interesting, our search for talent is the same.

Job Description: The Data Engineer is a technically excellent problem-solver responsible for building and maintaining a new analytics platform for the Underwriting, Risk, and Reinsurance teams. This business-critical platform will run complex mathematical models against vast amounts of geospatial and reference data to provide key pricing information and ensure we can have a balanced global risk portfolio without being overexposed to major catastrophes such as earthquakes, floods, and hurricanes.

Key Responsibilities:

1. Be a core member in the team delivering the Analytics Platform Operating Model, working in an agile way to deliver trusted governed data for the business.
2. Work across a diverse group of data consumers across the Group to identify and capture data requirements, associated ownership, definitions, transformations, and controls using standard terms.
3. Design and develop ETL processes and data structures (Azure Databricks) for the data warehouse following best practice procedures.
4. Gather and translate business requirements, convert into technical specifications, and implement solution design.
5. Perform data modelling based on the business/reporting requirements.
6. Create and maintain ETL process related documents (e.g., data lineage, data flow, mapping).
7. Own, maintain, and follow development and design principles as well as best practices.
8. Manage and deliver ad-hoc data/reporting requests from end-user requests and troubleshoot data issues.
9. Play an instrumental role supporting the data strategy and other data-related initiatives.
10. Proactively ensure that deliverables meet or exceed functional, technical, and performance requirements.
11. Be comfortable with manipulating and analysing large datasets including data cleansing to provide insight to the business.
12. Ability to understand and consolidate disparate information sources into summary metrics and report on them.
13. Ability to create and maintain dashboards/KPIs, and operate the processes that feed data into them.

Candidate Profile: The Data Engineer must have experience in:

• Databricks (Spark SQL)
• Azure DevOps
• Financial services experience

You will build and maintain data platforms within Microsoft Azure. Insurance, Underwriting, and Modelling experience is a nice to have but not essential. You will have deep technical knowledge and experience but will also not be afraid to speak to business stakeholders. You will be a team player, actively participating in all the relevant agile scrum ceremonies and working together with your peers to meet the sprint goals.

Technical Ability:

• A deep understanding of data warehousing and analytics platforms.
• SME knowledge of technology architectures & processes involved in the transfer of data.
• A good understanding of data modelling techniques.
• Up-to-date knowledge of data privacy & security standards in an Insurance context.

Innovation: Can suggest and implement innovative data solutions to meet user requirements.

Collaboration & Influencing Skills: Can work as part of a small scrum team to get the job done. Is able to build mutual trust and respect within the team to ensure that everyone learns, grows and meets the team goals.

Diversity & Benefits: At Hiscox, we care about our people. We hire the best people for the job and we are committed to diversity and creating a truly inclusive culture, which we believe drives success. Working life doesn’t always have to be in the office, so we have introduced hybrid working to encourage a healthy work-life balance. Our benefits package includes a bonus, contributory pension, 25 days annual leave plus 2 Hiscox days and a 4-week paid sabbatical with every 5 years’ worth of service, private medical for all the family and much more.