Research and Planning Data Analyst

About the role

In collaboration with the Director of Research and other Research Unit staff, the incumbent is responsible for conducting and coordinating all data related projects for the Agency while also acting as the local administrator of SPIRIT II, the Agency's case management system. The primary focus is extraction of raw data from SPIRIT II by building and modifying SQL queries using Toad Datapoint software and validation of such data, along with tracking, auditing, and analysis of the data. The incumbent is expected to have knowledge of Microsoft Power BI to be able to analyze and display as well as routinely refresh and update SPIRIT II data in the Power BI Dashboard.

Responsibilities

• Helps with extraction and validation of raw data from SPIRIT by building and modifying SQL queries using Toad Datapoint software
• Uses Microsoft Power BI to analyze, display and routinely refresh and update SPIRIT data in the Power BI Dashboard
• Creates weekly, monthly, and quarterly reports for units within the Agency for performance measurement, and communicates data issues where applicable
• Familiarizes themselves with Parole policies and business procedures across units to ensure data is entered and tracked by staff consistent with existing policies and procedures
• Regularly audits and tracks data captured by active reports and extracts from SPIRIT and communicates data quality issues to management and where advised, relevant staff across units
• On request from the Director, analyzes data to measure performance across different business processes to help towards improving policies and procedures
• Assists with coordination for conducting LS/CMI certification training and annual booster training
• Collects and prepares data annually for the MPB Statistical Report, BJS Parole Survey, and NCRP data submission
• As the SPIRIT backup administrator whenever needed, works on developing a very good understanding of SPIRIT II and how it is being utilized by different staff across units. Over time, should be able to troubleshoot any issues with recording data in SPIRIT II, and contribute significantly towards preparing reliable criteria for new SPIRIT enhancements to improve data tracking
• Uploads the RODs and monthly lifer hearing calendars on the Agency website and serves as one of the website managers
• Assists the Director with both internal and external data requests, including public records request, media requests, requests from legislators, and external and internal research requests when needed
• Other related duties as required

Requirements

Applicants must have (A) at least two years of full-time or equivalent part-time professional or technical experience performing related duties that include business data recovery, analysis, query design, reporting and statistical analysis; or (B) any equivalent combination of the required experience and the substitutions below:

• A Bachelor's degree or higher with a major in Mathematics, Economics, Computer Science, Information Management, Statistics or a related field may be substituted for the required experience

Preferred Qualifications

• Expertise with use of Microsoft Power BI, Toad Datapoint for building queries, excel

Pay

Salary $82,789.72

Schedule

Full-time, Day shift

Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package.