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. Serving Canadians since 1953, Allstate strives to reassure both customers and employees with its “You’re in Good Hands®” promise and is proud to have been named a Best Employer in Canada for nine consecutive years. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. To learn more, visit www.allstate.ca. For safety tips and advice, visit www.goodhandsadvice.ca.
Through our Employee Value Proposition, 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
Benefits to joining Allstate
Job description:
In this role, you will be designing and developing data integration components which support Allstate Canada’s insurance agent compensation measurement and reporting system and replated business intelligence reporting. The ideal candidate will be responsible for designing, developing data integration processes, feeds to data warehouse environments, and cloud-based data pipelines.
Accountabilities:
Qualifications:
Bonus Qualifications:
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.
#LI-GL1
Skills
Data Integration, Data Reconciliation, Data Validation, ETL Development, Microsoft SQL Server, Microsoft SQL Server Reporting Services, Performance Optimizations, SQL Server Integration Services (SSIS), Transact-SQL, Windows PowerShell, Windows Scripting
Compensation
Expected compensation for this role ranges from $ 93,500.00 - 143,500.00 annually. Actual salary offered to successful candidates will vary based on their skills and experience.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. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.
Allstate Canada Group uses AI technology tools to assist in screening, selecting, assessing, and scheduling interviews with candidates as part of the recruitment process.
This job posting is for a current open role within the organization.
Want to know if this job is worth applying to?
Markham, Ontario, Canada
Hybrid