Assistant Director, Enterprise Application Systems

Job description

Assistant Director, Enterprise Application Systems

Mt. San Antonio College

Job Category: Management

Employee Group:

Time (Percent Time): 100%

Term (months/year): 12 months/year

Current Work Schedule (days, hours): Monday - Friday, 7:30am - 4:30pm

Salary Range: M-17

Salary: Steps 1 - 6, $134,640 - $148,008 annually

Shift Differential:

Health & Welfare: The College contributes $7,930 toward annual premiums for medical, dental, vision, and life insurance coverage. Lifetime retirement benefits provided for eligible retirees. The District participates in the Public Employees’ Retirement System (PERS), State Teachers’ Retirement System (STRS) retirement programs, and MetLife Social Security Alternative Plan. Note Salary and Health & Welfare Benefits are subject to change.

Department: Information Technology

Open Date: 01/17/2018

Closing Date:

Open Until Filled: Yes

Basic Function/Overview:
Under general direction, supervises, organizes and coordinates user support and system development of the College's multi-module Enterprise Resource Planning (ERP) system applications; oversees complex application development projects; manages system upgrades and application enhancements; directs and provides ongoing supervision to information technology programming staff; provides technical leadership, and expertise in the areas of user support and systems programming to enhance the administrative functionality of the College's ERP system applications; and performs related work as required. This position is overtime exempt.

Receives general direction from the Director, Enterprise Application Systems. Exercises direct and general supervision over assigned staff.

This is a management level classification in the Information Technology Department responsible for the support, development, and system upgrades of the College's ERP system applications. The incumbent assumes critical oversight of projects focused on the on-going support and enhancement of the College's system. This classification is distinguished from other information technology classifications by its oversight of the enhancements and user support for the College's ERP system, the Ellucian Banner System. This classification is further distinguished from the Director, Enterprise Application Systems in that the latter has overall responsibility for all functions of the Enterprise Application Systems unit.

Essential Duties/Major Responsibilities:

1. Assumes leadership, management and supervisor responsibility for the design, development, and implementation of application enhancements to the College’s administration system, Ellucian Banner; ensures adherence to detailed programming procedures and change controls.
2. Selects, trains, mentors, motivates, and evaluates technical and professional personnel; provides or coordinates staff training.
3. Reviews Requests for Enhancements (RFE) to the Banner System; assesses user needs and requests; develops proposed solutions to meet user needs.
4. Develops and maintains programming change/enhancement request log; prioritizes projects at the direction of the Director, Enterprise Application Systems.
5. Serves as project manager for system development projects; develops objectives, timelines, assigns resources, work activities; plans, directs, coordinates, reviews, and evaluates work products, methods, and procedures; meets with staff to identify and resolve problems/challenges; develops and maintains standard project documentation and reporting.
6. Ensures appropriate completion and submission of all State-mandated Management Information System (MIS)/320 reporting in-line with Ellucian Banner baseline functionality.
7. Adheres to standards and procedures for client/server system development, database access, and reporting.
8. Serves as liaison to vendor(s) for application support and problem resolution; identifies, tracks, and responds to user issues.
9. Plans, organizes, and leads testing and installation of application updates and upgrades; participates in the impact analysis of upgrades and patches.
10. Enhances and supports web application access to Relational Database Management Systems (RDBMS) data.
11. Coordinates and oversees staff responsible for technical support, analysis, and programming to ensure complete and appropriate use of the Banner Administrative system.
12. Provides leadership in developing software and systems to optimize performance of Relational Database Management System (RDBMS), client/server application access, and web applications accessing RDBMS data.
13. Consults with other Ellucian Banner clients regarding user needs, product functionality, and proposed and existing application enhancements; attends and participates in professional group meetings; stays abreast of new trends and innovations in the field of Enterprise Resource Planning (ERP) and multi-module software applications.
14. Monitors and evaluates the efficiency and effectiveness of service delivery methods and procedures; recommends, within departmental policy, appropriate service and staffing levels.
15. Serves on a variety of workgroups and committees; prepares and presents committee reports and other documents.
16. Attends and participates in management team meetings at both the campus and department level.
17. Learns and applies emerging technologies and, as necessary, to perform duties in an efficient, organized, and timely manner.
18. Provides a working and learning environment that is free from prohibited discrimination, harassment and retaliation (DHR), and provided by applicable law and College policies. Attends College mandated DHR training and participates in DHR investigations as directed. Assist in providing information and resources to individuals who bring forward DHR complaints and reporting possible DHR complaints to the Director, Equal Employment Opportunity Programs in Human Resources and other appropriate authority as necessary.

Other Duties:

Knowledge Of:

1. Oracle design and development environment.
2. Reporting tools such as Argos and Form Fusion.
3. Complex higher education integrated information systems.
4. Database Functions, Triggers, and Views.
5. Relational Database programming, reporting, and Open Database Connectivity (ODBC) data access.
6. Complex relational database management systems (RDBMS).
7. Principles and techniques of web-based systems accessing RDBMS data.
8. Procedural Language/Structured Query Language (PL/SQL), Structured Query Language (SQL) Plus, Computer Generated Imagery (CGI), Common Business Oriented Language (COBOL), C and/or C++, UNIX, and client/server systems.
9. Specific UNIX procedures/commands related to RDBMS analysis and programming.
10. Ellucian Banner Software, Security, Naming Conventions, and Functionality.
11. Open Systems Interconnection (OSI) Model.
12. Security procedures and processes in a RDBMS environment.
13. Principles and techniques of structured systems analysis and design.
14. Operation and capabilities of computer equipment.
15. Oral and written communication skills - both technical and end-user related.
16. Theories, principles, and methods of standard project design, methodology, analyses, evaluation, documentation and reporting.
17. Principles of database structures and management, computer programming, and systems development.
18. Modern office practices, methods, and computer equipment and applications related to the work.
19. Principles and practices of employee leadership, management and supervision, including work planning, assignment, review and evaluation, discipline, and the training of staff in work procedures.
20. Principles and practices of program development and administration.
21. Record keeping principles and procedures.
22. Applicable federal, state, and local laws, regulatory codes, ordinances, and procedures relevant to assigned area of responsibility.
23. Research methods and technical documentation writing.
24. English usage, grammar, spelling, vocabulary, and punctuation.
25. Techniques for providing a high level of customer service by effectively dealing with the public, vendors, students, and College staff, including individuals of various ages, disabilities, socio-economic and ethnic groups.

Skills and Abilities:

1. Work effectively in a leadership role as part of a technical team.
2. Develop and coordinate a comprehensive College-wide training program in software and systems applications.
3. Supervise, train, plan, organize, schedule, assign, review, and evaluate the work of staff.
4. Participate in the development and administration of goals, objectives and procedures.
5. Inspect the work of others and maintain established quality control standards.
6. Identify and implement effective course of action to complete assigned work.
7. Analyze and evaluate user needs and create, build, and modify forms, documents, and reports for data processing and reporting.
8. Organize and provide leadership to committees and workgroups consisting of a broad range of stakeholders related to ERP configuration.
9. Interpret, apply, explain, and ensure compliance with applicable College standards, policies, and procedures related to assigned area of responsibility.
10. Compose clear and concise correspondence and reports.
11. Establish and maintain a variety of filing, record keeping, and tracking systems.
12. Operate modern office equipment including computer equipment and specialized software applications programs.
13. Assist in developing and implementing programming and documentation standards
14. Organize and prioritize a variety of projects and multiple tasks in an effective and timely manner; organize own work, set priorities, and meet critical time deadlines.
15. Use English effectively to communicate in person, over the telephone, and in writing.
16. Understand scope of authority in making independent decisions.
17. Review situations accurately and determine appropriate course of action using judgment according to established policies and procedures.
18. Establish, maintain, and foster positive and effective working relationships with those contacted in the course of work.

Minimum Qualifications/Education & Experience:

Equivalent to graduation from a regionally accredited four-year college or university with major coursework in computer science, management information systems, or a related field, and three (3) full-time equivalent years of progressively responsible experience in developing technical documentation, and testing systems application software, including management or project management experience.


Preferred Qualifications:

License(s) & Other Requirements:
Employees may periodically be required to operate a vehicle that necessitates possession of a valid California driver’s license. Such employees must have the ability to secure and maintain a valid California driver’s license.

Working Environment:
Incumbents work in an office environment with moderate noise levels, controlled temperature conditions, and no direct exposure to hazardous physical substances. Incumbents may interact with upset staff and/or public and private representatives in interpreting and enforcing departmental policies and procedures.

Physical Demands:
Must possess mobility to work in a standard office and classroom setting and use standard office equipment, including a computer; to operate a motor vehicle and to visit various College and meeting sites; vision to read printed materials and a computer screen; and hearing and speech to communicate in person and over the telephone. This is primarily a sedentary office classification although standing and walking between work areas is required. Finger dexterity is needed to access, enter, and retrieve data using a computer keyboard or calculator and to operate standard office equipment. Positions in this classification occasionally bend, stoop, kneel, reach, push, and pull drawers open and closed to retrieve and file information. Incumbents occasionally lift, carry, push, and pull materials and objects, typically weighting up to 20 pounds.


Instructions re: Confidential Letter of Recommendation:

Conditions of Employment:

Official offers of employment are made by Mt. San Antonio College Human Resources and are made contingent upon Board approval. It is also required that a final offer of employment will only be made after the candidate has successfully been live-scanned and clearance for employment is authorized by Human Resources. Costs for live-scan services shall be borne by the candidate.

Notice to all prospective employees - The person holding this position is considered a ‘mandated reporter’ under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in Administrative Procedure 3518, titled Child Abuse Reporting, as a condition of employment.

As required by the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, the Mt. San Antonio Community College Annual Security Report is available here:

The person holding this position is considered a ‘Responsible Employee’ under Title IX of the Educational Amendments Act of 1972 and is required to report to the College’s Title IX Coordinator all relevant details reported to him or her about an incident of alleged sexual misconduct including sexual harassment, sexual assault, dating and domestic violence and stalking.

Examination Requirements:

Typing Certificate Requirements:

Application Procedure:

Complete application packets will be accepted until the position is filled; however, those submitted by 11:59 p.m. (PST) on March 5, 2018 (Initial Screening Date) are assured consideration.
Applicants must submit all of the following materials online at to be considered for this position:
1. A Mt. San Antonio College online application.
2. A cover letter describing how the applicant meets the required education and experience.
3. A detailed résumé that summarizes educational preparation and professional experience for the position.
4. Three letters of recommendation that reflect relevant experience (do not use social media or professional networks as a means to provide letters of recommendation).
5. College and/or university transcripts showing the awarded/conferred degree are required and must be submitted with the online application by all applicants, including current or former employees of the college, to demonstrate that the required educational qualifications are met. Unofficial transcripts are acceptable at the time of application; however, copies of diplomas are not accepted in lieu of transcripts.

Special Notes:

Please note: A confirmation number will be assigned when your application packet indicates the supplemental questions have been answered and a document has been attached to each required link. Assistance with the online application process is available through the Office of Human Resources at 1100 N. Grand Avenue, Walnut, CA 91789-1399. Human Resources: (909) 274-4225. E-mail: [email protected]

TRAVEL POLICY: Costs associated with travel in excess of 150 miles one way from residence for the purpose of an interview will be reimbursed up to $500 maximum. Relocation costs will be borne by the successful candidate. Travel reimbursement claims must be submitted no later than 30 days following the interview date.


Foreign Transcripts:

Foreign Transcripts: Transcripts issued outside the United States require a course-by-course analysis with an equivalency statement from a certified transcript evaluation service verifying the degree equivalency to that of an accredited institution within the USA. This report must be attached with the application and submitted by the filing deadline.


Human Resources at 1100 N. Grand Avenue, Walnut, CA 91789-1399. Human Resources: (909) 274-4225. E-mail: [email protected]

Selection Procedure:
A committee will evaluate applications, taking into account breadth and depth of relevant education, training, experience, skills, knowledge, and abilities. The screening committee reserves the right to limit the number of interviews granted. Meeting the minimum qualifications for a position does not assure the applicant of an interview. Interviews may include a writing sample, committee presentation, and/or performance test. The committee will recommend finalists to the President/CEO and/or his designee for a second interview. The number of vacancies is dependent on student enrollment, College resources, needs, and Board of Trustees’ approval. The start date will follow Board approval and receipt of live scan clearance.

Special Instructions to Applicants:

To be guaranteed consideration, it is the applicant’s responsibility to ensure that all required materials are received before the initial screening date and time indicated on the job posting. Incomplete application packets will not be considered. All application materials will become College property, will not be returned, and will not be copied. Please visit our employment website at to complete and submit your application for this position.

EEO Policy:
The College is an equal opportunity employer. The policy of the College is to encourage applications from ethnic and racial minorities, women, persons with disabilities, and Vietnam-era veterans. No person shall be denied employment because of race, religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, marital status, sex (gender), age, sexual orientation, or the perception that a person has one or more of these characteristics.

Conflict of Interest:
Conflict of Interest

Cancel RTF Policy:
We reserve the right to reopen, re-advertise, delay, or cancel filling this position.

To apply, visit:





Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 1/18/2018
Application Due: 12/25/2018
Work Type: