Enterprise Apps Analyst I - API & Data Integrations

Johnson C. Smith University - JCSU; Charlotte (NC); On-site; USD 60,000 - 90,000; Full time

Job summary

Johnson C. Smith University - JCSU is seeking a Software Applications Analyst I to support, administer, integrate, and continuously improve the University’s enterprise application portfolio.

The role emphasizes Ellucian Colleague SaaS, Colleague Self‑Service and Experience, TouchNet, EAB platforms, Canvas, and other university systems through vendor collaboration, incident resolution, and secure data integrations.

Qualifications

• Bachelor’s degree in computer science, information systems, MIS, software engineering, data analytics, or a related field.
• 0–2 years of related experience supporting enterprise applications, application integrations, databases, reporting, automation, or software quality assurance.
• Demonstrated working knowledge of SQL and Python, including the ability to read, write, test, troubleshoot, and document code.
• Knowledge of relational databases and data concepts, including PostgreSQL, Microsoft Access, data mapping, validation, and structured data exchange.
• Knowledge of API concepts and integration methods, including REST, JSON, authentication, error handling, and secure data transmission.
• Knowledge of HTML and general web‑application concepts; familiarity with Java or other programming languages is beneficial.
• Ability to analyze complex issues, manage multiple priorities, work independently, meet deadlines, and maintain attention to detail.
• Strong written, verbal, analytical, customer‑service, presentation, and interpersonal communication skills, including the ability to communicate with university leadership and non‑technical users.

Responsibilities

• Provide day‑to‑day functionality and technical administration for assigned enterprise applications across production, test, development, and training environments.
• Manage incidents, service requests, known issues, vendor cases, upgrades, feature releases, maintenance activities, license or renewal notices, and application lifecycle tasks.
• Monitor system availability, scheduled jobs, interfaces, automated procedures, and integrations; investigate failures and coordinate timely resolution.
• Configure application settings, roles, permissions, workflows, forms, and features in accordance with approved change management and security practices.
• Provide accurate and responsive support to students, faculty, staff, and campus offices; elevate complex issues to vendors or internal technical teams when appropriate.
• Design, build, test, document, monitor, and maintain integrations among Ellucian Colleague SaaS, TouchNet, EAB, Canvas, and other University systems.
• Develop and support RESTful API integrations, including authentication, data mapping, error handling, logging, validation, scheduling, and secure transfer of institutional data.
• Use Python, SQL, vendor integration tools, scripting, and workflow or scheduling technologies to automate repeatable operational and data‑processing tasks.
• Create, maintain, optimize, and troubleshoot SQL queries, views, stored procedures, extracts, imports, and reports across supported database platforms.
• Perform data analysis, transformation, reconciliation, validation, and quality assurance to ensure complete, accurate, and timely information between systems.
• Maintain technical specifications, interface inventories, field mappings, schedules, dependencies, credentials‑handling procedures, and recovery steps for integrations and automated processes.
• Analyze business requirements and current operating procedures; translate needs into application configurations, technical requirements, integrations, reports, or process improvements.
• Evaluate vendor enhancements and new technologies for compatibility, security, accessibility, data integrity, operational impact, and alignment with university needs.
• Plan and perform unit, integration, regression, user‑acceptance, and post‑deployment testing; document results and coordinate issue remediation.
• Prepare and facilitate change requests, implementation plans, rollback plans, release communications, and production validation activities.
• Participate in application implementations, upgrades, migrations, data conversions, and cross‑functional technology projects.
• Create and maintain system documentation, runbooks, knowledge‑base articles, data dictionaries, user guides, training videos, and standard operating procedures.
• Deliver application training and presentations for students, faculty, staff, IT Support, campus departments, leadership, and vendors as required.
• Collaborate with functional offices, IT colleagues, vendors, consultants, and project teams to identify solutions and deliver successful outcomes.
• Communicate system status, risks, dependencies, outages, changes, and project progress clearly to technical and non‑technical audiences.
• Follow University policies and applicable standards for information security, privacy, access control, records handling, and change management.
• Apply least‑privilege access principles and protect credentials, personally identifiable information, financial data, and other sensitive institutional information.
• Support audit requests, access reviews, control documentation, disaster‑recovery preparation, and business‑continuity activities for assigned systems.
• Provide quality assurance for outstanding issues and contribute to reliable, efficient, and customer‑focused technology services.

Skills

SQL

Python

REST APIs

Data mapping

HTML

PostgreSQL

Education

Bachelor’s degree in computer science, information systems, MIS, software engineering, or related field

Tools

ETL tools

Git

Job description

Johnson C. Smith University - JCSU is seeking a Software Applications Analyst I to support, administer, integrate, and continuously improve the University’s enterprise application portfolio.

The role emphasizes Ellucian Colleague SaaS, Colleague Self‑Service and Experience, TouchNet, EAB platforms, Canvas, and other university systems through vendor collaboration, incident resolution, and secure data integrations.