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.
Role Designation: Hybrid with a requirement to go into our Markham office once or twice a month.
Job Description
In this role, you will support the delivery of business intelligence solutions that enable data-driven decision-making across Operations. You will work with large datasets to uncover insights, identify opportunities, and support the development of reporting and analytics solutions that improve operational performance.
You’ll play a key role in a new and evolving environment, contributing to the growth of Allstate’s direct sales channel. By combining strong analytical thinking with technical skills, you will help ensure data is accurate, accessible, and actionable supporting both day-to-day business needs and longer-term strategic objectives.
Accountabilities
Analyze large and complex datasets to identify trends, anomalies, and opportunities for process improvement and growth
Aggregate, validate, and prepare data to ensure accuracy and reliability of reporting and insights
Develop and maintain reports and dashboards to support operational and business decision-making
Partner with stakeholders to gather and document data and reporting requirements
Support user acceptance testing (UAT) to ensure solutions meet business needs and quality standards
Identify and resolve data issues, system discrepancies, and reporting challenges
Uncover actionable insights and communicate findings to support business improvements
Contribute to the development of metrics and ensure alignment across BI solutions
Support application and reporting projects as a data subject matter expert
Qualifications
Must-have expertise in Microsoft Fabric ETL Pipelines, SQL, Power BI visualization, Excel, Microsoft 365, and marketing analytics.
Strong analytical and problem-solving skills, with the ability to interpret data and generate insights
Demonstrated experience working with data visualization and reporting tools such as Power BI, python and power automate.
Proficiency in Excel and working with large datasets
Strong attention to detail, with the ability to identify data quality issues and inconsistencies
Ability to manage multiple priorities and adapt in a fast-paced environment
Effective communication skills, with the ability to collaborate with stakeholders and support requirements gathering
Curiosity and a proactive mindset, with a desire to explore data and uncover opportunities
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.
#LI-ND2
Skills
Analytical Thinking, Business Intelligence (BI) Solutions, Data Analysis, Data-Driven Decision Making, ETL Pipelines, Marketing Analysis, Marketing Analytics, Market Trends, Microsoft Power Business Intelligence (PBI), Structured Query Language (SQL), User Acceptance Testing (UAT)
Compensation
- Compensation
- Expected compensation for this role ranges from $66,200.00 - $85,500 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.
