Admissions Operations Technology Coordinator

Summary:

The Admissions Operations Technology Coordinator primarily focuses on data extraction, transformation, and loading of data between Slate CRM system, the Student Information System, and Object Data Storage for the Office of Admissions. Their responsibilities include generating Slate & SAS queries, generating reports for internal and external partners, and importing third-party source data into Slate. This position will also focus on data verification and integrity. Strong technical skills, attention to detail, and effective communication & problem-solving abilities are essential for success in this position.

Typical Duties

Ad-hoc Queries, Reporting, and User Support (30%):

• Design and execute database queries and reports as requested by internal and external partners from Slate and Object Data Storage.
• Complete query requests from the Admissions Communications Team to ensure messaging reaches the correct prospective students.
  
• Transform & provide extracted data to end-users in requested format.
  Inspect user-generated queries for accuracy.
  
• Contribute to the troubleshooting support efforts for internal and external user issues.
  

Provide support for Extract, Transform, & Load (ETL) software (20%):

• Inspect & troubleshoot issues with manual & automated data file migration and image/document acquisition from third-party application software (ETL) to Slate, Banner Student Information System & Perceptive Content. Interface with ETL vendors when necessary.

Generate & import data between various systems as requested (20%):

• Extract & merge clean data files using Banner, Slate, SAS, and MS Excel.
  
• Transform extracted data and import into other systems.
  

Resolve data & identity discrepancies (20%):

• Investigate & resolve duplicate student record discrepancies in Banner & Slate.
  
• Generate data projects to identify mismatched data and provide to other teams for correction.
  
• Communicate efficiently & professionally with applicants when required to resolve issues.
  

Provide support for test score imports and other recruiting data files (10%):

• Import test scores from various undergraduate & graduate national testing agencies. GRE, GMAT, SAT, ACT, AP, etc.
  
• Populate CRM with data gathered by recruiting sources such as college fairs, bulk purchasing, etc.