Business Intelligence Senior Analyst

Allstate Canada; Markham; Hybrid; CAD 75,000 - 95,000; Full time

Job summary

A leading insurance company in Canada is seeking a Business Intelligence Senior Analyst to join their growing team in Markham. The successful candidate will utilize data analytics to generate insights that drive business performance across various functions. This position requires a strong background in data analysis, experience with Power BI and SQL, and excellent communication skills to present insights to stakeholders. Join a company that values employee growth and inclusivity while helping protect families in Canada.

Qualifications

• 3-5 years of relevant experience in Marketing, Actuarial or Analytics.
• Strong knowledge of Power BI suite and presenting findings to partners.
• Excellent verbal and written communication skills.

Responsibilities

• Generate data insights and propose data-driven solutions for business partners.
• Create Power BI reports and dashboards to interpret trends in complex data.
• Lead multiple project streams and provide technical direction.

Skills

Data Analysis

Power BI

SQL

Project Management

Communication

Problem Solving

Education

University Degree (Math/Stats/Engineering or similar)

Tools

SAS

Microsoft SQL Server

Job description

Join to apply for the Business Intelligence Senior Analyst role at Allstate Canada

Join to apply for the Business Intelligence Senior Analyst role at Allstate Canada

At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection.

Job Description

Who is Allstate:

Allstate Insurance Company of Canada is a leading home and auto insurer focused on providing its customers prevention and protection products and services for every stage of life. The company is proud to have been named a Best Employer in Canada for nine consecutive years and prioritizes supporting employees and fostering an inclusive, welcoming corporate culture. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. Serving Canadians since 1953, Allstate strives to provide reassurance with its "You’re in Good Hands" promise.

Through our Employee Value Proposition, Opportunity, Flexibility, Community, Diversity and Family, we have worked hard to develop and nurture a culture where employees feel valued, experience personal growth, have career options and truly enjoy the work they do.

Role Designation: Hybrid

Our team is growing and we are actively looking to hire a Business Intelligence Senior Analyst to join our team! The Business Intelligence team provides key insights on all aspects of the customer lifecycle. We support most functions within the Allstate Company Group (Allstate, Pembridge, PAFCO and Ivantage) such as Product, HR, Marketing, Underwriting, Finance, Risk, Compliance, SLT and many more. The candidate will be providing data driven insights, and making recommendations that drive business performance to support Allstate Canada Group’s business plans and results.

Accountabilities:

• Meet with our various partners regularly to understand their objectives and challenges and propose data driven solutions that will help drive the business forward
• Use existing dashboards or mine our databases to generate the data needed to answer the specific business questions.
• Create Power Bi reports and dashboards to identify, analyze, and interpret trends or patterns in complex data sets
• Use ANOVA testing to determine if results are significantly different
• Summarize and present your findings to partners and executives, focusing on value added content that will help Partners better manage their business
• Advise business stakeholders on how to measure their business processes and advise on best metrics to use for different processes
• Gather proper requirements and ensure they are aligned with the overall objective and insights sought by our business stakeholders
• Work with management to prioritize business and information needs
• Locate and define new process improvement opportunities
• Ability to Lead multiple project streams and provide technical direction to BI Analyst on designing solution.
• Develop and Optimize SAS/SQL programs to create efficiency on run time.
• Extensive knowledge and use of Microsoft SQL Server and all Microsoft services associated with SQL Server (SSIS, SSRS, and SSAS) is a plus but not required.
  
  

Qualifications & Experience:

• University Degree (Math/Stats/ engineering or similar) preferred
• 3-5 years of relevant experience is recommended (Marketing, Actuarial or Analytics)
• At least 3 years of experience using Base SAS/EG, SAS Macro, SQL, Power Bi
• Strong knowledge of Power Bi suite of Products
• At least 3 yrs experience presenting analytical findings to Partners using PowerPoint or similar
• Ability to perform ANOVA testing, hypothesis testing to determine if results are significantly different
• Excellent verbal and written communication skills, effective negotiation and problem-solving skills
• Collaborate with stakeholders to identify needs and opportunities to provide insights on how to better manage their business
• Strong analytical and critical thinking skills to resolve / Propose solution approach to resolve stakeholder’s problem / needs and presenting findings
• Ability to work in a team as well as independently
• Identifying new ideas, techniques and opportunities for improving effectiveness, performance and productivity is essential
• Sound knowledge of relational database structure
• Proficient in MS Word, Excel, and PowerPoint Experience with insurance/actuarial data will be considered a plus
  
  

Allstate Canada Group has policies and practices that provide workplace accommodations. If you require accommodation, please let us know and we will work with you to meet your needs.

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.

Good Hands. Greater Together.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Insurance and Financial Services

Referrals increase your chances of interviewing at Allstate Canada by 2x

Get notified about new Senior Business Intelligence Analyst jobs in Markham, Ontario, Canada.

Business Analyst (Power BI & Tableau), Technology Services Group

Senior Business Intelligence Analyst (Power Automate / Apps)

Business Analyst / Power BI & Alteryx - Contract Role

Sr. Manager, Business Intelligence & Reporting

Manager, Business Intelligence & Information Management

Business Intelligence Manager- Biopharma

Manager, Business Intelligence and Reporting

Data Analytics & Reporting Analyst - Fall 2025 (Co-op/Internship) - 8 Months

Senior Analyst, Data Audience and Activation (English Services) (Telework/Hybrid)

Senior Business Analyst, Data Integration & Performance Platform (12 month contract)

Senior Business Analyst - Wealth Platform Data Masters

Business Analyst, Investment Data Operations

Senior Analyst, Data & AI Ethics - Research

Senior Analyst, Data Audience and Activation (English Services) (Telework/Hybrid)

Senior Analyst, Data and Application Support

Senior Consultant, Senior Business Data Analyst / Program Manager (AML & KYC)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.