State of Massachusetts Edp Systems Analyst III in Chelsea, Massachusetts
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.
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.
The Massachusetts Department of Revenue Tax Division seeks a senior system analyst to be assigned to the Data Analytics Unit located in Chelsea. We are looking for person who is ready to be responsible for helping drive key big data based initiatives that will generate significant benefits throughout the audit division. This role is not just about data, it's also about understanding the complex interplay between technology and audit division operations. We need someone who has a high level of analytical and system skills, but equally as important, the ability to understand the business impact of data quality.
Create and analyze queries based on data in the data warehouse. Use SQL, PLSQL and other query tools to execute complex queries. Work with Audit staff to translate business needs into data results by writing SQL queries from the Data Warehouse and other responsibilities as required. Help write and refine complex business rules for tax related projects and queries. Design and develop utility programs for DOR staff to automate manual operations, when needed. Write comprehensive reports explaining results of queries. Contribute to Audit projects and policy decisions by conducting research, obtaining data, and performing statistical analysis. Conduct evaluations of the effectiveness of Audit enforcement, collection and other initiatives. 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. Organize findings into summary results and publish reports for senior management and other internal and external requestors. Compile, program, and update reports regularly containing key agency statistics for distribution throughout the Department.
•Strong analytical skills.
Proficient with SQL/PL SQL.
Proficient with at least one computer programming language such as JAVA/C#/.Net/Python etc.
Experience of working and managing data warehouses.
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.
•Experience in the collection and analysis of external market data to provide benchmarks for comparison purposes.
•Ability to analyze requests for reports and/or analysis in order to assess user needs.
•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 prioritize multiple tasks and produce high-quality work for senior management under pressure. Knowledge of the methods of statistical report writing is required.
•Knowledge of Microsoft applications including Excel, ACCESS, and Word.
•Ability to communicate effectively orally and in writing; and handle confidential assignments.
Well versed with Microsoft Excel and other office applications. Knowledge of R/R-Studio or Python. Expert knowledge of Sql programming. Work experience with genesis a plus. 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.//
First consideration will be given to those applicants that apply within the first 14 days.
Minimum Entrance Requirements:
Applicants must have at least (A) four years of full-time, or equivalent part-time, professional experience in electronic data processing of which (B) at least two years must have been in work in which the major duties included computer systems analysis, or (C) any equivalent combination of the required experience and the substitutions below.
I. An Associate's degree with a major in the field of data processing or computer programming may be substituted for a maximum of one year of the required (A) experience.*
II. A Bachelor's degree with a major in the field of data processing or computer and/or information science may be substituted for a maximum of two years of the required (A) experience.*
III. A Graduate degree with a major in the field of data processing or computer and/or information science may be substituted for a maximum of two years of the required (A) experience.*
IV. A diploma for completion of a two year full-time, or equivalent part-time, program in a recognized non-degree granting business or vocational/technical school above the high school level with a major in the field of computer programming may be substituted for a maximum of one year of the required (A) experience.*
V. An official transcript from a recognized business or vocational/ technical school as evidence of completion of a program consisting of at least 650 hours of instruction in the field of computer programming may be substituted for a maximum of one year of the required (A) experience.
VI. Graduation from the data processing course of a recognized vocational/technical high school may be substituted for a maximum of one year of the required (A) experience.
*Education toward such a degree or diploma will be prorated on the basis of the proportion of the requirements actually completed.
NOTE: No substitution will be allowed for more than two years of the required (A) experience.
NOTE: No substitution will be allowed for the two years of the required (B) experience.
Special Requirements: None.
An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.
Job: *Information Systems and Technology
Organization: *Department of Revenue
Title: Edp Systems Analyst III
Location: Massachusetts-Chelsea-200 Arlington Street
Requisition ID: 190008L9