Data Analyst II

Job Description

Job Title: Data Analyst II (240004OS)

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.

Duties And Responsibilities:

• Help drive key big data-based initiatives that will generate significant benefits throughout the audit division.
• Review and complete requests for the enhancement of new and existing applications/reports and assist with the development and support of any other agency applications/reports.
• 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.
• Write comprehensive reports explaining results of queries and outputs.
• Produce standard and ad hoc reports using SQL, PLSQL, and 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.

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 existing applications.
• Experience in business intelligence analysis and design.
• Experience with predictive collections models and a risk-based scoring process to forecast behavior.
• Experience in integrating business intelligence data into daily operations to prioritize actions that result in the greatest return.
• Ability to design programs to gather and manipulate appropriate data for reports and/or analysis, and 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.

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.

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.

An Equal Opportunity / Affirmative Action Employer.

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.