Data Analyst

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, level funded stop loss, 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.

About the role

The Data Analyst supports business and technology teams by translating data needs into scalable reporting and analytics solutions. This role partners with business subject matter experts (SMEs) to understand reporting requirements, collaborates with engineering teams to source and prepare data within Azure and Microsoft Fabric, and develops business intelligence dashboards using Power BI and Tableau. The analyst operates in an agile environment and develops foundational expertise in data pipelines, data modeling, and modern analytics platforms to enable data-driven decision-making across Medical Stop Loss operations.

Responsibilities

• Business & Requirements Collaboration
  • Partner with business SMEs (e.g., underwriting, claims, actuarial, finance) to understand data needs, KPIs, and reporting requirements
  • Facilitate requirement gathering sessions and document business rules, definitions, and metrics
  • Translate business needs into structured data and reporting requirements for engineering teams
  • Support prioritization of backlog items based on business value and delivery feasibility
• Data Analysis & Validation
  • Perform data analysis, profiling, and validation across multiple enterprise data sources
  • Identify and troubleshoot data quality issues in collaboration with engineering teams
  • Organize and synthesize data into actionable insights for business stakeholders
  • Support definition and validation of data models and semantic layers
• Data Pipeline & Platform Collaboration (Azure & Fabric)
  • Work closely with data engineers to support development of data pipelines in Azure and Microsoft Fabric
  • Assist in defining requirements for data ingestion, transformation, and storage (e.g., Lakehouse, Dataflows)
  • Validate datasets produced through pipelines to ensure business accuracy and completeness
  • Contribute to documentation of data lineage, transformations, and data definitions
• Reporting & Business Intelligence
  • Design and develop dashboards and reports using Power BI (primary) and Tableau (secondary)
  • Build intuitive visualizations and data models within Fabric/Power BI semantic models
  • Ensure consistency in metric definitions and reporting standards across the organization
  • Maintain and enhance existing reports for performance, usability, and scalability
• Process & Delivery
  • Participate in Agile/Scrum ceremonies (stand-ups, sprint planning, retrospectives)
  • Provide clear communication on progress, risks, and dependencies
  • Maintain documentation for requirements, reports, and data definitions
  • Continuously build skills in Azure, Fabric, and analytics best practices

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience)
• 1-3 years experience in data analysis, business intelligence, or related field

Benefits

• Generous paid time off (PTO) and 12 paid company holidays
• 401(k) Retirement Plan with 6% company match
• Health, dental, and vision insurance
• Company-provided long-term disability and life insurance
• Paid Parental Leave
• Volunteer Time Off
• Casual dress and modern, comfortable office with free parking
• Hybrid work schedule
• Opportunities for advancement in a successful and growing organization
• Flexible work schedules and a great work/life balance