Job DescriptionClassification Title: ERP Business Analyst
Salary: $80,484.00 Annually
Department: Information Technology
Pay Grade: ADM6
Reports To: Director, Enterprise Applications
FLSA Status: Exempt
Unit: Administrative
Opening Date: 11/19/2026
Closing Date: 12/3/2026 11:59 p.m.
GENERAL STATEMENT OF JOBThe ERP Business Analyst is a hands-on, mid-level Information Technology (IT) role. The position is responsible for the planning, design, development, implementation and support of the College's ERP and CRM applications, reporting tools and related integrations. The ERP Business Analyst participates in project activities requiring IT subject matter expertise, including researching, evaluating, recommending and implementing new technologies and services. The ERP Business Analyst receives general direction from the Director of Enterprise Applications and is expected to manage assigned responsibilities and deliver projects with a high degree of autonomy.
SPECIFIC DUTIES AND RESPONSIBILITIESEssential Functions:
- Serves as a technical liaison between Information Technology and College departments to analyze and interpret business requirements, identify technology solutions and translate business needs into detailed functional and technical specifications.
- Develops and maintains enterprise reporting solutions using Ellucian Reporting & Analytics (Insights) and Entrinsik Informer. Develops, modifies, tests and troubleshoots SQL/PostgreSQL queries to support reporting, data analysis and operational requirements.
- Analyzes and troubleshoots data discrepancies, reporting inconsistencies, application errors and integration failures. Identifies root causes and recommends and implements appropriate corrective actions.
- Supports the design, implementation, maintenance and troubleshooting of integrations between Ellucian Colleague, CRM systems, and third-party applications using APIs, Ellucian Integration Management and Designer and other integration technologies.
- Prepares and maintains written documentation for IT department processes and procedures, including technical specifications, application configurations and system integrations.
- Supports IT strategic initiatives by participating in projects involving the implementation, configuration, setup and testing of new systems and functionality.
- Provides advanced technical troubleshooting and support for escalated enterprise application issues, collaborating with IT personnel, College departments and external vendors as needed.
- Identifies, recommends and implements system improvements, modifications and upgrades to ERP, CRM and other administrative software applications.
- Effectively prioritizes and manages multiple concurrent projects and assignments, meets established deadlines and maintains a high level of accuracy and attention to detail.
- Performs other duties as assigned.
MINIMUM QUALIFICATIONS- Bachelor's degree in Computer Science, Information Systems or a related field
- Five (5) years of experience in business systems analysis, application development, programming, or a related information technology role
- Three (3) years of experience working with higher education ERP systems in a technical or functional capacity
- Experience supporting Ellucian Colleague ERP applications, preferably in a SaaS environment
- Demonstrated experience developing, modifying and troubleshooting SQL/PostgreSQL queries to support enterprise reporting and data analysis
- Experience developing and modifying reports using enterprise reporting tools
- Working knowledge of ERP and CRM integrations, modern web APIs and related cloud-based technologies
- Strong analytical, troubleshooting and problem-solving skills
- Ability to work independently, manage multiple priorities and meet established deadlines
PREFERRED QUALIFICATIONS- Experience with Ellucian Reporting & Analytics (Insights), Entrinsik Informer, Ellucian Integration Management and Designer
- Experience with JavaScript or other scripting and programming languages
- Experience supporting and troubleshooting integrations between ERP, CRM and third-party application systems
- Strong interpersonal skills, including the ability to communicate effectively with technical and nontechnical personnel through oral and written communication
- Flexibility, adaptability and willingness to work in a changing technology environment
- Proficiency with Microsoft Word, Outlook, Excel, PowerPoint and other common business applications
SUPPLEMENTAL INFORMATIONSCHEDULE: Monday - Friday, 8:00 a.m. to 4:00 p.m.
RETIREMENT: Pension Eligible
NJ First ActAny Middlesex College employee hired after September 1, 2011 will have to meet the New Jersey residency law requirement.