Salary: $6,939.98 - $7,651.36 Monthly Location : Glendale, CA Job Type: Classified Job Number: 00980-2024 Department: Information Technology Services Opening Date: 10/23/2024 Closing Date: Continuous Description Definition Under direction, performs technical information systems analytical and programming duties, including analysis, development, coding, testing, and documentation of computer applications; researches and evaluates current business functions with new and existing information systems, including Enterprise Resource Planning (ERP) systems; develops design specifications for data structures, queries, reports, workflows, interfaces, and processes; designs and builds database structures; tests systems, upgrades, and patches and creates test data; troubleshoots information system problems; participates in developing and implementing user software related to ERPs systems and third-party applications; provides technical support and problem resolution to end users; and performs other related duties as assigned. Supervision Works under the direct supervision of the department manager. Does not directly or indirectly supervise other employees but may provide work direction to lower-level employees, temporary employees, and/or student workers. Work Schedule 40 hours per week, 12 months per year Monday-Friday 8:00am-4:30pm Examples of Duties ESSENTIAL DUTIES AND RESPONSIBILITIES: The following duties and responsibilities are typical of those performed in this classification.
- Performs technical information systems analytical and programming duties; including analysis, development, coding, testing, and documentation of computer applications
- Researches and evaluates current business functions with new and existing information systems, including ERP systems.
- Develops design specifications for data structures, queries, reports, workflows, interfaces, and processes.
- Designs and builds database structures, including tables and relationships between fields based on design specifications to ensure data integrity; develops and programs data-sharing interfaces between applications to maintain data integrity across systems; creates, maintains, and schedules processes, procedures, and triggers to update and manipulate data.
- Tests systems, upgrades, and patches and creates test data; works with end-users to develop and implement test plans and scripts; reviews the results and makes appropriate revisions to eliminate errors and/or enhance system performance.
- Analyzes and troubleshoots information system and application problems; may recommend and assist in the implementation of user solutions for software applications.
- Writes and maintains technical documentation detailing system workflows, data structures, interfaces, processes, procedures, forms, and reports; designs and builds forms, reports, views, and graphical user interfaces (GUIs) based on business needs and reporting requirements.
- Maintains programs by reviewing audit logs, confirming regularly scheduled operations, and troubleshooting and correcting code as necessary.
- Provides technical support and training to information technology support staff and end-users, resolving problems and advising on system and application operations and functionality.
- Compiles, creates, prepares, and submits periodic reports for users and management; extracts data from ERPs and other application.
- Participates in developing and implementing user software related to ERP systems and third-party applications.
- Assists in ensuring data security.
- May provide work direction to lower-level employees, temporary employees, and/or student workers.
- Performs other related duties as assigned.
Minimum Qualifications MINIMUM QUALIFICATIONS The education, training, and experience qualifications are considered likely to provide the required knowledge and abilities to perform the above essential duties. Education and Experience A Bachelor's degree from an accredited college or university. Three (3) years of applications programming and analysis experience. Licenses/Certifications/Other Requirements None. Knowledge of:
- Principles and methods of planning, analyzing, designing, functioning, and structuring information systems, relational databases, and applications, including systems integration and business process and relationship analysis tools.
- Characteristics, use, capabilities, and limitations of information systems and related equipment and hardware.
- Functions, capabilities, characteristics, limitations, and use of common operating systems (e.g., Windows, Linux, UNIX, IOS, etc.),ERP applications, and office software.
- Principles and concepts of structural and object-oriented programming, including tools, design, and analysis; programming theory, methods, and applicable languages (e.g., JavaScript, HTML, HTML5, XML, ASPX, COBOL, PeopleCode, PL/SQL).
- Technical and functional specifications and their application in structured programming.
- The use of document management and storing systems.
- Industry best practices regarding program development techniques, procedures, tools, documentation requirements, and evolving information system technologies.
- Program troubleshooting and analysis techniques, including debugging and testing, and data variation implications.
- Procedures for acceptance testing and validation of programs.
- Laws, regulations, standards, and/or requirements applicable to areas of assignment.
- Methods of prioritizing, planning, and organizing work.
- Standard office practices or procedures.
- Correct use of the English language, including spelling, punctuation, and grammar.
- Principles and practices of customer service.
Ability to:
- Develop and apply information systems solutions in various operations.
- Analyze user-provided information to discern business problems and needs and translate them into programming solutions.
- Analyze technical problems and data to troubleshoot and debug code and system problems.
- Use information systems and related equipment and hardware.
- Apply program development techniques, procedures, tools, and documentation requirements.
- Use evolving computer languages, data security requirements, and troubleshooting and analysis techniques.
- Identify and understand the implications of anomalies in datasets.
- Follow coding standards while developing programs for ERPs and other applications.
- Create complex forms, reports, interfaces, views, packages, triggers, and stored procedures for ERPs and other applications.
- Reason logically to foresee problems and develop and evaluate alternative solutions.
- Provide technical assistance and training to end-users and information technology support staff.
- Research, apply, and explain the laws, regulations, policies and/or procedures applicable to the area of assignment.
- Operate a variety of office equipment including computers and printers/copiers.
- Maintain confidentiality of sensitive and/or protected information.
- Prepare reports, correspondence, and other documents using multiple business formats.
- Prioritize work and complete assignments accurately and within established deadlines.
- Provide and obtain detailed information to/from others.
- Provide customer service with a high level of sensitivity, tact and patience.
- Exercise reasonable judgment in performing job duties.
- Work and perform duties independently.
- Perform and prioritize multiple tasks.
- Communicate effectively, both orally and in writing.
- Establish and maintain cooperative and effective working relationships with all employees and others encountered in the course of work.
- Demonstrate a sensitivity to, and understanding of, the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds of community college students.
PHYSICAL AND MENTAL STANDARDS The following physical and mental standards are identified as necessary to perform the essential duties and responsibilities. However, reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the position.
- Mobility: frequent sitting for long periods; occasional kneeling, crouching, pushing, pulling, walking, and standing; occasional reaching above and below desk level.
- Dexterity: frequent fine manipulation sufficient to operate a computer keyboard; frequent grasping to handle individual papers, write and take notes; and feel individual objects.
- Lifting: frequent lifting of papers, files, equipment, and materials weighing up to 10 pounds; occasional lifting up to 25 pounds.
- Visual Requirements: frequent use of vision sufficient to read files, documents, and computer screens and do close-up work.
- Hearing/Talking: frequent hearing and speaking in person and on the telephone.
- Emotional/Psychological Factors: frequent contact with others, including extensive public contact; frequent deadlines and time-limited assignments.
ENVIRONMENTAL CONDITIONS
- Work is primarily performed in a standard office or other indoor environment.
- May be required to respond to emergencies pertaining to information technology.
Additional Information The Programmer Analyst salary range is currently R 44. Starting salary: Step 1 $6939.98to Step 3 $7651.36 per month, based on training and experience. Salary range: Step 1- $6939.98 to Step 10- $10971.24 per month (including longevity steps.) Application ProcessThis position requires the following documents to be attached to your online application in order to be considered:
- Resume
- Scanned copy of official transcripts showing completion of required degreed. Unofficial transcripts will be accepted only during the application process. Foreign transcripts and degrees require official certification of equivalency to U.S. transcripts and degrees by a certified U.S. review service at the time of application.
Please note: Applicants must attach all required documents to the online application by the closing date. Documents submitted after the closing date will not be accepted. Applications will be accepted until the position is filled. First review: November 15, 2024. Applications with incomplete information (i.e. statements such as see resume ) or missing documents will not be reviewed. Selection Process All completed applications and application materials will be screened to ensure that the minimum requirements stated in the job announcement are met. Those candidates who meet the minimum qualifications will be invited to the college for an interview. All candidates will be notified of their final disposition in the selection process. Position Funding This position is offered contingent upon funding. GCCD reserves the right to extend, withdraw, and/or reopen this position at any time. Additional openings, for the same position, which become available prior to the end of the hiring process may be filled by qualified applicants that applied to this job announcement. Commitment to Diversity and Equal Employment Opportunity Employer GCCD is committed to employing administrators, faculty, and staff members who are dedicated to student success. GCCD recognizes that diversity in the academic environment fosters cultural awareness, promotes mutual understanding and respect, and provides suitable role models for all students. GCCD is committed to hiring processes that support equal opportunity, diversity, and provide equitable consideration for all candidates as required in federal and state law. To find out more about GCCD, please visit our website at glendale.edu. Accommodations If accommodations are needed for the application process in compliance with the Americans with Disabilities Act, please inform Human Resources. Thank you for your interest in employment opportunities with Glendale Community College. Robust and comprehensive health and welfare package for eligible employees, which may include:
- Medical, vision, and dental plans for employee and eligible dependent(s),
- Basic life insurance,
- Supplemental life insurance,
- Various optional insurance plans (short term disability, accident, critical care, and hospital),
- Flexible spending account,
- Defined-benefit retirement plan participation through CalPERS or CalSTRS,
- Optional 403(b) and 457 retirement plans,
- Paid sick leave,
- Paid vacation (classified staff and administrators), and
- Paid District holidays Note: Substitutes, Professional Experts and Police Cadets are temporary positions and are not eligible for District benefits. For information on GCCD's benefits package, please visit Administrative Services, Fiscal Services.
01 I have attached my resume. If you have not, please return to your application and attach your resume.
02 I have attached my transcripts showing the required degree(s). Note: Foreign transcripts and degrees require official certification of equivalency to U.S. transcripts and degrees by a certified U.S. review service at the time of application. If you have not attached your transcripts, please return to your application.
03 I understand that my application will be considered incomplete if any required sections of the application are not completed and/or if any documents that are required are not attached to my online application by the first review date.
04 I have completed all sections of the application. (Statements such as see resume will not be acceptable.)
05 I have provided current contact information for a minimum of three (3) professional references including at least one (1) supervisor.
Required Question