Research and Planning Data Analyst Job Natick area,Massachusetts USA,IT/Tech

An Official website of the Commonwealth of Massachusetts

Job Description
- Research and Planning Data Analyst (260003YL)

Job Description

Research and Planning Data Analyst - ( 260003YL )

Description

General Statement of

Duties and Responsibilities:

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

DETAILED STATEMENT OF DUTIES AND 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.

Preferred Qualifications

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

First consideration will be given to those applicants that apply within the first 14 days.

Minimum Entrance 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

Substitutions:

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

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee…