Data Warehouse Architect - Apollo Technology Solutions LLC
Chesterfield, VA
About the Job
Job Title: Data Warehouse Architect
Location: Chesterfield, VA-Hybrid
Duration: 12 Months
Note:
Candidate will be expected to create and modify pipelines with a cloud-based Enterprise Resource Planning (ERP) system.
Location: Chesterfield, VA-Hybrid
Duration: 12 Months
Note:
- 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.
- Candidate will need to be experienced with Azure Data Factory Pipeline development for both Azure and local SQL Server environments.
- Candidate will need to be experienced with SSIS development for both Azure and local Sql Server environments.
- Candidate will ideally have experience with Azure file storage data sources (data lake, blob, hadoop)
- Candidate will be expected to successfully complete training on HIPAA and PII
- Candidate should have excellent communication skills (written and verbal)
- Candidate will need to be self motivated, independent, and willing to work flexible hours.
- Candidate will be expected to work from home on occasion and therefore required to have a dependable high speed internet connection.
- Candidate will be expected to pass CJIS background checks.
- Candidate will have experience authoring Workday reports and outbound integrations
- Candidate should be comfortable mentoring other personnel regarding Workday technologies.
- Ideally, candidate would have experience working with Workday Studio
Source : Apollo Technology Solutions LLC