Data Warehouse Architect 4 - Chesterfield, United States - Serigor Inc

Description

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 ExperienceCandidate will need to be experienced with Azure Data Factory Pipeline development for both Azure and local Sql Server environments.
Required5YearsCandidate will have experience with managing data vault.

Required2YearsCandidate will have experience coding SQL languageRequired10YearsCandidate will be expected to successfully complete training on HIPAA and PIIRequiredIdeally, candidate would have experience working with the Central Square Finance Enterprise ERPHighly desiredIdeally, candidate would have experience with the Workday tools and implementation methodology.

Highly desiredCandidate should have excellent communication skills (written and verbal)RequiredCandidate will need to be self motivated, independent, and willing to work flexible hours.

RequiredCandidate will be expected to work from home and therefore required to have a dependable high speed internet connection.
RequiredCandidate will be expected to pass CJIS background checks.
Required