Data Warehouse Support Manager

Arch Capital Group•Farmington, NJ

About The Position

Arch is seeking a Data Warehouse Support Manager to lead the support, stability, and performance of its Segment Data Warehouse environment. The warehouse supports actuarial, underwriting, claims, and finance reporting across the Property & Casualty reinsurance business, including treaty analysis, loss reserving, exposure management, and regulatory reporting. The role combines technical data warehouse operations with the business-critical needs of a reinsurance organization. Travel of up to 10% may be required outside the country. The manager leads data warehouse support operations and a team of analysts and engineers, owns production support and stability, and coordinates incident response, change management, service improvement, and reporting-cycle readiness. The role works with upstream data providers, downstream consumers, vendors, infrastructure and cloud teams, BI teams, and Finance, Actuarial, Claims, and Underwriting stakeholders. It also drives AI-assisted operational automation and ensures data quality, governance, audit, and regulatory controls are maintained. The position is incentive eligible. The stated base salary range is $145,000–$175,000 per year; total compensation may include short- and long-term incentives and depends on factors such as location, responsibilities, qualifications, talent availability, and business needs.

Requirements

Bachelor’s degree in computer science, Information Systems, or a related field.
10+ years of experience in data warehouse support, operations, or administration, including at least 2–3 years in a management or team lead capacity.
Strong understanding of ETL/ELT processes, SQL, and relational and cloud database concepts, with hands-on experience across SQL Server and Snowflake.
Working knowledge of Databricks jobs, clusters, and notebooks, and Azure Data Factory pipelines, triggers, and monitoring.
Experience with data replication or CDC tools such as Qlik Replicate.
Experience with job scheduling and monitoring tools and incident management processes; ITIL framework experience is required.
Strong communication skills and ability to translate technical issues for non-technical business stakeholders.
Strong leadership and people management skills.
Excellent problem-solving skills under time pressure, especially during critical reporting periods.
High attention to detail and commitment to data accuracy.
Ability to balance hands-on technical troubleshooting with managerial oversight.
Strong vendor and stakeholder management skills.
Comfort operating across a hybrid on-premises and cloud data architecture.

Nice To Haves

Direct experience in Property & Casualty reinsurance, particularly treaty or facultative data, loss bordereaux, premium bordereaux, or cession accounting.
Familiarity with actuarial data needs, including loss triangles, exposure data, and catastrophe modeling outputs.
Experience with Microsoft Fabric, including Lakehouse, OneLake, and Power BI integration, and the Azure cloud ecosystem.
Knowledge of Power BI report and dataset architecture and DAX troubleshooting.
Familiarity with data governance and regulatory reporting requirements in insurance or reinsurance.
Experience with Databricks Unity Catalog or similar data governance and cataloging tools.

Responsibilities

Manage day-to-day data warehouse support, 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 data warehouse analysts and engineers responsible for monitoring Azure Data Factory pipelines, Databricks jobs and notebooks, Qlik Replicate streams, and SQL Server batch processes.
Own the production support model, including SLAs, escalation paths, on-call rotations, and incident and problem management for critical reporting cycles.
Oversee data quality controls and reconciliation between source systems and the warehouse, including monitoring Qlik Replicate CDC pipelines for latency and data drift.
Manage relationships with upstream data providers, downstream consumers, and third-party data feed providers.
Support and troubleshoot Power BI (Microsoft Fabric) semantic models, datasets, and refresh schedules in collaboration with BI developers.
Drive continuous improvement to reduce recurring incidents, improve automation and monitoring, and enhance observability across the data stack.
Maintain and improve data lineage, runbooks, and support procedures for Databricks, Azure Data Factory, Snowflake, and SQL Server.
Coordinate capacity planning, Microsoft Fabric and Azure upgrades, and change management with infrastructure, cloud platform, and BI/reporting teams.
Ensure compliance with data governance, audit, and regulatory requirements relevant to reinsurance reporting.
Manage vendor relationships and contracts for outsourced support, Qlik licensing, and other platform tools.
Own data warehouse production stability and operational readiness; lead quarter-close and other 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, root cause analysis, and data warehouse operations optimization.
Establish support KPIs, operational dashboards, and service improvement plans.
Manage onsite and offshore support capacity, vendor accountability, and knowledge retention.
Partner with Finance, Actuarial, Claims, and Underwriting stakeholders to prioritize production issues by business impact.