Technical Data Specialist
Technical Data Specialist
Salary: $54,180.00 - $74,700.00 Annually
Job Type: Classified
Job Number: 2017-00491
Location: Districtwide, CA
Closing: 5/24/2017 11:59 PM Pacific
This recruitment is being conducted to establish a list of eligible candidates that will be used to fill district-wide, current and upcoming, temporary and regular vacancies for the duration of the list, not to exceed one year. One of the current vacancy is a 12-month, 100% position located at the District Administrative Center in Camarillo, CA. The second vacancy is a 12-month, 100% position located at Moorpark College in Moorpark, CA.
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.
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
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.
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.
EXAMINATION AND SELECTION PROCESS:
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 24, 2017.
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. Those with the highest 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.
TECHNICAL INTERVIEW DATE RANGE AND LOCATION:
Date Range: Monday, June 5, 2017 to Friday, June 9, 2017
Location: Ventura County Community College District
761 East Daily Drive
Camarillo, CA 93010
The above date range is subject to change. Candidates will be notified of any scheduling changes via email.
SUBMISSION OF APPLICATION:
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. Experience that is included in the resume but not in the Work Experience section of the application may not be considered for the purpose of determining whether you meet the minimum qualifications.
When completing the application and the supplemental questionnaire, 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 shall be probationary for a period of six (6) months or one hundred thirty (130) days of paid service, whichever is longer.
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.
EQUAL EMPLOYMENT OPPORTUNITY STATEMENT:
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.
To apply, please visit https://www.governmentjobs.com/careers/vcccd/jobs/1736888/technical-data-specialist