Senior Analyst, Business Intelligence -
- Toronto, ON, Canada
Expected compensation for this role ranges from $ 73,500.00 - 116,850.00 annually. · Full-time
Applications open in a new tab.
Job details
- Pay
- Expected compensation for this role ranges from $ 73,500.00 - 116,850.00 annually.
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
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. Serving Canadians since 1953, Allstate strives to reassure both customers and employees with its “You’re in Good Hands®” promise and is proud to have been named a Best Employer in Canada for nine consecutive years. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. To learn more, visit www.allstate.ca. For safety tips and advice, visit www.goodhandsadvice.ca.
Through our Employee Value Proposition, 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.
Benefits To Joining Allstate
- Flexible Work Arrangements.
- Employee discounts (15% on auto and property insurance, plus many other products and services).
- Good Office program (receive up to $400 back after purchasing office equipment).
- Student Loan Payment Matching Program for Government Student loans.
- Comprehensive Retirement Savings Program with employer matched contributions.
- Annual Wellness allowance to support employees with improving health and wellbeing.
- Personal days.
- Tuition Reimbursement.
- Working within the community and giving back.
Job Description
In this role, you will partner with business stakeholders to transform complex data into actionable insights that drive customer-focused and data-driven decisions across Operations. You will work at the intersection of analytics and business strategy - breaking down problems, identifying trends, and delivering clear recommendations that influence operational efficiency and performance.
You’ll play a key role in a new and evolving space, supporting initiatives such as the launch and optimization of Allstate’s direct sales channels. By combining strong analytical thinking, storytelling, and technical expertise, you will help shape how data is used to guide decisions, improve customer experience, and uncover new opportunities for growth.
Accountabilities:
- Analyze structured and unstructured data from multiple sources to identify trends, patterns, and key business drivers
- Translate business questions into structured analysis, delivering actionable insights and recommendations
- Develop dashboards, reports, and scorecards to monitor performance and support decision-making
- Partner with stakeholders to gather requirements, align priorities, and provide consultative analytics support
- Assess performance against targets, identify variances, and recommend data-driven solutions to improve outcomes
- Forecast operational volumes and provide insights to support workforce planning and business strategy
- Build compelling data stories and visualizations to communicate insights effectively to diverse audiences
- Lead and deliver analytics projects of moderate complexity, including defining timelines, priorities, and deliverables
- Contribute to continuous improvement by enhancing analytical methodologies, processes, and reporting capabilities
- Must have demonstrated experience working with data visualization and analytics tools such as in Fabric ETL Pipelines, SQL, Visualization/Power BI, MS 365, Adobe Workspace
- Strong analytical and problem-solving skills, with the ability to interpret complex data and generate actionable insights
- Strong proficiency in Excel, including large dataset management, pivot table creation, and ad hoc analytical reporting.
- Ability to translate data into clear, compelling narratives for both technical and non-technical audiences
- Strong stakeholder engagement and communication skills, with the ability to influence decision-making
- Experience gathering requirements and working in a consultative, business-facing analytics role
- Familiarity with data querying or programming languages (e.g., SQL, DAX, or similar) is an asset
- Strong organizational and prioritization skills, with the ability to manage multiple projects in a dynamic environment
- Curiosity and a proactive mindset, with a passion for exploring data and uncovering insights.
Skills
Business Analysis, Business Case Analyses, Data Analytics, ETL Pipelines, ETL Workflows, Microsoft Copilot for Power BI, Microsoft Office 365, MS SQL Development, MS SQL Queries, Structured Query Language (SQL)
Compensation
Compensation
Expected compensation for this role ranges from $ 73,500.00 - 116,850.00 annually. Actual salary offered to successful candidates will vary based on their skills and experience.
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. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.
Allstate Canada Group uses AI technology tools to assist in screening, selecting, assessing, and scheduling interviews with candidates as part of the recruitment process.
This job posting is for a current open role within the organization.
More about this job
Responsibilities
Analyze data from multiple sources to identify trends, assess performance, forecast operational volumes, and provide actionable recommendations that support customer-focused decisions and workforce planning. Develop dashboards, reports, scorecards, and data stories while partnering with stakeholders and leading moderately complex analytics projects.
Requirements
Candidates must have experience with analytics and visualization tools such as Microsoft Fabric ETL pipelines, SQL, Power BI, Microsoft 365, and Adobe Workspace, along with strong Excel skills. They should be able to interpret complex data, communicate insights clearly, engage stakeholders, gather requirements, and manage multiple projects; familiarity with SQL, DAX, or similar languages is an asset.
Skills
- Business Analysis
- Data Analytics
- ETL Pipelines
- ETL Workflows
- Microsoft Fabric
- Power BI
- Microsoft Office 365
- Microsoft Excel
- SQL
- DAX
- Data Visualization
- Stakeholder Engagement
- Requirements Gathering
- Forecasting
- Business Intelligence
Benefits
- Flexible Work Arrangements
- Employee Discounts
- Office Equipment Allowance
- Student Loan Payment Matching
- Retirement Savings Program With Employer Matching
- Wellness Allowance
- Personal Days
- Tuition Reimbursement
- Community Involvement
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Finance & Accounting
- Consulting
Keywords
- Business Intelligence
- Business Analysis
- Data Analytics
- Structured And Unstructured Data
- Microsoft Fabric
- ETL Pipelines
- ETL Workflows
- SQL
- DAX
- Power BI
- Microsoft Office 365
- Microsoft Excel
- Adobe Workspace
- Data Visualization
- Dashboards
- Reports
- Scorecards
- Forecasting
- Workforce Planning
- Operational Performance
- Business Strategy
- Customer Experience
- Stakeholder Engagement
- Requirements Gathering
- Consultative Analytics
- Data Storytelling
- Continuous Improvement
- Insurance
- Direct Sales Channels