Senior Data Architect

This role is located onsite in Kennesaw, GA 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.

About Tmhcc

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

Responsibilities

• 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.
• Must have have experience defining and maintaining 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.
• Must have a minimum of 4 years of Data Architecture 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 warehouses, databases, reporting solutions, and data pipelines into the future-state architecture.
• Evaluate Microsoft Fabric and Azure capabilities and recommend appropriate technologies and patterns based on business needs, scalability, performance, security, maintainability, and cost.

Requirements

• 5+ years of experience understanding and hands-on implementation experience with enterprise data warehousing principles, architecture, design patterns, and best practices.
• 5 + years of demonstrated experience designing and implementing enterprise data warehouses from ingestion through consumption, including data integration, transformation, modeling, historical data management, and analytical delivery.
• Strong understanding of dimensional modeling, including facts, dimensions, star schemas, conformed dimensions, slowly changing dimensions, surrogate keys, and historical data management.
• Experience designing modern data warehouse, lakehouse, and medallion architectures, with the ability to determine when and where different patterns should be applied.
• Strong knowledge of Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, and Power BI capabilities.
• Strong experience with Azure data technologies and cloud-based data architectures.
• Strong understanding of ETL/ELT patterns, incremental data processing, change data capture, data reconciliation, and integration of heterogeneous source systems.
• SQL skills and understanding of data engineering practices, performance optimization, scalability, and workload management.
• Experience designing data architectures supporting enterprise reporting, semantic models, self-service BI, advanced analytics, AI/ML, and GenAI use cases.
• Strong understanding of data quality, metadata management, lineage, governance, security, privacy, and master/reference data concepts.
• Experience establishing reusable data architecture patterns, development standards, naming conventions, and data modeling practices across engineering teams.
• Ability to translate complex business concepts and processes into sustainable enterprise data models and architecture.
• Experience providing architectural guidance and conducting data models, pipelines, and solution design reviews with Data Engineering and BI teams.
• Experience modernizing legacy data warehouses and migrating analytical workloads to modern cloud-based data platforms.
• Strong collaboration skills across business SMEs, Data Engineering, BI, Application Engineering, Enterprise Architecture, and technology leadership.

Preferred

• Experience in insurance, healthcare, financial services, or another data-intensive and regulated industry preferred.

Benefits

• Medical Stop Loss or Accident & Health insurance experience is a plus.
• Tokio Marine offers a competitive salary and benefits package, including: Generous paid time off (PTO), 12 paid company holidays, 401(k) Retirement Plan with 6% company match.
• Health and dental insurance, and vision plan available.
• Company-provided long-term disability and life insurance.
• Opportunities for advancement in a successful and growing organization.
• Flexible work schedules and a great work/life balance.
• Paid Parental Leave.
• Volunteer Time Off.
• Enjoy casual dress and work in a modern, comfortable office with free parking.
• Hybrid work schedule The Tokio Marine HCC Group of Companies offers a successful, dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals.

Strong

The Tokio Marine HCC Group of Companies is an equal-opportunity employer. Please visit www.tmhcc.com for more information about our companies. #LI-CM3 #stoploss1