Research and Planning Data Analyst

Commonwealth of Massachusetts • Natick, MA

7h

About The Position

In collaboration with the Director of Research and other Research Unit staff, the incumbent of this position 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 of this position 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. As such, experience with SQL queries and TOAD Data Point is a must. Additionally, 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. The incumbent should be well versed with Parole policies and procedures pertaining to different business processes across units to ensure data is entered and tracked by staff as per existing policies and procedures in a reliable manner. The incumbent should be able to identify and communicate data quality issues to management and where required, to staff across units. The incumbent further needs to develop a very good understanding of SPIRIT II and how it is being utilized by different units and user roles. Over time, they 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. The incumbent may need to assist the Director with conducting LS/CMI certification training as well as annual booster training for the Agency staff and any other SPIRIT related trainings on a need basis. This position assists the Director with data preparation for the Agency’s Annual Statistical Report, annual surveys, and any internal and external data requests. Other related duties as assigned.

Requirements

• Experience with SQL queries and TOAD Data Point is a must.
• Knowledge of Microsoft Power BI.
• Well versed with Parole policies and procedures pertaining to different business processes across units.
• 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 any equivalent combination of the required experience and the substitutions below.

Nice To Haves

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

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.

Benefits

• Outstanding suite of employee benefits that add to the overall value of your compensation package.
• A work experience that supports you, your loved ones, and your future.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree