Data Analyst II

Job Description

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.

Tax:

The Tax Administration Division is responsible for fostering voluntary compliance and narrowing the tax gap by identifying, educating, and auditing noncompliant taxpayers. The Tax Administration Division audits the tax returns of businesses and individuals filed, including sales/use, meals, room's occupancy and special fuels are subject to examination by the Tax Administration Division staff.

• Who will be responsible for helping to drive key big data-based initiatives that will generate significant benefits throughout the audit division.
• Will be responsible in reviewing and completing requests in the enhancement of the new and the existing applications/reports and assisting with the development and supporting any other agency applications/reports.
• Will also perform unit testing by preparing test data, conducting test runs, and reviewing input and output data.
• Evaluate requests, gather business requirements, and creatively develop solutions, generating accurate queries and outputs to satisfy business requirements and needs.
• Write comprehensive reports explaining results of queries and outputs.
• Produce standard and ad hoc reports using SQL, PLSQL, other tools and data sources.
• Work with internal and external stakeholders regarding analysis and interpretation of data.
• Produce business rules and other project documentation based on DOR standards.
• Conduct advanced data mining, statistical analysis, and research activities.
• Manage a dynamic workload of development, testing and research tasks, ensuring key deadlines are met.
• Design and develop utility programs to automate manual operations, when needed.
• Conduct data matches for the purpose of improving collections, enforcement, and data reliability.
• Identify all audit and external source data files and variables needed to produce specific output requirements utilizing both data extracts and Data Warehouse.
• Design, implement and optimize machine learning services.
• Evaluate and refine new and existing models as needed.
• Work with subject matter experts from business units to translate business problems into analytical approaches and identify questions to be answered using available data.

• Proficient with SQL/PL SQL.
• Experience in SQL Server 2012 and up.
• Proficient with at least one computer programming language such as JAVA, C#, .Net, Python, XML, etc.
• Knowledge of Microsoft applications including Excel, Teams and Word.
• Strong analytical, troubleshooting, and problem-solving skills.
• Develop, maintain, and troubleshoot the existing applications.
• Experience in business intelligence analysis and design
• Experience with predictive collections models and a risked based scoring process to forecast behavior, to better understand our customers, and to determine what metrics are critical to the organization.
• Experience in the integration of business intelligence data into the daily operations of the organization to prioritize actions that will result in the greatest return.
• Ability to design programs to gather and manipulate appropriate data to accommodate requests for reports and/or analysis, and then translate that analysis into management reports.
• Ability to communicate effectively orally and in writing; and handle confidential assignments.
• Ability to work independently/ with minimal supervision, handle multiple tasks simultaneously and adapt quickly to changes.
• Perform unit testing by preparing test data, conducting test runs, and reviewing input and output data.

• 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.
• Good knowledge of MA and IRS tax laws, policies and procedures.