Data Engineer

Hiscox Underwriting Group Services Ltd (HUGS); York and North Yorkshire; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Employee benefits

Job summary

Hiscox Underwriting Group Services Ltd (HUGS) in the UK is seeking a data engineering specialist to join the Enterprise Technology Data service vertical. You will contribute to scalable data warehouse solutions and oversee end-to-end ETL design in a cloud/on-premise environment.

Responsibilities include translating business requirements into robust data pipelines, working within Agile teams and CI/CD pipelines to deliver across data platforms, and collaborating with stakeholders to enable

Qualifications

• Development background with exposure to Data Warehousing at scale on both cloud and on-premise.
• Experience developing ETL solutions in GCP including Python and SQL as well as SQL Server including SSIS & T-SQL.
• Exposure to DW development practices (code & configuration management, build processes).
• Strong understanding of enterprise level data warehouse architectures, data modelling concepts, and ETL/ELT best practices.
• Ability to take business requirements and work with other team members to estimate and design end-to-end solutions.
• Experience working in Agile delivery models with CI/CD pipelines for automated deployments across data platforms.

Skills

Data Warehousing

ETL

Python

SQL

SSIS

T-SQL

CI/CD

Agile

Power BI

Tools

Power BI

Job description

Job Type: Permanent

Build a brilliant future with Hiscox

Company description Hiscox is a diversified international insurance group with a powerful brand, strong balance sheet and plenty of room to grow. Listed on the London Stock Exchange and headquartered in Bermuda (with the bulk of group leadership sitting in London), Hiscox has over 3,000 staff across 14 countries and 34 offices. Structured by geography and product, Hiscox’s long-held business strategy has helped them grow from a niche Lloyd’s underwriter to an international insurance group with a powerful consumer brand. Hiscox is comprised of the following business lines: London Market Reinsurance & Insurance Linked Securities (ILS) Retail: Hiscox USA Hiscox UK Hiscox Europe For the financial year 2022 GWP grew to $4.425m, with net premiums earned growing to $2.928m. Hiscox’s Purpose: "We give people and businesses the confidence to realise their ambitions" Hiscox values: Courage; dare to take a risk Human; clean, fair, and inclusive Ownership; passionate, commercial, and accountable Integrity; do the right thing, however hard Connected; together, build something better

The Team This role forms part of the Enterprise Technology (ET) team lead by the CTO for ET who are accountable for the full life cycle of around 140 applications. ET has several service verticals, including Business Applications made up of 6 value streams and an Enterprise Application team, Data, End User Experience, Core Engineering, Architecture, and Portfolio Management. The role will sit within the Data service vertical, led by a Head of Data Engineering, reporting into the Lead Data Engineer.

• Development background with exposure to Data Warehousing at scale on both cloud and on-premise
• Experience developing ETL solutions in GCP including Python and SQL as well as SQL Server including SSIS & T-SQL
• Exposure to DW development practices (code & configuration management, build processes)
• Strong understanding of enterprise level data warehouse architectures, data modelling concepts, and ETL/ELT best practices
• Ability to take business requirements and work with other team members to estimate and design end-to-end solutions
• Experience working in Agile delivery models with CI/CD pipelines for automated deployments across data platforms.

Our nice to haves:

• Insurance industry experience
• Exposure to BI reporting toolsets - ideally Power BI
• Demonstrable experience in mentoring or supporting the development of junior team members
• Capability to architect highly scalable distributed systems, using different tools
• Intellect and gravitas to influence and gain credibility with stakeholders
• Excellent written and verbal communication skills
• Creative, proactive, logical and innovative - you do not accept the status quo
• Highly results driven, with the energy and determination to succeed in a fast paced environment
• Demonstrate a commitment to quality, service and personal ownership
• Deal well with ambiguity and enable a consensus to be reached
• An inquisitive mind-set and desire to understand both data and business requirements
• Continuous self-improvement and learning
• Work with amazing people and be part of a unique culture

If you want to help build a brilliant future; work with amazing people; be part of a unique company culture; and, of course, enjoy great employee benefits that take care of your mental and physical wellbeing, come and join us.

We’re a global, specialist insurer headquartered in Bermuda and listed on the London Stock Exchange. With 3,000 employees and 32 offices in 12 countries we’re a business with lots of opportunity for people with talent, spark and lots of ambition. If you want to build a great career with a company that prioritises strong values - such as integrity and courage - where our people always pull together to do the right thing for each other and our customers, then we’d love to hear from you.