Remote Data Analyst: Insurance Analytics & Reporting

AIS Insurance Specialists; United States; Remote; USD 77,000 - 142,000; Full time

Benefits offered by this job

Competitive compensation

Flexibility to work from anywhere in U

Paid time off

Incentive bonus programs

Medical, dental, vision, life, and pet

401(k) retirement savings with company

Education assistance

Professional development opportunities

Company recognition program

Mental wellbeing therapy/coaching & cr

Job summary

Auto Insurance Specialists is seeking a Data Analyst to provide data and reporting support, driving data-informed decisions while identifying opportunities to reduce premium leakage across all lines of business. The role emphasizes creating reports, dashboards, and monitoring underwriting production.

The position is remote, with opportunities to collaborate across AIS leadership, develop skills in analytics, and support process improvements within the organization.

Qualifications

• Data analysis & reporting using Excel, SQL, and Power BI.
• Excel skills: VLOOKUP/XLOOKUP, pivot tables, charts, formatting.
• Power BI or Tableau for dashboards and visualizations.
• SQL including joins, lag/lead, case statements; data modeling basics.
• UiPath or Power Automate for automation basics.
• Insurance industry knowledge, especially Home/Auto/Commercial.
• Strong underwriting and analytical skills for premium-loss analysis.
• Excellent written and verbal communication for presenting findings.
• Time management to handle multiple projects in a team setting.
• Willingness to learn new tools and adapt to technologies.
• Compliance and confidentiality in handling data.

Responsibilities

• Generate on-demand reports and maintain standardized templates.
• Identify data needs and collaborate on process improvements.
• Monitor CSR and Sales Agent productivity and AIS processes.
• Coordinate with AIS users and leaders on data requirements.
• Develop dashboards and visualizations to present insights.
• Support team objectives and data-driven decision making.

Skills

Data analysis

SQL

Power BI

Excel

Data visualization

Underwriting knowledge

Communication skills

Project management

Adaptability

Confidentiality

R basics

Education

Bachelor's degree

Statistics coursework

SAS training

SQL training

Insurance experience

Tools

MicroStrategy

Power BI

Winbroker II

Amazon Connect

Taske

Mercury's Enterprise Data Warehouse

Job description

Auto Insurance Specialists is seeking a Data Analyst to provide data and reporting support, driving data-informed decisions while identifying opportunities to reduce premium leakage across all lines of business. The role emphasizes creating reports, dashboards, and monitoring underwriting production.

The position is remote, with opportunities to collaborate across AIS leadership, develop skills in analytics, and support process improvements within the organization.