Senior Analyst Business Intelligence

Allstate Insurance Company; Markham; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Analyst in Business Intelligence to provide data-driven insights that enhance business performance. In this hybrid role, you will collaborate with various teams to design solutions that generate actionable insights, develop Power BI reports, and lead projects that optimize data processes. This opportunity allows you to thrive in a flexible environment that values innovation and inclusivity, making a significant impact on the company's success while supporting your professional growth. Join a team that is dedicated to protecting families and fostering a positive community.

Qualifications

• 3-5 years of experience in Marketing, Actuarial, or Analytics.
• Strong knowledge of Power BI and visual analytics tools.

Responsibilities

• Design and develop solutions for business insights.
• Create Power BI reports and dashboards to analyze trends.
• Lead multiple project streams and provide technical direction.

Skills

SAS

SQL

Power BI

Analytical Skills

Communication Skills

Problem-Solving

Education

University Degree in Math/Stats/Finance/Engineering

Tools

Microsoft SQL Server

SSIS

SSRS

SSAS

MS Word

Excel

PowerPoint

Job description

Senior Analyst Business Intelligence page is loaded

Senior Analyst Business Intelligence

Apply remote type Hybrid locations Canadian Head Office time type Full time posted on Posted 2 Days Ago job requisition id R15614

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 for nine 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 our Employee 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

Job Description

Our team is growing, and we are actively looking to hire a Senior Analyst, Business Intelligence to join us! The Business Intelligence team provides key insights on all aspects of the customer lifecycle. We support all functions within the Allstate Company Group (Allstate, Pembridge, PAFCO, and Ivantage) such as Sales, Product, HR, Marketing, Underwriting, Finance, Risk, Compliance, SLT, and many more. 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:

• Design and develop solutions that generate insights to be summarized and shared with our partners to help them better manage their business.
• Advise business stakeholders on how to measure their processes and recommend appropriate metrics.
• Gather proper requirements and ensure alignment with overall objectives and insights sought by stakeholders.
• Create Power BI reports and dashboards to identify, analyze, and interpret trends or patterns in complex data sets and provide insights back to partners.
• Work with management to prioritize business and information needs.
• Identify and define new process improvement opportunities.
• Develop and implement databases, data collection systems, analytics, and strategies to optimize efficiency and quality.
• Visually present and communicate data, analyses, and findings effectively.
• Lead multiple project streams and provide technical direction to BI Analysts on designing solutions and automating complex batch processes.
• Implement internal data process improvements such as automating manual processes, optimizing data delivery, and restructuring databases for efficiency.
• Develop and optimize SAS/SQL programs to improve runtime efficiency.
• Extensive knowledge and use of Microsoft SQL Server and related services (SSIS, SSRS, SSAS) is a plus but not required.

Qualifications & Experience:

• University Degree (Math/Stats/Finance/Engineering or similar) preferred.
• 3-5 years of relevant experience (Marketing, Actuarial, or Analytics recommended).
• At least 3 years of experience using Base SAS/EG, SAS Macro, SQL, Power BI.
• Strong knowledge of Power BI suite and other visual analytics tools.
• Excellent verbal and written communication skills, effective negotiation, and problem-solving skills.
• Ability to work independently and in a team.
• Ability to identify new ideas, techniques, and opportunities for improving effectiveness, performance, and productivity.
• Sound knowledge of relational database structures.
• Strong analytical and critical thinking skills to resolve stakeholder problems and present findings.
• Proficiency in MS Word, Excel, PowerPoint; experience with insurance/actuarial data is a plus.

Allstate Canada Group has policies and practices to provide workplace accommodations. If you require accommodation, please let us know, and we will work with you to meet your needs.

#LI-GL1

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. And one where you can impact the future for the greater good.

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change, and give back where they work and live.

Good Hands. Greater Together.

Welcome

At Allstate, we work hard to help people live a good life every day. Allstaters are dedicated to serving clients, customers, and communities, which allows employees to find meaning and value in their work. Allstate offers an environment that fosters innovative thinking where you’ll be able to explore your ideas and feel proud of the work you do.

Allstate helps protect nearly 16 million households with auto, home, life, and retirement products. We want every professional connected to Allstate to be committed to giving our customers the best, and that means finding the best talent. We want you to be our next great addition.

It’s easy to search and apply for a new opportunity with Allstate. Simply use the links below to identify the openings that interest you.