Data Warehouse Architect

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.

Skills Matrix:
·        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