Enterprise Applications and ERP Systems Administrator

Salem-Academy-and-Colleg; Winston-Salem (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

Salem Academy and College is seeking an Enterprise Applications & ERP Systems Administrator to oversee the SIS and ERP environment, including Ellucian PowerCampus, data reporting, and integrations. The role combines ERP administration with enterprise applications, database, and Microsoft 365 responsibilities in a small-college IT setting.

The successful candidate will help implement ERP/SIS initiatives, ensure data quality, and provide end-user training while supporting ongoing system health and

Qualifications

• Three or more years of experience supporting enterprise applications environments.
• Strong SQL development skills (T-SQL, PL/SQL, or comparable SQL dialects).
• Experience with reporting/development toolsets such as SSRS, Microsoft Visual Studio, Power BI, or comparable platforms.
• Strong Microsoft 365 skills, particularly Excel.
• Experience integrating applications using APIs.
• Experience with relational database platforms such as Microsoft SQL Server, Oracle, MySQL/MariaDB, or PostgreSQL.

Responsibilities

• Serve as the primary technical and functional administrator for Ellucian PowerCampus.
• Support ERP implementation activities including configuration, testing, data validation, conversion, go-live, and post-implementation stabilization.
• Administer ERP security roles, upgrades, patches, scheduled processes, interfaces, integrations, and related operational functions.
• Troubleshoot complex enterprise application issues and provide Tier II/III support.
• Coordinate with Ellucian and other third-party vendors for support, implementation, upgrades, and issue resolution.
• Maintain current system documentation, operating procedures, configuration records, and knowledge articles.
• Provide end-user training and knowledge transfer to functional and technical staff.
• Develop and maintain SQL queries, reports, dashboards, data extracts, and operational reporting solutions.
• Design, develop, support, and troubleshoot integrations between enterprise systems using APIs, integration platforms, database methods, file exchanges, and other appropriate technologies.
• Develop workflow automations and process improvements using Microsoft Power Platform or comparable tools.
• Monitor integration health, investigate failures, and maintain technical documentation for interfaces and data flows.
• Support Microsoft 365 services, including SharePoint Online, Entra ID, and Power Platform solutions.

Skills

SQL development

Relational databases

API integrations

Power BI

Microsoft 365

SSRS

Power Platform

Excel

Education

Bachelor's degree in information technology, computer science, information systems, or a related field

Tools

Ellucian PowerCampus

Ellucian Ethos

MuleSoft

Boomi

SQL Server

SharePoint Online

Job description

About Salem Academy and CollegeSalem Academy and College is the oldest continuously operating educational institution for girls and women in the country. Since 1772, the institution has engaged in transformational change to innovate women’s education. Founded with the mission of making education accessible to all, Salem has a rich 254-year-old history and a long-standing track record of educating students who are prepared to make a bold impact locally, nationally and globally through liberal arts education. Our graduates are committed to making the world a better, healthier and more equitable place. Salem Academy is a boarding and day college preparatory school with a focus on interdisciplinary learning using STEAM, wellness and leadership. Salem College is the nation’s only liberal arts college exclusively dedicated to developing the next generation of health leaders.Position SummaryThe Enterprise Applications & ERP Systems Administrator is a hands-on, cross-functional technology professional responsible for the administration, integration, reporting, and operational support of Salem College's core enterprise applications, with primary responsibility for the Student Information System (SIS) and associated distributed ERP environment. The position combines ERP administration with enterprise application, database, integration, Microsoft 365, identity, automation, and technical project responsibilities.This role is designed for a small-college environment where technology staff work across traditional functional boundaries. The successful candidate will serve as a key technical resource during our future ERP/SIS implementation and stabilization period while also providing sustainable support for the College's broader enterprise application ecosystem.Essential ResponsibilitiesERP & Enterprise Application AdministrationServe as the primary technical and functional administrator for Ellucian PowerCampus.Support ERP implementation activities including configuration support, testing, data validation, conversion, cutover, go-live, and post-implementation stabilization.Administer ERP security roles, upgrades, patches, scheduled processes, interfaces, integrations, and related operational functions.Troubleshoot complex enterprise application issues and provide Tier II/III support.Coordinate with Ellucian and other third-party vendors for support, implementation, upgrades, and issue resolution.Maintain current system documentation, operating procedures, configuration records, and knowledge articles.Provide end-user training and knowledge transfer to functional and technical staff.Data, Reporting & Database SupportDevelop and maintain SQL queries, reports, dashboards, data extracts, and operational reporting solutions.Support relational databases used by enterprise applications, including database troubleshooting, data validation, and appropriate administrative activities.Partner with institutional offices to improve data quality, reporting consistency, and business processes.Support data conversion, reconciliation, validation, and migration activities associated with ERP and enterprise application projects.Participate in data governance initiatives and help implement standards for institutional data quality, stewardship, access, and documentation.Integrations & AutomationDesign, develop, support, and troubleshoot integrations between enterprise systems using APIs, integration platforms, database methods, file exchanges, and other appropriate technologies.Support integrations involving Ellucian PowerCampus and third-party higher education platforms such as admissions/CRM (Slate), payment, learning, document, and other SaaS systems.Develop workflow automations and process improvements using Microsoft Power Platform or comparable tools.Monitor integration health, investigate failures, and maintain technical documentation for interfaces and data flows.Microsoft 365 & Enterprise Technology SupportSupport Microsoft 365 services, including SharePoint Online, Entra ID, and Power Platform solutions.Assist with SaaS application administration, identity and access management, and application lifecycle activities.Participate in disaster recovery, software lifecycle management, IT asset management, and other institutional technology projects.Assist with technical evaluation, implementation, documentation, and support of new enterprise applications.Project, Service & Stakeholder ResponsibilitiesLead or coordinate assigned technology projects and workstreams using sound project management practices.Work closely with functional offices to translate business needs into practical technical solutions.Provide responsive, customer-focused service and communicate effectively with both technical and nontechnical stakeholders.Support continuous improvement of IT service delivery, documentation, change management, and operational processes.Perform other related duties as assigned consistent with the scope and level of the position.Required QualificationsBachelor's degree in information technology, computer science, information systems, or a related field; equivalent combination of education and relevant professional experience may be considered.Three or more years of experience supporting enterprise applications environments.Three or more years of database management, database development, or closely related experience, or equivalent education.Strong SQL development skills (T-SQL, PL/SQL, or comparable SQL dialects).Experience with one or more relational database platforms such as Microsoft SQL Server, Oracle, MySQL/MariaDB, or PostgreSQL.Experience integrating applications using APIs and other common integration methods.Experience with reporting/development toolsets such as Microsoft SQL Server Reporting Services (SSRS), Microsoft Visual Studio, Power BI, or comparable platforms.Strong Microsoft 365 skills, particularly Excel.Demonstrated ability to troubleshoot complex application, data, and integration issues.Strong verbal, written, analytical, customer service, and documentation skills.Demonstrated project coordination or project management experience.Ability to manage multiple priorities and work effectively in a small, collaborative IT organization.Preferred QualificationsExperience administering Ellucian PowerCampus or similar SIS (Ellucian Colleague, Banner, Jenzabar, Workday, Anthology…etc.).Experience participating in an ERP implementation, migration, or major ERP upgrade.Higher education technology experience.Experience with application integration platforms such as Ellucian Ethos, Constituo, MuleSoft, Boomi, or comparable tools.Experience with SQL Server, Power BI, Microsoft 365, Entra ID, SharePoint Online, and Power Platform.Python development or scripting skills.Experience supporting higher education integrations such as Slate or other admissions/CRM platforms.Familiarity with third-party payment platforms.ITIL Foundation certification and/or formal project management training or certification.Experience evaluating and applying AI-enabled tools, automation, and intelligent workflows to improve business processes, system integrations, data access, and operational efficiency, with appropriate consideration for data privacy, security, governance, and responsible AI use.Experience identifying and implementing practical AI use cases that improve connectivity between enterprise systems, reduce manual processes, enhance data quality, and improve the user experience.Position ScopeThis position is intentionally broad and combines responsibilities commonly distributed across an ERP Administrator and an Enterprise Applications/Integrations professional. Priorities should be managed by IT leadership to ensure that mission-critical ERP operations, integrations, security, data integrity, and implementation commitments receive appropriate focus.Physical FunctionsWhile performing the responsibilities of the Enterprise Applications and ERP Systems Administrator the employee is required to sit for varying lengths of time; bend, reach, lift, push, and pull up to 25 pounds; occasionally stand, walk, and kneel and regularly ascend/descend stairs; use hands and fingers to handle or feel and manipulate keys on a keyboard; perform extended periods of work at a computer workstation, view a computer monitor; perceive sounds at normal speaking levels with or without correction, and receive detailed information through oral communication; express and exchange ideas by means of spoken word; and work in an office setting.Salem Academy and College is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, national origin, age, religion, disability status, sex, sexual orientation, gender identity, veteran status, pregnancy, or any other characteristic protected by law.For questions, please contact Garth Cormier, Fractional CIO at [e-mail] or JaNae Joyner, COO and VP of Administration and Operations at [e-mail].