Entry-Level Insurance Data Analyst

Job Title: Entry-Level Insurance Data Analyst

Location: Columbus, Ohio (Remote option Available)

Job Type: Full-Time

Experience Level: 0–2 Years

Work Authorization: OPT, CPT, GC, H4-EAD, L2

Job Overview:

We are seeking a detail-oriented and analytical Entry-Level Insurance Data Analyst to join our client’s analytics team. This role focuses on analyzing insurance data related to claims, underwriting, and policy performance to support business decisions and risk assessment strategies.

Key Responsibilities:

Collect, clean, and analyze large datasets related to insurance policies, claims, and customer data.

Perform data validation and ensure accuracy and consistency across multiple data sources.

Write and optimize SQL queries to extract and manipulate data from relational databases.

Assist in analyzing claims trends, fraud detection patterns, and risk factors.

Develop and maintain dashboards and reports using tools like Tableau or Power BI.

Support underwriting and actuarial teams with data-driven insights.

Identify patterns and trends to improve operational efficiency and customer experience.

Work closely with cross-functional teams, including claims, finance, and risk management.

Document data processes, workflows, and reporting methodologies.

Required Skills:

Strong knowledge of SQL and basic understanding of Python or R.

Proficiency in Excel (Pivot Tables, VLOOKUP, data analysis functions).

Basic understanding of data visualization tools (Tableau / Power BI).

Knowledge of insurance concepts (claims, underwriting, premiums) is a plus.

Strong analytical thinking and problem-solving skills.

Good communication and documentation skills.

Preferred Qualifications:

Bachelor’s degree in Data Analytics, Statistics, Mathematics, Finance, or related field.

Internship or academic project experience in data analysis or insurance domain.

Familiarity with ETL processes and data warehousing concepts.