Logo for OpsBrasil

Data Engineer ( 102-08SENG-01 )

Role overview

Qualifications

  • Experience with SQL Server and SSIS
  • Knowledge of data migration from Azure to AWS
  • Understanding of data warehouse architecture
  • Familiarity with PowerShell

Responsibilities

  • Migrate SQL Server enterprise data warehouse to AWS
  • Maintain SSIS integration layer during migration
  • Manage dependencies from stored procedure calls
  • Ensure operational data store and warehouse integration remains intact

Key facts

Hard skills

About the company

OpsBrasil logo

OpsBrasil

  • IT Services & Consulting
  • SME
  • 11–50
Staff augmentation, software development team augmentation, international recruiting, virtual teams, remote tech talent

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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.

Related jobs

See all Data Engineer jobs

Other jobs at OpsBrasil