Job Title: Data Analyst at Excelsior College
Department: Center for Educational Measurement Salary Level: 5
FLSA Status: Exempt
Prepared Date: May 1, 2014
The Data Analyst has responsibility for performing diversified functions that require the ability to learn and apply established policies and procedures as well as create new ones. Conduct activities that support psychometric, test administration and test development functions. Organize and prioritize various projects simultaneously and ensure that all work is accurately completed within prescribed deadlines. Conduct basic research activities and statistical and psychometric analyses. This position requires the ability to accurately attend to detail, strong organizational skills, the ability to work independently and as a team member, proficient use of computer based applications, the ability to utilize initiative and excellent written and organizational skills. This position necessitates professional, responsible, and mature behavior required to work with extremely secure and confidential information. The Data Analyst position reports to the Director of Psychometrics.
ESSENTIAL DUTIES AND RESPONSIBILITIES
includes the following:
The responsibilities of the Data Analyst include, but are not limited to the following:
Conduct the scoring of extended response examinations in Excelsior College’s student information system (SIS)
Run classical item analysis and prepare reports
Conduct and manage score testing activities using in Excelsior College’s student information system (SIS). Investigate and resolve problems encountered
Retrieve data from Excelsior College’s student information system into access database tables or flat files
Add exam form information to Excelsior College’s student information system (SIS)
Run and modify Discoverer Reports
Update grade distribution reports for multiple choice and extended response exams
Reconcile monthly expense accounts
Prepare all material and make arrangements for standard setting meetings
Setup standard setting database and create reports as needed
Run item analyses for over 50 examinations and coordinate the production of the Excelsior College and UExcel examinations Technical Handbook for publication
Prepare data files(formatting and cleaning)
Collaborate in the creation of item selection spreadsheets and in the form building process as needed
Run other psychometric and statistical analyses as needed (using basic statistics)
Use SPSS, Excel, and Access software to generate meaningful reports, graphs, and tables of data
Document and update processes and organize and files and directories
Conduct analyses to support research activities
Other tasks to assist the psychometric group as needed
To perform successfully in this position, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Knowledge of SPSS
An affinity for data and numbers
Familiarity with basic research methodology and statistical or psychometric analysis
Display high degree of accuracy and excellent attention to detail when working with data
Demonstrate high degree of organizational skills and productive time management
Proficiency in the utilization of databases (running queries), spreadsheets, and word processing applications such as Access and Excel
Professional commitment to responsibly secure and maintain confidential information
Excellent written, oral, and interpersonal communication skills
Ability to provide quality assistance to staff
Ability to work both independently and within a team environment
Availability to work flexible hours as needed
Education and/or Experience
The requirements for the position of Data Analyst are a Bachelors degree in statistics, mathematics, or related quantitative field, with 2 to 3 years of related experience.
Other Skills and Abilities
The successful candidate will also demonstrate the ability to work and communicate effectively with a diverse constituency in a non-judgmental manner, with good humor, and sensitivity that fosters tolerance, courtesy, and civility.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties for this position, the employee is regularly required to sit, use hands, to talk, and to listen or hear. The employee must frequently lift and/or move up to 10 lbs and occasionally lift and/or move up to 25lbs.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is usually moderate. The computer and monitor are on continuously. Office space may be shared with one or more staff person(s), which at times requires staff to be able to screen out distractions. The building is air-conditioned and has many windows, however these windows do not open.