ERP Analyst
Lamar University

Job Info

---

Posting Number:

20112845

Position Title:

ERP Analyst

FTE:

1.00

Position Type:

Staff

Department:

Information Technology Dept

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:

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

Who We Are:

Lamar University is a 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.

Benefits:

At Lamar University one of the ways, we show value to our team members is by offering the following perks:

• Health, dental & vision insurance.
• Life insurance.
• State of Texas Retirement plans.
• Tuition covered at 100% for employees, spouses and/or eligible dependent.
• Paid time off - vacation, sick, and holidays.

To see more information about the available benefits, please visit: Insurance - Lamar UniversityMinimum Qualifications:

• Bachelor's Degree and 3 years related experience.
• Associate's Degree with 5 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

Posting Date:

02/12/2024

Close Date:

05/12/2024

Open Until Filled:

No

Special Instructions:

Information Technology will not sponsor or transfer visa sponsorship for this position.

---