Business Analyst/Programmer



Business Analyst/Programmer

Salary

$80,813.32 - $98,448.00 Annually

Location

Costa Mesa, CA

Job Type

Classified Staff

Job Number

D-018-18

Division

District Office

Department

Educational Services

Opening Date

09/08/2017

Closing Date

9/25/2017 12:00 PM Pacific

Definition

Coast Community College District is seeking an application programming professional to administer the ERP production reporting environment. The current system utilizes Evisions' MAPS servers, Argos Report Writer, and Ellucian's Operational Data Store (ODS). A high level of programming skill and performing Business Process Analysis is  required.  Desirable qualifications include experience with Banner ERP, Oracle and MS-SQL databases.

DESCRIPTION: 
Under the direction of the assigned supervisor, oversee and participate in a variety of highly specialized and complex activities involved in the planning, analysis, design, programming, development, modification, maintenance, and implementation of assigned computer systems, databases, software applications and associated peripherals; coordinate projects, services, personnel and communications to meet district technology needs related to system and application development; plan, develop and implement computer programming projects; coordinate implementation of third-party systems; serve as technical expert to assigned departments.
 
EXAMPLES OF DUTIES: Duties may include, but are not limited to, the following:
  1. Work with assigned departments to analyze business processes and implement technology solutions to automate information and workflow; participate in meetings to review and document technology needs; research, recommend, develop and deploy enhancements to improve business efficiencies; receive, respond to, analyze and resolve requests regarding programming issues, system performance, and malfunctions.
  2. Oversee and participate in a variety of highly specialized and complex project development activities including but not limited to planning, design, programming, development, modification and analysis of assigned computer systems, databases, software and applications; establish and maintain computer programming timelines and priorities for assigned complex projects, systems and applications.
  3. Coordinate projects, services, staff and communications to meet district technology needs related to system and application development and ensure smooth and efficient activities; estimate equipment, material, hardware, software, time and cost requirements for projects; monitor, evaluate and adjust activities in response to project progress, needs and issues.
  4. Plan, develop, and implement a variety of computer programming projects; prepare and develop computer system, software and application project plans and specifications in accordance with district and/or department needs; coordinate projects related to complex systems and application development to meet data processing needs, resolve data problems and provide for system enhancements.
  5. Coordinate, oversee and participate in the design, coding, testing and implementation of new system software and applications; lead and participate in the review, analysis and modification of existing systems, software and applications as necessary; ensure new and revised software applications integrate with existing computer systems.
  6. Provide administrative support to management in various areas related to computer system development; confer with staff and administrators to coordinate project timelines, priorities, and status.
  7. Serve as a lead over various projects, assignments and activities related to system and application development, analysis, design, problems and malfunctions; train and provide work direction and guidance to assigned staff; assign duties to other staff, coordinate projects and review completed work for accuracy, completeness and compliance with established standards, requirements and procedures.
  8. Respond to inquiries and provide technical information concerning related software, data, malfunctions, applications, practices, techniques and procedures.
  9. Analyze system performance and ensure proper debugging of software and applications, and detection and resolution of programming errors and miscalculations; lead and participate in the timely troubleshooting and resolution of system, software and application malfunctions; receive, respond to, analyze, and resolve user requests and complaints regarding programming issues and malfunctions.
  10. Ensure proper operation, maintenance and implementation of new and revised systems and applications; oversee the installation, upgrading and configuration of software and applications to enhance and ensure operation of computer systems; monitor and analyze system software and hardware to ensure alignment with application and end user requirements.
  11. Receive, analyze, and coordinate responses to staff and administrative requests for system and application additions, revisions and modifications; confer with technology staff to ensure proper diagnosis and support of system, application and related technology needs; coordinate a response to user emergencies.
  12. Lead and participate in the analysis and testing of vendor computer systems, applications and components; analyze and identify system and application needs and issues; recommend in-house or vendor solutions according to feasibility and compatibility with current systems; coordinate and recommend the purchase of computer systems and applications to enhance district technology operations.
  13. Coordinate and oversee the enhancement and modification of databases to facilitate the collection, management, manipulation, reporting and distribution of computerized data used for analysis; develop and modify database systems to improve and resolve problems with computerized reporting, record-keeping, forms and documents.
  14. Oversee application and related user support functions; coordinate training and assistance to staff regarding system and application operations; oversee and participate in technical assistance services to provide staff with information concerning systems, software, applications and related practices, requirements, procedures and malfunctions.
  15. Oversee and participate in the preparation and maintenance of various records and reports related to projects, computer systems, software, applications, status and assigned activities.
  16. Assist with strategic and financial planning and project coordination.
  17. Develop and coordinate effective system security for assigned computer systems and applications.
  18. Assist in the development of programming and departmental standards; assist in assuring projects and programming activities comply with departmental processes and procedures.
  19. Maintain current knowledge of applicable programming languages and technological advances in computer systems, databases and applications.
  20. Attend and participate in various meetings as assigned.
  21. Perform other related duties as assigned.

Qualifications and Physical Demands

MINIMUM QUALIFICATIONS
 
Knowledge of:
  1. Project management techniques involved in the development and implementation of programming projects.
  2. Best practices and techniques used in programming, development, design, operation, analysis, maintenance, implementation and modification of databases, computer systems, and software applications.
  3. Specialized software applications (i.e., Enterprise Resource Planning, web, and mobile).
  4. Systems integration to ensure compatibility and operational efficiency between databases, systems, and applications. 
  5. System utilities, design, and programming applications, including knowledge of integrated development environments (IDE).
  6. Advanced programming languages and tools to design, code, test, develop, analyze, troubleshoot, and implement new and complex programs, modules, subsystems and applications.
  7. Principles, practices and methods of database structures, online applications, computer programming and system design.
  8. Data warehousing concepts and structures.
  9. Analytical tools to measure hardware, software, and databases to maximize system performance.
  10. Application software lifecycle management.
  11. Data mining, business intelligence, and querying of databases (including data cubes).
  12. Information security laws and standards.
  13. Accessibility requirements and standards.
  14. Security concepts including logical and physical security of databases, systems, applications, and user authentication.
  15. 15.              Principles of training and providing work direction and guidance.
  16. Record-keeping and report preparation techniques.
  17. Oral and written communication skills.
  18. Interpersonal skills using tact, patience and courtesy.
  19. Correct English usage, grammar, spelling, punctuation and vocabulary.
  20. Customer service standards, practices, techniques and procedures.
  21. Business communication techniques.
  22. Appropriate safety precautions and procedures for all job related functions and interactions.
 
Ability to:
  1. Lead complex project implementations; create project development plans and specifications; develop timelines and coordinate project meetings; oversee work of assigned project staff and provide status reports to management.
  2. Oversee and participate in a variety of highly specialized and complex activities involved in the planning, design, programming, development, modification and analysis of assigned computer systems, databases, and software applications.
  3. Coordinate projects, services, personnel and communications to meet technology needs related to system and application development; plan, develop and implement computer programming projects.
  4. Train and provide work direction and guidance to other project staff.
  5. Establish and maintain computer programming timelines and priorities for assigned complex projects, systems and applications.
  6. Develop computer system, software and application project plans and specifications.
  7. Oversee the design, coding, testing and implementation of new software and applications.
  8. Coordinate the review, analysis and modification of existing systems, software and applications.
  9. Investigate, troubleshoot and resolve system and application malfunctions.
  10. Ensure new and revised software applications integrate with existing computer systems.
  11. Coordinate activities to facilitate the collection, management, manipulation, reporting and distribution of computerized data used for analysis.
  12. Analyze, design, develop, program, test, document, implement, and maintain new and complex system programs, modules, subsystems and applications.
  13. Design, code, document, implement, and maintain interfaces between databases and systems.
  14. Analyze, define, and document application requirements for data, workflow, logical processes, programs, interfaces, internal and external security checks and controls.
  15. Design, code, document, implement, and maintain reports and analytical data presentations such as dashboards using business intelligence, database queries (including data cubes), or other advanced technologies.
  16. Remain current with new advances in computer sciences and information technology.
  17. Protect the confidentiality of data in accordance with the state and federal laws and institutional policies and procedures.
  18. Prepare and maintain various records and reports related to systems, programs, projects, status and assigned activities.
  19. Lead and participate in meetings and training sessions as assigned.
  20. Operate a variety of computers, servers, peripherals and specialized software.
  21. Communicate and exchange information with staff and outside agencies to resolve issues or concerns.
  22. Work independently with little direction.
  23. Work on multiple projects simultaneously.
  24. Meet schedules and timelines.
  25. Be flexible with work schedule and assignment.
  26. Communicate effectively both orally and in writing.
  27. Establish and maintain cooperative and effective working relationships with others.
 
Education and Experience:
  1. Bachelor's degree in Computer Science or related field.
  2. Minimum five years of experience involving the analysis, design, programming, development, modification, testing and implementation of computer systems, databases, programs, and software applications.
  3. Minimum three years of experience with project management and conducting business meetings.
  4. Minimum five years of programming experience in languages such as PL/SQL, SQL, C++, Java, .net, PHP, ColdFusion, XML, and/or HTML;
  5. Highly proficient with Oracle and SQL databases.
  6. A proven track record of related project implementations and accomplishments.
  7. Or, any combination of education and experience that meets the required equivalent qualifications for this position.
 
DESIRABLE QUALIFICATIONS:
 
  1. Experience working with Ellucian Banner Enterprise Resource Planning System.
  2. Experience working with SharePoint.
  3. Conducting or participating in a Business Process Analysis (BPA) to improve system and operational effectiveness/efficiencies.
  4. Experience administering production reporting environments utilizing MAPS/Argos and ODS or similar platforms.
 
LICENSES AND OTHER REQUIREMENTS:
  • Valid California driver's license and ability to drive personal or District vehicle to conduct work.
  • Travel to and from district sites to perform work as required.

Conditions of Employment

This is a full-time, 12-month per year classified position. The District reserves the right to extend, modify, or eliminate this position based upon available funds. The normal hours of work will be 8:00am to 5:00pm, Monday through Friday, with some flexibility required to meet the needs of the department. The effective date of employment will be arranged with the supervisor.

  • Regular attendance is considered an essential job function; the inability to meet attendance requirements may preclude the employee from retaining employment.
  • 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 Coast Community College District policies, procedures, and Title IX. (Reference: BP/AP 5910).
  • The Coast Community College District celebrates all forms of diversity and is deeply committed to fostering an inclusive environment within which students, staff, administrators, and faculty thrive. Individuals interested in advancing the District's strategic diversity goals are strongly encouraged to apply. Reasonable accommodations will be provided for qualified applicants with disabilities who self-disclose.
PAY PHILOSOPHY: Starting salaries for support staff positions begin at Step-1 of the salary range. All movement on the salary schedule will occur July 1 of each year for all classified employees.

Additional Information

ADDITIONAL INFORMATION:
ATTENTION: Before applying, please be sure to review the Coast Colleges District Board Policy
regarding Nepotism (BP 7310) to check if your application may be impacted. If you have any
questions, please contact HR Recruitment at 714-438-4714 or 714-438-4716.

APPLICATION REQUIREMENTS: To be considered for this opportunity, you must submit a
COMPLETE application packet. A complete application packet includes:
1. A complete Coast Community College District Online Employment Application.
2. A current resume (uploaded as a separate attachment - PDF recommended).
3. A cover letter highlighting your skills and experience relevant to educational research,
particularly on student equity (uploaded as a separate attachment - PDF recommended).
4. Answers to all supplemental questions (please provide clear and detailed responses as they will be carefully evaluated to determine the most qualified candidate(s) to be invited for an
interview; please do not paste your resume, or put "see resume" or "N/A").

Submission of all required application information and materials is the responsibility of the applicant.

APPLICATION PROCEDURES:
Applications must be received no later than the posted closing date. There are NO EXCEPTIONS.
Electronic applications may be completed by visiting www.cccd.edu/employment. Once you have
completed an electronic application, you may apply to open positions within the Coast Community
College District by submitting the application and all other required materials. Required materials differ for each open position and must be complete when submitted for a specific posting. Instructions for completing applications and applying to posted positions are available online or by calling Applicant Processing at (714) 438-4714 or (714) 438-4716.

Information for TDD users is available by calling (714) 438-4755.

All applications will be screened under a process of utmost confidentiality by a committee of
representatives from the college community. All application materials become the property of the
Coast Community College District and will NOT be copied or returned. Any documents that you are unable to attach can be faxed to (714) 782-6065. Faxes must clearly indicate your name and the job to which you are applying.

To ensure consistency and fairness to all applicants, please do not submit materials in addition to
those requested. Additional materials will not be considered or returned. Be sure to complete all
questions and sections of the application. For questions which may not apply, indicate "n/a" (not
applicable). If you do not know an answer, please indicate so, but do not leave any space blank.

Disability Accommodations:
If you require accommodations in the Application or Examination Process, please notify Human
Resources by calling (714) 438-4714 or (714) 438-4716.

SELECTION PROCEDURES:
1. All online applications and required materials received by the deadline date will be screened to
determine which applicant(s) meet(s) the minimum qualifications as stated in the job
announcement. Please note: Possession of the minimum qualifications does not ensure an
interview.

2. Applicants who meet the required qualifications and who are also deemed to possess the highest degree of desirable qualifications will be invited to discuss their qualifications in an
interview with the College/District. Therefore, it is required that applicants submit clear,
detailed responses to all supplemental questions in order to demonstrate his/her qualifications
as related to the position.
3. If any travel is required for an applicant to participate in-person during the interview process,
this will be done so at the candidate's own expense.

WORK ENVIRONMENT AND PHYSICAL DEMANDS:
1. The physical demands are representative of those that must be met by an employee to
successfully perform the essential functions of this job.
2. The work environment characteristics are representative of those an employee encounters while performing the essential functions of this job.
3. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
4. A detailed list of physical demands and work environment is on file and will be provided upon
request.

The Coast Community College District is a multi-college district that includes Coastline Community College, Golden West College, and Orange Coast College. The three colleges offer programs in transfer, general education, occupational/technical education, community services and student support services. Coastline, Golden West and Orange Coast Colleges enroll more than 60,000 students each year in more than 300 degree and certificate programs.
Since its founding in 1947, the Coast Community College District has enjoyed a reputation as one of the leading community college districts in the United States. Governed by a locally elected Board of Trustees, the Coast Community College District plays an important role in the community by responding to needs of a changing and increasingly diverse population.

Coast Community College District is an Equal Opportunity Employer
The Coast Community College District is committed to employing qualified administrators/managers, faculty, and staff members who are dedicated to student learning and success. The Board recognizes that diversity in the academic environment fosters awareness, promotes mutual understanding and respect, and provides suitable role models for all students. The Board is committed to hiring and staff development processes that support the goals of equal opportunity and diversity, and provide equal consideration for all qualified candidates. The District does not discriminate unlawfully in providing educational or employment opportunities to any person on the basis of race, color, sex, gender identity, gender expression, religion, age, national origin, ancestry, sexual orientation, marital status, medical condition, physical or mental disability, military or veteran status, or genetic information.

Comprehensive Medical, Dental and Vision
We know that the health of our employees and their families is a priority. That's why we offer extensive health care benefits to benefits-eligible employees. We offer the District's PPO plan as well as two HMO's, United Health Care and Kaiser Permanente. We also provide District-paid dental and vision insurance. 

Benefits are available to regular permanent employees working 20 or more hours per week.  Benefits are not available to temporary or short term employees.

District-paid Life Insurance
The District provides Life and Accidental Death & Dismemberment insurance benefits, underwritten by ING. This District-paid benefit is equal to one time your annual salary and remains in effect until age 70.

District-paid Disability Benefits
Coast provides both short and long term disability benefits for eligible employees unable to work because of disability due to illness, injury, or maternity.

Voluntary Plans
A variety of voluntary plans are offered through the District to benefits-eligible employees such as Long Term Care, Hyatt Legal, and Section 125 compliant flexible spending accounts.

Enrich Your Profession
Professional Development Programs
The District offers a variety of Professional Development programs for faculty and classified staff that encompasses all types of facilitated learning opportunities, ranging from college degrees to formal coursework and conferences. We encourage lifelong learning that maintains and improves professional competencies, enhances career progression, and keeps our employees on the cutting edge of their profession.

Sabbatical Leaves
Faculty members are encouraged to pursue professional growth leading to the development of increased competence and the improvement of instruction and/or redirection in their current teaching discipline. The District's sabbatical leave program is designed to assist in this pursuit and is available on a semester basis after completing six consecutive years of service.

Academic Senate
The Academic Senate is the governing body at each of our colleges for making recommendations to administration and to our Board of Trustees with respect to academic and professional matters. The Senate consists of elected faculty and has the responsibility for matters related to curriculum and general academic policy.

Time to Refuel
Vacation
Classified, contract staff earn vacation days commensurate with years of service. Classified Management and Administrators earn 22 days vacation per year.

Sick Leave
All contract employees earn sick leave as outlined in the CA Education Code. Sick leave may be carried over from year-to-year and, upon retirement, unused sick leave may contribute to your PERS and STRS retiree benefit.

Holidays
The District observes 21 paid holidays per year.

Jury Duty, Bereavement, Military Leave
Coast grants contract employees called to jury duty a leave of absence, without loss of pay, for the entire length of required service. Other available leaves include bereavement from 3-5 days and military leaves of absence in accordance with applicable state laws.

Great Expectations
Pension Plans
The District participates in the California State Teachers Retirement System (CalSTRS) and the California Public Employees Retirement System (CalPERS) for contract employees. Non-contract employees participate in Public Agency Retirement Services (PARS) plan for the first 1,000 hours of their employment.
Additionally, it is the policy of the Coast Community College District that contract employees who retire from the District with ten or more years of service be afforded the same group insurance benefits until 70 years of age. A Medicare Supplement or GAP plan  is available to retirees and their spouses after age 70.

Annuities
The District maintains a program whereby qualified employees may request through Payroll to have a portion of his or her salary deposited under a tax sheltered annuity plan or an approved deferred compensation plan.

Schools First Federal Credit Union

The Schools First Federal Credit Union is a federally insured, full service, financial cooperative that is a not-for-profit organization. Earnings are used to benefit all members to provide a full range of financial services and offerings.


01
I understand that a COMPLETE application packet is required for consideration, which includes the following: 1. A completed Coast Community College District Online Employment Application 2. A current resume (uploaded as a separate attachment - PDF recommended) 3. A cover letter (uploaded as a separate attachment - PDF recommended) 4. Clear and detailed responses to all supplemental questions (required for evaluation purposes)
  • Yes
  • No
02
Describe your experience administering an ERP reporting environment.
03
Describe your experience administering data warehouses or operational data stores.

Required Question

Agency
Coast Community College District
Address
1370 Adams Avenue

Costa Mesa, California, 92626
Phone
714-438-4668
714-438-4714