Data Warehouse Architect 4 (Hybrid)
Chesterfield, VA, VA
Contracted
Experienced
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:
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 |
Apply for this position
Required*