What are the responsibilities and job description for the Associate for Institutional Research (SQL Programmer) position at Lensa?
Lensa partners with DirectEmployers to promote this job for New York State Civil Service.
NY HELP No
Agency SUNY System Administration
Title Associate for Institutional Research (SQL Programmer)
Occupational Category I.T. Engineering, Sciences
Salary Grade NS
Bargaining Unit PSNU - Professional Services Negotiating Unit (UUP)
Salary Range From $80000 to $95000 Annually
Employment Type Full-Time
Appointment Type Permanent
Jurisdictional Class Unclassified Service
Travel Percentage 0%
Workweek Mon-Fri
Hours Per Week 40
Workday
From 8 AM
To 5 PM
Flextime allowed? No
Mandatory overtime? No
Compressed workweek allowed? No
Telecommuting allowed? No
County Albany
Street Address 353 Broadway
City Albany
State NY
Zip Code 12246
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 toolsGeneral 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.
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 - 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.
Name Human Resources
Telephone
Fax 518-320-1565
Email Address hr@sysadm.suny.edu
Address
Street 353 Broadway
City Albany
State NY
Zip Code 12246
Notes on Applying Please apply at this link: http://sunysystem.interviewexchange.com/jobofferdetails.jsp?JOBID=186398
If you have questions about this posting, please contact support@lensa.com
NY HELP No
Agency SUNY System Administration
Title Associate for Institutional Research (SQL Programmer)
Occupational Category I.T. Engineering, Sciences
Salary Grade NS
Bargaining Unit PSNU - Professional Services Negotiating Unit (UUP)
Salary Range From $80000 to $95000 Annually
Employment Type Full-Time
Appointment Type Permanent
Jurisdictional Class Unclassified Service
Travel Percentage 0%
Workweek Mon-Fri
Hours Per Week 40
Workday
From 8 AM
To 5 PM
Flextime allowed? No
Mandatory overtime? No
Compressed workweek allowed? No
Telecommuting allowed? No
County Albany
Street Address 353 Broadway
City Albany
State NY
Zip Code 12246
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 toolsGeneral 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.
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 - 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.
Name Human Resources
Telephone
Fax 518-320-1565
Email Address hr@sysadm.suny.edu
Address
Street 353 Broadway
City Albany
State NY
Zip Code 12246
Notes on Applying Please apply at this link: http://sunysystem.interviewexchange.com/jobofferdetails.jsp?JOBID=186398
If you have questions about this posting, please contact support@lensa.com
Salary : $80,000 - $95,000
