System Analyst (Hybrid 3 days a week)

Job Title: System Analyst

Location: Richmond VA

Duration: 24 months contract

Visa: Independent Visa only

Job Details:

Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA

Task 1: The Contractor will understand, replicate, and document Oracle SQL and PL/SQL code used in VDOT TMS for tasks such as generating traffic statistics and federal reports. They will shadow the Senior Oracle Database Architect/Engineer, validate results in a test environment, and ensure documentation is complete and up-to-date.

Task 2: The Contractor will perform similar tasks for other modules of VDOT TMS, including Payment and Link Management, collaborating with relevant personnel.

Task 3: The Contractor will also engage in data cleaning, preparation, and limited analysis and visualization to support the above tasks.

Skill Matrix:

Skill

Requirement

Experience Required

PL/SQL Development

Required

3 Years

Data retrieval using SQL

Required

2 Years

Technical writing

Required

4 Years

Strong written communication skills

Required

4 Years

Strong verbal communication skills

Required

4 Years

Ability to see the big picture and not get bogged down in the details

Required

3 Years

Strong organizational skills

Required

3 Years

Ability to work independently

Required

3 Years

Ability to follow technical guidance from VDOT staff

Required

2 Years

Scripting/coding in a modern language (Python, R)

Highly Desired

2 Years

Knowledge of relational database design

Highly Desired

1 Year

Data Engineering skills (cleaning, preparation, validation)

Highly Desired

1 Year

Data analysis and visualization

Highly Desired

1 Year

Exposure to or (some) knowledge of transportation data, skills, or concepts

Desired

1 Year