Data Warehouse Support Manager
About the role
With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.
We are seeking a Data Warehouse Support Manager to lead the ongoing support, stability, and performance of our Segment Data Warehouse environment, which underpins actuarial, underwriting, claims, and finance reporting across our Property & Casualty reinsurance business. This role bridges technical data warehouse operations with the business-critical needs of a reinsurance organization, ensuring accurate, timely, and reliable data for treaty analysis, loss reserving, exposure management, and regulatory reporting.
Responsibilities
- Manage day-to-day support operations for the data warehouse environment, including incident triage, root cause analysis, and resolution of data quality, ETL/ELT, and performance issues across Databricks, Azure Data Factory, Snowflake, and SQL Server
- Lead a team of data warehouse analysts/engineers responsible for monitoring Azure Data Factory pipelines, Databricks jobs/notebooks, Qlik Replicate data replication streams, and SQL Server batch processes feeding actuarial and finance systems
- Own the production support model: SLAs, escalation paths, on-call rotations, and incident/problem management aligned to business-critical reporting cycles (month-end, quarter-end, renewal seasons)
- Oversee data quality controls and reconciliation processes to ensure consistency between source systems (policy admin, claims, ceded reins