Systems Analyst/Programmer
higheredjobs.com/search/details.cfm
Institution:
Mt. San Antonio College
Location:
Walnut, CA
Category:
Admin - Computing - Programming/Analyst
Posted:
01/19/2018
Type:
Full Time
Systems Analyst/Programmer
Mt. San Antonio College
Job Category: Classified
Employee Group:
Time (Percent Time): 100%
Term (months/year): 12 months/year
Current Work Schedule (days, hours): Monday - Friday, 8:00am - 5:00pm
Salary Range: A-124
Salary: Steps 1 - 6, $6,506 - $8,304 per month
Shift Differential:
1/8
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.
Department: Information Technology
Open Date: 01/17/2018
Closing Date:
Open Until Filled: Yes
Basic Function/Overview:
DEFINITION
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.
SUPERVISION RECEIVED AND EXERCISED
Receives general supervision from the Dean of the assigned department. Exercises no direct
supervision of staff. May provide technical and functional to student workers.
CLASS CHARACTERISTICS
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:
Designs business processes for the maintenance, access, and retrieval of assigned
departments data; prepares detailed flow charts and diagrams outlining system
2/8
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 departments
enterprise system; creates documentation of processes.
Troubleshoots, updates, modifies, and analyzes information systems to ensure
compliance with regulatory needs and changes.
Designs methods and applications to import/export data for analysis; uses various
reporting tools and database applications to retrieve information from databases for
assigned departments staff and other staff as needed; determines required data and
presentation formats.
Ensures successful storage and retrieval of data across a variety of campus systems;
ensures assigned departments systems interface with other campus systems.
Creates complex custom queries and programs for a variety of assigned departments
management needs and reporting requirements; creates queries to analyze and identify
data integrity issues.
Monitors and maintains data integrity of assigned departments tables, fields, reports, and
related systems; works with central information technology to execute scripts to correct
data issues.
Provides expert technical assistance and training for assigned departments staff on
system procedures, system integration, data integrity, and reporting.
Plans, designs, and creates new databases for data collection, analysis, and reporting.
Installs and configures database access applications and troubleshoots database
connectivity issues.
Consults with information technology staff to create views and data blocks for data
reporting and extraction.
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.
Acts as the first-line contact person for assigned departments staff for technical
assistance with admissions and records student module system for testing,
troubleshooting, and problem resolution.
Tests and debugs applications to ensure accuracy of data and write related application
documentation, including system upgrade testing and end-user documentation.
Communicates with personnel and various outside agencies as needed to exchange
information and resolve issues or concerns.
Participates with end users and information technology in designing, testing, and
implementing new computer programs as appropriate, including developing and
maintaining related documentation.
Learns and applies emerging technologies and, as necessary, to perform duties in an
efficient, organized, and timely manner.
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
3/8
Other Duties:
Performs other related duties as assigned.
Knowledge Of:
Data systems concepts and structures, reporting relationships, data analysis methods,
design, practices, and procedures.
Principles and practices of programming and application generation tools.
Various software packages including word processing, spreadsheet, data and database
management, reporting tools, and desktop publishing applications and programs.
Basic data management, data extraction, and relational database systems theory,
principles, techniques, and practices.
Research and reporting methods, techniques, and procedures.
Principles and practices of data collection and report preparation.
Applicable Federal, State, local, and District policies, codes, regulations, technical
processes, and procedures related to the program to which assigned.
Modern office practices, methods, and computer equipment and applications.
Record keeping principles and procedures.
English usage, spelling, vocabulary, grammar, and punctuation.
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:
Use computer-related programs and software applications related to the area of
assignment.
Analyze situations and identify and troubleshoot pertinent technical problems/issues;
collect relevant information; evaluate realistic options; and recommend/implement
appropriate course of action.
Develop and implement systems application-related projects with sufficient speed and
accuracy.
Review, analyze, customize, and implement software packages and database
applications related to departmental projects.
Develop queries and perform complex analysis of data.
Interpret, apply, and explain technical materials to non-technical users; elicit user needs
and develop and implement appropriate solutions.
Conduct research; analyze, interpret, summarize, and present technical information and
data in an effective manner.
Make accurate mathematical and basic statistical computations.
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.
Operate modern office equipment including computer equipment and applications
programs.
Use English effectively to communicate in person, over the telephone, and in writing.
4/8
Understand scope of authority in making independent decisions.
Review situations accurately and determine appropriate course of action using judgment
according to established policies and procedures.
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 Associates 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:
Employees may periodically be required to operate a vehicle that necessitates possession of a
valid California drivers license. Such employees must have the ability to secure and maintain a
valid California drivers 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 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:
5/8
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: http://www.mtsac.edu/safety/pdf/2014ASRFinal.pdf
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 Colleges 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 February 8, 2018, are assured consideration.
Applicants must submit all of the following materials online at http://hrjobs.mtsac.edu 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 rsum that summarizes educational preparation and professional experience for
the position.
4. Two 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.
6/8
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.
THE MT. SAN ANTONIO COLLEGE DISTRICT WILL NOT SPONSOR ANY VISA
APPLICATIONS.
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.
Inquiries/Contact:
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 applicants 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 http://hrjobs.mtsac.edu 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-
7/8
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 RE-OPEN, RE-ADVERTISE, DELAY OR CANCEL FILLING
THIS POSITION.THIS RECRUITMENT MAY BE USED TO FILL FUTURE VACANCIES.
To apply, visit: https://hrjobs.mtsac.edu/
jeid-5289c768d6cfa6439c1ed9ed30f86aeb
It is the policy of Mt. San Antonio College that harassment is prohibited and that all persons shall receive equal
employment and educational opportunities without regard to sex, race, color, ancestry, religious creed, national origin,
age (over 40), medical condition (cancer), mental disability, physical disability (including HIV & AIDS), marital status,
sexual orientation, or Vietnam Era Veteran Status. This nondiscrimination policy covers Family and Medical Care
Leave and Pregnancy Disability Leave. Contact the Office of Human Resources if you need any special
accommodations to complete the application process at 909.594.5611, ext. 4225.
Mt. San Antonio College is an Equal Opportunity Employer
© Copyright 2018 Internet Employment Linkage, Inc.
8/8
