People Analytics Reporting Specialist - Markham, Canada - Allstate Canada

Allstate Canada

Verified Company

Markham, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

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:
Home-Based

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

Job description:

We are looking for a team member interested in growing their skills and capabilities and making an impact in People Analytics Reporting Specialist role.

You will work on our a fast-paced Digital Transformation small but mighty team on a challenging and varied scope of work.

Part of the transformation grow the maturity of our People Analytics portfolio at Allstate Canada.

Reporting to the Manager, People Analytics, the People Analytics Reporting Specialist will be responsible for the ongoing execution and delivery of regular and ad hoc Talent reporting, and will support the design, maintenance and optimization of Talent reporting solutions.

The role will also support various people analytics projects, working closely with colleagues across our Human Resources team and other functions within the organization.

Accountabilities:

Responsible for the design, development and delivery of regular and ad hoc reporting deliverables for various stakeholders as well as enhancement of existing reports
Create, Update, Refine and Maintain complex SQL queries for the operational reporting
Support reporting and analytics projects such as creating a unified HR Data layer and development and testing of new reporting functionality
Design, develop and deploy business intelligence solutions such as dashboards and interactive visual reports as per requirements
Support transformative Process Optimization, automation and efficiency

Qualifications:

3-5 years of experience in data analysis, preferably in People Analytics or HR Reporting
An exceptional knowledge of relational and multidimensional databases, and SQL and strong experience in reporting tools and systems on Oracle
Excellent communication, interpersonal skills and client-servicing skills, with the ability to communicate expertly and professionally with all levels of the organization
Exceptional attention to detail, analytical, critical thinking skills with the ability to prioritize efficiently, while meeting deadlines in a fast-paced environment
Advanced computer skills, with high proficiency Office 365 suite especially with Excel

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.