Data Analyst

Position Summary

The Data Analyst is responsible for analytic data needs of the business unit. Handle complex data projects and acts as a lead for other Data Analysts.

Job 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.

• 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.

• Power BI Data Analyst Associate Certification (PL-300), or Tableau Certified Data Analyst a plus.

Technical/Functional:

• Business Analytics
• Data Governance
• SQL
• ETL Pipelines
• Coding
• Data Warehouse
• Dashboards
• Data Visualization
• Ad hoc Reporting
• Tableau
• Power BI

Behavioral:

• Analytical Thinking
• Customer Service Management
• Effective Communication
• Organizational Skills
• Problem Solving
• Time Management

Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout our organization. Our vision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. We consider differences in race, creed, color, religious beliefs, physical or mental capabilities, gender identity or expression, sexual orientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients and partners.

Ryan Specialty offers a comprehensive benefits package that helps employees and their families achieve physical, financial, and emotional well-being. Included benefits are paid time off for holidays, vacation, sick and personal days, paid parental leave, mental health services, and more.

The target salary range for this position is $74,400.00 - $93,000.00 annually. Full-time roles are eligible for bonuses and benefits. The wage range may be modified in the future.

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation at

The above is intended to describe this job's general requirements and is not an exhaustive statement of duties, responsibilities, or physical requirements. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.