Data Analyst

RT Specialty, a division of Ryan Specialty, is a leading wholesale distributor of specialty insurance products and services. Our experienced brokers are specialized in property, casualty, professional lines, transportation and workers’ compensation, providing creative solutions to retail brokerage firms. We define ourselves through our superior execution on behalf of our clients, which has established us as a leader in the industry. Position Summary 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. What will your job entail? 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, 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. Required Experience: • Bachelor’s degree in Business, IT, or related field • Proficiency in Excel and Power BI • Experience managing projects or heavy involvement in project implementation. • Experience in Data Visualization and building dashboards Preferred Experience: • Experience with Coding language in Python • Experience in underwriting analysis. • Statistical analysis • Data warehouse Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the organization. Our vision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. 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, trading partners, and communities. This policy extends to all aspects of our employment practices, including but not limited to, recruiting, hiring, discipline, firing, promoting, transferring, compensation, benefits, training, leaves of absence, and other terms, conditions, and benefits of employment. How We Support Our Teammates Ryan Specialty seeks to offer our employees a comprehensive and best-in-class benefits package that helps them — and their family members — achieve their physical, financial, and emotional well-being goals. In addition to paid time off for company holidays, vacation, sick and personal days, Ryan offers paid parental leave, mental health services and more. The target salary range for this position is $62,000.00 - $62,000.00 annually. The wage range for this role considers many factors, such as training, transferable skills, work experience, licensure and certification, business needs, and market demands. The pay range is subject to change and may be modified in the future. Full-time roles are eligible for bonuses and benefits. For additional information on Ryan Specialty Total Rewards, visit our website 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 View email address on click.appcast.io The above is intended to describe this job's general requirements. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. A multi-time winner of Newsweek’s Most Loved Workplaces and Insurance Business’s Top Insurance Employers, Ryan Specialty is home to some of the brightest talent in the insurance industry. Join our team and help provide innovative solutions for insurance brokers, agents and carriers. Talent Network Not seeing the right job opening? To learn more about future opportunities Introduce yourself and join our talent network Benefits Curious about Ryan Specialty’s benefits? Explore our employee benefits here! Ryan Specialty, LLC and its affiliates (“Ryan Specialty”) do not accept unsolicited resumes or candidate profiles submitted by any staffing agencies, placement services or professional recruiters (“Agencies”), including any submissions made through our website or to email accounts of Ryan Specialty employees. Agencies must be registered in Ryan Specialty’s agency portal and have a fully executed contract for service between Ryan Specialty and the Agency. Agency fee agreements will only be valid if provided in such fully executed contract between Ryan Specialty and the Agency. Any unsolicited resume or candidate profile received from an Agency without prior approval from Ryan Specialty’s HR department and in compliance with Ryan Specialty’s candidate submission process shall be considered unsolicited, gratuitous and property of Ryan Specialty for recruiting purposes and, as such, is not subject to payment of any Agency fees.