Data Analyst 1

Data Analyst Trainee 1, NS (equivalent to SG-14)

Under the direction of the Data Analyst 2 in the Bureau of Data Reporting and Analytics, the Data Analyst 1 will perform data extraction, aggregation, and quality checks from multiple sources and tables in support of trend identification and root cause analysis and summarize results, create written reports, and collaborate with staff in support of innovative and effective dashboards and data visualizations. Duties include but are not limited to:

• Prepare data download, cleaning, and analysis across several large data systems using SAS, Python, and/or SQL.
• Update and maintain Tableau Dashboards to support operational and leadership reporting.
• Maintain integration processes required for optimal extraction, transformation, and loading of data from a wide variety of data sources in both on premise and cloud environments.
• Collaborate with staff and external partners to ensure support for all data sets and processes running in production.
• Translate program requirements to technical documentation and compile methodology/code to support for major quality, safety, and public health.
• Assess data structures of current data systems and provide suggestions for how they can be used to produce desired reports.
• Utilize cloud-based data analytics technology solutions to support both regular reports and analyses as well as research on health outcomes of interest.
• Prepare data for analysis and reporting using data wrangling techniques (joining, merging, stacking, cleansing, transposing, aggregating, transforming, etc.).
• Produce and interpret univariate analyses to identify patterns, outliers, and errors in data.
• Assist in the systems management, data management, and testing of systems used for data quality; develop scripts and data pipelines to automate these tasks.

Minimum Qualifications

Data Analyst Trainee Trainee 1, NS (equivalent to SG-14): four years of experience* in data visualization, and statistical models and data mining tools.

Data Analyst Trainee Trainee 2, NS (equivalent to SG-16): five years of experience* in data visualization, and statistical models and data mining tools.

Data Analyst 1, SG-18: four years of experience* in data visualization, and statistical models and data mining tools and satisfactory completion of a two-year traineeship; OR six years of experience* in data visualization, and statistical models and data mining tools.

*Substitution: An associate's degree may substitute for two years of general experience; or a bachelor's degree may substitute for four years of general experience. A master's degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of general experience; or a Ph.D. in these fields may substitute for two years of general experience.

Additional Comments

• Appointments may also be made at the Data Analyst Trainee levels. Candidates hired at the entry-level title (Data Analyst Trainee 1) may be advanced to the full-performance level (Data Analyst 1) following satisfactory completion of two-years of service.

• Salary range listed below encompasses the hiring rate of a Data Analyst Trainee 1 through the job rate of a Data Analyst 1.

• Data Analyst Trainee 1: $53,764

• Data Analyst Trainee 2: $59,994

• Data Analyst 1: $66,951 - $85,138

• The assignment of PS&T employees will be made in accordance with any agreed upon Memorandum of Understanding between PEF and the local DDSO regarding the posting of job vacancies.

• Preference will be given to OPWDD employees impacted by closures. If you are being impacted by closure, please indicate this on your resume.

• All OPWDD employees must be eligible and maintain eligibility for full and unconditional participation in the Medicare and Medicaid programs. Continued employment will depend on maintaining eligibility.

• If you are employed by state government you may be able to receive loan forgiveness under the Public Service Loan Forgiveness Program (PSLF). The PSLF Program forgives the remaining balance on Direct Loans after 120 qualifying monthly payments have been made under a qualifying repayment plan while working full-time for a qualifying employer. For more information on PSLF, please visit

• Employees on long term leave can bid on positions but must be able to report to work within fourteen (14) days and be able to perform the essential functions of their positions with or without reasonable accommodation (RA).

• If an employee or job applicant believes that they need a reasonable accommodation, they should contact the Reasonable Accommodation Unit at View phone number on click.appcast.io or email View email address on click.appcast.io to obtain information and RA forms.

• Savings programs such as the U.S. Savings Bond and the College Savings Plan.

• Voluntary pre-tax savings programs such as Health Care Spending Account and the Dependent Care Advantage Account offer employees options to pay for uncovered health care expenses or dependent care expenses.

• Access to the Employee Assistance Program (EAP) an assessment and referral service that connects employees with local service providers and support services to address their personal needs.

• Life insurance and Disability insurance.

• The New York State Deferred Compensation Plan is a voluntary retirement plan that offers employees the option to invest a part of their salaries for retirement on a tax-deferred basis.

• Paid Holidays and Leave:

• Thirteen (13) paid holidays each year.
• Thirteen (13) days of paid vacation leave initially.
• Five (5) days paid personal leave each year.
• Thirteen (13) days of paid sick leave each year (PEF/CSEA), which may carry over from year to year.
• Up to three (3) days professional leave each year to participate in professional development events.

• Health Care Coverage:

• Employees and their eligible dependents can choose from a variety of affordable health insurance programs. Employees are provided family dental and vision plans at no extra cost.

• Paid Parental Leave:

• Paid Parental Leave allows eligible employees to take up to 12 weeks of paid leave at full pay for each qualifying event. A qualifying event is defined as the birth of a child or placement of a child for adoption or foster care.

• Retirement Program:

• Participate in The NYS Employees' Retirement System (ERS), which is recognized as one of the best-managed and best-funded public retirement systems in the nation.

• Professional Development and Education and Training:

• NYS offers training programs and tuition assistance to eligible employees to maintain and increase their professional skills and prepare them for promotional opportunities. For more information, please visit

• Additionally, the Public Service Workshops Program (PSWP) offers certain professional training opportunities for PEF represented and M/C designated employees that may grant continuing education credits towards maintaining professional licensure. For more information, please visit

• OPWDD is an Equal Opportunity/Affirmative Action employer dedicated to creating and sustaining a culture of inclusion. We believe that we are most effective in managing and improving our service system with a diverse team of employees. With such a large workforce, we rely on the collective individual differences, life experiences, knowledge, self-expression, ideas and talent that our employees bring to their work. This speaks to our culture and is a key part of our successes. As we continuously recruit people for our team, we welcome the unique contributions that applicants bring in terms of their education, culture, ethnicity, race, sex, gender identity and expression, nation of origin, age, languages spoken, veteran's status, color, religion, disability, sexual orientation and beliefs.

***All people with disabilities are encouraged to apply***