Analyst, Business Intelligence

Allstate; Markham; Híbrido; CAD 66.000 - 86.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible Work Arrangements

Employee discounts (15% on auto and **

Office equipment reimbursement

Descripción de la vacante

Allstate Canada Group is seeking a data analyst to support the delivery of business intelligence solutions across Operations. You will work with large datasets to uncover insights and develop reporting that improves 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 to

Formación

• Must-have expertise in Microsoft Fabric ETL Pipelines, SQL, Power BI visualization, Excel, Microsoft 365, and marketing analytics.
• Strong analytical and problem-solving skills; ability to interpret data and generate insights.
• Experience with data visualization and reporting tools such as Power BI, Python and Power Automate.

Responsabilidades

• 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.

Conocimientos

Microsoft Fabric ETL Pipelines

SQL

Power BI visualization

Excel

Microsoft 365

Marketing analytics

Analytical Thinking

UAT

Herramientas

Power BI

Python

Power Automate

Descripción del empleo

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. 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 itoperatesthrough partnerships with charitable organizations, employeegivingand volunteerism. To learn more, visit www.allstate.ca. For safety tips and advice, visitwww.goodhandsadvice.ca.

Through our Employee Value Proposition, we haveworked hard to develop and nurture a culture where employees feel valued, experience personal growth, have careeroptionsandtruly enjoytheworkthey do.

Benefits to joining Allstate

• FlexibleWorkArrangements.

• Employee discounts (15% on auto and property insurance, plus many other products and services).

• Good Office program (receive up to $400 back afterpurchasingoffice equipment).

• Student Loan Payment Matching Program for Government Student loans.

• Comprehensive Retirement Savings Program withemployer matchedcontributions.

• 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 willworkwith large datasets to uncover insights,identifyopportunities, and support the development of reporting and analytics solutions that improve operational performance.

You’llplay 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 isaccurate, accessible, andactionable supportingboth day-to-day business needs and longer-term strategicobjectives.

Accountabilities:

• Analyze large and complex datasets toidentifytrends, anomalies, and opportunities for process improvement and growth

• Aggregate,validate, and prepare data to ensure accuracy and reliability of reporting and insights

• Develop andmaintainreports 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

• Identifyand 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.

• Proficiencyin Excel andworking with large datasets

• Strong attention to detail, with the ability toidentifydata 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 provideworkplace accommodations. If you require accommodation, please let us know and we willworkwith you to meet your needs.

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.