Assistant Director, Enterprise Solutions

Assistant Director, Enterprise Solutions

POSITION SUMMARY:

The Assistant Director, Enterprise Solutions works with Salem Technology staff, Salem stakeholders, and third-party partners to design, develop, implement, and support the organization’s enterprise applications. By ensuring the reliability and optimization of Salem’s enterprise solutions, the Assistant Director supports student success, operational efficiencies, and overall institutional effectiveness.

The Assistant Director, Enterprise Solutions reports to the Vice President for Finance and Administration and serves as the lead technical member of an applications team that includes an applications integration specialist and a part-time database analyst.

Salem’s Assistant Director, Enterprise Solutions, is responsible for Salem’s student information systems and works with the Applications Specialist to ensure integration and support of financial aid and finance systems, admissions systems, and other ERP services.

Essential Duties and Responsibilities

The Assistant Director, Enterprise Solution’s key duties and responsibilities fall into the following categories:

Enterprise Application Support:

• Provides enterprise applications with technical support, troubleshooting, and problem resolution and resolve enterprise applications support tickets related to end-user requests.
• Ensures issues are resolved and properly documented in a timely manner.
• Troubleshoots application and database issues and provides data issues research assistance as needed.
• Evaluates issues and engages vendor or other support as needed.
• Oversees server and end-user enterprise application infrastructure.
• Oversees the Student Information System (SIS) and other enterprise application patching and release schedule in collaboration with vendors and stakeholders.

Enterprise Applications Architectural Design and Implementation

• Works collaboratively with other stakeholders on campus such as the Registrar, Controller, and other functional department heads, internal integration specialist, and vendors to design and implement new or optimized enterprise applications.
• Develops and maintains technical architecture documentation.
• Works with external agencies, independent contractors, vendors, and organizations on technology services, applications, and/or data requirements.
• Applies systems development lifecycle and project management techniques.
• Coordinates and implements data conversions and transitions from old to new systems as needed.
• Oversees enterprise applications testing as needed.

Enterprise Database Management

• Maintains internal enterprise applications database servers.
• Monitors database configuration and log files and takes preventive and/or corrective actions as needed.
• Performs periodic database backup and restore testing.
• Resolves database issues, installs updates, and leads testing with departments.
• With the Integration Specialist and part-time ERP Analyst, and with users, develop periodic specialized reports.

Oversight of Enterprise Applications Integration Development

• Oversees integration of internal and cloud-based enterprise applications.
• Work with Integration Specialist to ensure integrations are developed according to appropriate standards and are both functional and resilient.
• Oversees creation, automation, and maintenance of integrations using batch and/or API processes as required.
• Oversees integration development activities and testing as needed.

Management Reporting and Support for External Data

• Develops management reporting using PowerBI with data from the Student Information Systems and other Enterprise data
• Supports data required for external surveys including IPEDS data, USNWR, etc.

Required Qualifications

• Strong SQL development skills required (T-SQL, PL-SQL, etc. acceptable).
• MS-SQL Server, Oracle, MySQL/MariaDB, or Postgres experience required.
• 3 years supporting enterprise applications environments required; Experience with higher education enterprise systems such as Banner, PowerCampus, Jenzabar, or Workday preferred.
• 3 years of database management experience or equivalent education required.
• Experience in integration of applications using API’s required.
• Experience with MSSRS, Microsoft Visual Studio, or similar toolsets required.
• MS-Office 365, especially Excel, required.
• Strong verbal and written communications skills required.
• Successful project management experience required.
• Experience with applications integration platforms such as Constituo, MuleSoft, Boomi, Ellucian Ethos, or other platform strongly preferred.
• Python skills preferred.
• Higher education experience preferred.
• Familiarity with third-party payment platforms a plus.
• Familiarity with third party higher education app integrations such as Slate Admissions/CRM portal a plus.

Physical Functions

While performing the responsibilities of the Assistant Director, Enterprise Solutions, 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 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.