You are viewing a preview of this job. Log in or register to view more details about this job.
Email

Agency Overview

The Department of Revenue's core mission is to collect the revenues required to support the business of the Commonwealth, to make a difference in the lives of children by enforcing the financial responsibilities of parenthood, and to assist Massachusetts cities and towns in sound and efficient fiscal management. Our vision is to conduct our operations in a manner that inspires public confidence in government by administering and enforcing tax, child support and municipal finance laws in ways that are innovative, customer-focused, and transparent.

 

Bureau/Division Overview

The Data Analytics Group is responsible for audit selection and analysis utilizing DOR's data warehouse as well as analysis in our AWS cloud Data Lake.

 

Position Summary

The candidate will learn how Data Analytics drives key big data-based initiatives that will generate significant benefits throughout the audit division. The candidate will be exposed to all our existing and new applications/reports and learn how they are developed and supported with other agency applications/reports. The candidate will also gain exposure to and learn how we perform unit testing, preparation of test data, conducting test runs, and reviewing input and output data. 

 

Core Responsibilities

Learn and assist in generating audit queries from within our various database applications

·    Produce standard and ad hoc reports using SQL, as well as other tools and data sources 

·    Exposure to how Data Analytics conducts advanced data mining, statistical analysis and research activities

 

 

Preferred Qualifications

Well versed with Microsoft Excel and other office applications

 Knowledge of R/R-Studio or Python

·       Experience working with Jira and AWS

·       Experience working with Tableau

·       Expert knowledge of SQL/PL SQL programming

 

As part of the Future of Work Initiative, the agency is adopting a hybrid work model.  Hybrid work is a mix of in-office work and telework.  This position will work remotely some days and in-person on other days.

An external candidate recommended for a position with the Department of Revenue will be subject to a background check that includes checks for: state and federal tax compliance; child support compliance; education verification; Massachusetts CORI checks; criminal background checks in state(s) of current and previous residence/employment; validation of eligibility to work in the United States; and national fingerprint-based criminal background checks.