Data Warehouse Architect

Job ID: 743061

Data Warehouse Architect

Client: Chesterfield County

Duration: 12+ Months

Location: Chesterfield, VA 23832

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.

Job Summary
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.

Required Skills
Experience with Azure Data Factory Pipeline development for both Azure and local SQL Server environments.
Experience with SSIS development for both Azure and local SQL Server environments.
Ideally, experience with Azure file storage data sources (data lake, blob, hadoop).
Willingness to successfully complete training on HIPAA and PII.
Excellent communication skills (written and verbal).
Self-motivated, independent, and willing to work flexible hours.
Ability to work from home on occasion and required to have a dependable high-speed internet connection.
Must pass CJIS background checks.
Experience authoring Workday reports and outbound integrations.
Comfortable mentoring other personnel regarding Workday technologies.
Ideally, experience working with Workday Studio.

#J-18808-Ljbffr