Senior Business Analyst

Ryan Specialty Group

Chicago, Illinois

Apply

JOB DETAILS

SKILLS

Address Management, Analysis Skills, Business Analysis, Business Intelligence, Business Intelligence Software, Communication Skills, Compensation and Benefits, Cross-Functional, Data Analysis, Data Formats, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Management Reporting, Mentoring, Microsoft Excel, Microsoft Visual Basic for Applications (VBA), Multiplatform/Cross-Platform, Operations Management, Organizational Skills, Performance Analysis, Power BI, Problem Solving Skills, Project/Program Management, Quality Assurance, Reporting Dashboards, SQL (Structured Query Language), Tableau, Test Data, Time Management, Underwriting

LOCATION

Chicago, Illinois

POSTED

30+ days ago

Position Summary
The Senior Data Analyst is responsible for analytic data needs of Ryan Specialty Underwriting Managers (RSUM). This role will handle complex data projects and act as a liaison between systems teams, business teams, and multiple data teams to implement new datapoints in the enterprise data warehouse. This role will also be responsible for downstream reporting to operational teams, utilizing these newly added datapoints along with legacy data.

What will your job entail?

Coordinate with the Corporate systems team, Corporate data engineering team, and RSUM Business Intelligence team for implementation, validation, and reporting of newly added data fields in core source systems
Review data to determine operational impacts and needed actions; elevate issues, trends, areas for improvement and opportunities to management
Work with data in several tools/capacities to address operational and management reporting needs, including MS Excel, SQL, Power BI, DataBricks, etc.
Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources
Own end-to-end lifecycle of data & reporting projects
Assist with training and mentoring other Data Analysts
Performs other duties as assigned

Work Experience and Education:

Bachelor's degree in related field, and 7-10 years of experience in roles related to business analysis, data analysis, business intelligence, etc.
Experience managing projects or heavy involvement in project implementation
Experience collaborating with multiple cross-functional teams to deliver projects & outcomes
Experience with regular QA testing and data validation

Technical/Functional Skills:

Business Analytics
Project Management
Data Governance
SQL
BI Tools: Dashboarding and Visualization in Power BI, Tableau, etc.
Intermediate/Advanced Fluency in MS Excel. Power Query, Power Pivot, and VBA are a plus.
ETL Pipelines and Data Warehousing

Behavioral Skills:

Analytical Thinking
Effective Communication, especially between cross-functional teams
Organizational Skills
Problem Solving
Time Management

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 $96,000.00 - $120,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 https://benefits.ryansg.com/.

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 HR@Ryansg.com

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 essen

About the Company

Ryan Specialty Group

Resume Resources

Free Resume Templates Free Resume Builder