Sr. Data Analyst, Data & Analytics Digital Transformation

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

Job summary

A leading insurance company is seeking a Data Analyst to support business plans through data analysis and reporting. The role involves interpreting data, collaborating with various teams, and optimizing processes. Ideal candidates will have a relevant degree and 3-5 years of experience in analytics, with strong skills in SAS, SQL, and Tableau.

Benefits

Flexible Work Arrangements

Employee discounts on insurance products

Tuition Reimbursement

Annual Wellness allowance

Qualifications

• 3-5 years experience in analytics or similar fields.
• Experience with analytics platforms and methodologies like data lakes and ETL.
• Strong knowledge of SAS/SQL programming.

Responsibilities

• Interpret data and translate it into backend database requirements.
• Build relationships with Claims, Policy, and Finance teams for operational reporting.
• Develop and improve SAS/SQL programs for complex analysis.

Skills

Analytical skills

Problem-solving skills

Communication skills

Education

Bachelor’s degree in Actuarial Sciences/Computer Science/Engineering/Math/Stats/Finance or similar

Tools

SAS

SQL

Tableau

Excel

VBA

PowerPoint

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

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.

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.

Benefits To Joining Allstate

• Flexible Work Arrangements
• Employee discounts (15% on auto and property insurance, plus many other products and services)
• Good Office program (receive up to 400$ back after purchasing office equipment)
• Student Loan Payment Matching Program for Government Student loans
• Comprehensive Retirement Savings Program with employer matched contributions
• Annual Wellness allowance to support employees with improving health and wellbeing
• Personal reflection day
• Tuition Reimbursement
• Working within the community and giving back!
  
  

Reporting to the Manager, Data & Analytics Digital Transformation, you will be providing key technical expertise to design, acquire, investigate, manipulate and analyze data to support Allstate Canada Group’s business plans and results. The candidate will require an in-depth understanding of the data structure and environment and understand the implications from the day-to-day insurance business. The candidate will also be asked to foster efficiency, bring forward creative solutions and create awareness around potential benefits for other initiatives and units. The candidate will be expected to be proactive in developing a network of key collaborators and to be willing to think outside of the box and push the projects a step further.

Role Designation: Hybrid

Accountabilities:

• Interpret the data from the user interface of the different source systems and master how it translates into the backend database
• Build strong relationships with Claims, Policy and Finance teams to enable their needs in operational reporting, analytics, BI and predictive modeling
• Design, provide and articulate requirements for new or improved analytics and reporting
• Monitor and ensure data quality of the curated data sets using proper reconciliation methods
• Oversee testing of newly integrated data sources and/or environments
• Develop and improve SAS/SQL programs to perform various complex analysis.
• Analyze change requests in the source systems or projects, assess their impact on existing data layers, and suggest and carry out the appropriate changes
• Collaborate with DBAs, other IT teams, Architecture as required
• Implement internal data process improvement: automating manual processes, optimizing data delivery, redesign/restructure database for more efficiency
  
  

Qualifications:

• Bachelor’s degree (Actuarial Sciences/Computer Science/Engineering/Math/Stats/Finance or similar) preferred
• 3-5 years experience in analytics or similar fields
• Strong business acumen
• Ability to articulate ideas in both technical and business friendly language
• The candidate must be proactive, curious and comfortable working with new data models
• Experience with analytics platforms and methodologies (data lake, data warehouse, data marts, ETL, data modelling, data governance, etc.)
• Experience in SAS/SQL programming for developing data, cleansing, performing data validation, required data integrity checks, auditing data and improve efficiency of programs
• Strong knowledge of Tableau and/or other visual analytics tools
• Proficient in MS Word, Excel, VBA, and PowerPoint
• Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
• Experience with insurance/actuarial data will be considered a plus
  
  

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.