Data Analyst 1
for sections like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Use - for any list of duties/requirements/benefits, and
for prose. Do NOT repeat job title as heading. Do NOT put Job ID/requisition numbers as headings. Preserve all substantive info. Remove boilerplate: LinkedIn line, EEO, etc. Also remove application instructions, etc. Include sections only when posting has real specific content.
We need to parse the posting.
Content:
- Duties Description: description of DQI, responsibilities, tasks.
- Minimum Qualifications Preferred Qualifications: list of qualifications.
- Additional Comments: includes salary range, benefits, etc.
We need to separate sections: maybe "About the role" (description of division and role), "Responsibilities" (list of duties), "Qualifications" (minimum/preferred), "Skills" (maybe list of skills), "Benefits", "Pay". Schedule not present.
We must not create sections with filler.
Let's extract substantive info.
First paragraph: "The Division of Quality Improvement (DQI) is responsible for developing and implementing key components of OPWDD's mission. A central objective of DQI is to integrate and promote quality improvement practices across the service system to enhance the quality of support and outcomes for the people we serve. The incumbent will serve as a core member of the DQI Data Analysis and Evaluation Unit (DAEU), supporting expanding data analysis and reporting needs and assisting with new federal requirements. DQI is responsible for overseeing implementation of the federal Access Rule quality measure set issued by the Centers for Medicare & Medicaid Services (CMS). The incumbent will contribute to analyses and reporting related to critical incidents and the Incident Report and Management Application (IRMA), including tasks required under the Access Rule. This position will be essential to many data analysis functions and initiatives central to DQI."
That's about the role.
Then "The incumbent will be expected to:" followed by list of duties:
- Perform structured data analysis using quantitative, statistical, and operational methodologies.
- Extract, clean, merge, and prepare datasets from OPWDD, Medicaid, and other enterprise systems using SQL, SAS, and similar tools.
- Develop analytic outputs including frequencies, trends, quality indicators, and operational metrics.
- Develop visualizations, summaries, dashboards, and reports in both paper and presentation formats.
- Support data-driven decision-making through clear, reliable, and audit-ready reporting.
- Support implementation of CMS Access Rule quality requirements through data preparation, metric development, validation, and reporting.
- Assist with IRMA federal reporting changes required under the Access Rule.
- Identify potential unreported critical incidents using Medicaid data and structured analytic methods.
- Trend statewide incident data in collaboration with SCIR to support prevention of harm, abuse, and neglect.
- Coordinate with DSM and partner agencies to align data structures, integrate data sources, and support enterprise data strategy.
- Use SQL, SAS, Tableau, and other analytic tools to meet reporting and data processing needs.
- Apply Medicaid data knowledge when working on incident-related analytics and Access Rule requirements.
- Support development and maintenance of standardized definitions and methodologies for key DQI measures and analytic products.
That's responsibilities.
Then "LinkedIn: ..." we drop.
Then "Minimum Qualifications Preferred Qualifications:" Actually the text: "Minimum Qualifications Preferred Qualifications: Strong statistical and data management skills. Proficient in the use of data visualization tools such as Tableau and Power BI. Experience with SAS, SQL, Microsoft Excel, Word, and Power Point. Experience extracting, merging, and linking health care datasets, including Medicaid data, for the application of data visualization and advanced statistical analysis. Knowledge of statistical methods and their application for predictive analytics. Excellent communication and organizational skills. The ability to work independently, as well as in a team environment."
Then after that: "Data Analyst Trainee 1, NS (equivalent to SG-14): four years of experience* in data visualization, and statistical models and data mining tools. Data Analyst 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."
That's qualifications.
Then "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: $56,183 Data Analyst Trainee 2: $62,694 Data Analyst 1: $69,964 - $88,970 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. ... ***All people with disabilities are encouraged to apply***"
We need to remove boilerplate: EEO, equal opportunity, scam warning, etc. Also remove LinkedIn line. Also remove application instructions? There's none explicit. Remove the parts about "Preference will be given to OPWDD employees impacted by closures..." maybe that's not boilerplate but specific? It's a preference statement; might be considered part of posting but could be considered administrative. The instruction says remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The preference for impacted employees might be considered not boilerplate but maybe still part of posting; but it's a specific condition. I'd keep it? It's not EEO; it's a preference. Might be okay to keep. However the instruction says remove application instructions. That part about indicating closure on resume is an application instruction. So we should remove that sentence. Also the sentence about contacting Reasonable Accommodation Unit is also an instruction; remove. Also the sentence about PSLF link maybe considered info but could be kept as benefit? It's a program info; could be considered benefit. Might keep as part of Benefits.
We need to keep substantive info: salary range, benefits (holidays, leave, health care, parental leave, retirement, professional development, deferred compensation, savings programs, EAP, life/disability insurance). Also maybe note about appointments at trainee levels and advancement.
We need to output sections: About the role (maybe
About the role
with paragraph). Responsibilities (Responsibilities
with - ...). Qualifications (
Qualifications
with maybe - ...). Skills (
Skills
maybe list of tools). Benefits (Benefits
with list). Pay (Pay
with paragraph). Schedule not present, so omit.
We must not create sections with filler. Ensure we have real content.
Let's extract qualifications content: The "Minimum Qualifications Preferred Qualifications:" block includes skills: Strong statistical and data management skills. Proficient in data visualization tools such as Tableau and Power BI. Experience with SAS, SQL, Microsoft Excel, Word, and Power Point. Experience extracting, merging, and linking health care datasets, including Medicaid data, for the application of data visualization and advanced statistical analysis. Knowledge of statistical methods and their application for predictive analytics. Excellent communication and organizational skills. Ability to work independently, as well as in a team environment.
Then the specific experience requirements for titles: Data Analyst Trainee 1: four years of experience* in data visualization, and statistical models and data mining tools. Data Analyst Trainee 2: five years... Data Analyst 1: four years... plus two-year traineeship OR six years... Substitution: associate’s degree may substitute for two years of general experience;
for prose. Do NOT repeat job title as heading. Do NOT put Job ID/requisition numbers as headings. Preserve all substantive info. Remove boilerplate: LinkedIn line, EEO, etc. Also remove application instructions, etc. Include sections only when posting has real specific content. We need to parse the posting. Content: - Duties Description: description of DQI, responsibilities, tasks. - Minimum Qualifications Preferred Qualifications: list of qualifications. - Additional Comments: includes salary range, benefits, etc. We need to separate sections: maybe "About the role" (description of division and role), "Responsibilities" (list of duties), "Qualifications" (minimum/preferred), "Skills" (maybe list of skills), "Benefits", "Pay". Schedule not present. We must not create sections with filler. Let's extract substantive info. First paragraph: "The Division of Quality Improvement (DQI) is responsible for developing and implementing key components of OPWDD's mission. A central objective of DQI is to integrate and promote quality improvement practices across the service system to enhance the quality of support and outcomes for the people we serve. The incumbent will serve as a core member of the DQI Data Analysis and Evaluation Unit (DAEU), supporting expanding data analysis and reporting needs and assisting with new federal requirements. DQI is responsible for overseeing implementation of the federal Access Rule quality measure set issued by the Centers for Medicare & Medicaid Services (CMS). The incumbent will contribute to analyses and reporting related to critical incidents and the Incident Report and Management Application (IRMA), including tasks required under the Access Rule. This position will be essential to many data analysis functions and initiatives central to DQI." That's about the role. Then "The incumbent will be expected to:" followed by list of duties: - Perform structured data analysis using quantitative, statistical, and operational methodologies. - Extract, clean, merge, and prepare datasets from OPWDD, Medicaid, and other enterprise systems using SQL, SAS, and similar tools. - Develop analytic outputs including frequencies, trends, quality indicators, and operational metrics. - Develop visualizations, summaries, dashboards, and reports in both paper and presentation formats. - Support data-driven decision-making through clear, reliable, and audit-ready reporting. - Support implementation of CMS Access Rule quality requirements through data preparation, metric development, validation, and reporting. - Assist with IRMA federal reporting changes required under the Access Rule. - Identify potential unreported critical incidents using Medicaid data and structured analytic methods. - Trend statewide incident data in collaboration with SCIR to support prevention of harm, abuse, and neglect. - Coordinate with DSM and partner agencies to align data structures, integrate data sources, and support enterprise data strategy. - Use SQL, SAS, Tableau, and other analytic tools to meet reporting and data processing needs. - Apply Medicaid data knowledge when working on incident-related analytics and Access Rule requirements. - Support development and maintenance of standardized definitions and methodologies for key DQI measures and analytic products. That's responsibilities. Then "LinkedIn: ..." we drop. Then "Minimum Qualifications Preferred Qualifications:" Actually the text: "Minimum Qualifications Preferred Qualifications: Strong statistical and data management skills. Proficient in the use of data visualization tools such as Tableau and Power BI. Experience with SAS, SQL, Microsoft Excel, Word, and Power Point. Experience extracting, merging, and linking health care datasets, including Medicaid data, for the application of data visualization and advanced statistical analysis. Knowledge of statistical methods and their application for predictive analytics. Excellent communication and organizational skills. The ability to work independently, as well as in a team environment." Then after that: "Data Analyst Trainee 1, NS (equivalent to SG-14): four years of experience* in data visualization, and statistical models and data mining tools. Data Analyst 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." That's qualifications. Then "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: $56,183 Data Analyst Trainee 2: $62,694 Data Analyst 1: $69,964 - $88,970 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. ... ***All people with disabilities are encouraged to apply***" We need to remove boilerplate: EEO, equal opportunity, scam warning, etc. Also remove LinkedIn line. Also remove application instructions? There's none explicit. Remove the parts about "Preference will be given to OPWDD employees impacted by closures..." maybe that's not boilerplate but specific? It's a preference statement; might be considered part of posting but could be considered administrative. The instruction says remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The preference for impacted employees might be considered not boilerplate but maybe still part of posting; but it's a specific condition. I'd keep it? It's not EEO; it's a preference. Might be okay to keep. However the instruction says remove application instructions. That part about indicating closure on resume is an application instruction. So we should remove that sentence. Also the sentence about contacting Reasonable Accommodation Unit is also an instruction; remove. Also the sentence about PSLF link maybe considered info but could be kept as benefit? It's a program info; could be considered benefit. Might keep as part of Benefits. We need to keep substantive info: salary range, benefits (holidays, leave, health care, parental leave, retirement, professional development, deferred compensation, savings programs, EAP, life/disability insurance). Also maybe note about appointments at trainee levels and advancement. We need to output sections: About the role (maybe
About the role
with paragraph). Responsibilities (Responsibilities
with- ...). Qualifications (
Qualifications
with maybe- ...). Skills (
Skills
maybe list of tools). Benefits (Benefits
with list). Pay (Pay
with paragraph). Schedule not present, so omit. We must not create sections with filler. Ensure we have real content. Let's extract qualifications content: The "Minimum Qualifications Preferred Qualifications:" block includes skills: Strong statistical and data management skills. Proficient in data visualization tools such as Tableau and Power BI. Experience with SAS, SQL, Microsoft Excel, Word, and Power Point. Experience extracting, merging, and linking health care datasets, including Medicaid data, for the application of data visualization and advanced statistical analysis. Knowledge of statistical methods and their application for predictive analytics. Excellent communication and organizational skills. Ability to work independently, as well as in a team environment. Then the specific experience requirements for titles: Data Analyst Trainee 1: four years of experience* in data visualization, and statistical models and data mining tools. Data Analyst Trainee 2: five years... Data Analyst 1: four years... plus two-year traineeship OR six years... Substitution: associate’s degree may substitute for two years of general experience;
- ...). Skills (