Data Analyst Ii - Chelsea, United States - Tax Administration

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:


Duties and Responsibilities:

The Massachusetts Department of Revenue Tax Division Data Analytics team is seeking to hire a Data Analyst:

• Who will be responsible for helping to drive key big data-based initiatives that will generate significant benefits throughout the audit division.
• 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.

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.
• Strong analytical, troubleshooting, and problemsolving skills.
• 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 mínimal 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:

• 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.
• As part of the Future of Work initiative, the agency is adopting a hybrid work model. Hybrid work is a mix of inoffice work and telework. This position will work remotely some days and inperson on other days._

Qualifications

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 /