Enrollment Data Specialist
Enrollment Data SpecialistJob Summary:
This position reports to the Associate Director of Enrollment Systems Operations and is responsible for effectively supporting the data reporting, maintenance of administrative systems and other technical needs of the Division of Enrollment Management, in close collaboration with the Associate Director of Enrollment Systems Operations. This position will prepare a variety of data analyses related to both financial and performance indicators, including enrollment, tuition, scholarships, and student retention and analysis. This position will also assist with the design, development, testing, documentation, research, data compilation, data analysis and preparation of reports.Essential Duties and Responsibilities:
•Cleans data in preparation for reporting and analysis
•Manages and ensures timely daily data CRM & Banner data migration for reports.
•Extracts and uploads Banner to Slate CRM data updates.
•Uploads prospect files to Slate CRM.
•Conducts regular data audits and collaborate with team members to resolve data discrepancies.
•Provide functional expertise, serve as technical support and troubleshoot/resolve problems related to the Ellucian Banner modules within Enrollment Management
•Works with supervisor to safeguard standardization, consistency, data integrity, security, and adherence to policy and procedures within systems
•Assists with system development, testing, implementation and maintenance
•Manages daily FTP and upload schedules and verify successful dataload
•Prepares clear, concise and accurate systems documentation and reports of work performed
•Monitors, audits, and ensures delivery of Enrollment Management operational reports.
•Builds queries to extract and aggregate data from various sources, including student
database and CRM systems.
•Catalogs and archives all reports.
•Respond to external ad-hoc data requests as assigned.
•Assists in developing and maintaining various models.
•Assists in the maintenance and publishing of dashboard reports for Enrollment Management in addition to preparing various scheduled or ad-hoc complex reports and summaries for the division, including status reports, progress summaries and audit reports.
•Maintains report directory and report archives
•Develop SQL statements for data warehouse exports.
•Assists with Slate, Banner, and new software testing.
•Provides written report on testing and data anomalies.
•Collaborates with other functional leads within the division to develop efficient processes
•Assists with maintaining updated procedures across the division; develop and maintain procedure manuals and training materials
•Plans and organizes work to meet established timelines and department schedules
Bachelor’s degree preferred and two years of directly related work, or equivalent combination of education and experience are required.
This position requires a high level of technical proficiency. The incumbent must be proficient in the use of relational databases and use of report-writing tools and languages. Experience with infographic design also preferred. Extensive experience in the following will be critical for success: MS Access, Ellucian Banner Student, General and Financial Aid modules, Ellucian Banner Letter Generation, and Ellucian Banner Object Access Views. Proficiency in Tableau, SQL, XML, FTP/SFTP protocols, and MS Office Suite.
This position requires excellent interpersonal, customer service, organizational skills and record keeping techniques.
The incumbent must possess the ability to prioritize effectively, maintain confidentiality, handle matters with tact and diplomacy, interact in a diverse community, manage details, multi-task, and adapt to changing situations.Certifications, Licenses, Restrictions :
While performing the duties of this job, the employee is regularly required to: sit, walk, use hands to handle office supplies, operate computer and other office equipment, talk, and hear. The employee is frequently required to: stand, reach with hands and arms and occasionally required to stoop and move up to 15 pounds. Specific vision abilities required by this job include the ability to adjust focus.Shift:
Days% Travel Required:
1% - 25%Full Time/Part Time:
Non-ExemptNumber of Vacancies:
SC0294PPosting Open Date:
04/26/2021Open Until Filled:
Spelman College is an EEO/Minority/Female/Disabled/Veteran/Title IX Employer and we participate in E-Verify. We are a smoke-free campus.