Business Intelligence Senior Analyst

Allstate Northern Ireland Limited; Markham; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading insurer is seeking a Business Intelligence Senior Analyst to provide data-driven insights and recommendations to support business operations. This hybrid position requires expertise in SQL and Power BI, along with strong analytical skills to enhance business performance.

Qualifications

• 3-5 years of relevant experience (Marketing, Actuarial or Analytics).
• Experience presenting analytical findings to partners with PowerPoint.
• Strong verbal and written communication skills.

Responsibilities

• Gather requirements and propose data-driven solutions.
• Create Power BI reports and dashboards.
• Summarize and present findings to partners and executives.

Skills

Power Bi

SQL

ANOVA testing

Analytical thinking

Education

University Degree (Math/Stats/Engineering or similar)

Tools

Microsoft SQL Server

SAS

MS Word

Excel

PowerPoint

Job description

Business Intelligence Senior Analyst page is loaded

Business Intelligence Senior Analyst

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

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 aBusiness IntelligenceSenior Analystto 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) such as 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:

• 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/SQL programs to create efficiency on run time.
• Extensive knowledge and use of Microsoft SQL Server and all Microsoft services associated with SQL Server (SSIS, SSRS, and SSAS) is a plus but not required.

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.

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.