VDOT System Analyst 2
2 weeks ago
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 foundationaltasks 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 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.
RequirementsSkill
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
1
Years
-
VDOT System Analyst 2
1 week ago
Richmond, United States Lorven technologies Full timeJob DescriptionJob DescriptionJob ID- 734662Role: VDOT System Analyst 2Location: 1401 E Broad St Richmond VA 23219 - HybridWeb 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 VAUnderstanding, replication, and technical documentation of Oracle...
-
VDOT Programmer Analyst .NET Core
2 weeks ago
Richmond, United States Syntricate Technologies Full timeAgency 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...
-
System Analyst 2
2 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...
-
VDOT IT Technical Writer
2 weeks ago
Richmond, United States Lorven technologies Full timeJob DescriptionJob DescriptionJob ID- 734834Role: VDOT IT Technical Writer / Systems AnalystLocation: 1401 E Broad St Richmond VA 23219 - HybridBoth Web Cam and In Person Interview*Local Richmond, VA candidates only *Candidate must also be able to work onsite 2-3 days/week.QUALIFICATIONSThe candidate should have 10 years of overall IT experience with...
-
Richmond, United States VA Dept of Transportation Full time**Title**: Human Resources Information Systems Analyst **State Role Title**: Policy Planning Spec I **Hiring Range**: $60,276 - $97,949 **Pay Band**: 4 **Agency**: VA Dept of Transportation **Location**:Dept of Transportation **Recruitment Type**: General Public - G **Job Duties** What drives you? Whether it's knowing the work you do makes a...
-
VDOT Sr Oracle Database Developer
1 week ago
Richmond, United States Argyllinfotech Full timeJob DescriptionJob DescriptionSr PL/SQL Oracle Resource/VDOT Sr Oracle Database Developer *Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement *Web Cam and ONSITE interviews *Candidates must be willing and able to work onsite 2 days/week for the first couple of weeks, and 1-2 days/week thereafter....
-
IT Financial Analyst
2 weeks ago
Richmond, United States Crescens Full timeJob Title: IT Financial Analyst Location: Richmond, VA Duration: 8 Months contract Local Richmond, VA candidates needed as they must be able to work onsite at times, for meetings and trainings as needed. Please do NOT submit candidates who were submitted to previous VDOT IT Financial Analyst reqs. Job Description: Contractor will be responsible for...
-
Senior Systems Analyst
2 weeks ago
Richmond, United States Softpath System Full time• Job Title: Senior System Analyst • Preferred bill rate: *** • Length of assignment: 12-24 months • How many positions: one • What is the preferred candidate location (local, non-local, remote?) and is there flexibility? Local (hybrid - 1 week in office, 1 week remote). • Will you consider candidates who will re-locate at their own expense? Yes...
-
Senior Systems Analyst
4 days ago
Richmond, United States Softpath System Full time• Job Title: Senior System Analyst • Preferred bill rate: *** • Length of assignment: 12-24 months • How many positions: one • What is the preferred candidate location (local, non-local, remote?) and is there flexibility? Local (hybrid - 1 week in office, 1 week remote). • Will you consider candidates who will re-locate at their own expense? Yes...
-
Operations Systems Specialist
2 days ago
Richmond, United States Va Department Of Transportation Full timeVDOT is looking for an Operations Systems Specialist to Support the planning, design and implementation of mission critical systems for VDOT's Operations Program that includes Advanced Traffic Management Systems (ATMS), Detour Routes and System Integrations. Systems Oversight: Leads, directs and manages the planning, design and implementation of mission...
-
Operations Systems Specialist
3 weeks ago
Richmond, United States VA Department of Transportation Full timeVDOT is looking for an Operations Systems Specialist to Support the planning, design and implementation of mission critical systems for VDOT's Operations Program that includes Advanced Traffic Management Systems (ATMS), Detour Routes and System Integrations. Systems Oversight: Leads, directs and manages the planning, design and implementation of mission...
-
Operations Systems Specialist
16 hours ago
Richmond, United States Va Department Of Transportation Full timeVDOT is looking for an Operations Systems Specialist to Support the planning, design and implementation of mission critical systems for VDOT's Operations Program that includes Advanced Traffic Management Systems (ATMS), Detour Routes and System Integrations. Systems Oversight: Leads, directs and manages the planning, design and implementation of mission...
-
Senior Business Systems Analyst
3 days ago
Richmond, United States Softpath System Full timeSenior Business Systems Analyst Description: Preferred rate: *** - *** •Length of assignment: 1 year (Staff augmentation, will extend after 1 year) •How many positions: 2 •What is the preferred candidate location (local, non-local, remote?) and is there flexibility? If remote possibility, indicate schedule. Local to Richmond & Cayce is preferred....
-
System Analyst 2 Technician
2 weeks ago
Richmond, United States Serigor Inc Full timeJob Title: System Analyst 2 Technician (Hybrid) Location: Richmond, VA Duration: 12+ Months Job Description: Primary Responsibilities Jr LIMS Analyst needed to work on new projects and enhancements for the Division of Consolidated Lab Services. This includes internal and external facing applications and data exchange interfaces. Work closely with laboratory...
-
System Analyst 2 Technician
4 days ago
Richmond, United States Serigor Inc Full timeJob Title: System Analyst 2 Technician (Hybrid) Location: Richmond, VA Duration: 12+ Months Job Description: Primary Responsibilities Jr LIMS Analyst needed to work on new projects and enhancements for the Division of Consolidated Lab Services. This includes internal and external facing applications and data exchange interfaces. Work closely with laboratory...
-
System Analyst 2 Technician
1 month ago
Richmond, United States Serigor Inc Full timeJob Title: System Analyst 2 Technician (Hybrid)Location: Richmond, VADuration:12+ MonthsJob Description:Primary ResponsibilitiesJr LIMS Analyst needed to work on new projects and enhancements for the Division of Consolidated Lab Services. This includes internal and external facing applications and data exchange interfaces.Work closely with laboratory users...
-
Data Analyst
1 month ago
Richmond, United States Serigor Inc. Full timeJob DescriptionJob DescriptionJob Title: Data Analyst (Onsite)Location: Richmond, VADuration: 06 MonthsJob Description:This role will serve as the primary resource responsible for maintaining Central Office workstation inventory, ordering, issuance, peripherals, maintenance, disposal, etc.The Data Analyst will be responsible for appropriate stewardship of...
-
Data Analyst
1 month ago
Richmond, United States Serigor Inc Full timeJob Title: Data Analyst (Onsite)Location: Richmond, VADuration:06 MonthsJob Description:This role will serve as the primary resource responsible for maintaining Central Office workstation inventory, ordering, issuance, peripherals, maintenance, disposal, etc.The Data Analyst will be responsible for appropriate stewardship of VDOT funds related to Information...
-
System Analyst 2 Technician
2 weeks ago
Richmond, United States Serigor Inc. Full timeJob DescriptionJob DescriptionJob Title: System Analyst 2 Technician (Hybrid)Location: Richmond, VADuration: 12+ MonthsJob Description:Primary ResponsibilitiesJr LIMS Analyst needed to work on new projects and enhancements for the Division of Consolidated Lab Services. This includes internal and external facing applications and data exchange...
-
System Analyst 2 Technician
3 weeks ago
Richmond, United States Serigor Inc. Full timeJob DescriptionJob DescriptionJob Title: System Analyst 2 Technician (Hybrid)Location: Richmond, VADuration: 12+ MonthsJob Description:Primary ResponsibilitiesJr LIMS Analyst needed to work on new projects and enhancements for the Division of Consolidated Lab Services. This includes internal and external facing applications and data exchange...