Duties Description

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 and draft technical requirements and data definitions for new data models and data pipelines from ingestion to consumption in several large data systems.
Perform processes handling the download, cleaning, and structuring of data.
Program scalable and efficient data pipelines for several large data systems in programming languages including SAS, Python, or SQL.
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 1, NS (equivalent to SG-14): A bachelor's or higher degree.

Data Analyst Trainee 2, NS (equivalent to SG-16): A bachelor's or higher degree AND one year of experience* in data visualization, and statistical models and data mining tools.

Data Analyst 1, SG-18: bachelor’s degree and either: satisfactory completion of a two-year traineeship or two years of experience* in data visualization, and statistical models and data mining tools.

Substitution: A master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for one year of the specialized experience. A Ph.D. in the above fields may substitute for two years of the specialized experience.

Additional Comments

The position may be filled at the Data Analyst Trainee 1 level equated to SG-14 ($53,764), Data Analyst Trainee 2 level equated to SG-16 ($59,994) or full performance Data Analyst 1 SG-18 ($66,951) based on education and experience. Candidates hired at the trainee level will be advanced to the full performance Data Analyst 1, SG-18 following successful completion of the traineeship.
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 www.studentAid.gov/publicservice.
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 (518) 486-7222 or email accommodationrequests@opwdd.ny.gov 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 https://oer.ny.gov/training-and-professional-development.

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 https://oer.ny.gov/public-service-workshops-program-pswp.
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.

NYS Office for People With Developmental Disabilities

New Jobs

Data Analyst 1