Data Engineer

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