Title: Senior Business Data Analyst (Part-Time)

State Role Title: Prog Admin Specialist III

Hiring Range: $42.23- $68.62

Pay Band: 6

Agency: VA Dept of Transportation

Location: Dept of Transportation

Agency Website: https://www.virginiadot.org/jobs

Recruitment Type: General Public - G

Job Duties

Virginia Department of Transportation’s (VDOT) is excited to offer and announce a competitive opportunity to serve as a part-time Senior Business Data Analyst in our Central Office Traffic Operations Division, Data and System Analysis Group. The selected analyst will be engaged in various aspects of Traffic Data Analytics tasks including but not limited to data acquisition, cleaning and validation; data fusion; data analysis; data visualization; prototype/first implementation for pilot VDOT projects and ad-hoc data analyses; research and literature review.

Data acquisition, cleaning and preparation tasks require working with many transportation and non-transportation data sets e.g. speed, daily and hourly traffic volume, road geometry and characteristics, socio-demographics data, posted speed limits, weather, work zone information, crash and incident data, pedestrian and bicycle data, and others. Obtaining those data sets can be through different means such as: graphical user interfaces, APIs, direct access to back-end databases, either internally from VDOT or from third party vendor and archives. Data cleaning and preparation steps will be needed, and they may be different based on the data set and source. These duties overlap with data engineering duties.

Data fusion tasks require merging or aligning (fusing) data sets on the spatial (location) or temporal (point in time or similar period of year and time of day) dimensions, in a redundant (same attributes) or complementary (different attributes) or other fashions. These duties can overlap with data engineering duties.

Data analysis tasks require the incumbent to apply tried-and-true but also new-and-innovative methods to identify historical travel trends, conduct Before-and-After studies, perform congestion and reliability analyses for specified areas and time periods of interest, identify locations and time periods experiencing unusual traffic behavior, or study specific traffic conditions at locations and during time periods of interest to the agency.

Data visualization tasks consist of presenting analysis results in a format and at a level of detail appropriate for the audience, through interactive and static charts, graphs, and maps. The Senior Business Data Analyst Hourly will create visualizations for projects where they have done the analysis themselves, and also for projects where the analysis has been done by other team members.

Prototyping and first implementation of VDOT projects and ad-hoc data analyses draw from transportation domain expertise and transportation data knowledge. The incumbent will receive appropriate guidance on the methodologies needed to develop new projects and perform ad-hoc analyses and will have to use knowledge gained previously to take them to a successful finish.

Research includes but is not limited to literature review of transportation data analytics algorithms, investigating the feasibility and usability of incorporating new data sources into analytics algorithms to improve accuracy and relevance of results, traffic forecasting methods, investigation of innovative concepts. To be successful in this position, on-your-own research and learning will be needed for all aspects of the job.

This position is an Hourly/Wage position. Hourly(wage) positions may not work more than an average of 29 hours per week and cannot exceed 1500 hours during the wage employment year (May1-April 30). This position does not include health insurance, retirement or leave benefits.

Minimum Qualifications

• Skill in working with business and/or financial information systems.
• Proficient use of Microsoft software.
• Knowledge of theory and principles of database development, data management, business process improvement, and performance management.
• Skill in developing and managing large data sets and integrating data from different sources and across different platforms.
• Ability to apply logic and reasoning to identify and analyze problem areas and recommend various solutions.
• Skill in oral and written communication to build effective relationships.

Additional Considerations

• Experience working in teams to solve complex problems.
• Experience defining a business need, identifying a solution, implementing the solution, and monitoring performance.
• Proficient use of Microsoft software including SharePoint, Teams, Excel, PowerBI, etc.
• A combination of training, experience, or education in Engineering, Computer Science, Applied Mathematics, Information Management Systems, Technology, Communications or related field desired.
• Experience in data processing using programming languages such as Python and R.
• Experience with GUI-based data analytics and visualization tools such PowerBI and Tableau
• Experience with SQL, Oracle databases, and APIs
• Any experience with data analytics, visualization, scripting, and coding
• Any experience preparing, exploring, cleaning, analyzing, fusing, and visualizing large data sets
• Attention to detail and be meticulous with data
• Ability to work independently

Special Instructions

You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to “Your Application” in your account to check the status of your application for this position.

• This position requires a fingerprint based Criminal History Background Check, DMV Record Check and Work History Verification with references.

• This position is designated as essential, employees may be required to work in emergencies, to include weekends, holidays, and after normal business hours; assignments may vary based on business needs to include working in severe weather.

• Once onboarded, this position may be eligible for telework opportunities; availability, hours, and duration of telework shall be approved as outlined in the Commonwealth telework policy. (only for eligible positions)

• We are a “Virginia Values Veterans” (V3) official certified company and state agency that provides hiring preference to Veterans and Members of the Virginia National Guard in support of Executive Order 29, (2010). If you are a Veteran or Virginia National Guard Member, we urge you to respond accordingly on your state application.

• VDOT utilizes a market based pay program, which has been approved by DHRM. Therefore, advertised rates of pay may or may not align with the Commonwealth pay bands.

Contact Information

Name: Candace Raigns

Email: [email protected]

In support of the Commonwealth’s commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at 800-552-5019.

Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.