Job Type
Permanent
Build a brilliant future with Hiscox
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 over exposed to major catastrophes such as earthquakes, floods and hurricanes.
You will take business stakeholder requirements, which have been refined, and build data solutions to meet these requirements. You will be expected to deliver tested, working code and data into production to meet the business' needs. Reporting to the Group Modelling Delivery Manager, you will be part of a wider agile scrum delivery team and will be expected to work with the team, including Product Owners, to meet the sprint goals, which drive towards the data platform product vision.
Key Responsibilities
- 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.
- 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.
- Design and develop ETL processes and data structures (Azure Databricks) for the data warehouse following best practice procedures (e.g. Auditing, delta load, insert else update logic, Error logging)
- Gather and translate business requirements, convert into technical specification and implement solution design.
- Perform data modelling based on the business/reporting requirements.
- Create and maintain ETL process related documents (e.g. data lineage, data flow, mapping)
- Own, maintain and follow development and design principles as well as best practice (e.g. unit testing, performance tuning, table naming conventions, peer review).
- Manage and deliver ad-hoc data/reporting requests from end-user requests and troubleshoot data issues.
- Play an instrumental role supporting the data strategy (e.g. Data warehouse) and other data related initiatives (e.g. Data science, business intelligence).
- Proactively ensure that deliverables meet or exceed functional, technical and performance requirements.
- Be comfortable with manipulating and analysing large datasets including data cleansing to provide insight to the business and troubleshooting ETL issues.
- Ability to understand and consolidate disparate information sources into summary metrics and report on them.
- Ability to create and maintain dashboards/KPI’s, and operate the processes that feed data into them. (Power BI experience desirable)
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.
In terms of the performance and personal competencies required for the position, the following are important:
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.
- Can work in partnership with other technical areas of the business such as Data Scientists, IT and Solutions Architecture to drive the use of modelling, automation and analytics.
Executing for Results
- Delivering implemented user stories within the expected timeframes with a minimal number of defects.
Strategic Ability / Learning Ability
- Is a quick learner with a can-do attitude. Is happy to put their hand to new, unfamiliar tasks with the ability to plug knowledge gaps as required.
- Is inquisitive and stays up to date with the latest industry trends and technologies.
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’re 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. This hybrid working model is set by the team rather than the business to enable you to manage your own personal work-life balance.
We see it as the best of both worlds; structure and sociability on one hand, and independence and flexibility on the other.
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.
Work with amazing people and be part of a unique culture