IT Business Systems Analyst - Institutional Research

The primary purpose of this position is to collaborate with the Manager of Data Collection and Reporting in extracting and analyzing data from databases, especially the Banner Student/HR system. This position is instrumental in the creation and submission of files and reports to UNC-General Administration, This position uses a variety of tools to extract and compile reports such as SAS, SQL, EXcel and UltraEdit. Additionally, this position assists the Manager of Data Collection and Reporting in the coordination and oversight of office projects and responsibilities, creates the university college portrait, and acts as the office liaison for facilities and faculty workload data. The person in this position acts as office manager in the absence of both the Director for Institutional Research and the Manager of Data Collection and Reporting.

The overall duties of this position entail data collection, analysis, reporting that support decision-making. Under this general job function, the position specifically is responsible for:
• Lead Student Data Mart Collection and Submissions (30%). The person in this position is a key member of Student Data Mart team, HR Data Mart team and GA Dave Facilities team;
• Lead SQL/SAS Programming (20%). The person will write SQL queries to extract, gather and combine live data from Banner and to document data using the best practice and methodologies. S/he will work with large complex data sets, merge current with historical records, and develop programming logic that can be deployed and repeated to extract, translate, and load data into various systems;
• Maintenance, integrity and visualization of institutional data (30%). The person in this position requires integrating data from various sources to maintain a coherent system using institutional knowledge and information. S/he will work with other staff to respond major surveys and ad hoc requests, as well as visualize reporting (e.g., Fact Books) using Tableau or other tools.
• Other duties as assigned (not limit to) (20%). The position represents IR on various campus committees and serves as the key person in Banner Data Standard Committee.Miinimum Training and Experience Requirements:

Bachelor's degree in Computer Science, Computer Information Systems, Statistics, or related technical degree from an appropriately accredited institution; 2-3 years of experience in Institutional Research or business application consulting and development.

Preferred qualifications:
• Knowledge of and experience with Banner student data system, including the use of forms and creation of views.
• Master's degree in a technical discipline such as computer science, information technology, or management information systems; or a master's degree in a non-technical field with two or more years of relevant work experience.

Special Instructions to Applicants:

This position is subject to the successful completion of an employment background check. An employment background check includes a criminal background check, employment verification, reference checks, license verification (if applicable) and credit history check (if applicable).

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire.

New employees are paid only by direct deposit to the financial institution of their choice. Candidates claiming Veterans Preference must attach a copy of their DD-214 as a part of the online application process.

Per the requirements of the Clery Act of 1998, the Campus Security Report can be found at:

UNC Pembroke is an Equal Opportunity Employer. The University prohibits discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities, and prohibits discrimination against all individuals based on their age, race, color, genetic information, religion, sex, sexual orientation, gender identity or national origin. UNC Pembroke is a VEVRAA Federal Contractor and seeks priority referrals of protected veterans for our openings.


Similar jobs

Similar jobs