Datawarehouse Developer

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.

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. Corporate Centre consists of Group & Enterprise Services, IT Services, and Information Security.

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 and Production support.

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

1. Work closely with internal and external delivery teams, external vendors, infrastructure, and 3rd party application teams to uphold and evolve common standards.
2. Collaborate with data modellers and data analysts to implement and produce data models.
3. Build and maintain automated pipelines to support data solutions across BI and analytics use cases.
4. Work with Enterprise-grade technology, primarily SQL Server 2019 and potentially Azure technologies.
5. 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 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.