Data Warehouse Architect . Richmond Move Collective

Data Warehouse Architect

Location:

Chesterfield, VA, Hybrid

Rate:
Best competitive rate

Local Richmond area candidates or those willing to relocate to the Richmond area during this engagement due to onsite work requirement. ONSITE interviews only. Candidates must be willing and able to work onsite 3 days/week, NO Exceptions.

Candidate will be expected to create and modify pipelines with a cloud-based Enterprise Resource Planning (ERP) system. To manage these pipelines the candidate will need experience with Azure Data Factory (ADF) and Sql Server (SSIS) pipelines. Candidate will be creating data pipelines that support data marts and will be expected to code processes according to our standards. Candidate will be well-versed in current methodologies for synchronizing data mart datasets from source systems via file-based extracts.

Working with our business partners to develop data mapping from one system to another is desirable but not strictly required.

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 need to be experienced with SSIS development for both Azure and local Sql Server environments. Required 2 Years

Candidate will ideally have experience with Azure file storage data sources (data lake, blob, hadoop). Highly desired 1 Year

Candidate will be expected to successfully complete training on HIPAA and PII. Required

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 on occasion and therefore required to have a dependable high speed internet connection. Required

Candidate will be expected to pass CJIS background checks. Required

Candidate will have experience authoring Workday reports and outbound integrations. Nice to have

Candidate should be comfortable mentoring other personnel regarding Workday technologies. Nice to have

Ideally, candidate would have experience working with Workday Studio. Nice to have

We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status.