Search Jobs

IT opportunities are waiting for you.

System Analyst (7527)

Capitol, VA 23219

Posted: 05/01/2024 Employment Type: Contract Job Category: Systems Analyst Job Number: 7527

Job Description

Position Title: System Analyst 2    
Position Status: 12-month contract with rolling extensions 
Schedule: HYBRID (3 days per week onsite)
Overview: Our client is looking for a System Analyst for a HYBRID position based out of Richmond, VA.          
  • Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code.
  • 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. 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).
  • Some initial and possibly incomplete or outdated in some places documentation for the above processes already exists and will be shared with the Contractor. To fully understand the processes used for the tasks above, the Contractor will shadow the Senior Oracle Database Architect/Engineer, observe his work, and take notes. The Contractor will be tasked with making sure that documentation is complete, easy to understand, and up-to-date by working with both the Senior Database Architect/Engineer and the and users of these data sets, such as Data Scientists and Architect/Engineers and Data Analysts. For replication, the Contractor will run the Oracle scripts used to produce the above measures in a test environment and validate their results against the results from the production environment produced by the Senior Oracle Database Architect/Engineer. The Contractor will need to understand, document, and replicate the general procedures as well as the special/edge cases, where a case-by-case decision or human decision may be needed. The possibility of creating parallel non-Oracle SQL code that connects to the Oracle database, processes the data outside Oracle, and writes it back to the Oracle database is preferable, and will be offered to the Contractor.
  • Task 2: The Contractor will perform the same tasks (understand, replicate results, produce technical documentation) for other modules of the VDOT 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.

  • 4 Years – Experience with technical writing.
  • 4 Years – Strong written communication skills, especially for technical audiences.
  • 3 Years – Prior SQL/PL development experience.
  • 3 Years – Ability to see the big picture and not get bogged down in the details.
  • 2 Years – Ability to follow technical guidance from the VDOT staff reporting to and working with.
  • 2 Years – Experience doing data retrieval using SQL.

About Our Client: Our client is an Equal Opportunity Employer and maintains a drug-free workplace by both policy and practice. Applicants are considered for all positions without regard to race, color, religion, sex, sexual orientation, national origin, age, marital or veteran status, or the presence of a non-job-related medical condition. Employment and personnel practices conform to all applicable federal, state, and local laws and regulations regarding non-discrimination. While the Company is committed to following this principle in every facet of employment, all employees share in the responsibility to promote and foster a favorable work environment.
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Capitol, VA

Ready to take the next step in your career? Explore our job opportunities in the vibrant area around Capitol, Virginia! Nestled in the heart of the state, Capitol boasts a perfect blend of historic charm and modern amenities, making it an ideal place to grow both personally and professionally. From the iconic Capitol building to the bustling waterfront district, this region offers a unique cultural experience. Indulge in mouth-watering Southern cuisine, catch a show at the renowned Capitol Theater, or explore the stunning galleries and parks that dot the area. Join us in Capitol, VA, and discover why this dynamic region is the perfect place to advance your career.