What are the responsibilities and job description for the Chesterfield County Data Warehouse Arch 2 position at TMS?
Job Title : Data Warehouse Arch 2
Location : Richmond / Chesterfield, VA (Hybrid)
Duration" 6-12 Months contract position with high possibility of extension
- local Richmond, VA candidates required for onsite work
- only submit candidates able to interview onsite. This is REQUIRED
- candidate will be required to work ONSITE 3 days / wk, or additional days if requested. This is REQUIRED
Working with our business partners to develop data mapping from one system to another is required. As such the candidate will be expected to manage data mapping from a legacy system to a new system. The candidate will have a solid attention to detail and be able to manage tedious tasks. The candidate needs to be proficient with Azure Data Factory Pipelines and Sql Server stored procedures or SSIS packages. There may also be some work required to create or support packages on local servers as well. Required / Desired Skills
Skill
Required / Desired
Amount
of Experience
Candidate will need to be experienced with Azure Data Factory Pipeline or SSIS packages for Sql Server environments
Required
Years
Candidate will have experience managing source code in a GIT repository using Azure DevOps.
Required
Years
Candidate will have successful experience with estimating level of effort and managing deadlines.
Required
Years
Candidate could have data profiling and comparison experience with Toad Datapoint
Nice to have
Years
Candidate will have excellent communication skills (written and verbal)
Required
Candidate will need to be self motivated, independent, and willing to work flexible hours.
Required
Candidate is required to have a dependable high speed internet connection because some work will be performed from home.
Required
Candidate will be expected to pass CJIS background checks.
Required
Candidate will be expected to successfully complete training on HIPAA and PII
Required
Questions
Question
Question1
Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?
Question2
Please list candidate's email address.
Question3
Do you attest that the candidate has lived in the United States for a minimum of 10 years?
Question4
In what city / state does your candidate PERMANENTLY reside?
Question5
Does your candidate agree to interview onsite? This is REQUIRED.
Question6
Does your candidate agree to work onsite 2 days per week, as determined by mgr? This is REQUIRED.
Question7
How soon after an offer can your candidate start?
