Data Engineer

Hiscox Underwriting Group Services Ltd Portugal (HUGS PT); Lisboa; On-site; EUR 55,000 - 85,000; Full time

Job summary

Hiscox Underwriting Group Services Ltd Portugal (HUGS PT) is seeking a data engineer to join the Enterprise Technology Data service vertical, reporting to the Head of Data Engineering. You will work on scale data warehousing, ETL/ELT pipelines, and cloud-on-premise architectures across multiple platforms.

The role requires hands-on development in GCP with Python and SQL, experience with SQL Server, SSIS and T‑SQL, and the ability to translate business requirements into end-to-end data solutions,

Qualifications

• Experience developing ETL solutions in GCP using Python and SQL.
• Experience with SQL Server, SSIS and T-SQL.
• Strong understanding of data warehouse architectures and ETL/ELT best practices.

Skills

Data warehousing at scale

ETL development

Python

SQL

CI/CD pipelines

Tools

Power BI

SQL Server

SSIS

T-SQL

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.

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

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