Data Analyst

Tokio Marine HCC – A&H Group; Kennesaw (GA); Hybrid; USD 70,000 - 95,000; Full time

Benefits offered by this job

PTO & holidays

401(k) match

Health & dental insurance

Vision plan

Long-term disability & life insurance

Parental leave

Volunteer time off

Casual dress

Free parking

Hybrid work schedule

Job summary

Tokio Marine HCC – A&H Group seeks a Data Analyst to translate data needs into scalable reporting solutions. You will partner with underwriting, claims, actuarial, and finance SMEs to define KPIs, build dashboards in Power BI (primary) and Tableau, and collaborate with data engineers on Azure and Fabric-powered pipelines.

The role emphasizes agile delivery and data-driven decision making. The ideal candidate has 1–3 years in data analytics, SQL proficiency, and strong Excel skills, with

Qualifications

• Bachelor's degree in a related field or equivalent experience
• 1-3 years in data analysis, BI, or related field
• SQL proficiency for querying and data analysis
• Experience with Power BI (preferred) and/or Tableau
• Familiarity with Microsoft Fabric or Azure data platforms is a plus
• Proficiency with Excel and Office tools

Responsibilities

• Partner with business SMEs to understand data needs, KPIs, and reporting requirements
• Translate business needs into structured data and reporting requirements for engineering teams
• Perform data analysis, profiling, and validation across multiple enterprise data sources
• Design and develop dashboards with Power BI (primary) and Tableau
• Work with data engineers to support data pipelines in Azure and Microsoft Fabric
• Participate in Agile/Scrum ceremonies and maintain documentation

Skills

SQL

Power BI

Tableau

Excel

Data analysis

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field

Tools

Azure

Microsoft Fabric

Data pipelines

Dashboards

Job description

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

Position Summary

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.

Key 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
• Translating 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

Education, Experience & Knowledge

• 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.
• Working knowledge of SQL for querying and data analysis
• Experience with Power BI (preferred) and/or Tableau
• Familiarity with Microsoft Fabric or Azure data platforms is a strong plus
• Understanding of relational databases and data structures
• Basic knowledge of ETL/ELT or data pipeline concepts
• Proficiency in Microsoft Excel and Office tools

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.
• this role is onsite with 2 remote days a week

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.