Data Engineer ( 102-08SENG-01 )
This is the employer's own posting, not a copy on a job board.
What we know
Is it still open?
Confirmed still open
Last checked 1h ago — checked against the employer's own applicant tracking system, which is the company answering directly.
We re-read the employer's own applicant tracking system and the posting was still there. That is the company answering directly.
How old is it?
Posted 55d ago
The date the source published, not the day we noticed it (2026-08-20). Last seen at its source just now.
Is it remote?
Marked remote on the employer's board
Their board carries a remote setting on this posting — a field they filled in, not wording we read. The location field names somewhere specific, which is usually where the team or the entity sits.
Who may apply?
Brazil
The description agrees: it names LATAM.
What the ad says
…Open to candidates from all LATAM…
Pay not stated
Similar roles pay $80k–145.5k/yr
Middle 50% of 34 listings that do state pay — Engineering · all levels · Brazil · USD/year. This employer has published no salary; this is what comparable listings we hold disclose, never converted between currencies or periods. How this is calculated.
Skills named in the ad
Recognised terms only, from a fixed vocabulary — this is what CV matching compares against.
Carried by 1 source
-
Recruitee employer's own board first seen 1h ago · last seen just now
The listing
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.
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
Contractor Hourly
Estimated start date: December 2026
Duration of project: 9 months
EST Time Zone
Open to candidates from all LATAM