Drive innovation in data integration as a Senior ETL Developer at Allstate. This hybrid role involves creating robust solutions to enhance data reporting and analysis.
As part of Allstate Canada’s team, you will play a pivotal role in designing data integration components for the agent compensation and sales reporting system. Your hands-on experience in ETL development and Microsoft SQL Server will be vital, as you build data pipelines and optimize workflows to ensure accuracy in reporting.
Key Responsibilities:
• Lead the data integration efforts for agent compensation
• Design and implement solutions for sales reporting accuracy
• Develop and support SQL Server and Power BI integration
• Troubleshoot and resolve ETL-related issues
• Write scripts for job automation and monitoring
Requirements:
• Extensive experience in ETL development and data integration
• Proficient in SSIS, MS SQL Server, and T-SQL
• Experience with Windows scripting and job automation
• Solid understanding of data validation techniques
• Knowledge of Oracle Database PL/SQL is advantageous
Bring your ETL and SQL expertise to elevate Allstate's data capabilities.
#J-18808-Ljbffr

📌 Allstate Senior ETL Developer Role (Toronto)
🏢 Allstate Canada
📍 Toronto