Data Warehouse Support Manager

Arch Capital Group Ltd.

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

Posted 10/12/2026full-timeUnited StatesSeniorLead💰 $145,000 - $175,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in managing data warehouse operations, including incident management, ETL/ELT processes, and data quality controls. Proficient in leading teams, ensuring compliance with regulatory requirements, and driving continuous improvement initiatives.

Highest-signal resume keywords

Data Warehouse SupportETL/ELT ProcessesSQL ServerAzure Data FactoryLeadership

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData Quality ControlsIncident ManagementData ReplicationCloud Database ConceptsPower BIDatabricksAutomationData GovernanceITIL Framework

Soft Skills

Strong CommunicationProblem-SolvingAttention to DetailVendor ManagementStakeholder Management

Tools & Technologies

Azure Data FactoryDatabricksQlik ReplicatePower BIMicrosoft FabricSQL ServerSnowflake

Industry Keywords

P&C ReinsuranceActuarial DataRegulatory ReportingData LineageHybrid Data Architecture

Tech Stack

Tools & technologies

AzureCloudETLSQLUnity

About the role

Key responsibilities & impact

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
Lead data warehouse analysts/engineers monitoring Azure Data Factory pipelines, Databricks jobs/notebooks, Qlik Replicate streams, and SQL Server batch processes
Own SLAs, escalation paths, on-call rotations, incident management, and problem management
Oversee data quality controls and reconciliation between source systems and the warehouse
Manage upstream data providers, downstream consumers, and third-party data feeds
Support and troubleshoot Power BI/Microsoft Fabric semantic models, datasets, and refresh schedules
Drive automation, observability, and continuous improvement to reduce recurring incidents
Maintain data lineage, runbooks, and support procedures
Coordinate infrastructure, cloud platform, and BI/reporting teams on capacity planning, upgrades, and change management
Ensure compliance with data governance, audit, and reinsurance regulatory requirements
Manage vendor relationships and contracts
Own data warehouse production stability and operational readiness
Lead quarter-close and business-critical reporting support
Govern production changes, release validation, and rollback readiness
Manage security access reviews, audit evidence, and compliance controls
Drive AI-assisted automation for monitoring, root-cause analysis, and optimization
Establish support KPIs, operational dashboards, and service improvement plans
Manage onsite/offshore support capacity, vendor accountability, and knowledge retention
Partner with Finance, Actuarial, Claims, and Underwriting stakeholders to prioritize production issues

Requirements

What you’ll need

Bachelor’s degree in computer science, Information Systems, or related field
10+ years of experience in data warehouse support, operations, or administration
At least 2-3 years in management or team lead capacity
Strong understanding of ETL/ELT processes, SQL, and relational/cloud database concepts
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 required
Strong communication skills with ability to translate technical issues for non-technical business stakeholders
Travel of up to 10% may be required outside of the country
Preferred: Direct experience in P&C reinsurance, familiarity with actuarial data needs, Microsoft Fabric and Azure, Power BI/DAX, reinsurance regulatory reporting, and Databricks Unity Catalog or similar tools
Strong leadership, problem-solving, attention to detail, technical troubleshooting, vendor and stakeholder management skills
Comfortable operating across a hybrid on-prem/cloud data architecture

Benefits

Comp & perks

Multiple medical plans plus dental, vision and prescription drug coverage
Competitive 401k with generous matching
PTO beginning at 20 days per year
Up to 12 paid company holidays per year
2 paid days of Volunteer Time Off
Basic Life and AD&D Insurance
Short and Long-Term Disability
Paid Parental Leave of up to 10 weeks
Student Loan Assistance and Tuition Reimbursement
Backup Child and Elder Care