Data Analyst

ROLE : - Data Analyst

LOCATION : - Quincy, MA

DURATION : - 6 Months (option to extend)

INTERVIEW TYPE : Webcam Interview Only

Hybrid - 8+ year experience required.

Complete Description :

Required Basic knowledge of SQL queries and .NET

Knowledge of RMV database ATLAS

Duties and Responsibilities :

• Examine data in the Commercial Skills Test Information System (CSTIMS) and ATLAS to analyze pass / fail test data to determine reasons for CDL road test failures
• Track failures within each specific skills test component to include pre-trip inspection, maneuvers, and the road test
• Determine how many attempts it takes for a road test applicant to pass the CDL road skill test
• Analyze and document trends related to CDL training schools, road test training sites, and road skill test examiners
• Determine length of time it takes CDL applicants to obtain a license, from written permit exam to issuance of CDL by RMV
• Analyze and document how long it takes from the time an applicant requests a road test to their actual road skill test appointment
• Using analysis specific to training schools, make recommendations as to how they might better prepare their CDL students for the RMV road skill testing process
• Provide recommendations as to specific reports that would enable the RMV to monitor the Road Skill Test program on an on-going basis
• Provide the Commercial Motor Vehicle (CMV) Program Coordinator with actionable insights and analysis reports based on data, to support decision-making efforts toward program oversight and monitoring goals
• Communicate with, and present technical information to non-technical stakeholders
• Gather and aggregate data to meet the business need of developing a program monitoring and oversight solution
• Analyze the reports currently provided by the American Association of Motor Vehicle Administrators (AAMVA) regarding CDL testing, determine their usefulness to program monitoring and oversight efforts, and suggest new or different reports for needed information
• Create a database and possibly reports that track the specific information needed to become compliant with FMCSA regulations around the RMV Road Skill Test program
• Become familiar enough with CMV program to understand the data needed to address program deficiencies and create improvement, and how to access that data; specifically, the Entry Level Driver Training requirements and related database
• Identify key performance indicators for the CMV program coordinator to measure the effectiveness of the Road Skill test program
• Explore large data sets to find usable information

Requirements :