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 University