Senior Business Analyst
About The Position
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
Requirements
- 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
- 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
- Analytical Thinking
- Effective Communication, especially between cross-functional teams
- Organizational Skills
- Problem Solving
- Time Management
Responsibilities
- 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
Benefits
- 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.
- For additional information on Ryan Specialty Total Rewards, visit our website https://benefits.ryansg.com/.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
