Note:  This job announcement has been designed to indicate the general nature and level of work performed by employees within this classification.  It is not designed to contain or be interpreted as a comprehensive inventory of all duties and responsibilities required or assigned to an employee in this position. 

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:

Data Management

• 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 data load
• Prepares clear, concise and accurate systems documentation and reports of work performed

Reporting

• 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

Operational Efficiency

• 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

Education and/or Experience:

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 is preferred. 

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. 

Good oral and written communication skills are important, as this position will regularly interact with and communicate ideas with other members of the division and the Spelman community at large in the execution of responsibilities. 

Spelman College is an EOE/Minority/Female/Disability/Veteran/Title IX Employer and we participate in E-Verify.

NO PHONE CALLS PLEASE