ERP & Data Automation Analyst (Banner/SQL)

Tennessee Board of Regents; Dyersburg (TN); On-site; USD 55,000 - 69,000; Full time

Benefits offered by this job

Vacation and Sick Leave

14 paid holidays

Medical, dental, vision and life insu​

Retirement plans

401K/403B Deferred Compensation Plans

Educational benefits for employee and

State Employee Discount Program

Job summary

Dyersburg State Community College in Tennessee is seeking a technically skilled Programmer/Analyst to provide primary technical support for the Student and Student Services modules of the ERP system and the CRM system. The role emphasizes advanced analysis, workflow automation, data troubleshooting, and cross‑departmental system support.

The position develops dashboards, automates processes, and supports Banner patches, BDM/OTS, UC4, and data integration tasks, ensuring data quality and

Qualifications

• Associate degree in a computer related field from a regionally accredited institution.
• Experience using problem-solving skills and applying programming logic and root-cause analysis to diagnose and resolve technical issues with complex, multi-system integrations.
• Experience using SQL and other modern languages, such as Java.
• Knowledge of Oracle relational database concepts.
• Experience using the Microsoft Office suite of productivity tools.

Responsibilities

• Provide technical and consulting support for Ellucian Banner Student including advising, registration, enrollment, testing, academic, and all other Student Services related aspects as needed.
• Build and automate SQL/Argos dashboards and reports, aligning with institutional priorities to support data-driven decision-making.
• Provide technical and consulting support for Banner Document Management (BDM) and Output Transformation Server (OTS), including developing JavaScript parsing and indexing logic and automating document‑processing workflows and developing and maintaining batch scripts and file‑transfer automations to support BDM/OTS ingestion, archiving, and cross‑system integrations.
• Provide technical support for Automic/UC4 to automate processes for Banner Student and other cross‑departmental workflows including: enrollment reporting, data imports and other critical operational tasks.
• Provide technical assistance as needed for Student and Financial Aid related Banner patches and new versions.
• Analyze Banner datasets to provide technical insights and drive data-driven decision-making.
• Collaborate with cross-functional stakeholders to troubleshoot issues, identify system enhancements, and implement solutions.
• Leverage emerging technologies to continuously optimize the modernized ERP platform.
• Ensure seamless continuity during student systems migrations including accurate data mapping, data transformations, and data verification afterward.
• Provide development support for the various aspects of Slate including but not limited to the Admissions Applications, Advising Portal, and Tutoring Center Kiosk as requested by the users.
• Provide technical support for Remark scanning software used by various departments to perform functions such as faculty evaluations.
• Provide configuration/development and troubleshooting support for Axiom.
• Provide support for Ellucian Degree Works including applying updates from the catalog and troubleshooting issues with CPOS.
• Provide support for the data exchanges with National Student Clearinghouse and the Reverse Transfer systems.
• Analyze complex data and manage data files utilizing SQL, SFTP, and Microsoft Office suite to support the needs of internal users.
• Support faculty and staff in the use of other software, such as Microsoft Office applications, email, SFTP, and related tools.
• Provide primary backup for the Financial Aid Analyst position and secondary backup for other Information Technology staff as needed.
• Utilize customer service skills to respond to inquiries and comments in a courteous and professional manner, while maintaining a serious attitude toward every aspect of this job.
• Perform other duties as assigned.

Skills

Problem solving

SQL

Java

Communication skills

Scripting

Education

Associate degree

Bachelor's degree preferred

Tools

Ellucian Banner Student

Oracle database

Argos

PL/SQL

ProC

Automic/UC4

Banner Document Management

Output Transformation Server

JavaScript

Job description

Dyersburg State Community College in Tennessee is seeking a technically skilled Programmer/Analyst to provide primary technical support for the Student and Student Services modules of the ERP system and the CRM system. The role emphasizes advanced analysis, workflow automation, data troubleshooting, and cross‑departmental system support.

The position develops dashboards, automates processes, and supports Banner patches, BDM/OTS, UC4, and data integration tasks, ensuring data quality and