Business Systems Analyst

The Business Systems Analyst supports the college’s enterprise resource planning (ERP) and ancillary administrative systems. Activities include developing integrated reporting and analytics, import/export query management, presentation of source data through reports and dashboards, data integrity and needs analysis, and strategic partnerships, particularly with Institutional Research, supporting data governance, operational needs, and external reporting.

This position is on-site in Jackson, MS. Regular work hours are from 8:00 a.m. to 4:30 p.m. Evening and night hours and occasional weekend work are required.

• Responsible for administering the ERP system and integrated applications. Responsibilities include, but are not limited to, system configuration, installation of software upgrades, data refresh clones of supported environments, debugging/testing all implementations, provisioning/maintaining end user accounts and security roles, etc.
• Supports the ERP transactional/operational database and the analytical databases (data warehouse), applications, and functions associated with the ERP system, including technical maintenance upgrades and module installation. Responsible for researching and resolving the day-to-day operating issues that affect processing services.
• Utilize a strong understanding of SQL and ETL processes to design, develop, and maintain data integration workflows, ensuring efficient data extraction, transformation, and loading across multiple systems.
• Provides technical advice and support to end users, including troubleshooting issues and creating data extracts, reports, data analysis, and business intelligence dashboards.
• Performs systems analysis and design work for functional end users.
• Assists other Information Technology Services staff members with design, program logic, instruction, and database structure.
• Debugs programs by preparing test data and evaluating computer output for valid results, satisfying end-user requests.
• Coordinates with the Director of Information Technology on protocols and security to connect the ERP system to the infrastructure.
• Maintaining and monitoring database systems performance by creating, debugging, and testing various database types, including SQL Server and Unidata.
• Maintains, creates, debugs, and tests flat-file exchange and data extraction in an Electronic Data Interchange (EDI) environment.
• Works with third-party vendors to implement and maintain custom database integrations.
• Supports the Instructional Technologist’s duties regarding the Learning Management System (LMS) and its integration with the ERP system.
• Other related duties as assigned.

• Requires a bachelor’s degree or five years of related experience.
• Requires at least five years of experience designing or implementing major software systems.
• Requires extensive relational database system design knowledge and enterprise-level experience with multiple project management.
• Requires project management skills.
• Experience in higher education and/or Ellucian Colleague software suite is preferred.
• Experience with, or knowledge of, accessible web and mobile development and technology security issues is preferred.
• Experience with MS SQL queries, SAP Business Objects report writing, and/or comparable software is preferred.
• Knowledge of
• Database structures (SQL Server, Oracle, Unidata, MySQL)
• Relational database concepts, tools, and techniques, including the use of Structured Query Language (SQL) and Open Database Connectivity (ODBC)
• Data warehouse dimensional design using a star schema or similar approach
• ETL processes such as SQL Server Integration Services
• Various computer programming languages (Python, SQL, T-SQL, R, Java)
• Interpersonal skills requiring extraordinary courtesy and tact are necessary to communicate effectively with users and vendors in person and on the telephone.
• Analytical skills necessary to understand and develop solutions to problems and organize workload according to established priorities

• Able to lift and carry up to 15 pounds without assistance.
• Prolonged periods sitting at a desk and working on a computer.
• Occasional stooping, bending, lifting and reaching are required.
• Manual dexterity needed for keyboarding and other repetitive tasks.