Product Engineering; Senior ETL Developer

At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. For more than 90 years our innovative drive has kept us a step ahead of customers’ evolving needs, from advocating for seat belts to leading the industry in pricing sophistication, telematics, and more recently device and identity protection.

Allstate Insurance Company of Canada is a leading home and auto insurer focused on prevention and protection for every stage of life. Serving Canadians since 1953, Allstate proudly delivers on its “You’re in Good Hands®” promise and has been named a Best Employer in Canada for nine consecutive years.

Hybrid

• 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 days.
• Tuition Reimbursement.
• Working within the community and giving back.

In this role you will design and develop data integration components that support Allstate Canada’s insurance agent compensation measurement and reporting system as well as related business‑intelligence reporting. The ideal candidate will design, develop, and maintain data integration processes, feeds to data warehouse environments, and cloud‑based data pipelines.

• Own the data integration capabilities within the agent compensation and sales reporting team using Microsoft ETL development tools and MS SQL Server.
• Create new solutions to enable accurate sales tracking and reporting.
• Develop new capabilities and support integration between an Oracle DB and SQL Server.
• Develop new data pipelines and support integration between SQL Server and Power BI.
• Develop and optimize complex SQL queries, stored procedures, functions, packages, and views.
• Write Windows shell scripts for job automation, scheduling, file handling, and monitoring.
• Troubleshoot ETL failures and resolve production issues.

• Extensive experience in ETL development and data integration projects involving large data volumes.
• Hands‑on development experience with the MSBI Stack:
  • SSIS (SQL Server Integration Services)
  • SSRS (SQL Server Reporting Services)
• Solid development experience working with Microsoft SQL Server and T‑SQL stored procedures.
• Experience in developing and maintaining ETL workflows using SSIS.
• Experience with Windows scripting and Power Shell.
• Experience in data validation, reconciliation, and performance optimization.

• Strong knowledge of data warehousing concepts, Star Schema, and Snowflake Schema.
• Experience with SSAS (SQL Server Analysis Services).
• Experience working with Oracle Database PL/SQL, packages, procedures, functions, and triggers.

Data integration, data reconciliation, data validation, ETL development, Microsoft SQL Server, Microsoft SQL Server Reporting Services, performance optimization, SQL Server Integration Services (SSIS), Transact‑SQL, Windows Power Shell, Windows scripting.

Expected compensation for this role ranges from $93,500.00 to $ annually. The actual salary offered will vary based on skills and experience.

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.

Allstate Canada Group uses AI technology tools to assist in screening, selecting, assessing, and scheduling interviews with candidates as part of the recruitment process.