Data Analyst 2

State of New York - People With Developmental Disabilities, Office for; City of Schenectady (NY); On-site; USD 91,000 - 115,000; Full time

Benefits offered by this job

Thirteen paid holidays annually

Paid vacation leave

Paid personal leave

Job summary

State of New York - OPWDD is seeking a Data Analyst 2 to support the Data Integration and Governance Team in Schenectady. This onsite role focuses on building governance-focused data assets, standardizing governance practices, and reporting on governance activities.

You will conduct analyses, validate data, and support data modernization documentation and testing efforts, collaborating with NYS IT Services and stakeholders to improve data quality and governance processes.

Qualifications

• Seven years of experience in data visualization, statistical models, and data mining tools.
• Strong analytic and data management skills, including dataset and code documentation.
• Knowledge of data governance frameworks, data life cycle management, data architecture components, data warehousing principles, and ETL pipelines.
• Experience working with large relational health care datasets.
• Proficiency in SAS or SQL, Microsoft Excel, Word, and Power Point.
• Excellent communication and organizational skills, including translating technical concepts to non-technical stakeholders.
• Strong problem-solving skills and the ability to work independently and in a team environment.

Responsibilities

• Contribute to the creation of data assets supporting OPWDD needs.
• Support standardization of data governance across OPWDD.
• Document, implement, and promote data governance policies and best practices within the agency.
• Collaborate on projects with NYS Information Technology Services and other stakeholders.
• Compile reports on data governance activities, including data quality assessments and compliance checks.
• Participate in ongoing efforts to improve governance practices, understand agency data needs, and enhance overall data quality.
• Contribute to documentation and testing of OPWDD data modernization efforts.
• Help develop and maintain data dictionaries, business glossaries, metadata, data standards, and data lineage documentation.
• Conduct data validation and quality checks, identify anomalies, and work with staff to resolve issues.
• Design and execute analyses using approaches such as tabulations, visualizations, predictive and retrospective analysis, and statistical models.
• Write clear and concise results summaries for policy, clinical, and technical audiences.
• Assist in integrating data from multiple sources, including data warehouses, billing systems, and eligibility systems.
• Perform other duties and special projects as required.

Skills

Analytical skills

Data management

Communication

Teamwork

Independent work

Problem solving

Data governance

Tools

SAS

SQL

Excel

Word

PowerPoint

Job description

The State of New York, Office for People With Developmental Disabilities (OPWDD), Office for People With Developmental Disabilities, is hiring a Data Analyst 2 to support the Data Integration and Governance Team. In this onsite role in Schenectady, NY, you will help produce reliable data products that align with policy and decision making, while strengthening data governance and data quality across the agency.

Role overview

This position focuses on building and supporting governance-focused data assets, standardizing governance practices, and reporting on governance activities. You will also conduct analyses and validation work to answer business and operational questions, identify anomalies, and support OPWDD’s data modernization documentation and testing efforts.

Responsibilities

• Contribute to the creation of data assets supporting OPWDD needs.
• Support standardization of data governance across OPWDD.
• Document, implement, and promote data governance policies and best practices within the agency.
• Collaborate on projects with NYS Information Technology Services and other stakeholders.
• Compile reports on data governance activities, including data quality assessments and compliance checks.
• Participate in ongoing efforts to improve governance practices, understand agency data needs, and enhance overall data quality.
• Contribute to documentation and testing of OPWDD data modernization efforts.
• Help develop and maintain data dictionaries, business glossaries, metadata, data standards, and data lineage documentation.
• Conduct data validation and quality checks, identify anomalies, and work with staff to resolve issues.
• Design and execute analyses using approaches such as tabulations, visualizations, predictive and retrospective analysis, and statistical models.
• Write clear and concise results summaries for policy, clinical, and technical audiences.
• Assist in integrating data from multiple sources, including data warehouses, billing systems, and eligibility systems.
• Perform other duties and special projects as required.

Requirements

• Seven years of experience in data visualization, statistical models, and data mining tools.
• Strong analytic and data management skills, including dataset and code documentation.
• Knowledge of data governance frameworks, data life cycle management, data architecture components, data warehousing principles, and ETL pipelines.
• Experience working with large relational health care datasets.
• Proficiency in SAS or SQL, Microsoft Excel, Word, and Power Point.
• Excellent communication and organizational skills, including translating technical concepts to non-technical stakeholders.
• Strong problem-solving skills and the ability to work independently and in a team environment.

Technologies

• SAS
• SQL
• Microsoft Excel
• Word
• Power Point

Compensation and location

• Location: Schenectady, NY (onsite)
• Salary: USD 90,582 - 114,585 per year

Benefits

• 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 for professional development events.
• Affordable health insurance programs for employees and eligible dependents.
• Family dental and vision plans provided at no extra cost.
• Paid Parental Leave for eligible employees to take up to 12 weeks of paid leave at full pay for each qualifying event.
• Participation in The NYS Employees’ Retirement System (ERS).
• NYS training programs and tuition assistance for eligible employees.
• Public Service Workshops Program (PSWP) professional training opportunities for certain employees that may provide continuing education credits toward maintaining licensure.
• Savings programs including 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.
• Employee Assistance Program (EAP) access.
• Life insurance and Disability insurance.
• The New York State Deferred Compensation Plan (voluntary).

Substitution options

• 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

• PS&T employee assignment follows any agreed Memorandum of Understanding between PEF and the local DDSO regarding posting job vacancies.
• Preference is given to OPWDD employees impacted by closures.
• All OPWDD employees must be eligible and maintain eligibility for full and unconditional participation in the Medicare and Medicaid programs.
• State government employees may be able to receive loan forgiveness under the Public Service Loan Forgiveness Program (PSLF).
• Employees on long term leave may bid on positions but must be able to report to work within fourteen (14) days and perform essential functions with or without reasonable accommodation (RA).
• For reasonable accommodation, contact the Reasonable Accommodation Unit at [phone] or email [e-mail] to obtain information and RA forms.