Data Warehouse Architect 4 (Hybrid)

Job Title: Data Warehouse Architect 4 (Hybrid)
Location: Chesterfield, VA
Duration: 12+ Months
Job Description:
Candidate will be expected to create Azure Data Factory Pipelines and Sql Server stored procedures that will consume and create data in Azure Sql Server databases. These pipelines and stored procedures will be controlled 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 required. Working with our business partners to develop data mapping from one system to another is desirable but not strictly required.
Skills:
Skill Required / Desired Amount of Experience Candidate will need to be experienced with Azure Data Factory Pipeline development for both Azure and local Sql Server environments. Required 5 Years Candidate will have experience with managing data vault. Required 2 Years Candidate will have experience coding SQL language Required 10 Years Candidate will be expected to successfully complete training on HIPAA and PII Required Ideally, candidate would have experience working with the Central Square Finance Enterprise ERP Highly desired Ideally, candidate would have experience with the Workday tools and implementation methodology. Highly desired Candidate should have excellent communication skills (written and verbal) Required Candidate will need to be self motivated, independent, and willing to work flexible hours. Required Candidate will be expected to work from home and therefore required to have a dependable high speed internet connection. Required Candidate will be expected to pass CJIS background checks. Required