System Analyst

2 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 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 Virginia State Agency's 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 Type**: Contract

Pay: $45.00 - $50.00 per hour

**Benefits**:

- 401(k)
- Dental insurance
- Health insurance
- Tuition reimbursement

Experience level:

- 4 years

Schedule:

- 8 hour shift

**Experience**:

- Prior PL/SQL Development: 3 years (required)
- Data retrieval using SQL: 2 years (required)
- Technical writing: 4 years (required)
- Strong written communication skills, for technical audiences: 4 years (required)
- see the big picture and not get bogged down in the details: 3 years (required)
- Strong organizational skills, work independently: 3 years (required)
- Exposure to transportation data, skills, or/and concepts: 1 year (required)
- follow technical guidance for staff reporting to and working: 2 years (required)
- Scripting/coding in a modern language: 2 years (required)
- Python (pandas, numpy) or R. Working with dataframes.: 2 years (required)
- Knowledge of relational database design.: 1 year (required)
- Data Engineering skills (cleaning, preparation, validation): 1 year (required)
- Data analysis and visualization: 1 year (required)

Work Location: Hybrid remote in Richmond, VA

  • 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

    3 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 days 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

    4 weeks ago

    Richmond, United States Apollo Technology Solutions LLC Full time

    **Title: System Analyst** **Location: Richmond, VA/ Hybrid** **Duration: 4+ Months** - This position is for a Systems Analyst with proficiency in coordination, direction and procedures for all testing phases of a multi-vendor, large scale software system. - Responsible for communicating and reporting to a variety of stakeholders about the results and...

  • System Analyst

    4 weeks ago

    Richmond, United States Noralogic INC Full time

    **Role - Systems Analyst** **Location: Richmond, VA 23219** **Contract - Hybrid** Duration: Expected to extend past 8/30/24 (6 Month+ assignment expected) ON SITE REQUIRED: 3 days onsite and 2 days remote. **ABOUT THE ROLE** **Systems Analyst** Expected to have the ability to understand the requirements and design of the project and able to develop test...

  • Systems Analyst

    4 weeks ago

    Richmond, United States Intone Networks Full time

    Position Title: Systems Analyst location: HYBRID (3 days onsite) Richmond, VA

  • System Analyst

    4 weeks ago

    Richmond, United States Tri-Force Consulting Services Full time

    **Job Information**: Industry - IT ServicesWork Experience - 5+ yearsSalary - NaCity - RichmondState/Province - VirginiaCountry - United StatesZip/Postal Code - 23219**Title**: System Analyst**Duration**:04 Months**Client**:Virginia Information Technology Agency**Location**:Richmond, VA **Note: This position is a hybrid position.** **"The applicant is the...

  • Business Systems Analyst

    3 days ago

    Richmond, United States Cynet Systems Full time

    Job Description: The Business System Analyst reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Leads analysis and solution definition. Understands the business issues and data challenges of the organization. Identifies the organization's strengths and weaknesses and...

  • System Analyst

    3 weeks ago

    Richmond, United States The Custom Group of Companies Full time

    Systems AnalystLong-term contract, 9+ months Hybrid (3x a week onsite) Richmond, VA (23219)Rate: $60/hr W2 Summary:This position is for a Systems Analyst with proficiency in coordination, direction, and procedures for all testing phases of a multi-vendor, large scale software system. The candidate must be able to work with minimum supervision and have the...

  • System Analyst

    3 weeks ago

    Richmond, United States The Custom Group of Companies Full time

    Systems AnalystLong-term contract, 9+ months Hybrid (3x a week onsite) Richmond, VA (23219)Rate: $60/hr W2 Summary:This position is for a Systems Analyst with proficiency in coordination, direction, and procedures for all testing phases of a multi-vendor, large scale software system. The candidate must be able to work with minimum supervision and have the...

  • 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

    3 days 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...

  • Senior System Analyst

    1 week ago

    Richmond, United States TalentBurst Full time

    W2 Acceptable OnlyDescription:IT Generation team is seeking a Senior Systems Analyst with strong analytical skills and attention to detail to provide support for the project Coastal Virginia Offshore Wind Power (CVOW). The successful candidate will need to be an expert in all aspects of the System Analyst role. The ideal candidate will possess an exceptional...

  • System Analyst

    4 weeks ago

    Richmond, United States Tri-Force Consulting Services, Inc. Full time

    Job DescriptionJob DescriptionTitle: System Analyst Duration: 04 MonthsClient: Virginia Information Technology AgencyLocation: Richmond, VANote: This position is a hybrid position."The applicant is the center of our universe."Job Description:This position is for a Systems Analyst with proficiency in coordination, direction and procedures for all testing...

  • Systems Analyst

    2 weeks ago

    Richmond, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Systems Analyst (Hybrid)Location: Richmond, VADuration: 12+ MonthsJob Description:This position does involve quite a bit of analytical skills as well as testing skills.Strong Systems Analyst is needed to support the Release 103 Cardinal Care Managed Care 2.0 initiative which deals with Consolidation of the Medallion...

  • Systems Analyst

    1 week ago

    Richmond, United States Serigor Inc Full time

    Job Title: Systems Analyst (Hybrid)Location: Richmond, VADuration:12+ MonthsJob Description:This position does involve quite a bit of analytical skills as well as testing skills.Strong Systems Analyst is needed to support the Release 103 Cardinal Care Managed Care 2.0 initiative which deals with Consolidation of the Medallion 4.0 and CCC Plus programs into...

  • Systems Analyst

    3 weeks ago

    Richmond, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Systems Analyst (Hybrid)Location: Richmond, VADuration: 12+ MonthsJob Description:This position does involve quite a bit of analytical skills as well as testing skills.Strong Systems Analyst is needed to support the Release 103 Cardinal Care Managed Care 2.0 initiative which deals with Consolidation of the Medallion...

  • Systems Analyst

    4 weeks ago

    Richmond, United States Serigor Inc Full time

    Job Title: Systems Analyst (Hybrid)Location: Richmond, VADuration:12+ MonthsJob Description:This position does involve quite a bit of analytical skills as well as testing skills.Strong Systems Analyst is needed to support the Release 103 Cardinal Care Managed Care 2.0 initiative which deals with Consolidation of the Medallion 4.0 and CCC Plus programs into...

  • System Analyst 2

    1 week ago

    Richmond, United States TalentBridge Full time

    Job Description: Position Title: Systems Analyst 2 Summary: We are seeking a skilled individual to join our team as an Oracle SQL and PL/SQL Code Analyst & Technical Documentation Specialist. This role involves understanding, replicating, and documenting Oracle SQL and PL/SQL code used in data analysis processes. The successful candidate will work closely...

  • Business System Analyst

    2 weeks ago

    Richmond, United States Serigor Inc Full time

    Job Title: Business System Analyst (HYBRID) Location: Richmond, VA Duration: 12+ Months Job Description: The client seeks a Business Systems Analyst to work on an inhouse software development project for the Division of Securities and Retail Franchising. This position will be responsible for eliciting functional requirements for the division's new SERFIS...