VDOT System Analyst 2

2 weeks ago

Richmond, United States Lorven Technologies, Inc. Full time

Job ID- 734662

Role: VDOT System Analyst 2

Location: 1401 E Broad St Richmond VA 23219 - Hybrid

Web Cam Interview Only

**Please submit candidates who already live in Richmond, VA
**Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA

Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the VDOT TMS (Traffic Monitoring System). Traffic data analysis.

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)

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.

Skill

Required / Desired

Amount

of Experience

Prior PL/SQL Development experience

Required

3

Years

Data retrieval using SQL

Required

2

Years

Technical writing

Required

4

Years

Strong written communication skills, especially for technical audiences

Required

4

Years

Strong verbal communication skills, especially when addressing technical audiences

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 reporting to and working with

Required

2

Years

Scripting/coding in a modern language such as Python (pandas, numpy) or R. Working with dataframes.

Highly desired

2

Years

Knowledge of relational database design.

Highly desired

1

Years

Data Engineering skills (cleaning, preparation, validation)

Highly desired

1

Years

Data analysis and visualization

Highly desired

1

Years

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

Desired

  • VDOT Programmer Analyst .NET Core

    4 days ago

    Richmond, United States Spark Tek Inc Full time

    Short Description: VDOT Programmer Analyst .NET Core Long Term Developer with 10 years .NET experience - Onsite 3 days a week in Richmond, VA Complete Description: Mgr requests vendors ONLY submit candidates who already live in Richmond, VA ALL interviews ONSITE Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond...

  • VDOT Programmer Analyst .NET Core

    2 weeks ago

    Richmond, United States Syntricate Technologies Full time

    Agency Interview Type: In Person Only Work Arrangement: Hybrid Short Description: VDOT Programmer Analyst .NET Core Long Term Developer with 10 years .NET experience - Onsite 3 days a week in Richmond, VA VENDOR MAXIMUM SUBMITTAL RATE ***/hr*** Complete Description: **Mgr requests vendors ONLY submit candidates who already live in Richmond, VA **ALL...

  • VDOT IT Technical Writer

    2 weeks ago

    Richmond, United States Lorven Technologies, Inc. Full time

    Job ID- 734834 Role: VDOT IT Technical Writer / Systems Analyst Location: 1401 E Broad St Richmond VA 23219 - Hybrid Both Web Cam and In Person Interview *Local Richmond, VA candidates only *Candidate must also be able to work onsite 2-3 days/week. QUALIFICATIONS The candidate should have 10 years of overall IT experience with emphasis on technology project...

  • System Analyst 2

    4 weeks ago

    Richmond, United States GS1 Consulting Full time

    **Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA **Assignment to be extended beyond 6/30, possibly 24 months **Contractor will be responsible for purchasing parking through VDOT’s Parking Management Office or procuring their own parking Understanding, replication, and technical documentation of Oracle SQL and...

  • System Analyst

    2 weeks ago

    Richmond, United States Mindsource Inc Full time

    Hi Mindsource is seeking a System Analyst 2 for one of our Direct Clients based in Silicon Valley . If interested, please drop your resume to Title: System Analyst 2Location: Richmond, VAModel: Hybrid (3 days a week) SKILLS: Prior PL/SQL Development experienceData retrieval using SQLTechnical writingStrong written communication skills, especially for...

  • VDOT ERP Developer 4

    2 weeks ago

    Richmond, United States Spark Tek Inc Full time

    Short Description: VDOT ERP Developer 4 Long Term Full Stack Developer with 14 years .NET experience Complete Description: **Mgr requests vendors ONLY submit candidates who already live in Richmond, VA **ALL interviews ONSITE **Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA **Assignment to be extended beyond 6/30,...

  • VDOT ERP Developer 4

    4 days ago

    Richmond, United States Spark Tek Inc Full time

    Short Description: VDOT ERP Developer 4 Long Term Full Stack Developer with 14 years .NET experience Complete Description: Mgr requests vendors ONLY submit candidates who already live in Richmond, VA ALL interviews ONSITE Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA Assignment to be extended beyond 6/30,...

  • VDOT Prog Analyst PowerBI/GIS

    4 days ago

    Richmond, United States Smart Gauge Staffing LLC Full time

    Short Description: VDOT Programmer Analyst 3 Complete Description: Local Richmond, VA candidates strongly preferred *at least 3 days/wk onsite required *assignment will be extended beyond 6/30/24, likely for 6-12+ months *Contractor will be responsible for purchasing parking through VDOT’s Parking Management Office or procuring their own...

  • System Analyst

    2 weeks ago

    Richmond, United States Trillium Staffing Full time

    Trillium Professional is now seeking a System Analyst in Richmond for a hybrid position! Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the internal system and data analysis. - The contracted System Analyst candidate will understand, replicate results, and produce technical documentation for the procedures and...

  • System Analyst

    3 days ago

    Richmond, United States Trillium Staffing Full time

    Trillium Professional is now seeking a System Analyst in Richmond for a hybrid position! Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the internal system and data analysis. - The contracted System Analyst candidate will understand, replicate results, and produce technical documentation for the procedures and...

  • VDOT Veterans Internship Program

    2 weeks ago

    Richmond, United States VA Department of Transportation Full time

    Please apply online at Title: VDOT Veterans Internship Program Hiring Range: $25.00 per hour Pay Band: Agency: VA Dept of Transportation Location: Dept of Transportation Agency Website: Recruitment Type: General Public - G Job Duties Positions are filled based on business need and funding availability. This remains a continuous recruitment. The...

  • VDOT Transportation Design Director

    7 days ago

    Richmond, United States Vanasse Hangen Brustlin , Inc. Full time

    VDOT Transportation Design Director Job Locations US-VA-Richmond | US-VA-Virginia Beach | US-VA-Williamsburg | US-VA-Tysons Corner | US-DC-Washington ID 2023-3760 Category Engineering Type Regular Full-Time Overview ABOUT THE POSITION VHB is seeking a growth-oriented, entrepreneurial, and experienced engineer to serve as the VDOT Transportation Design...

  • VDOT IT Purchasing Analyst

    2 weeks ago

    Richmond, United States Spark Tek Inc Full time

    Complete Description: *Local Richmond, VA candidates required for occasional onsite work *Candidate will telework. May be required to report on-site to attend meetings or trainings. Daily responsibility for supporting the Procurement / Finance team Seeking a highly motivated and driven candidate to support procurement for IT goods and services for the...

  • VDOT Transportation Design Director

    7 days ago

    Richmond, United States VHB Full time

    Overview ABOUT THE POSITION VHB is seeking a growth-oriented, entrepreneurial, and experienced engineer to serve as the VDOT Transportation Design Program Executive (PX). The successful candidate will play a critical role in driving the growth of the VDOT Transportation Design practice to increase market share across the state of Virginia. As the company...

  • VDOT Transportation Design Director

    6 days ago

    Richmond, United States VHB Full time

    Overview ABOUT THE POSITION VHB is seeking a growth-oriented, entrepreneurial, and experienced engineer to serve as the VDOT Transportation Design Program Executive (PX). The successful candidate will play a critical role in driving the growth of the VDOT Transportation Design practice to increase market share across the state of Virginia. As the company...

  • VDOT Project Manager PMP

    4 days ago

    Richmond, United States Spark Tek Inc Full time

    Complete Description: *Preferably local candidates. *Candidate MUST possess PMP certification through PMI or 's PM certification. No other certification qualifies. *Candidate must also be able to work onsite 2-3 days/week. *Contractor will be responsible for purchasing parking through VDOT’s Parking Management Office or procuring their own...

  • VDOT Technical Support Analyst 4

    4 days ago

    Richmond, United States HCL Global Systems Full time

    *local candidates strongly preferred *ALL interviews conducted ONSITE, NO exceptions *FIRST 90 DAYS ONSITE, NO exceptions *engagement to be extended beyond 6/30/24, probably for 6-12+ months VDOT is seeking a Telecommunications Coordinator for its Central Office work location in Richmond, VA. This position will renew on July 1, 2024 with options for...

  • VDOT IT Infrastructure Project Manager PMP

    4 days ago

    Richmond, United States HCL Global Systems Full time

    Hybrid VDOT IT Infrastructure Project Manager PMP Parking not provided for contractors. *Local candidates only please *Candidate MUST possess PMP certification through PMI or VITA's PM certification. No other certification qualifies. *Candidate must also be able to work onsite 2-3 days/week *engagement to be extended beyond 6/30/24 up to a year or...

  • IT Compliance Analyst

    1 day ago

    Richmond, United States Insight Global Full time

    A state client of ours is seeking a team member to function as an IT Compliance Analyst. The Analyst will be receiving audit requests, doing evaluations and assessments within the organization's IT systems to make sure they are compliant and regulated. They will be analyzing processes, developing documentation, and evaluating audits to support Governance...

  • IT Compliance Analyst

    5 hours ago

    Richmond, United States Insight Global Full time

    A state client of ours is seeking a team member to function as an IT Compliance Analyst. The Analyst will be receiving audit requests, doing evaluations and assessments within the organization's IT systems to make sure they are compliant and regulated. They will be analyzing processes, developing documentation, and evaluating audits to support Governance...