Apply on Employer Site

Ryan Specialty · 5 hours ago

Data Analyst

Chicago, IL

Full-time

Onsite

Entry, Mid Level

$74K/yr - $93K/yr

1+ years exp

Ryan Specialty is a company that focuses on providing specialized insurance solutions. The Data Analyst role involves handling complex data projects, providing analytical support for business operations, and developing reports for management.

Financial ServicesInsuranceRisk Management

Comp. & Benefits

H1B Sponsor Likely

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, Access, SQL, 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

Performs other duties as assigned

Qualification

SQLData VisualizationETL PipelinesPower BIPythonBusiness AnalyticsData WarehouseAnalytical ThinkingEffective CommunicationProblem SolvingTime Management

Required

Bachelor's degree in related field or equivalent experience

1+ years of statistical analysis or 1+ years of related IT experience, including data warehouse, coding or ETL experience

Experience managing projects or heavy involvement in project implementation

Experience in Data Visualization and building dashboards using SQL

Experience with Coding language such as Python or R

Experience in underwriting analysis

Business Analytics

Data Governance

SQL

ETL Pipelines

Coding

Data Warehouse

Dashboards

Data Visualization

Ad hoc Reporting

Tableau

Power BI

Analytical Thinking

Customer Service Management

Effective Communication

Organizational Skills

Problem Solving

Time Management

Preferred

Power BI Data Analyst Associate Certification (PL-300)

Tableau Certified Data Analyst

Benefits

Paid time off for company holidays

Vacation

Sick and personal days

Paid parental leave

Mental health services

Company

Ryan Specialty

Glassdoor3.7

Ryan Specialty is an insurance firm that provides solutions for brokers, agents, and insurance carriers.

Founded in 2010

Chicago, Illinois, USA

5001-10000 employees

https://ryanspecialty.com

H1B Sponsorship

Ryan Specialty has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (7)

2024 (5)

2023 (1)