Data Analyst

Ryan Specialty•Richmond, VA

About The Position

The Data Analyst supports the Personal Lines team by analyzing data, creating reports, and developing dashboards using Microsoft Excel and Power BI to deliver digestible meaningful business insights. This entry-level role is ideal for a recent graduate with strong technical skills who can demonstrate experience with Excel and Power BI through academic projects or internships. The position offers the opportunity to learn the insurance industry, collaborate with carrier partners, and grow into advanced analytics or underwriting career paths over time.

Requirements

Bachelor’s degree in Data Analytics, Statistics, Business, Finance, Risk Management & Insurance, or a related field.
Proficiency in Excel and Power BI
Experience managing projects or heavy involvement in project implementation.
Experience in Data Visualization and building dashboards

Nice To Haves

Experience with Coding language in Python
Experience in underwriting analysis.
Statistical analysis
Data warehouse

Responsibilities

Provide advanced analytical support for business operations in all or some of the following areas: claims, client data, policy data, and external reporting.
Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources.
Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management.
Develop reports and deliverables for management.
Model data using MS Excel, Power BI, and/or other data warehouse analytical tools.
Ensure compliance with federal and state deliverable reporting requirements by performing data quality audits and analysis.
Assist with training and mentoring other Data Analysts.
Supports Data systems as functional administrator evaluating new release functionality to include testing and implementation of new functionality.