Systems Analyst/Programmer (initial screening date extended)

Job description

Position Information

Position Information

Job Title: Systems Analyst/Programmer (initial screening date extended) Position Number: 201314814 Department: Information Technology Job Category: Classified Unit A Time (Percent Time): 100% Term (months/year): 12 months/year Current Work Schedule (days, hours): Monday - Friday, 7:30 a.m. - 4:30 p.m. Salary Range: A-124 Salary: Steps 1 - 6, $78,079 - $99,651 annually Shift Differential: Open Date: 04/24/2018 Initial Screening Date: 01/02/2019 Open Until Filled: Yes Application Procedure:

Complete application packets will be accepted until the position is filled; however, those submitted by 11:59 p.m. (PST) on January 2, 2019, 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 (3) 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 (if applicable) 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.

Health & Welfare:

College contributes $10,946 toward annual premium 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.

Basic Function/Overview:


Under general supervision, performs a variety of application development and analysis functions of the assigned department’s technology and application systems; creates business processes to meet end user requirements and Federal, State, District, local, and department regulatory mandates, rules, regulations, policies, and procedures; evaluates and personally participates in the functions necessary to implement and sustain the creation, maintenance, and use of assigned department’s databases and applications; tests and maintains data analysis and reporting programs to enhance and support reporting requirements and data tracking needs; coordinates work and services with central Information Technology Department and other staff; Performs routine to complex technical support, analysis, and programming to ensure complete and appropriate use of the District’s administrative and student systems.


Receives general supervision from the Dean of the assigned department. Exercises no direct supervision of staff. May provide technical and functional to student workers.


This is a single-position professional-level analyst classification that performs a variety of business process analysis, system application, and reporting activities. Incumbents exercise a high level of discretion and independent judgment in performing the full range of routine and complex assignments. Successful performance of the work requires thorough knowledge of database applications and basic knowledge of the District’s information systems infrastructure. This class is distinguished from other information technology classes by the level of specialized technical knowledge of and emphasis on assigned department’s software and database applications.

Essential Duties/Major Responsibilities:

1.Designs business processes for the maintenance, access, and retrieval of assigned department’s data; prepares detailed flow charts and diagrams outlining system capabilities and processes; defines data rules and relationships and develops methods for quality control of the database system; reviews and evaluates database access and reporting software applications to streamline and enhance the assigned department’s enterprise system; creates documentation of processes.
2.Troubleshoots, updates, modifies, and analyzes information systems to ensure compliance with regulatory needs and changes.
3.Designs methods and applications to import/export data for analysis; uses various reporting tools and database applications to retrieve information from databases for assigned department’s staff and other staff as needed; determines required data and presentation formats.
4.Ensures successful storage and retrieval of data across a variety of campus systems; ensures assigned department’s systems interface with other campus systems.
5.Creates complex custom queries and programs for a variety of assigned department’s management needs and reporting requirements; creates queries to analyze and identify data integrity issues.
6.Monitors and maintains data integrity of assigned department’s tables, fields, reports, and related systems; works with central information technology to execute scripts to correct data issues.
7.Provides expert technical assistance and training for assigned department’s staff on system procedures, system integration, data integrity, and reporting.
8.Plans, designs, and creates new databases for data collection, analysis, and reporting.
9.Installs and configures database access applications and troubleshoots database connectivity issues.
10.Consults with information technology staff to create views and data blocks for data reporting and extraction.
11.Coordinates with information technology, finance, and other college staff to facilitate the resolution of implementing and scheduling new and/or modified business processes and the development of new modified database processes and reporting requirements.
12.Acts as the first-line contact person for assigned department’s staff for technical assistance with admissions and records student module system for testing, troubleshooting, and problem resolution.
13.Tests and debugs applications to ensure accuracy of data and write related application documentation, including system upgrade testing and end-user documentation.
14.Communicates with personnel and various outside agencies as needed to exchange information and resolve issues or concerns.
15.Participates with end users and information technology in designing, testing, and implementing new computer programs as appropriate, including developing and maintaining related documentation.
16.Learns and applies emerging technologies and, as necessary, to perform duties in an efficient, organized, and timely manner.
17.Creates complex custom queries and programs for a variety of needs and reporting requirements; creates queries to analyze and identify data integrity issues and debugs applications to ensure accuracy of data; Designs methods and applications to import/export data for analysis.

Other Duties:

Performs other related duties as assigned.

Knowledge Of:

1.Data systems concepts and structures, reporting relationships, data analysis methods, design, practices, and procedures.
2.Principles and practices of programming and application generation tools.
3.Various software packages including word processing, spreadsheet, data and database management, reporting tools, and desktop publishing applications and programs.
4.Basic data management, data extraction, and relational database systems theory, principles, techniques, and practices.
5.Research and reporting methods, techniques, and procedures.
6.Principles and practices of data collection and report preparation.
7.Applicable Federal, State, local, and District policies, codes, regulations, technical processes, and procedures related to the program to which assigned.
8.Modern office practices, methods, and computer equipment and applications.
9.Record keeping principles and procedures.
10.English usage, spelling, vocabulary, grammar, and punctuation.
11.Techniques for providing a high level of customer service by effectively dealing with the public, vendors, students, and District staff, including individuals of various ages, disabilities, various socio-economic and ethnic groups.

Skills and Abilities:

1.Use computer-related programs and software applications related to the area of assignment.
2.Analyze situations and identify and troubleshoot pertinent technical problems/issues; collect relevant information; evaluate realistic options; and recommend/implement appropriate course of action.
3.Develop and implement systems application-related projects with sufficient speed and accuracy.
4.Review, analyze, customize, and implement software packages and database applications related to departmental projects.
5.Develop queries and perform complex analysis of data.
6.Interpret, apply, and explain technical materials to non-technical users; elicit user needs and develop and implement appropriate solutions.
7.Conduct research; analyze, interpret, summarize, and present technical information and data in an effective manner.
8.Make accurate mathematical and basic statistical computations.
9.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.
10.Operate modern office equipment including computer equipment and applications programs.
11.Use English effectively to communicate in person, over the telephone, and in writing.
12.Understand scope of authority in making independent decisions.
13.Review situations accurately and determine appropriate course of action using judgment according to established policies and procedures.
14.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, computer information systems, or a related field and three (3) full-time equivalent years of professional experience in designing, programming, supporting, and implementing database applications that address the specific needs of an assigned area.

Equivalent to an Associate’s degree from a regionally accredited college with major coursework in in computer science, computer information systems, or a related field and five (5) full-time equivalent years of directly related experience, may be substituted for the four-year degree and three (3) full-time equivalent years of experience described above.

Equivalencies: Preferred Qualifications:

Experience in an assigned department at an institute of higher education is desirable.

License(s) & Other Requirements:

Incumbents may periodically be required to operate a vehicle that necessitates possession of a valid California driver’s license. Such incumbents must have the ability to secure and maintain a valid California driver’s license.

Examination Requirements: 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 staff, students, and/or the public in interpreting and enforcing departmental policies and procedures.

Physical Demands:

Must possess mobility to work in a standard office setting and use standard office equipment, including a computer; 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 may be 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 must possess the ability to lift, carry, push, and pull materials and objects up to 20 pounds.

Hazards: 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.

Typing Certificate Requirements: 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 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 start date will be following 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.

Letters of Recommendation
Confidential letters of recommendation are not accepted for this position. All letters of recommendation must be uploaded to the application.

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

Mt. San Antonio College employees and the Board of Trustees members shall not engage in any employment or activity that is inconsistent with, incompatible with, or in conflict with Mt. San Antonio College’s Administrative Procedures (AP 2710 Conflict of Interest, AP 2712 Conflict of Interest Codes).

Cancel RTF Policy:



Quick Link Posting Specific Questions

Required fields are indicated with an asterisk (*).

  1. * The District does not provide sponsorship for authorization to work in the United States. Work authorization should be established at the time of application submission.
    • I understand this statement
  2. * Incomplete applications packets will not be considered. Stating “see resume” on your application will be considered an incomplete response.
    • I understand this statement
  3. * Evidence of minimum qualifications must be established in the online application form. Supporting documents such as cover letter, resume, etc. will not be used for the purpose of determining minimum qualifications.
    • I understand this statement
  4. * Letters of recommendation including confidential letters of recommendation must be received prior to the initial screening date deadline in order for the application to be guaranteed consideration. Applications submitted without letters of recommendation (if required) will be considered incomplete.
    • I understand this statement
Optional & Required Documents Required Documents
  1. Cover Letter
  2. Resume/Curriculum Vitae
  3. Letter of Recommendation 1
  4. Letter of Recommendation 2
  5. Letter of Recommendation 3
  6. Transcripts to Meet Required Qualifications
Optional Documents
  1. Other Document 1
  2. Other Document 2
  3. Other Document 3




Diversity Profile: University



View more

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

Arrow pointing right
Job No:
Posted: 12/25/2018
Application Due: 5/6/2019
Work Type: