Enrollment Management Data Analyst

Location
Deland, Florida
Posted
Jun 02, 2017
Ref
# 1788
Institution Type
Four-Year Institution

POSITION OVERVIEW:

The Data Management Analyst maintains the data integrity of the Admissions databases, develops and oversees reporting, and provides functional user and high-level technical expertise. Responsible for Admissions office data integrity and for reporting to all state and federal agencies as requested, as well as daily, weekly, monthly and yearly trends. Responsible for the operational maintenance and data integrity of the Admissions databases including, but not limited to BANNER and Technolutions Slate, BDMS, and ensures accuracy of data by updating and changing student information, and by developing methods to check for discrepancies. Builds and maintains data mapping and import and export rules of a wide range of source files, including Slate, Common Application, CollegeNet, ACT, and SAT, NPC, etc. and all work related to processing student applications and reports.  Quality assures all data entered by identifying and correcting discrepancies.

QUALIFICATIONS, KNOWLEDGE AND SKILL REQUIREMENTS:

  • Bachelor’s degree, or equivalent certificate of competency, supplemented by two years of college with course work in information sciences; or three (3) years of experience in a wide scope of modern data management procedures and practices, or an equivalent combination of training and experience.
  • Extensive knowledge in use and structure of databases and spreadsheets software; Broad experience with relational database management required, including proficiency in SQL, HTML, Python, COGNOS, ARGOS, or other report writing and querying tools. Strong skill and ability to provide report information in spreadsheet, graph, and table format; ability to maintain confidentiality; and skilled in all areas of Windows and Microsoft Office.
  • Be able to manage multiple tasks in a fast paced and high-pressure high stakes environment.

ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:

  • Responsible for the operational maintenance and data integrity of the Admissions databases including, but not limited to BANNER and Technolutions Slate, and ensures accuracy of data by updating and changing student information, and by developing methods to check for discrepancies.
  • Assist in the creation of procedures of import/export processes; editing large data sets to ensure accuracy on up-loads; bridging information on a daily basis from CRM to Banner and all IR office and one-stop shop interfaces. Develops procedures and processes to automate manually performed procedures.
  • Works closely with IT/Information Services staff to improve database operations and data import/export processes; monitors, filters and corrects data and troubleshoots and problem solves all system related issues.
  • Synchronizes prospective student information between web application and database and develops procedures related to handling of data.
  • Develops reports to assist in: strategic decisions, data accuracy, qualification of prospective students, and daily recruitment.
  • Other duties as assigned:
    • Assists with data entry during high volume periods
    • Retrieval of online applications and application credentials
    • Sorting, organizing, and matching application credentials of prospective students
    • Enrollment management tasks during high volume periods
  • Performs other site and position specific functions as assigned

ROUTINE DUTIES AND RESPONSIBILITIES:

  • Builds and maintains data mapping and import and export rules of a wide range of source files, including Slate, Common Application, CollegeNet, ACT, and SAT, NPC, etc. (10%)
  • Performs data accuracy checks and database and import table maintenance (20%)
  • Creates and maintains queries and student record rules utilizing ARGOS, SQL, and MS ACCESS tools and languages; maintains and develops ad-hoc reports. (10%)
  • Develops reports to assist in strategic decisions, data accuracy, qualification of prospective students, and daily recruitment. Maintaining and disseminating the weekly reports (20%)
  • Works closely with IT/Information Services staff to improve database operations and data import/export processes; monitors, filters and corrects data and troubleshoots and problem solves all system related issues (15%)
  • Develops procedures to automate manually performed procedures (5%)
  • Synchronizes prospective student information between web application and database and develops procedures related to handling of data (10%)
  • Other duties as assigned (10%):
    • Assists with data entry during high volume periods
    • Retrieval of online applications and application credentials
    • Sorting, organizing, and matching application credentials of prospective students
    • Enrollment management tasks during high volume periods