Hybrid ETL Developer at Allstate

Transform data integration at Allstate as a Senior ETL Developer in a hybrid work setting. Focus on designing and maintaining critical data processes for effective business intelligence reporting.

In this hybrid role at Allstate, you will contribute to the agent compensation measurement and reporting system. Your extensive ETL development experience will enable you to create innovative solutions using Microsoft ETL tools and MS SQL Server. This position also includes building data pipelines and optimizing SQL queries to empower accurate sales tracking.

Key Responsibilities:

• Own data integration capabilities using MS ETL tools

• Create solutions for accurate sales tracking and reporting

• Develop and integrate data between Oracle DB and SQL Server

• Optimize SQL queries and stored procedures for performance

• Troubleshoot ETL failures and monitor production issues

Requirements:

• Extensive ETL development experience with large data volumes

• Hands-on experience with SSIS and SQL Server

• Strong skills in T-SQL and Windows scripting

• Experience in data validation and performance optimization

• Knowledge of data warehousing concepts is a bonus

Utilize your expertise in ETL development and SQL to enhance data integration processes at Allstate.
#J-18808-Ljbffr