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 colleagues.

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 work with the London Market and Re & ILS businesses. Corporate Centre includes Group & Enterprise Services, IT Services, and Information Security. Each team is led by a Technology Director reporting to the CIO. The goal of the Technology organisation is to put Technology at the heart of the business.

This role sits within the Group Enterprise Systems (GES) Technology team. The ideal candidate is an experienced Microsoft data warehouse developer (SQL Server, SSIS, SSAS) capable of working independently and within a team to deliver enterprise-class data warehouse solutions and analytics platforms. The role involves working on Actuarial Reserving systems change initiatives (including regulatory projects) and providing production support. We seek a skilled, motivated individual with a strong data warehousing background to collaborate with the team and deliver according to the strategic roadmap.

What you’ll be doing as a Data Warehouse Developer:

• Collaborate with internal and external delivery teams, vendors, infrastructure, and third-party application teams to uphold and evolve standards, ensuring data solutions are fit for purpose.
• Work with data modellers and analysts to implement data models.
• Build and maintain automated pipelines supporting BI and analytics use cases, ingesting, transforming, and loading data from multiple sources, structured and unstructured.
• Utilise Enterprise-grade technology, primarily SQL Server 2019 and potentially Azure technologies, and explore other solutions where appropriate.
• Develop patterns, best practices, and standardized data pipelines to ensure consistency across the organisation.

Essential Core Technical Experience:

• 5 to 10+ years of experience in SQL Server data warehouse or data provisioning architectures.
• Advanced SQL query writing and stored procedure experience.
• Experience developing ETL solutions in SQL Server, including SSIS & T-SQL.
• Experience with Microsoft BI technologies (SQL Server Management Studio, SSIS, SSAS, SSRS).
• Knowledge of data/system integration and dependency identification.
• Proficiency in MS Excel & VBA.
• Knowledge of Insurance or Banking/Finance domains.
• Exposure to DW development practices (code & configuration management, build processes).
• Understanding of data warehouse design patterns (e.g., Data Modelling).
• Ability to elicit business requirements and collaborate on end-to-end solutions.

Supporting Core Technical Experience:

• Experience with Jira, Confluence, MS Teams, or similar tools.
• Exposure to BI reporting tools.
• Understanding of Agile methodologies.

Additional Skills:

• Experience mentoring or supporting team development.
• Knowledge of Azure SQL DB, Data Factory, Data Lake, Logic Apps, Data Bricks (Spark SQL), and Snowflake is advantageous.