Data Warehouse Architect - Chesterfield, United States - Ztek Consulting

    Ztek Consulting
    Ztek Consulting Chesterfield, United States

    1 month ago

    Default job background
    Description

    Title: Data Warehouse Architect

    Location: Chesterfield, VA 23832

    Interview Type: Both Web Cam and In Person Interview

    Work Arrangement: Hybrid

    Start Date: 05/20/2024 to 10/14/2025.

    *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

    Skills required/Desired:

    Candidate will need to be experienced with Azure Data Factory Pipeline or SSIS development for both Azure and local Sql Server environments. (Required 5 Years)

    Candidate will have experience with XSLT development (Required 1 Years)

    Candidate will have experience authoring Workday reports and outbound integrations (Highly desired 2 Years)

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

    Ideally, candidate would have experience working with Workday Studio (Highly desired 2 Years)

    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 should be comfortable mentoring other personnel regarding Workday technologies. Required

    Job Description:

    Candidate will be expected to create and modify Workday inbound and outbound interfaces. To manage these interfaces the candidate will need experience with Sql Server (SSIS) and Azure Data Factory pipelines. Ideal candidate will have extensive experience with Workday Studio and XSLT. Candidate could be creating data pipelines that support data vaults or data marts and will be expected to code processes according to our standards. Working with our business partners to develop data mapping from one system to another is desirable but not strictly required.