UNIV - Database Administrator I - College of Pharmacy

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.
Responsibilities include the design, implementation, and maintenance of databases and other technologies used in the collection, management, and reporting of data.

Entity

Medical University of South Carolina (MUSC - Univ)

Worker Type

Employee

Worker Sub-Type​

Classified

Cost Center

CC000948 COP College Of Pharmacy Deans Office

Pay Rate Type

Salary

Pay Grade

University-TEC05

Pay Range

57,700.00 - 80,800.00 - 103,900.000

Scheduled Weekly Hours

40

Work 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 a