Business Intelligence Analyst

About The Company

Allstate Insurance Company of Canada is a leading provider of home and auto insurance solutions dedicated to safeguarding families and their belongings from life's uncertainties. Established in 1953, the company has built a reputation for innovation, customer-centricity, and community engagement. With a focus on prevention and protection, Allstate offers a comprehensive range of products and services tailored to meet the evolving needs of Canadians. The organization prides itself on its "You're in Good Hands®" promise, which underscores its commitment to delivering reliable and trustworthy insurance solutions. Recognized as a Best Employer in Canada for nine consecutive years, Allstate emphasizes fostering a positive workplace culture, promoting personal growth, and supporting diversity and inclusion. The company actively partners with charitable organizations, encourages employee volunteerism, and invests in community development initiatives.

About The Role

We are seeking a dedicated Business Intelligence Analyst to join our dynamic team, supporting the delivery of data-driven solutions that enhance operational efficiency and strategic decision-making within Allstate Canada. In this hybrid role, you will work closely with stakeholders across various departments to analyze large datasets, develop insightful reports and dashboards, and identify opportunities for process improvements. Your expertise will contribute to the growth of our direct sales channel, ensuring data accuracy, accessibility, and actionable insights. The ideal candidate will possess strong technical skills in data analysis, visualization, and ETL processes, along with excellent communication abilities to translate complex data findings into meaningful business recommendations. This position offers an exciting opportunity to be part of a forward-thinking organization committed to innovation, community impact, and employee development.

Qualifications

• Proficiency in Microsoft Fabric ETL Pipelines and SQL
• Experience with Power BI visualization tools
• Strong skills in Excel and working with large datasets
• Knowledge of Microsoft 365 applications
• Experience with marketing analytics and marketing data analysis
• Familiarity with Python and Power Automate for automation and advanced analytics
• Excellent analytical and problem-solving skills
• Strong attention to detail and data quality management
• Effective communication and stakeholder collaboration skills
• Ability to manage multiple priorities in a fast-paced environment
• Curiosity and proactive mindset for exploring data and uncovering opportunities
  
  

Responsibilities

• Analyze large and complex datasets to identify trends, anomalies, and opportunities for operational improvement and growth
• Aggregate, validate, and prepare data to ensure accuracy and reliability of reports and insights
• Develop, maintain, and optimize reports and dashboards to support business decision-making processes
• Collaborate with stakeholders to gather and document data requirements and reporting needs
• Support user acceptance testing (UAT) to ensure BI solutions meet business standards and expectations
• Identify and resolve data discrepancies, system issues, and reporting challenges promptly
• Uncover actionable insights from data analysis and communicate findings effectively to stakeholders
• Contribute to the development of key performance metrics and ensure alignment across BI solutions
• Support application and reporting projects as a subject matter expert in data analytics
  
  

Benefits

• Flexible work arrangements to promote work-life balance
• Employee discounts of 15% on auto and property insurance, along with other products and services
• Good Office program offering up to $400 reimbursement for office equipment purchases
• Student Loan Payment Matching Program for government student loans
• Comprehensive Retirement Savings Program with employer-matched contributions
• Annual Wellness allowance to support health and wellbeing initiatives
• Personal days for additional flexibility
• Tuition Reimbursement to support continuous learning and development
• Opportunities to engage within the community and participate in volunteer activities
  
  

Equal Opportunity

Allstate Canada Group is committed to fostering an inclusive and diverse workplace. We provide accommodations for applicants with disabilities throughout the recruitment process and are dedicated to ensuring equal employment opportunities for all candidates. If you require any accommodations or support, please let us know, and we will work with you to meet your needs.