Financial Aid Systems Analyst
Financial Aid Systems Analyst
Mt. San Antonio College
Job Category: Classified
Time (Percent Time): 100%
Term (months/year): 12 months/year
Current Work Schedule (days, hours): Monday - Thursday, 8:00 a.m. - 5:00 p.m.; Friday, 8:00 a.m. - 4:30 p.m.
Salary Range: A-124
Salary: Steps 1 - 6, $78,079 - $99,651 annually
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: Financial Aid, Scholarships, and Veterans
Open Date: 04/02/2018
Open Until Filled: Yes
Under general supervision, performs a variety of application development and analysis functions of the Financial Aid 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 financial aid 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.
SUPERVISION RECEIVED AND EXERCISED
Receives general supervision from the Director, Financial Aid. Exercises no direct supervision of staff. May provide technical and functional direction to student workers.
This is a 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 financial aid software and database applications.
Essential Duties/Major Responsibilities:
1. Designs business processes for the maintenance, access, and retrieval of financial aid 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 financial aid 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 financial aid 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 financial aid systems interface with other campus systems.
5. Creates complex custom queries and programs for a variety of financial aid management needs and reporting requirements; creates queries to analyze and identify data integrity issues.
6. Monitors and maintains data integrity of financial aid 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 financial aid staff on system procedures, system integration, data integrity, and reporting.
8. Plans, designs, and creates new databases for data collection, analysis, and reporting.
9. Consults with information technology staff to create views and data blocks for data reporting and extraction.
10. 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.
11. Acts as the first-line contact person, representing Financial Aid to internal and external staff who need assistance with any enterprise application systems module that integrates with Financial Aid, Scholarships, and Veterans.
12. In collaboration with Information Technology department, tests and debugs applications to ensure accuracy of data and write related application documentation, including system upgrade testing and end-user documentation.
13. Communicates with personnel and various outside agencies as needed to exchange information and resolve issues or concerns.
14. Participates with end users and information technology in testing and implementing new computer programs as appropriate, including developing and maintaining related documentation.
15. Learns and applies emerging technologies and, as necessary, to perform duties in an efficient, organized, and timely manner.
Performs other related duties as assigned.
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 two (2) full-time equivalent years of professional experience in designing, programming, supporting, and implementing enterprise applications for financial aid, admissions, finance, and/or student services.
Experience in student financial aid administration in higher education.
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.
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.
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. Incumbents 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.
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 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:
Complete application packets will be accepted until the position is filled; however, those submitted by 11:59 p.m. (PST) on April 23, 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 resumé that summarizes educational preparation and professional experience for the position.
4. Two (2) letters of recommendation that reflects 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.
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@example.com.
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: 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: firstname.lastname@example.org.
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 http://hrjobs.mtsac.edu 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.
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 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/