Data Analyst Ii

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 Overview:

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.

Duties and Responsibilities:

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

Qualifications:

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

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

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.

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. 

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

Minimum Entrance Requirements:

Applicants must have (A) at least four years of full-time or equivalent part-time professional 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 substitution below.

Substitutions:

I.     A Bachelor's degree with a major in Mathematics, Economics, Computer Science, Information Management, Statistics or a related field may be substituted for two (2) years of the required experience

II.    A Master's degree or higher with a major in Mathematics, Economics, Computer Science, Information Management, Statistics or a related field may be substituted for three (3) years of the required experience
 

Comprehensive Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

Want the specifics? Explore our Employee Benefits and Rewards!

An Equal Opportunity / Affirmative Action Employer.  Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law.  Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements.  We encourage individuals who believe they have the skills necessary to thrive to apply for this role.