Trainee Sas Sql Jobs (NOW HIRING)

Duties Description 1. Perform data extraction and aggregation from various sources and tables. 2.

Compile, analyze, mine, parse and cleanse data related to agency processes, NYS, or national education, and/or higher education spending, trends, and outcomes. 3. Assist with analyzing and monitoring grants and scholarships spending and trends.

4. Review data for quality assurance. 5.

Identify trends in data and identify risks in programs based on these trends. 6. Devise methods for identifying data patterns and trends in data sources; assess data structures and how they can be used to produce desired reports.

7. Perform quantitative and/or qualitative data collection. 8.

Contribute to the development of dashboards, reports, and publications. 9. Summarize results, interpret data, and communicate results.

10. Compile other ad-hoc data analysis based on current needs and executive management priorities. 11.

Perform other duties as assigned. Minimum Qualifications MINIMUM QUALIFICATIONS: Non-Competitive Appointment to Data Analyst 1: Six years of experience in data visualization, and statistical models and data mining tools. Non-Competitive Appointment to Data Analyst Trainee 2: Five years of experience in data visualization, and statistical models and data mining tools.

Non-Competitive Appointment to Data Analyst Trainee 1: Four years of experience in data visualization, and statistical models and data mining tools. Substitution: An associate's degree may substitute for two years of specialized experience; or a bachelor's degree may substitute for four years of specialized experience; a master's degree in data or computer science, informatics, economics, statistics, mathematics, or a related field, may substitute for five years of specialized experience; a J.D may substitute for six years of specialized experience. Preference may be given to candidates who have: Qualifying experience is preferred when performed in a school, school district, BOCES, education oversight agency, educational institution, education research institution, or other related research institution

It is essential that candidates clearly and concisely indicate exactly how they meet the above minimum qualifications in their resume. Failure to show how you meet the minimum qualifications above may result in disqualification and removal from consideration. PREFERRED QUALIFICATIONS: Strong quantitative skills, including proficiency with Microsoft Excel, Word, and Power Point.

Some experience with SAS, SQL, R or Tableau is desired, but not necessary. Strong communication skills and ability to maintain relationships across a diverse set of stakeholders. Experience working with large datasets, confidential data, and relational databases.

Experience preparing analytical reports, data visualizations via excel pivots or Tableau. Additional Comments NYS is an equal opportunity employer. Benefits of Working for NYS Generous benefits package, worth 65% of salary, including: Holiday & Paid Time Off Thirteen (13) paid holidays annually, plus two (2) floating holidays Up to Thirteen (13) days of paid vacation leave annually Up to Five (5) days of paid personal leave annually Up to Thirteen (13) days of paid sick leave annually for CSEA or PEF; up to eight (8) days of paid sick leave annually for M/C Up to three (3) days of professional leave annually to participate in professional development Initially positions will work full-time in the office and a hybrid telecommuting schedule of up to 50% remote work can be discussed with the hiring manager during the interview .

Health Care Benefits Eligible employees and dependents can pick from a variety of affordable health insurance programs Family dental and vision benefits at no additional cost Additional Benefits New York State Employees' Retirement System (ERS) Membership NYS Deferred Compensation Access to NY 529 and NY ABLE College Savings Programs, as well as U.S. Savings Bonds Public Service Loan Forgiveness (PSLF) And many more. METHOD OF APPLICATION: RESUME, to apply, please submit a clear, concise cover letter and resume, to: resumes@hesc.ny.gov indicating that you are applying for the position of Data Analyst 1 by the deadline listed on the vacancy

Please clearly indicate how you meet the minimum qualifications for this position. Some positions may require additional credentials or a background check to verify your identity.