Previous Job
VDOT Programmer Analyst 5 - SQL Server
Ref No.: 18-00054
Location: Richmond, Virginia
Position Type:Contract
Experience Level: 8 Years
Start Date: 01/11/2018
Location - Richmond, VA
Rate - $ 60 per hr on W2
Contract - 6 months
local candidates strongly preferred
*ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions

Assist in the design and development of processes to extract data from existing databases and merge with new additional data to load into large data platforms. Make stored data available in a timely and efficient manner. Assist in creation of decision support visualizations. Assist in the amelioration of data quality issues. Assist in the design, development, testing, and validation of statistical, mathematical, and simulation models. Experience creating and maintaining Oracle and MS SQL Server Databases. Experience utilizing Business Intelligence reporting capabilities at an enterprise level.
Skill Required / Desired Amount of Experience
IT Experience Overall Required 6 Years
Experience with automated builds Desired 1 Years
Experience Data Modeling Required 4 Years
MS-Access Required 2 Years
PL/SQL, T-SQL Required 5 Years
SQL Server 2008 R2/2014 Required 5 Years
SQL Server Analysis Services Desired 2 Years
SQL Server Reporting Services Required 5 Years
Power BI Desired 1 Years

Global Candidate Requirements
Skill Required / Desired Amount of Experience

Question 1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question 2 Please list candidate's email address that will be used when submitting E-RTR.
Question 3 In what city/state does candidate reside?
Question 4 Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each sklll?
Question 5 Is candidate willing and able to travel to Richmond, VA for a personal interview? Manager will ONLY conduct in person interviews, NO Skype, NO exception
Question 6 Does your candidate agree to complete the entire engagement?
Question 7 How soon after an offer can your candidate start?
Question 8 Has your candidate been submitted to CAI in the past? If so, for which VA state agency and when?