Data Engineer ( 102-08SENG-01 )
该角色将 SQL Server 企业数据仓库及其 SSIS 集成层从 Azure 迁移到 AWS,而不是开源数据堆。一年的范围：客户端数据工作负载中的70%仍运行在这个 SQL Server 仓库上 （其余30%已经转向 Databricks）,其中1060个存储程序调用依赖于管道，必须通过迁移继续解决.SSIS 包装财富 (SSISDB) 基于可配置的运行时间值来加载操作数据商店和仓库，ODS→EDW→BI 依赖链包括 PowerShell 触发的 SSIS 运行 CRM 和核心业务应用程序传输中保持完整。需要的 · 将 SQL Server 企业数据仓库从 Azure VMs 迁移到 AWS,保存 ODS 至 EDW 到 BI 依赖链。·将 SSIS 包移动和重新点击，包括 PowerShell 在上游文件下载后触发的 SSIS 包。·保持600多个存储程序和1,060条管道调用依赖性工作，并重构无法出现的那些。· 在切断之前对源进行排列数量和业务措施的协调。所需 ·实体验建设和 SQL 服务器集成服务 (SSIS) 包。这一角色中枢。·高级 T-SQL:能够实际阅读500行存储程序并解释它是什么。· SQL Server 企业版在生产中，包括性能调整。· 维度建模：星际方案，缓慢变化的尺寸和知道何时重建与升级和转换的判断力。· 在工作水平 AWS (EC2,RDS,S3);预计在第一年内获得认证，如果尚未进行。· 经验证明了迁移仓库是正确的，而不仅仅是搬家。·专业的书面和口语英语。有 SSRS,SSAS/OLAP 立体，Power BI,AWS DMS,AWS Glue,Databricks, Python, PowerShell,Informatica,dbt,金融服务报告，CRM 数据。参与细节 · 开始时间 · 2027年2月 · 开放至今所有 LATAM 亮点的候选人 基于数据的基础知识，它可以通过网络来实现数据化。
查看英文原文
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
What you will do
- Migrate the SQL Server enterprise data warehouse from Azure VMs to AWS, preserving the ODS to EDW to BI dependency chain.
- Move and re-point SSIS packages, including those triggered by PowerShell after upstream file downloads.
- Keep 600+ stored procedures and 1,060 pipeline call dependencies working, and refactor the ones that cannot come across as-is.
- Reconcile row counts and business measures against source before cutover.
Required
- Real experience building and operating SQL Server Integration Services (SSIS) packages. Central to this role.
- Advanced T-SQL: able to read a 500-line stored procedure and explain what it actually does.
- SQL Server Enterprise Edition in production, including performance tuning.
- Dimensional modeling: star schemas, slowly changing dimensions, and the judgment to know when to rebuild versus lift-and-shift.
- Working-level AWS (EC2, RDS, S3); certification expected within the first year if not already held.
- Proven experience validating that a migrated warehouse is correct, not just moved.
- Professional written and spoken English.
Nice to have
SSRS, SSAS/OLAP cubes, Power BI, AWS DMS, AWS Glue, Databricks, Python, PowerShell, Informatica, dbt, financial services reporting, CRM data.
Engagement details
- Full-time
- Start date: February 2027
- Open to candidates from all LATAM
Highlights
SQL Server, SSIS, T-SQL, Dimensional Modeling, AWS (EC2, RDS, S3), SSRS, SSAS/OLAP, Power BI, AWS DMS, AWS Glue, Databricks, Python, PowerShell, Informatica, dbt
Originally posted on Himalayas