Remote Data Analyst – Insurance Analytics & Dashboards

AIS Insurance; Northern (KY); Hybrid; USD 77,000 - 142,000; Full time

Benefits offered by this job

Competitive compensation

Remote-friendly US

Paid time off

Bonus programs

Healthcare

401(k) retirement plan

Development opportunities

Education assistance

Company recognition

Wellbeing resources

Job summary

Auto Insurance Specialists is seeking a Data Analyst to provide data and reporting support, helping identify unprofitable risk segments and reduce premium leakage across lines. This remote role involves developing dashboards, monitoring underwriting production, and driving data-informed decisions.

The candidate will work with the Data Analyst Team Lead, leveraging Excel, SQL, Power BI, and other tools to deliver insights and improve AIS processes. In-person interviews may be required.

Qualifications

• Proficient in performing data analysis and reporting using Excel, SQL, and Power BI.
• Experience with dashboard creation and data visualization.
• Knowledge of data modeling and SQL querying techniques.
• Familiarity with data warehousing concepts and BI tools.
• Experience with automation tools for data workflows.

Responsibilities

• Data Analysis & Reporting: generate on-demand reports and standard templates; support premium leakage initiative.
• Collaboration & Support: work with AIS leaders to identify data needs; follow project plans with objectives and timelines.
• Reporting & Productivity Monitoring: create, monitor, and analyze CSR and Sales Agent productivity reports; improve efficiency.
• Tools & Systems Usage: coordinate reporting using MicroStrategy, Power BI, Winbroker II, Amazon Connect, Taske, and data warehouse.
• General Support: assist in developing AIS goals and support team objectives.

Skills

Data Analysis & Reporting

Excel

SQL

Power BI

Data Visualization

VLOOKUP/XLOOKUP

Data Modeling

Robotic Process Automation

Underwriting & Analytics

Communication Skills

Project Management

Adaptability

Education

Bachelor’s degree

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, helping identify unprofitable risk segments and reduce premium leakage across lines. This remote role involves developing dashboards, monitoring underwriting production, and driving data-informed decisions.

The candidate will work with the Data Analyst Team Lead, leveraging Excel, SQL, Power BI, and other tools to deliver insights and improve AIS processes. In-person interviews may be required.