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 PL/SQL code used in the VDOT TMS (Traffic Monitoring System). Traffic data analysis.
- 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.

**Job Types**: Full-time, Contract

Pay: $45.00 per hour

Compensation package:

- 1099 contract

Schedule:

- 8 hour shift

Application Question(s):

- Strong written communication skills, especially for technical audiences / 4 Years Required.
- Strong verbal communication skills, especially when addressing technical audiences / 4 Years Required.
- Ability to see the big picture and not get bogged down in the details / 3 Years Required.
- Strong organizational skills / 3 Years Required.
- Ability to work independently / 3 Years Required.
- Ability to follow technical guidance from VDOT staff reporting to and working with / 2 Years Required.
- Do you agree to work onsite 3+ days per week, as determined by mgr? This is REQUIRED.

**Experience**:

- PL/SQL Development: 2 years (required)
- Data retrieval using SQL: 2 years (required)
- Technical writing: 4 years (required)

Work Location: Hybrid remote in Richmond, VA 23219

  • 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

    2 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 "...

  • Senior Business Systems Analyst

    2 weeks ago

    Richmond, United States Softpath System Full time

    Senior 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 time

    Job 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

    3 days ago

    Richmond, United States Serigor Inc Full time

    Job 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 time

    Job 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...

  • System Analyst 2 Technician

    7 hours ago

    Richmond, United States Serigor Inc Full time

    Job 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...

  • System Analyst 2 Technician

    4 weeks ago

    Richmond, United States Serigor Inc. Full time

    Job 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

    1 month ago

    Richmond, United States Serigor Inc. Full time

    Job 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...

  • Senior Systems Analyst

    2 weeks ago

    Richmond, United States Softpath System Full time

    Note - Hiring manager will start interview after 4-5 weeks. • Job Title: Senior Systems Analyst • Preferred bill rate: *** • Length of assignment: 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. My team is hybrid. We are onsite...

  • 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...

  • 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

    24 hours 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...

  • Business Systems Analyst

    2 weeks ago

    Richmond, United States Perfict Global, Inc. Full time

    About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...

  • System Analyst

    4 weeks ago

    Richmond, United States St Jardins 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 Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the Virginia State Agency's TMS (Traffic Monitoring System). Traffic data analysis. - generating traffic statistics...

  • Business Analyst 2

    1 week ago

    Richmond, United States My3Tech Inc Full time

    Job: Business Analyst 2 Location : Chesterfield, VA Duration : Long Term local Richmond, VA candidates required candidates must be able to be hired directly by the county without sponsorship, NO exceptions This is initially a contract position with the intent to hire a full-time Business Systems Analyst. Bachelor's degree in computer science, business...

  • Systems Analyst

    2 weeks ago

    Richmond, United States Crescens Full time

    Job Title: Systems Analyst Job Location: Richmond, VA Duration: 6+ months Notes: ON SITE REQUIRED: 3 days onsite and 2 days remote. Parking is not provided for contractors Duration: Expected to extend past 8/30/24 (6 mo + assignment expected) Job Responsibilities: This position is for a Systems Analyst with proficiency in coordination, direction and...

  • Systems Analyst

    1 month ago

    Richmond, United States Crescens Full time

    Job Title: Systems Analyst Job Location: Richmond, VA Duration: 6+ months Notes: ON SITE REQUIRED: 3 days onsite and 2 days remote. Parking is not provided for contractors Duration: Expected to extend past 8/30/24 (6 mo + assignment expected) Job Responsibilities: This position is for a Systems Analyst with proficiency in coordination, direction and...

  • Business Systems Analyst

    6 days ago

    Richmond, United States RIT Solutions, Inc. Full time

    IT Technical Writer / Systems Analyst Location - Richmond, VA 23219 Interview Type - Both Web Cam and In Person Interview Work Arrangement- Hybrid Visa: USC or GC QUALIFICATIONS The candidate should have 10 years of overall IT experience with emphasis on technology project management. •The candidate must have a minimum of 2 years of experience...

  • Business Systems Analyst

    2 days ago

    Richmond, United States Expert In Recruitment Solutions Full time

    IT Technical Writer / Systems Analyst Location - Richmond, VA 23219 Interview Type - Both Web Cam and In Person Interview Work Arrangement- Hybrid Visa: USC or GC QUALIFICATIONS The candidate should have 10 years of overall IT experience with emphasis on technology project management. " The candidate must have a minimum of 2 years of...