Data Warehouse Architect IV
Precision Solutions
- Chesterfield, VA
- Permanent
- Full-time
Our client is is a leading application Engineering Consulting firm in the Washington, D.C. metro region specializing in Management Services, Technology Solutions and Facilities Services. They partner with and assist Federal, State and local government agencies; private sector Energy Services Companies (ESCOs); and Commercial entities in the design and implementation of their various Engineering and Technology related projects. Additionally, they are able to leverage an engineering team with proven technology industry experience that resulted in multi-million-dollar contracts within federal government, state & local government clients!ResponsibilitiesOur client is looking for a Data Warehouse Architect IV to join their project-based team! The Data Warehouse Architect will be expected to create and modify Workday inbound and outbound interfaces. This is a hybrid position 3 days/week onsite in Chesterfield, VA.Requirements
- At least 5 years of experience with Azure Data Factory Pipeline or SSIS development for both Azure and local SQL Server environments
- At least 2 years of experience authoring Workday reports and outbound integrations
- At least 2 years of experience working with Workday Studio
- At least 1 year experience with XSLT development
- Experience with SQL Server (SSIS) and Azure Data Factory pipelines
- Extensive experience with Workday Studio and XSLT
- Create data pipelines that support data vaults or data marts and will be expected to code processes according to client standards
- Expected to successfully complete training on HIPAA and PII
- Excellent communication skills (written and verbal)
- Need to be self motivated, independent, and willing to work flexible hours
- Expected to work from home on occasion and therefore required to have a dependable high speed internet connection
- Expected to pass CJIS background checks
- Comfortable mentoring other personnel regarding Workday technologies
- Working with business partners to develop data mapping from one system to another is desirable but not strictly required
- At least a High School Diploma or GED is required
- Applicants selected must have an appropriate driver's license valid in the Commonwealth of Virginia.