Technical Data Specialist

Salary: $55,536.00 - $76,572.00 Annually

Job Type: Classified

Job Number: 2020-01688

Location: Moorpark College (Moorpark CA), CA

Department: MC - Business Services

Closing: 5/28/2020 11:59 PM Pacific

Under the general direction of an assigned supervisor, plan, write, and maintain a variety of databases, data analysis, and reporting programs for District reporting and data tracking needs; coordinate and support electronic processing of instructional, college reporting, and/or financial aid data; evaluate and analyze data to ensure accuracy and integrity.

Moorpark College is located 15 minutes from the San Fernando Valley and is one of the most beautiful community colleges in California. Moorpark College opened in 1967, serves approximately 15,000 students, and with a "students first" philosophy, empowers its diverse community of learners to complete their goals for academic transfer, basic skills, and career education.

The Financial Aid Office is comprised of dedicated financial aid professionals committed to serving students and provide them information to secure the necessary financial resources to meet their educational objectives.

More information about Moorpark College: https://www.moorparkcollege.edu/

More information about the Financial Aid Department: https://www.moorparkcollege.edu/departments/student-services/financial-aid-office

Ventura County Community College District (VCCCD) is a public community college district serving residents throughout Ventura County. VCCCD's three colleges - Moorpark College, Oxnard College, and Ventura College - offer programs for transfer to four-year colleges and universities; career technical training; basic skills instruction; as well as community service, economic development, and continuing education for cultural growth, life enrichment, and skills improvement.

Plan, design, and create new databases for data collection, analysis and reporting for college and district administration; consult with Information Technology staff to create views for data extraction. E

Retrieve information from databases for a variety of purposes; access data in desired format for projects using open database connectivity (ODBC) enabled products. E

Review and evaluate software packages to enhance production or representation of information pertinent to instructional and/or financial aid, district reporting, and institutional research; coordinate, troubleshoot and report problems with software. E

Create report designs; program and run complex reports to extract data from database systems for a variety of purposes, including instructional, financial aid, District reporting, and/or institutional research; design applications to generate reports or graphs to display information as necessary. E

Receive and log data extract/report requests for institutional research data, financial aid data, instructional data, or data utilized for other District reporting purposes; coordinate with multiple users regarding specific needs. E

Coordinate with Information Technology, institutional research staff, and the colleges to facilitate the resolution of database system issues and the development of new/modified database processes and reporting requirements; execute, coordinate, and oversee new technology initiatives. E

Develop and oversee the maintenance of data utilized by the District; ensure integrity and functionality of data reporting systems; coordinate public website and student portal updates. E

Test and debug applications to ensure accuracy of data and write related application documentation, including system upgrade testing and end-user documentation. E

Provide training and technical assistance to users regarding a variety of system upgrades and/or modifications, such as Banner Financial Aid processes and procedures and/or Banner student processes. E

Design and maintain the process to download and create the schedule of classes for publication.

Assist in development of algorithms, routines, scripts, and SQL queries for programming interfaces between multiple data sources; develop data extracts, data normalization processes, and merge routines for MIS, Clearinghouse, and other District-critical reports.

Assist in the review, analysis, and compilation of data for a variety of State and federally mandated programs, activities, and reporting requirements, such as Management Information Systems (MIS), Clearinghouse, Integrated Postsecondary Education System (IPEDS).

Assist college staff to ensure successful input of instructor assignments, load, part-time and extra-hourly data.

Maintain current budget information; monitor budget expenditures; assist in budget preparations.

Perform related duties as assigned.

E = Essential Duties

Education:

12 units of college-level coursework in computer information systems or a related field. Specific coursework in SQL, SQL-Plus, or other relational database programming language is preferred.

Experience:

Three years of experience as a reporting/database specialist in a networked environment, including experience using reporting tools and ODBC in an RDBMS application environment.

This is an examination open to the public and current district employees seeking a promotional opportunity. To ensure consideration, please submit your application materials by May 28, 2020.

The examination process will consist of any of the following components:

A) Evaluation of Training and Experience (T&E) = Qualifying (pass/fail)

B) Technical Interview = 100% weighting on final score

Applicants must meet minimum qualifications stated by the filing deadline in order to move forward in the testing process. Those candidates who meet the minimum qualifications will have their application materials reviewed during a Training and Experience Evaluation (T&E). A T&E is an assessment of training and experience that has prepared the candidate for the position. The nine (9) candidates with the highest passing scores on the T&E will be invited to the technical interview. The examination process is subject to change as needs dictate. All communication regarding this process will be delivered via email.

Date Range: Monday, June 1, 2020 to Friday June 5, 2020

Date Range: Monday, June 15, 2020 to Friday, June 19, 2020

Location: Ventura County Community College District

761 E. Daily Drive, Suite 200

Camarillo, CA 93010

The above dates are subject to change. Candidates will be notified of any scheduling changes via email.

ONCE YOU HAVE SUBMITTED YOUR APPLICATION YOU WILL NOT BE ABLE TO MAKE REVISIONS TO YOUR APPLICATION MATERIALS.

When completing the application, please make sure you include ALL current and previous employment in the Work Experience section of the application and complete ALL fields, including the name and contact information for your supervisors.

When completing the application and the supplemental questionnaire (if applicable), outline in detail your education, training (such as classes, seminars, workshops), and experience. Please be sure to answer every component of each supplemental question as your responses will be scored and serve as your score on the training and experience (T&E) evaluation. Advancement to the next step of the examination process will be limited to the candidates with the highest T&E scores.

All required documents must be submitted by the applicant. Human Resources Department staff will not upload your documents for you. The VCCCD does not accept letters of recommendation for classified positions. Please do not attempt to attach letters of recommendation to your application.

Upon completion of the examination, the eligibility list will be compiled by combining the final examination score with applicable seniority and veteran's credits, if any. The candidates will be ranked according to their total score on the eligibility list. Certification will be made from the highest three ranks of the eligibility list. This eligibility list will be used to fill current vacancies for up to one year from the date of the technical interview.

All appointments made from eligibility lists for initial appointment or for promotion, with certain exceptions, shall be probationary for a period of six (6) months or one hundred thirty (130) days of paid service, whichever is longer. Classified management, police, and designated executive classifications shall be probationary for a period of one (1) year of paid service from initial appointment or promotion.

Individuals with disabilities requiring reasonable accommodation in the selection process must inform the Ventura County Community College District Human Resources Department in writing no later than the filing date stated on the announcement. Those applicants needing such accommodations should document this request including an explanation as to the type and extent of accommodation needed to participate in the selection process.

If you have a foreign degree and the institution from which your degree was granted is not recognized as accredited by the Council for Higher Education Accreditation (CHEA) or the U.S. Department of Education, foreign transcript evaluation is required if the foreign degree/coursework is used to meet minimum qualifications. The foreign transcript evaluation must be included with your application materials. To search institutions that are recognized as accredited by CHEA or the U.S. Department of Education, visit http://www.chea.org/search/search.asp or http://ope.ed.gov/accreditation/search.aspx. For a list of recognized organizations providing transcript evaluation services, visit http://www.naces.org/members.htm.

The Ventura County Community College District is committed to the principles of equal employment opportunity. It is the District's policy to ensure that all qualified applicants for employment and employees have full and equal access to employment opportunities and are not subjected to discrimination in any program or activity of the District on the basis of ethnic group identification, race, color, national origin, religion, age, sex, physical disability, mental disability, ancestry, sexual orientation, language, accent, citizenship status, transgender status, parental status, marital status, economic status, veteran status, medical condition, or on the basis of these perceived characteristics, or based on association with a person or group with one or more of these actual or perceived characteristics.