Senior Data Architect

Tokio Marine HCC (TMHCC) brings 50 years of service to the specialty insurance industry, today offering over 100 products to commercial customers in 180 countries around the world.

Organic growth and over 60 successful acquisitions have grown our 2022 Gross Written Premium (GWP) to $5 Billion.

Our workforce has grown to 4,300 worldwide … big, but not so big that you cannot make a difference.

Our Good Company values, including integrity, empowerment, and commitment to customer service, and a culture of innovation, communication, and collaboration make TMHCC a great place to work.

For over 50 years, HCC Life Insurance Company, operating as Tokio Marine HCC – A&H Group, has been at the forefront of medical stop loss insurance. In addition to traditional stop loss, we offer captive and Taft-Hartley stop loss solutions, Organ & Tissue Transplant insurance and Med Plus insurance. Tokio Marine HCC – A&H Group is rated A++ (Superior) by A.M. Best Company and benefits from the financial stability of its parent company, Tokio Marine HCC.

Position Summary:

The Data Architect will play a key role in designing and enabling the future-state enterprise data platform for the Medical Stop Loss business. The role will define the architecture, data models, integration patterns, and technical standards for a modern enterprise data warehouse and analytics ecosystem built on Microsoft Fabric and Azure.

This role requires strong enterprise data warehousing expertise combined with modern cloud data architecture experience. The Data Architect will work closely with business SMEs, Data & Analytics, Application Engineering, Enterprise Architecture, and other technology teams to ensure data across key business domains is integrated, standardized, governed, and readily available for reporting, analytics, AI, and operational decision-making.

Key Responsibilities:

• Define and maintain the target-state architecture for the enterprise data warehouse and broader data platform using Microsoft Fabric and Azure.
• Establish architectural patterns and standards for data ingestion, transformation, storage, modeling, integration, and consumption.
• Apply established enterprise data warehousing principles and best practices to create a scalable, maintainable, and extensible data environment.
• Lead the design of conceptual, logical, dimensional, and physical data models supporting key Medical Stop Loss business domains.
• Define approaches for integrating data from Policy Administration, Claims, Underwriting, external partners, and other operational systems.
• Establish patterns for handling source-system differences, data standardization, incremental processing, historical data, change data capture, and evolving source structures.
• Partner with business SMEs and Data & Analytics teams to establish common business definitions, canonical entities, relationships, and data rules.
• Design warehouse structures and semantic models that effectively support enterprise reporting, analytics, self-service BI, and AI/ML use cases.
• Provide architectural guidance to Data Engineers and conduct data model, pipeline, and solution design reviews to ensure alignment with target-state standards.
• Partner with application and solution architects to ensure modern applications and services produce data that can be effectively integrated into the enterprise data ecosystem.
• Define and promote standards for data quality, reconciliation, metadata, lineage, governance, security, privacy, and appropriate access to sensitive information.
• Establish reusable data architecture patterns and standards that reduce duplication and improve consistency across business domains and engineering teams.
• Support modernization and migration of existing data…