Senior Business Intelligence Specialist

Position Summary:

Position Summary

The Senior Business Intelligence Specialist plays a critical role in transforming data into actionable business insights that support strategic decision-making across SSRU and Ryan Specialty Canada. This role serves as a key partner to business leaders, leveraging data analytics, reporting, and visualization tools to identify trends, measure performance, and drive operational excellence.

Working closely with stakeholders across underwriting, operations, finance, claims, and executive leadership, the Senior Business Intelligence Specialist is responsible for developing and maintaining reporting solutions, dashboards, and analytical models that deliver meaningful business intelligence. The role will help shape data strategy, ensure data quality and governance, and support the organization's growing analytical capabilities through innovative reporting and automation solutions.

The successful candidate is a highly analytical problem solver with strong business acumen, expertise in Power BI and data analytics, and a passion for delivering data-driven insights that improve business performance and support organizational growth.

This posting is for an existing vacancy.

Salary Range: $90,000–$130,000 CAD annually, depending on experience, qualifications, and skills.

We use artificial intelligence (AI) tools to assist in evaluating candidate applications against job-related criteria. AI is not used to make hiring decisions, including decisions about which candidates are contacted, interviewed, advanced, or hired. All recruitment decisions are made by human reviewers.

Location:
Toronto, Ontario

Location:

Toronto - Ontario

What will your job entail?

• Develop, maintain, and enhance business intelligence reporting, dashboards, and analytics solutions.
• Partner with business leaders to understand reporting requirements and translate business needs into technical solutions.
• Aggregate, transform, and analyze complex data from multiple systems and sources.
• Deliver actionable insights that support operational, financial, and strategic decision-making.
• Design and implement Power BI dashboards and visualizations that track key business metrics and performance indicators.
• Identify trends, risks, opportunities, and process improvement initiatives through data analysis.
• Support data governance efforts by ensuring the accuracy, consistency, and integrity of reporting data.
• Collaborate with IT and business teams to integrate new data sources and improve reporting capabilities.
• Present findings and recommendations to stakeholders at all levels of the organization.
• Support strategic planning initiatives through forecasting, trend analysis, and performance reporting.

Drive Business Intelligence and Analytics Excellence

• Design, build, test, and maintain enterprise reporting solutions and dashboards.
• Develop meaningful KPIs and metrics that provide visibility into business performance.
• Perform complex quantitative and qualitative analyses to uncover business insights.
• Create automated reporting processes that improve efficiency and reduce manual effort.
• Validate reporting outputs and ensure data accuracy across all analytical tools.
• Support advanced analytics initiatives, including predictive reporting and business forecasting.
• Continuously improve reporting capabilities through new tools, methodologies, and best practices.

Build Strategic Business Partnerships

• Collaborate with business leaders to identify analytical opportunities and reporting requirements.
• Partner with underwriting, operations, finance, and executive teams to support business objectives.
• Translate complex technical findings into clear business recommendations.
• Act as a trusted advisor to stakeholders on data, reporting, and analytics solutions.
• Support enterprise initiatives by providing analytical expertise and performance insights.

Serve as the Reporting and Data Expert

• Act as the organization's subject matter expert for business intelligence, reporting, and analytics.
• Establish reporting standards, governance practices, and data quality controls.
• Maintain documentation for reporting processes, data definitions, and business rules.
• Monitor and improve data quality across reporting environments.
• Provide training and guidance to end users on reporting tools and dashboards.

Support Operational and Strategic Growth

• Analyze business processes and identify opportunities for improvement through data.
• Support executive reporting and board-level analytics requirements.
• Assist with strategic planning, budgeting, forecasting, and performance reviews.
• Recommend technology and reporting enhancements that improve organizational effectiveness.
• Mentor junior analysts and contribute to the development of internal analytics capabilities.

Qualifications

Education

• Bachelor's degree in Statistics, Mathematics, Economics, Business Analytics, Computer Science, Information Systems, or a related quantitative discipline.
• Master's degree or advanced analytics certification considered an asset.

Experience

• 8+ years of experience in business intelligence, reporting, data analytics, or a related field.
• Proven experience developing Power BI dashboards and enterprise reporting solutions.
• Experience working with large, complex datasets and multiple data sources.
• Strong understanding of business processes and the ability to translate business requirements into technical solutions.
• Experience within insurance, financial services, or related industries is considered a strong asset.

Licenses and Certifications

• Microsoft Power BI Data Analyst Associate (PL-300) preferred.
• Certified Business Intelligence Professional (CBIP) considered an asset.
• Other data analytics or business intelligence certifications are welcomed.

Key Competencies

Technical Expertise

• Business Intelligence & Reporting
• Power BI
• Data Analytics & Visualization
• SQL
• Data Modeling
• ETL Processes & Data Integration
• KPI Development & Performance Measurement
• Forecasting & Trend Analysis
• Data Governance & Quality Controls
• Process Improvement & Automation

Leadership Capabilities

• Analytical Thinking: Leverages data to identify trends, solve problems, and support business decisions.
• Business Partnership: Builds credibility and trust while effectively supporting stakeholders across the organization.
• Communication: Translates complex analytics into practical business recommendations.
• Innovation: Continuously seeks opportunities to improve reporting, analytics, and business processes.
• Execution Excellence: Delivers accurate, timely, and impactful reporting solutions.
• Coaching & Mentorship: Supports the development of colleagues and promotes a culture of continuous learning.

Why this role matters

The Senior Business Intelligence Specialist enables informed decision-making across the organization by transforming data into meaningful insights, improving transparency, driving operational excellence, and supporting SSRU's continued growth through data-driven strategies and reporting capabilities.

Disclaimer

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.