Data Analyst 1

New York State Department of Taxation and Finance; City of Albany (NY); On-site; USD 59,000 - 66,000; Full time

Job summary

New York State Department of Taxation and Finance seeks a Data Analyst Trainee 1/2 to support the Office of Data Analytics. You will work under supervision to build business solutions, produce forecasts, and analyze program performance across fraud detection and revenue forecasting projects.

Responsibilities include data preparation, creating data dictionaries, conducting univariate and multivariate analyses, and developing basic predictive models while adhering to HR and internal control

Qualifications

• Six years of experience in data visualization, and statistical models and data mining tools.
• Associates degree AND four years of experience in data visualization, and statistical models and data mining tools.
• Bachelor’s degree AND two years of experience in data visualization, and statistical models and data mining tools.
• Master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field AND one year of experience in data visualization, and statistical models and data mining tools.
• Ph.D. in data or computer science, informatics, economics, statistics, mathematics, or a related field.

Responsibilities

• Preparing data for analysis and reporting using data wrangling techniques (joining, merging, stacking, cleansing, transposing, aggregating, transforming, etc.).
• Creating and maintaining data dictionaries and specifications documents.
• Producing and interpreting univariate analyses to identify patterns, outliers, and errors in data.
• Performing multivariate analyses using correlations, regression analysis (linear, nonlinear, tree, etc.), and multidimensional graphical techniques.
• Developing basic predictive models and assessing the results to ensure validity, applicability, efficiency, and accuracy.
• Summarizing and presenting analytical results using tables, graphs, dashboards, fact sheets, and written reports.
• Writing clear and concise results summaries for policy, business, and technical audiences.
• Maintaining knowledge of the Department’s data sets and data storage areas.
• Assisting in the systems management, data management, and testing of systems used for analysis; developing scripts and data pipelines to automate these tasks.
• Complying with Office of Human Resources Management, Affinitive Action, Code of Conduct, Ethics, and Internal Control policies and procedures.
• Adhering to Department's time and attendance rules and regulations.

Skills

Data analysis

Programming experience

Statistical methods

Education

Bachelor's degree

Associates degree

Master's degree

Ph.D.

Tools

SPSS Modeler

SPSS Statistics

SAS

Python

R

Stata

Tableau

SQL

GIS

Job description

Minimum Qualifications

Non-Competitive Minimum Qualifications

• Six years of experience in data visualization, and statistical models and data mining tools; OR
• Associates degree AND four years of experience in data visualization, and statistical models and data mining tools; OR
• Bachelor’s degree AND two years of experience in data visualization, and statistical models and data mining tools; OR
• Master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field AND one year of experience in data visualization, and statistical models and data mining tools; OR
• Ph.D. in data or computer science, informatics, economics, statistics, mathematics, or a related field.

Traineeship Qualifications:

Applicants with less than the required experience may be considered for a two-year (Data Analyst Trainee 1) or one year (Data Analyst Trainee 2) traineeship leading to Data Analyst 1 if the following minimum qualifications are met:

Data Analyst Trainee 1

• Four years of experience in data visualization, and statistical models and data mining tools; OR
• Associates degree AND two years of experience in data visualization, and statistical models and data mining tools; OR

Data Analyst Trainee 2

• Five years of experience in data visualization, and statistical models and data mining tools; OR
• Associates degree AND three years of experience in data visualization, and statistical models and data mining tools; OR
• Bachelor’s degree AND one year of experience in data visualization, and statistical models and data mining tools; OR
• Master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field

Preferred Qualifications:

• Candidates with strong data analysis skills and programming experience using one or more of the following tools: SPSS Modeler, SPSS Statistics, SAS, Python, R, Stata, Tableau, SQL, AQT, Cognos, GIS systems and advanced knowledge of statistics and machine learning are preferred.

Duties Description

The Data Analyst 1 will work in the Office of Data Analytics (ODA) under the direction of a supervisor or manager to build business solutions, produce forecasts, and answer questions across all areas of the Department of Taxation and Finance. Examples of projects include fraud detection, revenue forecasting at the micro and macro level, and analysis of program performance. Duties may include, but are not limited to:

• Preparing data for analysis and reporting using data wrangling techniques (joining, merging, stacking, cleansing, transposing, aggregating, transforming, etc.).
• Creating and maintaining data dictionaries and specifications documents.
• Producing and interpreting univariate analyses to identify patterns, outliers, and errors in data.
• Performing multivariate analyses using correlations, regression analysis (linear, nonlinear, tree, etc.), and multidimensional graphical techniques.
• Developing basic predictive models and assessing the results to ensure validity, applicability, efficiency, and accuracy.
• Summarizing and presenting analytical results using tables, graphs, dashboards, fact sheets, and written reports.
• Writing clear and concise results summaries for policy, business, and technical audiences.
• Maintaining knowledge of the Department’s data sets and data storage areas.
• Assisting in the systems management, data management, and testing of systems used for analysis; developing scripts and data pipelines to automate these tasks.
• Complying with Office of Human Resources Management, Affinitive Action, Code of Conduct, Ethics, and Internal Control policies and procedures.
• Adhering to Department's time and attendance rules and regulations.

Additional Comments

• Fall, Winter, and Spring graduates will be considered.
• This position is on site in Albany, NY and interviews will be scheduled in person.
• Telecommuting will be discussed at the interview.

Salaries for Trainees: The hiring rate for Data Analyst Trainee 1 – M/C is $59,204, and Data Analyst Trainee 2 – M/C is $66,023.

All candidates must be eligible for employment in the United States and maintain this eligibility throughout their employment with New York State. Employment is contingent upon the provision of proof of the right to accept employment in the United States.

Any candidate selected for this position will be subject to a review of their tax return submissions by the New York State Department of Taxation and Finance. Employment of a candidate is conditioned upon a finding by the New York State Department of Taxation and Finance that the candidate is in compliance with all local, state, and federal tax laws. In accordance with federal government requirements, the employment of any candidate selected for this position is conditioned upon completing a background investigation including a criminal history record check (fingerprint check).

New York State is an equal opportunity employer. It’s the policy of the state of New York to provide for and promote equal opportunity in employment, compensation, and other terms and conditions of employment without discrimination on the basis of age, race, color, religion, disability, national origin, gender, sexual orientation, marital status, or an arrest or criminal conviction record unless based on a bona fide occupational qualification or other exception.