Associate for Institutional Research (SQL Programmer) Position Available In Albany, New York

Basics Schedule Location Job Specifics How to Apply Indicates whether if this vacancy posting is part of the

NY HELPS

Program. NY HELP No The agency in which the vacancy exists. Agency SUNY System Administration The job title for the vacancy. Title Associate for Institutional Research (SQL Programmer) The job title for the vacancy. Occupational Category I.T. Engineering, Sciences The salary grade for this vacancy. Salaries are determined by salary grade and bargaining unit. Salary Grade NS The collective bargaining unit to which this vacancy is assigned. Bargaining Unit PSNU

• Professional Services Negotiating Unit (UUP) The minimum and maximum of the salary range for this vacancy.

Salary Range From $80000 to $95000 Annually Indicates whether this job is full-time or part-time. If the job is part-time, an estimated percentage will be provided. Employment Type Full-Time This indicates the type of job, typically permanent, temporary, or provisional. ‘Provisional’ means that the appointment will be temporary until the incumbent takes and passes an appropriate civil service examination. Appointment Type Permanent Jurisdictional class is the indicator for how this job can be filled. The classified service is governed by the Civil Service Commission, and consists of competitive, non-competitive, exempt, and labor classes. ‘Competitive class’ indicates that the applicant must take and pass an appropriate civil service examination. ‘Non-competitive class’ indicates that the applicant’s qualifications will be evaluated without a civil service examination. ‘Exempt class’ indicates that the applicant will be evaluated by methods other than competitive or non-competitive, and that incumbents will not be granted tenure. ‘Labor class’ requires that applicants possess skills or other physical characteristics that cannot effectively be evaluated by other means. The unclassified service is legislatively defined, and includes such positions as elected officials, department and agency heads, and all academic personnel in public schools, colleges, and universities. Jurisdictional Class Unclassified Service Estimates the percentage of time incumbents of this vacancy will be required to travel. Travel Percentage 0% This provides information on the expected workweek. Workweek Mon-Fri The number of hours in the workweek, typically 37.5 or 40 for full time, or any other number for part time. Hours Per Week 40 Workday The start time for this vacancy. If the agency employs flextime, this will be the earliest time this vacancy’s shift can start. From 8 AM The end time for this vacancy. If the agency employs flextime, this will be the latest time this vacancy’s shift can end. To 5 PM If checked, the agency allows flextime. Flextime allowed? No If checked, this vacancy includes mandatory overtime. Mandatory overtime? No If checked, this agency allows compressed workweek scheduling. Compressed workweek allowed? No If checked, this agency allows telecommuting for this position. Telecommuting allowed? No The county in which the vacancy is located. County Albany The street address where the vacancy is located. Street Address 353 Broadway The city where the vacancy is located. City Albany The state where the vacancy is located (the default is New York). State NY The zip code where the vacancy is located. Zip Code 12246 The duties that the incumbent of the vacancy will be expected to perform. Duties Description The individual holding this position will have strong computer programming skills necessary to perform a key role in the office’s advanced data manipulation and integration sub-unit. The individual will join the office well-prepared to regularly work with millions of records at the broad system and sector levels as well as the campus level to produce both insightful snapshot and longitudinal reports. The individual will come with effective technical and programming skills and will have interest in learning new skills. The individual will be curious, resourceful, and self-motivated.

Data Specific:

• Extract, clean, combine, and analyze data from various sources using advanced SQL scripting and programming techniques.
• Collaborate with cross-functional teams to identify data needs and develop solutions to meet business objectives.
• With a high degree of accuracy and efficiency, collect routine and/or ad hoc data/information from campuses and other SUNY System Administration functional area offices, review the data/information for potential issues, and consolidate the data/information into reports.
• Develop and implement data queries, programming, and management to support decision-making processes.
• Create and maintain documentation of data processes and findings.
• Track and investigate system errors and failures, determine root-cause, and coordinate response.
• Stay abreast of changes in IPEDS and NYSED reporting requirements, adjusting data definitions, code, and procedures to meet new mandates.
• Stay updated on best practices and emerging technologies in data programming and reporting tools

General Office:

• Review detailed campus data submissions and assist in their finalization as needed to ensure a solid data foundation for the office’s work.
• Work closely with SUNY campus counterparts and associates from other SUNY System Administration offices.
• Assist in responding to internal and external, formal and informal, scheduled and ad hoc data requests for information, data, and reports.
• Support the office’s reporting of NYSED and IPEDS surveys, serving as survey project manager as needed. The minimum qualifications required for this vacancy. Minimum Qualifications Required Qualifications
• Bachelor’s degree in data science, computer science, statistics, or a related field.
• Proven experience in complex data programming, with a minimum of three (3) years of experience working with complicated, large-scale data sets, particularly within the higher education context.
• Expertise in SQL and proficiency in other programming languages to manipulate, integrate, and analyze large data sets with complex structures.
• Demonstrated experience working with data definitions, data dictionaries, and data standards.
• Strong attention to detail. Ability to spot errors and inconsistencies in programming code, spreadsheets, reports, and graphics.
• Interpersonal and communication skills necessary to establish and maintain effective working relationships with other System and campus administrators and staff.
• Demonstrated ability to complete assignments in a timely manner with a high degree of accuracy.
• Demonstrated ability to work both independently with minimal supervision and collaboratively as part of a team.
• Strong organizational and follow-through skills to develop and execute work plans, prioritize work, manage multiple projects, and meet program demands and deadlines.

Preferred Qualifications:

• At least five (5) years of experience working in higher education.
• Experience developing databases, in particular large-scale and from multiple data sources.
• Experience analyzing, querying, manipulating, and extracting data from large databases using SQL in an applied research or educational setting.
• Familiarity with matching data sets and manipulating large amounts of data from multiple sources.
• Demonstrated efficiency with advanced features in Excel, including but not limited to pivot tables, macros, and functions.
• Demonstrated ability to visually and graphically present data and information in a clean and informative manner. Additional comments regarding the vacancy. Additional Comments
• Salary is dependent on a variety of factors, including but not limited to, experience, education, training, and certifications. The range for this position is $80,000
• 95,000.

• State Title:

  Associate for Institutional Research (SL-4)

• Applicants must be currently authorized to work in the United States on a full-time basis. VISA sponsorship is not available for this position.
• This is a full-time hybrid position that requires being on-site in Albany 50% (alternating 3 days one week, 2 days the next)
• Will be required to attend university initiative meetings and attend job related conferences and/or trainings as needed.
• Excellent Benefit Package which includes: NYS health insurance, free dental and vision coverage, competitive retirement options, tuition assistance, parental leave at full pay, and generous vacation, sick, and holiday time.

Generous amount of time off:

13 days of paid holidays per year; 15 days of vacation and 15 days of sick time accrued for the first year of employment. Then increases thereafter. Please see our UUP benefits summary for additional information: https://www.suny.edu/media/suny/content-assets/documents/benefits/benefit-summaries/UUP-FT-Benefits-at-a-Glance.pdf Some positions may require additional credentials or a background check to verify your identity. The name of the contact person for this vacancy. Name Human Resources The telephone number to use for questions about this vacancy. Telephone The fax to use for this vacancy. Fax 518-320-1565 Email address for emailing applications, or to ask questions about this vacancy. Email Address hr@sysadm.suny.edu Address The street address of the contact for this vacancy. Street 353 Broadway The city for the contact for this vacancy. City Albany The state of the contact for this vacancy (the default is New York). State NY The zip code for the contact for this vacancy. Zip Code 12246 Instructions for potential applicants. Notes on Applying Please apply at this link: http://sunysystem.interviewexchange.com/jobofferdetails.jsp?

JOBID=186398