Jobs
>
Richmond

    System Analyst II - Richmond, United States - Phaeton Solutions

    Default job background
    Description

    Job Description

    Job DescriptionSalary:

    JOB DESCRIPTION:

    Our client is seeking a System Analyst II who will be responsible for understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the VDOT TMS (Traffic Monitoring System). This is a hybrid position 3 days/week onsite in Richmond, VA.

    Contract date: 05/20/ /30/2024 ****Assignment to be extended beyond 6/30, possibly 24 months

    ESSENTIAL FUNCTIONS:

    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.

    KNOWLEDGE, SKILLS AND ABILITIES:

    • Experience troubleshooting challenging technical issues and identifying scope of issue to determine if escalation to next-tier support is necessary
    • Knowledge of server operations, management and backup/restore processes
    • Familiarity with Microsoft Window server environments such as Active Directory and Group Policies
    • Knowledge of LAN/WAN, Wi-Fi networks, network systems, network concepts and protocols, structured cabling and facilities
    • Knowledge of systems infrastructure requirements and standards based on ITIL
    • Knowledge of best practices for structured cabling for racks and network cabinets
    • Understanding of cloud computing, virtualization, and storage
    • Ability to communicate effectively and professionally
    • Ability to establish and maintain effective working relationships with fellow employees, superiors, and other departments
    • Ability to communicate technical information to non-technical personnel

    EDUCATION AND EXPERIENCE:

    • At least 4 years of Technical writing experience
    • At least 3 years of experience PL/SQL Development
    • At least 2 years of experience with Data Retrieval using SQL
    • At least 2 years experience in Scripting/Coding in a modern language such as Python (pandas, numpy) or R. Working with data frames
    • Strong written communication skills, especially for technical audiences
    • Must be able to see the big picture and not get bogged down in the details
    • Strong organizational skills
    • Ability to work independently
    • Ability to follow technical guidance from VDOT staff reporting to and working with
    • Knowledge of relational database design
    • Data Engineering skills (cleaning, preparation, validation)
    • Data Analysis and Visualization
    • Exposure to or some knowledge of transportation data

    SPECIAL REQUIREMENTS:

    • Possession of an appropriate driver's license valid in the Commonwealth of Virginia

    Phaeton Solutions, LLC is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Employment Opportunity (EEO), making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. U.S. Citizenship and/or authorization to work within the U.S. is required for most positions.


  • Serigor Inc

    Systems Analyst

    4 weeks ago


    Serigor Inc Richmond, United States

    Job Title: Systems Analyst (Hybrid) · Location: Richmond, VA · Duration:12+ Months · Job 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 ...

  • DataStaff, Inc.

    System Analyst

    6 days ago


    DataStaff, Inc. Richmond, United States

    DataStaff, Inc is in need of a System Analyst - Go-Live Planning & Coordination for a long-term contract opportunity with one of our direct clients located in the Richmond, VA area. · *The selected candidate will work onsite. · Responsibilities: · Serve as the Team Leader for a g ...

  • Mindsource Inc

    System Analyst

    2 weeks ago


    Mindsource Inc Richmond, United States

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

  • Swift Strategic Solutions Inc

    Systems Analyst

    2 weeks ago


    Swift Strategic Solutions Inc Richmond, United States

    A Public Sector client of ours is looking for a Systems Analyst to work on their ongoing project in the Richmond, VA office. · Below are the additional details of this role: · Required Skills: · We need a minimum of 5+ years of hands-on experience in the following. · Experience w ...

  • JSVV Sols LLC

    Systems Analyst

    2 weeks ago


    JSVV Sols LLC Richmond, United States

    Job Description · Job DescriptionRole: Sr. System Analyst · Location: Richmond, VA – Remote but need local · About the Role: · Enterprise Solutions is seeking a Systems Analyst to join our team. This position is crucial for performing operations and maintenance for our existing ...


  • Lorven Technologies Richmond, United States C2C, W-2

    Position: Business Systems Analyst TWO ROLES - Data Clean-up · Location: Richmond, VA (Hybrid Role) · Contract · *Local Candidates Only · The Business System Analyst reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall busin ...


  • Perfict Global, Inc. Richmond, United States

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


  • NN Tech, LLC Richmond, United States

    Job Description · Job DescriptionThis is a BSA role NOT a BA role and calls for a seasoned Senior Business Analyst with Systems Analyst experience. Suitable candidates must be comfortable working in a highly dynamic collaborative work environment to meet the needs of multiple bus ...


  • Cynet Systems Richmond, United States

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


  • Orbis Sibro, Inc. Richmond, United States

    Ship's System Analyst - Hull, Mechanical and Electrical · Norfolk, VA · Responsibilities: · Position is to help provide engineering, technical, and maintenance services to support for Navy Aircraft Carrier maintenance and modernization in the area of Hull, Mechanical and Elect ...

  • Phaeton Solutions

    System Analyst II

    1 week ago


    Phaeton Solutions Richmond, United States

    Job Description · Job Description Salary: · JOB DESCRIPTION: · Our client is seeking a · System Analyst II · who will be responsible for understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the VDOT TMS (Traffic Monitoring System). · ...

  • Integrated Resources

    System Analyst 2

    1 week ago


    Integrated Resources Richmond, United States

    Job Title: System Analyst 2 · Location: Richmond VA (Hybrid) · Duration: 6- 24 Months · Interview Process: Web Cam Interview Only · **Please submit candidates who already live in Richmond, VA · **Long-Term position requires onsite 3 days a week · **Assignment to be extended be ...


  • Serigor Inc. Richmond, United States

    Job Description · Job DescriptionJob 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 Reta ...

  • Precision Solutions

    Systems & QA Analyst

    2 weeks ago


    Precision Solutions Richmond, United States

    Overview · Systems & QA Analyst · Hybrid | Richmond, VA | As Needed (3-4 Times a Month) · US Citizenship Required · Summary · Our client is is a leading application Engineering Consulting firm in the Washington, D.C. metro region specializing in Management Services, Technology So ...


  • General Dynamics Information Technology Richmond, United States

    Req ID: · RQ174475 · Type of Requisition: · Regular · Clearance Level Must Be Able to Obtain: · Top Secret SCI + Polygraph · Job Family: · Business Process Analysis · Skills: · Analytical Thinking,Business Systems,Business Systems Analysis · Certifications: · Security ...

  • JSVV SOLS LLC

    Sr. System Analyst

    2 weeks ago


    JSVV SOLS LLC Richmond, United States

    Role: Sr. System Analyst · Location: Richmond, VA Remote but need local · About the Role: · Enterprise Solutions is seeking a Systems Analyst to join our team. This position is crucial for performing operations and maintenance for our existing applications while also developing ...


  • TECHEAD Richmond, United States

    TECHEAD is celebrating over thirty-five years of incredible heritage, talent, and accomplishments To learn more about TECHEAD, visit us at · or on · Glassdoor. · Interested in this role You can find all the relevant information in the description below. · Business System Anal ...


  • MKS2 Technologies Richmond, United States

    Job Description · Job DescriptionMKS2 Technologies, LLC, an award-winning high growth small business, creates innovative and customer-centric technology solutions in the areas of Cyber Security, Instructional Design and Training, Software Engineering and IT Support Services to im ...


  • Seneca Richmond, United States

    Role: Business Systems Analyst · Location: Richmond, VA · Must be able to work without sponsorship · My client is currently seeking a Senior Business Analyst contractor to assist our client in their Enterprise Project Management Office · The Senior BA will ensure that require ...

  • Logix Shapers

    System Analyst 4

    1 week ago


    Logix Shapers Richmond, United States

    Job Description · Job DescriptionRole - System Analyst 4 - CRIS Go-Live Planning & Coordination · Start Date - 06/24/2024. · End Date - 06/30/2025. · Location - North Chesterfield, VA · Interview Type - In Person Only · Work Arrangement- Onsite · Complete Description: · Client is ...