Data Warehouse Support Manager

Arch Insurance Group Inc.; Farmington (CT); Presencial; USD 145.000 - 175.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Comprehensive medical, dental, vision,

Prescription drug coverage

401k with generous matching

PTO 20 days per year

12 paid holidays per year + 2 paid Vol

Life and AD&D insurance

Short and Long-Term Disability

Paid Parental Leave up to 10 weeks

Student loan assistance

Tuition reimbursement

Backup child and elder care

Descripción de la vacante

Arch Capital Services LLC is seeking a Data Warehouse Support Manager to lead the DW ops, ensure data quality, and optimize performance across Databricks, ADF, Snowflake and SQL Server. You will oversee a team, manage incidents, and align data delivery with actuarial and finance needs.

The role requires 10+ years in DW support with leadership experience, strong SQL/ETL skills, and collaboration with IT and BI teams. Travel up to 10% outside the country is expected.

Formación

• Bachelor’s degree in computer science, information systems, or related field.
• 10+ years in data warehouse support/operations, with 2–3 years in management.
• Strong ETL/ELT, SQL, and relational/cloud DB concepts; hands-on with SQL Server and Snowflake.
• Experience with Databricks and Azure Data Factory pipelines and monitoring.
• Experience with data replication/CDC tools such as Qlik Replicate and ITIL processes.
• Ability to translate technical issues for non-technical stakeholders.

Responsabilidades

• Lead daily data warehouse support operations, incident triage, and issue resolution.
• Oversee pipelines, jobs/notebooks, replication streams, and batch processes for actuarial/finance.
• Own production support model: SLAs, escalation, on-call rotations, and reporting cycles.
• Maintain data quality controls and reconciliation across source systems and the warehouse.
• Manage vendor relationships and third‑party data feeds.
• Troubleshoot Power BI and Microsoft Fabric models, datasets, and refreshes.
• Drive automation to reduce incidents and improve observability across data stack.
• Maintain runbooks, data lineage, and documentation across Databricks/ADP/Snowflake/SQL Server.
• Coordinate with IT infra, cloud and BI teams on capacity planning and upgrades.
• Ensure data governance, audit, and regulatory reporting compliance.

Conocimientos

Leadership

Data warehouse experience

ETL/ELT

SQL

Databricks

Azure Data Factory

Snowflake

Qlik Replicate

ITIL framework

Communication

Educación

Bachelor’s degree in computer science or related

Herramientas

Databricks

Azure Data Factory

Snowflake

SQL Server

Qlik Replicate

Power BI

Microsoft Fabric

Descripción del empleo

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., Solvency II, 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 data governance/cataloging tools

Key Competencies

• 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
• Comfortable operating across a hybrid on prem/cloud data architecture

For individuals assigned or hired to work in the location(s) indicated below, the base salary range is provided. Range is as of the time of posting. Position is incentive eligible.

$145,000 - $175,000/year

• Total individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above pay range may be modified in the future.

• Arch is committed to helping employees succeed through our comprehensive benefits package that includes multiple medical plans plus dental, vision and prescription drug coverage; a competitive 401k with generous matching; PTO beginning at 20 days per year; up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer; basic Life and AD&D Insurance as well as Short and Long-Term Disability; Paid Parental Leave of up to 10 weeks; Student Loan Assistance and Tuition Reimbursement, Backup Child and Elder Care; and more.

10200 Arch Capital Services LLC