System Analyst

System Analyst for one of our direct clients in the Richmond, VA area for a long-term contract opportunity.

Local candidate with DL

USC/GC/GC-EAD/H4-EAD

$60/hr

*This position is hybrid, 3 days per week will be onsite

Responsibilities:
Task 1: The contracted System Analyst candidate ("Contractor") will understand, replicate results, and produce technical documentation for the procedures and processes that the Senior Oracle Database Architect/Engineer employs for various foundational tasks of the TMS (Traffic Management System). Examples of these tasks are:generating traffic statistics such as AADTs (Average Annual Daily Traffic), MADW (Monthly Average Day of Week Traffic), DVMT (Daily Vehicle Miles Traveled)
generating different traffic factors (seasonal, growth, day of week, hourly, K-factor, directional, classification, etc.) that are used to estimate the above statistics when/where not enough data is available
generating mandated federal reports such as HPMS submittals (Highway Performance Monitoring System)

Task 2: The Contractor will perform the same tasks (understand, replicate results, produce technical documentation) for other modules of the TMS (Traffic Management System), the most important ones being Payment, and Link Management.
For this task, the Contractor will work with the Senior Oracle Database Architect/Engineer and the Traffic Data Analysts, Traffic Monitoring Systems Engineers, and Engineering Techs who use these modules.

Task 3: For the successful completion of the above two tasks, the Contractor will need at the minimum to understand the data, perform some data cleaning and preparation tasks, and conduct at least some limited data analysis and visualization.

Knowledge and Abilities:Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the TMS (Traffic Monitoring System)

Required Skills:
3 Years - Prior PL/SQL Development experience
2 Years - Data retrieval using SQL
4 Years - Technical writing
4 Years - Strong written communication skills, especially for technical audiences
4 Years - Strong verbal communication skills, especially when addressing technical audiences
3 Years - Ability to see the big picture and not get bogged down in the details
3 Years - Strong organizational skills
3 Years - Ability to work independently
2 Years - Ability to follow technical guidance from staff reporting to and working with

Desired Skills:
2 Years - Scripting/coding in a modern language such as Python (pandas, numpy) or R. Working with dataframes.
1 Years - Knowledge of relational database design.
1 Years - Data Engineering skills (cleaning, preparation, validation)
1 Years - Data analysis and visualization
1 Years - Exposure to or (some) knowledge of transportation data, skills, or/and concepts