Data Engineer ( 102-08SENG-01 )

This role migrates a SQL Server enterprise data warehouse and its SSIS integration layer from Azure to AWS — the Microsoft data stack, not the open-source one. The scope for year one: 70% of the client's data workloads still run on this SQL Server warehouse (the remaining 30% has already moved to Databricks), with 1,060 stored procedure call dependencies from pipelines that must keep resolving through the migration. The SSIS package estate (SSISDB) loads the Operational Data Store and the warehouse, driven by configurable runtime values, and the ODS→EDW→BI dependency chain — including PowerShell-triggered SSIS runs for CRM and core business application feeds — must stay intact throughout.

Requirements