System Analyst Hybrid 3 days a week

Job Title: System Analyst

Location: Richmond VA

Duration: 24 months contract

Visa: Independent Visa only

Job Details:

LongTerm 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 uptodate.

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