Datawarehouse Developer

Job Description - Data Warehouse 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.

As an international specialist insurer, we focus on our key areas of expertise and strength-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 seek talented people who do the same. 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 find solutions. Despite our long history (since 1901), we are young in many ways-ambitious and going places. If that sounds good to you, get in touch. Follow us on LinkedIn, Glassdoor, and Instagram

Data Warehouse Developer

Location: London

Band: Band II

Type: Permanent

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.

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

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

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

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