Product Engineering
Pubblicato il 16-08-2026 - Allstate in Roma
Job Description
Dato l'elevato interesse per questa posizione, la preghiamo di candidarsi tempestivamente se il suo profilo è in linea con il ruolo.
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 related 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
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.
Develop Windows shell scripts for job automation, scheduling, file handling,
and monitoring.
Troubleshoot ETL failures and resolve production issues.
Qualifications
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 PowerShell.
Experience in data validation, reconciliation, and performance optimization.
Premio Qualifications
Strong knowledge of data warehousing concepts, star schema, and snowflake schema.
SSAS (SQL Server Analysis Services).
Experience working with
Oracle Database
PL/SQL, packages, procedures, functions, and triggers.
Benefits
Flexible Work Arrangements