Systems Analyst

Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve its business communities as a leading IT vendor providing innovative, quality, and cost-effective IT business solutions and services.

We offer a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.

YSI is seeking a highly qualified Systems Analyst. The selected candidate will be able to communicate effectively (written/verbal), possess strong interpersonal skills, be self-motivated, and be innovative in a fast-paced environment.

Job Responsibilities:

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

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.

For the successful completion of the above two tasks, the SA 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.

Required Skills and Qualifications:

· Prior PL/SQL Development experience (3 Years)

· Data retrieval using SQL (2 Years)

· Technical writing (4 Years)

· Strong written communication skills, especially for technical audiences (4 Years)

· Strong verbal communication skills, especially when addressing technical audiences (4 Years)

· Scripting/coding in a modern language such as Python (pandas, numpy) or R. Working with data frames. (2 years) Desired

· Knowledge of relational database design. (1 Year) Desired

· Data Engineering skills (cleaning, preparation, validation) (1 Year) Desired

· Data Analysis and Visualization 1 Year) Desired

· Exposure to or (some) knowledge of transportation data, skills, or/and concepts (1 Year) Desired

Job Types: Full-time, Contract

Pay: $65,000.00 - $70,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Professional development assistance
• Vision insurance

Compensation package:

• Yearly pay

Experience level:

• 3 years
• 5 years

Schedule:

• 8 hour shift
• Monday to Friday

Experience:

• PL/SQL Development: 3 years (Required)
• SQL Data Retrieval: 1 year (Required)
• Technical writing: 4 years (Required)
• Relational Database Design: 1 year (Required)
• Scripting/Coding in modern language such as Python: 2 years (Required)

Ability to Commute:

• Richmond, VA 23219 (Required)

Work Location: In person