SPIRIT II Data Analyst — Power BI & SQL Specialist

Commonwealth of Massachusetts; Natick (MA); Hybrid; USD 82,789 - 120,508; Full time

Benefits offered by this job

Hybrid work schedule

Job summary

The Commonwealth of Massachusetts, Parole Board, seeks a Research and Planning Data Analyst in Natick to manage SPIRIT II data. You will extract and validate data using SQL queries and TOAD Data Point, and maintain Power BI dashboards for ongoing performance monitoring.

You will generate weekly, monthly, and quarterly reports, ensure data quality and policy-aligned entry, and support training and external data requests. A bachelor’s degree with data experience is preferred.

Qualifications

• Two years of professional/technical experience in data recovery, analysis, query design, reporting and statistics.
• Bachelor’s degree or higher in Mathematics, Economics, Computer Science, Information Management, Statistics or related field may substitute for required experience.

Responsibilities

• Extract and validate raw data from SPIRIT by building and modifying SQL queries using Toad Data Point.
• Use Power BI to analyze, display, and routinely refresh and update SPIRIT data in the Power BI Dashboard.
• Create weekly, monthly, and quarterly reports for agency units for performance measurement and communicate data issues.
• Familiarize with Parole policies and procedures to ensure data entry and tracking aligns with policies.
• Regularly audit and track data from SPIRIT reports and communicating data quality issues to management and relevant staff.
• Analyze data to measure performance across business processes to support policy improvement.
• Assist with LS/CMI certification training and annual booster training.
• Collect and prepare data annually for the MPB Statistical Report, BJS Parole Survey, and NCRP data submission.
• Act as SPIRIT backup administrator and develop understanding of SPIRIT II usage across units.
• Troubleshoot data recording issues and contribute to SPIRIT enhancements for better data tracking.
• Upload RODs and monthly lifer hearing calendars on the Agency website and serve as a website manager.
• Assist the Director with internal and external data requests (public records, media, legislators) when needed.
• Other related duties as required.

Skills

SQL

Power BI

Data analysis

Education

Bachelor’s degree or higher in Mathematics, Economics, Computer Science, Information Management, Statistics or related field

Tools

Toad Data Point

Job description

The Commonwealth of Massachusetts, Parole Board, seeks a Research and Planning Data Analyst in Natick to manage SPIRIT II data. You will extract and validate data using SQL queries and TOAD Data Point, and maintain Power BI dashboards for ongoing performance monitoring.

You will generate weekly, monthly, and quarterly reports, ensure data quality and policy-aligned entry, and support training and external data requests. A bachelor’s degree with data experience is preferred.