Data Engineer

Hiscox Insurance Company Inc.; Lisboa; Presencial; EUR 60.000 - 90.000; Jornada completa

Descripción de la vacante

Hiscox Insurance Company Inc. is seeking a Data Engineer within our Enterprise Technology Data service vertical. You will contribute to scalable data warehousing solutions and design ETL/ELT pipelines in GCP and SQL Server environments, collaborating with BI, data modelling and DevOps teams.

Ideal candidates have cloud/on-prem data platform experience, strong communication skills, and the ability to translate business requirements into end-to-end data solutions in an Agile setting.

Formación

• Experience developing ETL solutions in cloud and on-premise environments.
• Strong understanding of data warehouse architectures and data modelling concepts.
• Familiarity with Agile delivery models and CI/CD for data platforms.
• Ability to translate business requirements into end-to-end data solutions.

Responsabilidades

• Contribute to scalable data warehouse solutions across cloud and on-prem environments.
• Develop ETL/ELT pipelines using Python, SQL, SSIS and T-SQL.
• Collaborate with BI, data engineering and platform teams to deliver end-to-end data solutions.
• Support and mentor junior team members where appropriate.

Conocimientos

Data warehousing

ETL development

Python

SQL

SSIS

T-SQL

GCP

CI/CD

Educación

Bachelor's degree in a relevant field

Herramientas

Power BI

Descripción del empleo

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.

Technical Skills

• - 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