Data Analyst
About The Office
The Middlesex District Attorney’s Office serves the most populous county in New England, covering 54 diverse cities and towns. We prosecute cases across 12 district courts, 4 juvenile courts, and 2 superior courts.
Our core mission is to protect and serve the people who work, live, and raise their families in Middlesex County. Assistant District Attorneys, Victim Witness Advocates, Paralegals, and other talented professionals pursue this mission through exhaustive investigations, unassailable prosecutions, and compassionate victim advocacy.
We are also committed to innovative crime prevention and intervention initiatives. Our staff partners with community groups, social service providers, medical professionals, private industry leaders, and law enforcement officers to address a variety of public safety issues.
Job Title Data Analyst
Full Time Full Time; Non-Exempt
Reports to Director of Information Technology
Salary $75,000 - $80,000 yearly
Placement within MDAO MDAO Main Office in Woburn
Position Summary
The Data Analyst will support the Information Technology department by overseeing the Office’s proprietary case management system (“Damion”). The Data Analyst will be responsible for providing timely and detailed analytical information and procedural guidance relating to the collection, analysis, and presentation of prosecution data maintained in the Damion system. Responsibilities will include meeting internal and external reporting demands and identifying methods to improve the accuracy and completeness of information that is entered into the system. This full-time position requires an extremely hardworking, innovative, organized individual who possesses expertise in interpreting and analyzing criminal justice system data. The position requires both great attention to detail and a demonstrated ability to manage SQL databases and other types of large data sets.
Primary Responsibilities
- Design reports and dashboards that analyze data though use of reporting software
- Work closely with data entry staff managers to ensure the accuracy, completeness, and reliability of information that has been entered into case management system
- Meet regularly with management to leverage pre-existing knowledge of prosecutorial processes, assess reporting needs, and construct reports and dashboards to meet those needs.
- Advise management on the potential for implementation or optimization of workflows involving data entry into case management system
- Enhance functionality of case management system by modifying front-end windows and back-end SQL code as needed
- Additional duties assigned to the Information Technology department as required
Requirements
- Bachelor’s or Master’s degree in Computer Science, Data Science, Data Engineering, Software Engineering, Statistics, Mathematics or a related field.
- 2+ years of experience as a data analyst, database analyst, database administrator, or comparable position
- Strong proficiency in SQL & PL/SQL
- Strong proficiency in Python or Powershell
- Familiarly with the Commonwealth’s criminal justice system, particularly with court procedure
- Demonstrated ability to efficiently and effectively present information in dashboards using Tableau, PowerBI, or dbxtra Reporting software
- Excellent organizational skills with a strong attention to detail and ability to meet tight deadlines
- Excellent written and verbal communication skills with the ability to interact with a variety of functional areas and different levels of management
- A valid driver’s license, as travel across Middlesex County may be required
- A background check is required
Preferred Qualifications
- Experience with the Commonwealth case management system (“Damion”)
MDAO Benefits
The MDAO is pleased to offer a comprehensive benefits package to its employees. The specific components and eligibility may vary based upon position classification, hours worked per week and other variables. Therefore, specific benefits for this position may be discussed as part of the interview and offer process for this position.
The overall benefits available include: Paid Vacation, Sick and Personal Leave Time; Health, Dental and Vision Insurance through the Commonwealth’s Group Insurance Commission and a pre-tax Health Savings Account optional plan. In addition the MDAO provides employees the opportunity to elect Life Insurance, Long-Term Disability Insurance, Deferred Compensation Savings, Tuition Remission, along with other programs.
MDAO employees also participate in the Commonwealth’s State Retirement Plan, which can become a defined benefit plan for those that both vest and subsequently retire from state service.
The MDAO provides the ability to accrue up to two weeks of paid vacation leave per year, up to 3 personal days of leave per year (depending upon the quarter of the year that one’s employment begins), 11 recognized state / federal paid holidays, and the opportunity to accrue up to 9.375 hours of paid sick leave per month.
Commitment to Diversity
District Attorney Ryan is committed to building a diverse staff and has formed both internal and external diversity committees to help attract, hire, retain and promote the very best staff, diverse in background and perspective, while helping formulate and guide policy and decision making, and pursue the mission of the office. The MDAO is an equal opportunity employer.
Application Process
Interested candidates should submit an MDAO Application form (found at www.middlesexda.com under the “About” tab) and forward it with a cover letter, resume, and a list of references to mdaojobs@state.ma.us by April 30, 2024. Please indicate in the “Subject” line the position you are applying for.
Further Information
Candidates are encouraged to visit the MDAO website at www.middlesexda.com to learn more about the work of the office.