Job Description Summary
The Assessment Administrator is responsible for assisting the Dean for Assessment and Accreditation with evaluations of courses, faculty, academic programs, and student learning by collecting, analyzing, and reporting on various data within the College of Pharmacy.Entity
Medical University of South Carolina (MUSC - Univ)Worker Type
EmployeeWorker Sub-Type
ClassifiedCost Center
CC000948 COP College Of Pharmacy Deans OfficePay Rate Type
SalaryPay Grade
University-TEC05
Pay Range
Scheduled Weekly Hours
40Work Shift
Job Description
Designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Assists in the development and design of database and warehouse applications across multiple platforms and computing environments. Assists in the development of an overall data architecture that supports the information needs of the business in a flexible but secure environment. Responsible for implementing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
Job Responsibilities:
15% - The Database Administrator will design data management systems for the purpose of collecting, reporting and analyzing assessment data for the college. This includes writing codes, functions, queries, and reports, and testing programming for in-house custom Microsoft Access or other databases. Manages security access to databases and ensures appropriate back up of data.
20% - Responsible for the integrity of data and creating mechanisms to validate data. Creates and administers procedures for ensuring accuracy and completeness of data. Responsible for input, transfer or importation of data into data collections system including but not limited to the following data management systems: students, grades, self-assessments, co-curricular, elective course tracking, and Naplex/Pre-Naplex/MPJE/Pre-MJPE/NAPLEX Advantage results.
25% - Design, build, testing, and updating of college’s syllabus database program. Provides technical support to faculty use of the syllabus database. Ensures updated curriculum mapping via maintenance of the syllabus database. Pulls data for the curriculum committee to assist with curricular and course reviews as needed. Imports data into PowerBi for curriculum committee review. Exports data for faculty teaching calculation yearly from syllabus database. Exports data from ExamSoft, Brightspace, and the syllabus database to create course coordinator reports twice a year and distributes to faculty. Pulls data for the curriculum committee to assist with curricular and course reviews as needed. The Assessment Administrator will design and develop data collection systems using REDCap for student satisfaction and other required surveys and conducts end-user training when applicable. Assists faculty and administrators in the creation of projects to house rubrics and other scoring tools for data collection. Creates queries and exports of REDCap data for analysis per special requests. Exports data from COREELMS and creates a report of IPPE and APPE EPA data for the experiential team 3 times a year. Manages annual promotion of students in accordance with academic performance and scholastic standing in the Microsoft Access. Works with the Associate Dean of Student Affairs to accurately maintain the student database and reporting to ACPE and AACP via yearly survey. Maintains and administers AACP faculty, graduating student, and preceptor surveys in the AACP system and pulls and compiles data for review when surveys close. Pulls, tracks, and analyzes data from NABP for NAPLEX and MPJE pass rates throughout the year for review.
10% - Creates/distributes grade sheet and assists faculty with grade calculations. Reports weekly on assessment grades from Brightspace and Examsoft for P1-P3 classes. Uses Brightspace, ExamSoft and COREELMs to track grade assignments. Pulls data from Brightspace, ExamSoft and COREELMs for tracking and reporting.
10% - Serves as the primary administrator for the didactic university evaluation system and manages course and instructor evaluation templates in compliance with MUSC university standards. Provides technical support to students regarding the completion of course and faculty evaluations and to faculty on the process of accessing their reports. Creates semester faculty evaluation schedules for P1-P3 students for approximately 30 courses. Prepares and distributes compliance reports to the Assistant Dean for Assessment and Accreditation.
15% - Serves on the university-wide evaluation committee and College of Pharmacy (COP) Assessment committee. Provides administrative assistance to the COP Assessment committee. Ensures that assessment data required to be publicly reported as outlined in the college’s ACPE accreditation requirements is accurately reported on the College of Pharmacy website and updated in accordance with the guidelines. Serves on and participates in the COP Web Committee. Prepares data for and completes the annual assessment report, including collection of data, development of tables and formatting techniques to report on all key data points. Creates PowerPoint presentation of assessment data for presentation at the annual fall faculty meeting. Assist in pulling data and preparing reports for ACPE accreditation self-study.
5% - Learns new systems as necessary to provide assessment services to the college. Provides support to the Assistant Dean for Assessment and Accreditation on special projects as the need arises.
Must be proficient in Microsoft Access (creating/editing tables, reports, queries, macros, etc.), and have strong skills in all Microsoft Apps, in particular PowerBI and PowerApps.
Additional Job Description
Minimum Requirements: A high school diploma and two years' work experience in systems development and maintenance, technical support, or the support of database management systems. A bachelor's degree in a related field may be substituted for the required experience.
Physical Requirements: (Note: The following descriptions are applicable to this section: Continuous - 6-8 hours per shift; Frequent - 2-6 hours per shift; Infrequent - 0-2 hours per shift) Ability to perform job functions in an upright position. (Frequent) Ability to perform job functions in a seated position. (Frequent) Ability to perform job functions while walking/mobile. (Frequent) Ability to work indoors. (Continuous) Ability to work in confined/cramped spaces. (Infrequent) Ability to bend at the waist. (Frequent) Ability to fully use both hands/arms. (Continuous) Ability to perform repetitive motions with hands/wrists/elbows and shoulders. (Frequent) Ability to reach in all directions. (Frequent) Possess good finger dexterity. (Continuous) Ability to maintain tactile sensory functions. (Continuous) Ability to lift, lower, push or pull objects 15 lbs. or more, unassisted. (Infrequent) Ability to maintain 20/40 vision, corrected. (Continuous) Ability to see and recognize objects close at hand. (Continuous) Ability to see and recognize objects at a distance. (Continuous) Ability to match or discriminate between colors. (Continuous) Ability to determine distance/relationship between objects; depth perception. (Continuous) Good peripheral vision capabilities. (Continuous) Ability to hear and/or understand conversations. (Continuous) Ability to perform gross motor functions with frequent fine motor movements. (Continuous) Ability to work in dusty areas. (Infrequent)
If you like working with energetic enthusiastic individuals, you will enjoy your career with us!
The Medical University of South Carolina is an Equal Opportunity Employer. MUSC does not discriminate on the basis of race, color, religion or belief, age, sex, national origin, gender identity, sexual orientation, disability, protected veteran status, family or parental status, or any other status protected by state laws and/or federal regulations. All qualified applicants are encouraged to apply and will receive consideration for employment based upon applicable qualifications, merit and business need.
Medical University of South Carolina participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here: http://www.uscis.gov/e-verify/employees