Detailed Job Description
The Information Systems Department for the West Valley-Mission Community College District is seeking a talented individual to fill the position of Data Analyst.
Comprised of two colleges, West Valley College and Mission College, we are located in the heart of Silicon Valley. Our staff and faculty are among the most qualified in the state and our students appreciate our two colleges for our friendly staff and supportive atmosphere.
Under the general direction of an assigned supervisor, the Data Analyst will have responsibility for programming, testing, maintaining, documenting and implementing application programs. Investigate complex issues, evaluate alternatives and recommend appropriate solutions. The Data Analyst can act independently on assignments and can assist other programmers in a team environment. Consult with users to determine specific user needs and provide assistance in developing solutions to user needs.
Applicants who possess the knowledge, skills, and life experiences to address the cultural and educational needs of a culturally diverse student population are encouraged to apply.
100% of full time, 37.5 hours per week, 12 months per year, with anticipated start date of March 16, 2016. Schedule may change to include some evening or weekend hours, as needed. This position is a member of the West Valley-Mission Classified Employees Association (WVMCEA), Office, Technical & Business Services Employee Unit.
Work Location: West Valley-Mission Community College District, located on the West Valley College campus, Saratoga, CA.
We have begun a district-wide classification study of all regular, non-faculty staff positions. A classification study is a process of studying, analyzing, and describing the nature and level of work performed by employees. This classification study will ultimately produce uniform job descriptions for every employee.
The classification study will also include a compensation study that will provide information on what other employers pay employees who are performing similar duties. The District will use this information to ensure that our employees are adequately compensated.
The classification study started in November 2014 and is expected to take approximately 12-18 months to complete. As a result of this study, it is possible for the job description and/or compensation to change in this position opening.
Any combination equivalent to:
1. Education – Two-year degree with course work in Computer Science, or a related technical field. Two years of experience during which the applicant has acquired and successfully applied the knowledge and abilities may be substituted for the required education on a year-for-year basis;
2. Experience – One year of increasingly responsible programming experience;
3. Demonstrated ability to effectively work with persons of diverse socioeconomic, cultural, disability, and ethnic backgrounds.
- Knowledge of Data Warehouse systems relevant to the community college environment
- Knowledge of ERP systems relevant to the community college environment
- Knowledge of California Community College MIS laws, codes and regulations
- Ability to use current Business Intelligence software and tools used in data analysis
Examples of Duties and Responsibilities
To perform this job successfully, an individual must be able to perform each essential duty of the position satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions required for the position.
- Using the enterprise software’s Envision programming language, make programming enhancements to existing Application programs based on prioritized work requests from Admissions and Records supervisors, Finance accountants, HR specialists or other key department users. Communicate with users and develop testing procedures for application program changes. Set up test schedules; assist in creating test data and be an active member of the test team. Work with the System Analyst to implement successfully tested programs.
- Accept assigned work orders from the supervisor for the enterprise software reports or downloads. Work directly with users to prepare a detailed draft of the work required. Using the enterprise software’s Uniquery, Unidata or Unibasic, or other reporting tools such as Safari, write programs to comply with assigned work orders. Test the program with the users and get approval for implementation. Document program specifications and run-time user instructions.
- Assist in the testing of new software tools for use in the enterprise software application environment. Train users in the use of a variety of hardware and software tools that satisfy specific application functions; Examples include but are not limited to enterprise software’s printer output options, Uniquery reports tools, User Interface (UI) access to the enterprise software; provide training and technical expertise to users and staff during implementation of new applications.
- Operate computer hardware including mainframe terminals, microcomputers and peripheral equipment; operate utility software support tools including editors, forms design and database query tools. Obtain a thorough knowledge of the enterprise software’s output capabilities including the evision forms processing software. Be able to modify existing applications.
- Attend enterprise software training and consulting classes as needed. Act as an Information Systems representative at user training classes and learn the applications from a user’s point of view. Attend Information Systems specific enterprise software training and be able to modify and test application programs in a test environment.
- Provide technical programming assistance to the ‘help-desk’. Act as a backup to the Information Systems work request tracking system and be able to assist users with the web front-end portion of the help-desk application. Learn to add new users, write work order reports and modify vendor delivered screens based on Information Systems requirements. Attend formal help-desk training as needed.
- Assist in the evaluation of application releases and patches to the enterprise software. Assure integrity is maintained for any change to the production environment. Working in a test environment, test modified applications that are received from the vendors. Make recommendations for releasing application programs to the user community.
- Use data modeling techniques to analyze and specify data usage within an application area; define logical views and physical data structures; assure data integrity and security.
- Provide support, training and service to users for the web applications such as web registration or web help-desk software.
- Analyze user needs and evaluate existing programs and applications; conduct feasibility studies as appropriate; develop requirements specifications; analyze requirements and design program and database solutions to meet requirements.
- Confer with administrators and users regarding desired enhancements and modifications; provide technical expertise and recommend platform, software and hardware issues.
- Install software for production use; write and test job streams and write operations procedures for batch applications; setup appropriate user interface for online applications.
- Evaluate, demonstrate and recommend packaged software solutions to meet District needs; maintain current knowledge of technological developments in the information processing field.
- Assist in systems training and troubleshooting; serve on committees related to information systems and make recommendations concerning hardware and software purchases as requested.
- Design new forms for data input and output and working with the users and other Information Systems staff to implement these new forms.
- Develop web applications, stand-alone applications (e.g. File-Maker pro or Microsoft Access), and/or new applications from enterprise software.
- Perform related duties as assigned.
Any one position may not include all of the duties listed nor do listed examples include all tasks which may be found in positions of this class.
Knowledge and Abilities
- Program coding and testing methodology.
- Various high-level programming languages.
- Structured programming skills including program testing and debugging techniques.
- Principles and techniques of computer programming including basic on-line programming and programming documentation
- Documenting of any program changes and updating user documentation changes.
- Data sharing techniques such as posting documents to a web link or file copies to a shared device (ftp).
- Utility software support tools such as editors, forms design and database query languages.
- Mainframe and microcomputer capabilities, operations, limitations, hardware and software for community college applications.
- Popular Web browsers (e. g. Netscape Navigator, MS Internet Explorer).
- Web application development tools.
- Application Program Development utilizing relational databases.
- Interpersonal, analytical and problem solving skills.
- Oral and written communication skills.
- Apply effective programming methods to existing and new applications.
- Write, debug, test and document new programs, program interfaces and other enhancements to meet user needs.
- Translate programmatic procedures into clear and concise documentation.
- Train and provide technical direction and assistance to users.
- Consult with users, analyze existing hardware, software and networks and develop feasible alternative courses of action.
- Design, program, modify, install, implement and maintain software applications to meet the needs of District faculty, staff and students.
- Analyze situations accurately and adopt an effective course of action.
- Research and compile information.
- Prepare clear and concise written and verbal reports.
- Establish and maintain cooperative and effective working relationships with others.
- Operate modern office equipment such as personal computer and related equipment, copier, automated telephone system and facsimile machine.
- Perform assigned work with speed and accuracy.
- Relate effectively to people of varied academic, cultural and socioeconomic background using tact, diplomacy and courtesy.
- Maintain records and files.
- Meet schedules and timelines.
- Plan and organize time and work effectively.
- Work independently with minimum supervision.
Salary and Benefits
West Valley-Mission Community College District is an Equal Opportunity Employer
- Anticipated Hiring Range: $5,386–$5,888 monthly (WVMCEA Salary Schedule, Programmer Analyst classification, Range 70, Steps A-C).
- Employer-contributed medical, dental and vision for employee, spouse, and/or dependents.
- Employer-paid long term disability for employee.
- Voluntary life insurance.
- 13 paid holidays, plus 1 floating holiday annually; paid non-workdays between Christmas and New Year.
- 10 days vacation leave accrued annually; rate increases step-wise up to maximum 22 days vacation leave accrued annually.
- 12 days sick leave accrued annually.
- Personal necessity leave and personal business leave.
- Educational growth incentive program from $40 to $200 monthly.
- $500 longevity award annually after 10 years of service and $1,000 longevity award annually after 15 years of service.
- CalPERS retirement.
- Position is union affiliated with required dues.