Product Engineering (Senior ETL Developer)

Vedi l’offerta su Go Lavoro: golavoro.it/annuncio-lavoro/7a6f79

Job Description

Qualifiche, competenze e l'esperienza necessaria per questo ruolo sono disponibili nella descrizione completa riportata di seguito.
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.

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.

Role Designation
Hybrid

Skills
Data Integration, Data Reconciliation, Data Validation, ETL Development, Microsoft SQL Server, Microsoft SQL Server Reporting Services, Performance Optimizations, SQL Server Integration Services (SSIS), Transact‑SQL, Windows PowerShell, Windows Scripting.

Compensation
Expected compensation for this role ranges from $93,5 ,500.00 annually. Actual salary offered to successful candidates will vary based on their skills and experience.

Allstate Canada Group has policies and practices that provide workplace accommodations. xysqume If you require accommodation, please let us know and we will work with you to meet your needs.

#J-18808-Ljbffr

Vedi l’offerta su Go Lavoro: golavoro.it/annuncio-lavoro/7a6f79