Data Warehouse Support Manager

Arch Capital

New Jersey

On-site

USD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Arch Capital is seeking a Data Warehouse Support Manager to lead ongoing operations, stability, and performance of the Segment Data Warehouse used for actuarial, underwriting, claims, and finance reporting in a reinsurance context. The role ensures accurate, timely data for treaty analysis and regulatory reporting across a modern data stack.

The candidate will manage a team of analysts/engineers, drive improvements, and partner with Finance, Actuarial, and Underwriting to resolve production

Qualifications

  • Bachelor's degree in computer science, information systems, or a related field.
  • 10+ years of data warehouse support/operations with prior management experience.
  • Strong understanding of ETL/ELT processes, SQL, and cloud/relational databases (SQL Server, Snowflake).
  • Hands-on experience with Databricks jobs/notebooks and ADF pipelines.
  • Experience with data replication/CDC tools (Qlik Replicate) and ITIL-based incident management.

Responsibilities

  • Lead day-to-day data warehouse support operations, including incident triage and RCA across Databricks, ADF, Snowflake and SQL Server.
  • Oversee data quality, lineage, and reconciliation between source systems and the warehouse.
  • Manage production support model: SLAs, on-call rotations, escalation paths, and release controls.
  • Coordinate with IT, cloud, and BI teams on capacity planning and upgrades.
  • Support Power BI reporting and ensure performance and connectivity across datasets.

Skills

Leadership
ETL/ELT
SQL
Databricks
Azure Data Factory
Qlik Replicate
ITIL
Communication
Data governance
Regulatory reporting

Education

Bachelor's degree in Computer Science / Information Systems

Tools

Databricks
Azure Data Factory
Snowflake
Qlik Replicate
SQL Server

Job description

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.

The Position

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. Travel of up to 10% may be required outside of the country.

Job 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 reinsurance systems) and the warehouse, including monitoring Qlik Replicate CDC pipelines for latency and data drift
  • Manage relationships with upstream data providers and downstream consumers, including third-party data feeds
  • Support and troubleshoot Power BI (Microsoft Fabric) semantic models, datasets, and refresh schedules, working closely with BI developers to resolve performance and connectivity issues
  • Drive continuous improvement initiatives to reduce recurring incidents, improve automation (e.g., ADF pipeline alerting, Databricks job monitoring), and enhance observability across the modern data stack
  • Maintain and improve documentation, including data lineage, runbooks, and support procedures across Databricks, ADF, Snowflake, and SQL Server environments
  • Coordinate with IT infrastructure, cloud platform, and BI/reporting teams on capacity planning, Microsoft Fabric/Azure environment upgrades, and change management
  • Ensure compliance with data governance, audit, and regulatory requirements relevant to reinsurance reporting (e.g., SolvencyII, statutory filings)
  • Manage vendor relationships and contracts for outsourced support, Qlik licensing, and other platform tools
  • Own Datawarehouse production stability and operational readiness.
  • Lead quarter-close and business-critical reporting support activities.
  • Govern production change management, release validation, and rollback readiness.
  • Manage security access reviews, audit evidence, and compliance controls.
  • Drive AI-assisted automation for monitoring, RCA, and optimizing Datawarehouse operations.
  • Establish support KPIs, operational dashboards, and service improvement plans.
  • Manage onsite/offshore support capacity, vendor accountability, and knowledge retention.
  • Partner closely with Finance, Actuarial, Claims, and Underwriting stakeholders to prioritize production issues based on business impact.
Required Qualifications
  • Bachelor's degree in computer science, Information Systems, or related field
  • 10+ years of experience in data warehouse support, operations, or administration, with at least 2-3 years in management or team lead capacity
  • Strong understanding of ETL/ELT processes, SQL, and relational/cloud database concepts, with hands‑on experience across SQL Server and Snowflake
  • Working knowledge of Databricks (jobs, clusters, notebooks) and Azure Data Factory (pipelines, triggers, monitoring)
  • Experience with data replication/CDC tools such as Qlik Replicate
  • Experience with job scheduling and monitoring tools and incident management processes (ITIL framework experience a must)
  • Strong communication skills with the ability to translate technical issues for non‑technical business stakeholders
Preferred Qualifications
  • Direct experience in P&C reinsurance, specifically with treaty/facultative data, loss bordereaux, premium bordereaux, or cession accounting
  • Familiarity with actuarial data needs (loss triangles, exposure data, catastrophe modeling outputs)
  • Experience with Microsoft Fabric (Lakehouse, OneLake, Power BI integration) and Azure cloud ecosystem
  • Knowledge of Power BI report/dataset architecture and DAX troubleshooting
  • Familiarity with data governance and regulatory reporting requirements in (re)insurance
  • Experience with Databricks Unity Catalog or similar
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Support Manager
Data Warehouse Support Manager

Arch Insurance Group Inc. • Farmington (CT)

On-site
USD 145,000 - 175,000
Comprehensive medical, dental, vision,
Prescription drug coverage
401k with generous matching
+8
Data Warehouse Support Manager
Data Warehouse Support Manager

Arch Capital Group Ltd. • Morristown (NJ)

On-site
USD 145,000 - 175,000
Medical plans
Dental, vision and prescription
401k with generous matching
+4
Data Warehouse Support Manager
Data Warehouse Support Manager

Arch Capital Group Ltd. • Farmington (CT)

On-site
USD 145,000 - 175,000
None
Data Warehouse Support Manager
Data Warehouse Support Manager

Arch Capital Group • Morristown (NJ)

On-site
USD 145,000 - 175,000
Medical plans
Dental and vision
401k with matching
+6
Data Engineering Lead: Snowflake, ADF & Databricks
Data Engineering Lead: Snowflake, ADF & Databricks

TechDigital Group • Dallas (TX)

On-site
USD 90,000 - 150,000
Remote Senior Data Engineer – Databricks / Azure Data Platform
Remote Senior Data Engineer – Databricks / Azure Data Platform

PROSTAFF Schweiz GmbH • United States

Remote
USD 168,000 - 252,000
Data Quality Lead (Microsoft Azure / Power BI) Hybrid - Farmington, CT or Morristown, NJ
Data Quality Lead (Microsoft Azure / Power BI) Hybrid - Farmington, CT or Morristown, NJ

Arch Capital • Farmington (CT)

Hybrid
USD 120,000 - 180,000
Director, Financial Data Operations and Delivery
Director, Financial Data Operations and Delivery

W. R. Berkley Corporation • Urbandale (IA)

On-site
USD 130,000 - 180,000
Data Engineer
Data Engineer

5 Star Recruitment • Princeton (NJ)

On-site
USD 90,000 - 120,000
Sr. Data Analyst
Sr. Data Analyst

Accord Technologies Inc • Piscataway Township (NJ)

Hybrid
USD 110,000 - 160,000