Location
toronto, on, Canada
Posted
July 20, 2026
Job Description
Advance your career with Allstate as a Senior ETL Developer in a hybrid work model. Leverage your expertise in data integration and ETL processes to optimize insurance reporting.
As a key member of the agent compensation team, you will develop and enhance data integration components responsible for effective sales tracking and business intelligence reporting. Your hands-on experience with Microsoft ETL tools and SQL Server will ensure seamless data workflows and enhanced reporting capabilities.
Key Responsibilities:
• Design and develop ETL processes for data integration
• Create and optimize SQL queries for reporting and analytics
• Automate job processes with Windows Shell Scripts
• Troubleshoot ETL failures and resolve issues
• Support integration between Oracle DB and SQL Server
Requirements:
• Extensive experience in ETL Development and data integration
• Proficient in MSBI stack and T-SQL programming
• Experience with PowerShell and Windows script...
As a key member of the agent compensation team, you will develop and enhance data integration components responsible for effective sales tracking and business intelligence reporting. Your hands-on experience with Microsoft ETL tools and SQL Server will ensure seamless data workflows and enhanced reporting capabilities.
Key Responsibilities:
• Design and develop ETL processes for data integration
• Create and optimize SQL queries for reporting and analytics
• Automate job processes with Windows Shell Scripts
• Troubleshoot ETL failures and resolve issues
• Support integration between Oracle DB and SQL Server
Requirements:
• Extensive experience in ETL Development and data integration
• Proficient in MSBI stack and T-SQL programming
• Experience with PowerShell and Windows script...