Ryan Specialty→
Business Analyst at Ryan Specialty in Chicago, IL
Entry LevelOn-siteFull-timeChicago, IL$64k–$80k/yr
Skills
advanced excel skillsbasic sql knowledgeanalytical mindsetwritten communication skillsverbal communication skillsorganizational abilitiestime-management abilitiesattention to detail
Job Description
Summary: Ryan Specialty is a dynamic and rapidly growing organization focused on alternative insurance solutions. The Business Analyst will support the development and execution of workflows by providing data-driven insights, collaborating with teams, and assisting in the development of new tools and processes.
Responsibilities:
- Collaborating with cross-functional teams to design and optimize business workflows for alternative insurance solutions
- Performing data analysis to support strategic decisions and program development
- Creating reports and dashboards to monitor performance and identify opportunities for improvement
- Assisting in the development of new tools and processes (e.g., rating methodologies, automation solutions)
- Communicating effectively with internal teams, brokers, and stakeholders to ensure alignment and transparency
- Supporting compliance and monitoring industry trends to inform business initiatives
Required Qualifications:
- Bachelor's degree or minor in Business, Economics, or a Quantitative discipline
- 0–1 year of experience (entry-level; training provided)
- Strong interest in the insurance industry and willingness to learn
- Advanced Excel skills (including formulas, pivot tables; VBA/macros a plus)
- Basic knowledge of SQL for data extraction and manipulation
- Strong written and verbal communication skills
- Excellent organizational and time-management abilities
- Analytical mindset with attention to detail
Preferred Qualifications:
- Degree in business, economics, or a quantitative discipline preferred
- Strong interest in the insurance industry and enthusiasm for building innovative solutions
- Ability to work independently and as part of a collaborative team
- Comfortable in a fast-paced environment and eager to tackle complex challenges
Required Skills: Advanced Excel skills
Important Skills: Basic SQL knowledge
Nice-to-Have Skills: Analytical mindset, Written communication skills, Verbal communication skills, Organizational abilities, Time-management abilities, Attention to detail
Benefits: Paid time off for company holidays, Vacation, Sick and personal days, Paid parental leave, Mental health services
Benefits
Paid time off for company holidays
Vacation
Sick and personal days
Paid parental leave
Mental health services