"Alerted.org

Position Information

Posting Number 20113116

Position Title ERP Analyst

FTE 1.0

Position Type Staff

Department Information Technology Dept

Position Summary Information

Job Summary/Basic Function

About This Role:

This position provides analysis and maintenance support of the university’s ERP system. This position will be involved in gathering information from users to document requirements for complex functional processes for projects and in support of current operations. Collaborate with functional and technical users to document programming requirements. Use PL/ SQL and SQL to support ERP processes, reporting, and other third-party applications. As a member of the ERP Operations department, this position strives to ensure consistency in communications, actions, and alignment to the strategic plan of the university. This position is also responsible for supporting the mission of the university by delivering technology, services, solutions and guidance to the students, faculty, staff, and the community in a professional, exemplary, service oriented collaborative manner.

What You’ll Do – Position Responsibilities:

+ Query Oracle and Microsoft SQL databases to provide ad-hoc and scheduled reports and data visualizations.

+ Work with users to support, troubleshoot, and configure the Banner ERP system (and other third-party enterprise applications) to ensure needs are met.

+ Write complex SQL queries to serve as a data pipeline for a variety of products and initiatives across campus including data analysis and third-party application interfaces.

+ Work with structured and unstructured data from a variety of data stores, such as relational database management systems and/or data warehouses.

+ Maintain and audit user accounts and permissions in enterprise applications.

+ Work with vendors to resolve issues or research configurations to provide solutions for day-to-day processing as well as large-scale projects.

+ Review product releases, create test plans, work with users for testing, and create change management documentation for new product releases in our ERP environment.

Key Competencies: (KSAs – Knowledge Skills and Abilities)

+ Oracle SQL , Microsoft SQL , Oracle database components, BI application experience, MS Office 365 Suite, large-scale ERP application configuration and support, application security configuration.

Physical Requirements: Requirements of a typical desk job.

Job Conditions: Desk job that can require before or after hours and weekends.

Important Notice: This position is not eligible for sponsorship.

Who We Are:

Lamar University is an accessible global university for life-long learners with a passion for broad-based community engagement. As a vital contributor to the socioeconomic wellbeing and resilience of the Gulf Coast region, our expertise is recognized locally and beyond. Lamar University is home to more than 17,000 students and is among the fastest growing Texas colleges and universities. LU is a member of The Texas State University System, which is the first higher education system of Texas and maintains the lowest average tuition and fees of any university system in Texas. With more than 100-degree options and a community that cares, Lamar students are always proud to be Cardinals.

Lamar University is committed to fostering a culture where students, faculty and staff of all backgrounds can learn, work, and serve.

Benefits:

+ Health, dental & vision insurance

+ Life insurance

+ State of Texas Retirement plans

+ Tuition covered at 100% for employees, spouses and/or eligible dependents.

+ Paid time off – vacation, sick, and holidays.

To see more information about the available benefits, please visit: Benefits – Lamar University (https://www.lamar.edu/faculty-staff/human-resources/hr-services/benefits/index.html)

Minimum Qualifications

+ Bachelor’s Degree and 3 years related experience OR associate’s degree with 5 years related experience.

+ At least 3 years related experience.

+ Familiarity with any programming language used for querying a database.

+ Functional or technical knowledge with any ERP level application.

+ Experience setting up application security groups and privileges.

+ Strong problem-solving skills.

+ Strong interpersonal communication skills and the ability to maintain effective working relationships with co-workers, vendors and the public are required.

+ Strong written, oral, and organizational skills.

+ Proficiency with MS Office applications.

EEO Statement

Lamar University is An Equal Opportunity Employer

Veteran's Preference Statement

Lamar University is proud to provide employment preference to veteran applicants in accordance with Texas 805 Government Code, Section 657.003.

Preferred Qualifications

+ Experience with additional Ellucian products.

+ Experience with Application Manager (AppWorx/UC4/Automic).

+ Experience researching, documenting, and testing application releases.

+ Experience working with vendor support groups.

+ Experience with Evisions product suite.

+ Ability to quickly learn a range of databases and extract information from that for either interface files or data analysis/visualization.

Security Sensitive Statement

This position is security-sensitive and thereby subject to the provisions of the Texas Education Code §51.215, which authorizes the employer to obtain criminal history record information.

Salary $53,496 - $69,545

Work Hours

Application Information

Posting Date 05/16/2025

Close Date 06/06/2025

Open Until Filled No

Special Instructions

Important Notice: This position is not eligible for sponsorship.