Junior Data & Reporting Analyst (Insurance Analytics)

Role: Junior Data \& Reporting Analyst

(Insurance Analytics)

Requisition ID:

CD-FCI-DA-0626-INS

Experience:

0-2 Years

(Internships acceptable)

Duration:

18-24 Months

Work Model:

Hybrid

Location: Bedford Park, IL

Work Authorization:

OPT, OPT-EXT, CPT, GC, GC-EAD, H4-EAD, TN Visa

Business \& Project Context

This role supports analytics and reporting initiatives within the Product \& Actuarial function, focusing on:

• Insurance product performance (Auto, Liability)
• Claims and underwriting analytics
• Business and operational reporting

The team works across business units including Underwriting, Claims, Marketing, and Finance, delivering structured dashboards, reports, and performance insights to support decision-making.

The environment involves data from multiple internal systems, requiring data validation, reporting consistency, and structured analytics within a regulated insurance domain.

Role Objective

The Junior Data \& Reporting Analyst supports the Product \& Actuarial team by developing and maintaining structured reports, performing data validation, and generating insights across insurance product lines (Auto, Liability). The role involves working with data from underwriting, claims, and operational systems to ensure reporting accuracy, track performance trends, and support business decision-making. It requires strong attention to data quality, consistency, and collaboration with cross-functional teams to deliver reliable and actionable outputs.

Key Responsibilities

• Support development and maintenance of recurring business reports and dashboards (weekly/monthly/quarterly)
• Translate stakeholder requirements into simple reporting and data visualization outputs
• Perform data validation, cleansing, and accuracy checks across multiple data sources
• Assist in trend analysis and performance tracking for insurance product lines
• Support automation of reporting processes to improve efficiency and reduce manual effort
• Collaborate with business teams (Underwriting, Claims, Finance) to understand reporting needs
• Assist in developing KPIs and performance metrics for business evaluation
• Maintain documentation for reports, data definitions, and reporting logic
• Support ad-hoc data requests and business analysis tasks

Required Skills

• Bachelor’s degree in Data Analytics / Computer Science, Mathematics / Statistics. Business Analytics / Finance / Actuarial Science
• Strong proficiency in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas)
• Basic to intermediate knowledge of SQL and relational databases
• Understanding of data analysis, reporting, and structured datasets
• Strong analytical and problem-solving skills
• Ability to work with large datasets and identify trends/patterns
• Good communication skills for interacting with business stakeholders
• Ability to manage multiple tasks and work within deadlines

Preferred Qualifications

• Exposure to

insurance domain (Property \& Casualty)

through coursework or internship is a plus

• Familiarity with

data visualization tools (Power BI, Tableau, or similar)

• Basic knowledge of

data mapping and reporting frameworks

• Exposure to tools such as SAS, R, or Python (academic level acceptable)
• Understanding of

business metrics, financial reporting, or operational analytics