Job ID: VA-638520 (97391030)
SSIS Developer/Data Warehouse Architect with SQL Server, Azure and Data Factory experience
Location: 6730 Public Safety Way Chesterfield, VA (Chesterfield County )
Duration: 6 months
*local candidates strongly preferred
*interviews will be conducted via phone
*candidates will telework now (after coming to office to pick up laptop). Once restrictions are lifted, candidates will be required to work onsite daily M-F 8-5pm, NO exceptions
Sql Server SSIS Package construction and support Required 3
Sql Server Database working knowledge Required 3
Azure database Required 1
Azure Data Factory Required 1
Relational Database coding experience Required 3
Perform Sql Server package creation and maintenance using Azure tools and standard processes.
Candidate will be expected to create Sql Server packages and stored procedures that will consume and create data in Azure Sql databases. These packages and stored procedures will be called by Azure Data Factory. There may also be some work required to create or support packages on local servers as well.
Candidate will be creating data pipelines that support data vaults and data marts, and will be expected to code processes according to our standards. Experience working with Data Vaults is preferred but not strictly required.
Candidate will need to be experienced with Sql Server package development for both Azure and local Sql Server environments.
Candidate will need to be self motivated, independent, and willing to work flexible hours.
Candidate will be expected to work from home and therefore required to have a dependable high speed internet connection.