Senior Data Architect

Tokio Marine HCC International; Kennesaw (GA); On-site; USD 130,000 - 190,000; Full time

Benefits offered by this job

PTO & holidays

401(k) with company match

Health, dental & vision insurance

Long-term disability & life insurance

Hybrid work schedule

Paid parental leave

Volunteer time off

Casual dress code

Free parking

Job summary

Tokio Marine HCC seeks a Data Architect to design the future-state enterprise data platform for Medical Stop Loss, defining the architecture, data models, integration patterns, and standards for a modern data warehouse and analytics stack built on Microsoft Fabric and Azure.

You will partner with business SMEs and Data & Analytics, Application Engineering, and Enterprise Architecture to ensure data is integrated, governed, and available for reporting, analytics, AI, and GenAI use cases,

Qualifications

• Experience with enterprise data warehousing architecture, design patterns, and best practices.
• Designing data warehouses from ingestion to consumption, including data integration and analytics delivery.
• Strong SQL skills and performance optimization for large-scale data environments.
• Experience with modern cloud data architectures (Azure, Fabric) and BI capabilities.
• Knowledge of governance, metadata, lineage, security, and data quality in data ecosystems.

Responsibilities

• Define target-state architecture for the data warehouse and data platform on Fabric and Azure.
• Establish patterns for ingestion, transformation, storage, modeling, integration, and consumption.
• Lead design of conceptual, logical, dimensional, and physical models for key domains.
• Integrate data from Policy Administration, Claims, Underwriting, and partners.
• Provide architectural guidance and review data models, pipelines, and solutions.

Skills

Data warehousing

Data modeling

ETL/ELT

SQL

Microsoft Fabric

Azure

Power BI

Data governance

Architectural leadership

Tools

Power BI

Azure Data Factory

OneLake

Job description

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.

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

Education, Experience & Knowledge:

• Deep understanding and hands-on implementation experience with enterprise data warehousing principles, architecture, design patterns, and best practices.
• 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.
• Strong 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.
• Experience in insurance, healthcare, financial services, or another data-intensive and regulated industry preferred.
• 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. The Tokio Marine HCC Group of Companies is an equal-opportunity employer. Please visit www.tmhcc.com for more information about our companies.