Job Description – Datawarehouse Developer

About Hiscox:

At Hiscox we care about our people. We hire the best people for the work, and we’re committed to diversity and creating a truly inclusive culture, which we believe drives success. We embrace hybrid-working practices, balancing the ability to work remotely with the culture and energy we experience when we are face-to-face in our offices. Our focus on collaboration and cross- functional working is supported with virtual tools that minimise physical travel, hot-desking neighbourhoods that create a physical sense of community and Team Charters that our teams co- create to set out how they’ll work together. This modern way of working has contributed to impressive employee engagement scores across Hiscox and means we’re delivering even better solutions for our Hiscox Colleagues. As an international specialist insurer we are far removed from the world of mass market insurance products. Instead we are selective and focus on our key areas of expertise and strength – all of which is underpinned by a culture that encourages us to challenge convention and always look for a better way of doing things. We insure the unique and the interesting. And we search for the same when it comes to talented people. Hiscox is full of smart, reliable human beings that look out for customers and each other. We believe in doing the right thing, making good and rebuilding when things go wrong. Everyone is encouraged to think creatively, challenge the status quo and look for solutions. Scratch beneath the surface and you will find a business that is solid, but slightly contrary. We like to do things differently and constantly seek to evolve. We might have been around for a long time (our roots go back to 1901), but we are young in many ways, ambitious and going places. Some people might say insurance is dull, but life at Hiscox is anything but. If that sounds good to you, get in touch. You can follow Hiscox on LinkedIn, Glassdoor and Instagram (@HiscoxInsurance)

Data Warehouse Developer Location: London Band: Band II Type: Permanent The team

The Technology organisation comprises a Corporate Centre team and five business-aligned Technology teams partnering with our federated businesses. Our retail technology teams partner with the UK, Europe and US business units. Our ‘big ticket’ technology teams partner with the London Market and Re & ILS businesses. Corporate Centre consists of Group & Enterprise Services, IT Services and Information Security. Each team is led by a Technology Director who reports into the CIO. Collectively the goal of the Technology organisation is to put Technology at the heart of the business.

The role

This role sits within the Group Enterprise Systems (GES) Technology team. The right candidate would be an experienced Microsoft data warehouse developer (SQL Server, SSIS, SSAS) who can work both independently and as a member of a team to deliver enterprise class data warehouse solutions and analytics platforms. This role will primarily involve working on Actuarial Reserving systems change initiatives (some of which will be regulatory in nature), and Production support. We are looking for a skilled and motivated individual with a strong background in data warehousing who can work closely with the existing team to successfully deliver the requirements set out in the strategic roadmap. What you’ll be doing as a Data Warehouse Developer

Work closely with internal and external delivery teams, external vendors, infrastructure and 3rd party application teams to uphold and evolve common standards and collaborate to ensure that our data solutions are fit for purpose. Work closely with data modellers and data analysts to implement and produce data models. Build and maintain automated pipelines to support data solutions across BI and analytics use cases and collaborate with other technology teams to ingest, transform and load data from multiple data sources, structured and unstructured data. Work with Enterprise-grade technology, primarily SQL Server 2019 and potentially Azure technologies. Have exposure across the SQL Server stack but also be encouraged to pursue other technology solutions where appropriate. Build patterns, common ways of working, and standardized data pipelines for DLG to ensure consistency across the organization. Essential Core Technical Experience

• 5 to 10+ years’ extensive experience in SQL Server data warehouse or data provisioning architectures

• Advanced SQL query writing & SQL procedure experience. • Experience developing ETL solutions in SQL Server including SSIS & T-SQL • Experience in Microsoft BI technologies (SQL Server Management Studio, SSIS, SSAS,

SSRS). • Experience of data/system integration and a strong ability to identify dependencies. • Sound knowledge of MS Excel & VBA • Knowledge and exposure to Insurance Businesses and/or other Banking and Finance

domains. • Exposure to DW development practices (code & configuration management, build

processes) • Appreciation of design patterns and practices that apply to the data warehouse

space (e.g. Data Modelling) • Ability to elicit business requirements, and take existing requirements and work with

other team members to estimate and design end-to-end solutions Supporting Core Technical Experience

• Jira, Confluence, MS Teams, or similar collaboration tools • Exposure to BI reporting toolsets • Understanding of Agile principles

• Demonstrable experience in mentoring or supporting the development of team members

• Azure SQL DB, Data Factory, Data Lake, Logic apps, Data Bricks (Spark SQL) and/or Snowflake experience is advantageous.