Senior Analyst Business Intelligence

Allstate Insurance Company; Markham; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Allstate Insurance Company seeks a Senior Analyst in Business Intelligence to provide insights on customer lifecycle and support business plans. The role involves creating Power BI dashboards, advising partners, and optimizing existing data processes. Candidates should have a degree in a related field and relevant analytical experience, focusing on data-driven recommendations.

Qualifications

• 3-5 years of relevant experience in Marketing, Actuarial, or Analytics.
• At least 3 years of experience using Base SAS/EG, SAS Macro, SQL.
• Strong experience presenting analytical findings to stakeholders.

Responsibilities

• Create Power BI reports to analyze and interpret trends in data.
• Meet with partners to propose data-driven solutions.
• Advise stakeholders on business processes and best metrics.

Skills

Power BI

SQL

ANOVA testing

Analytical skills

Communication skills

Education

University Degree in Math/Stats/Engineering

Tools

SAS

Microsoft SQL Server

MS Office

Job description

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 fornine 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 ourEmployee 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 aSenior Analyst, Business Intelligenceto 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) with a focus on Product, Underwriting and Marketing. 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 programming language codes and/or SQL programs to create efficiency on run time.
• Optional: Extensive knowledge and use of Microsoft SQL Server and all Microsoft services associated with SQL Server (SSIS, SSRS, and SSAS).

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

#LI-MO1

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.