CLOVIS UNIFIED SCHOOL DISTRICT POSITION DESCRIPTION

SUMMARY

Prepares and provides machine instructions to produce regularly recurring and custom reports from relational databases, to internal and external sources such as the County and State agencies. Ensures database instructions support reporting requirements including conversion of data to centralized tables for final data extraction. Establishes procedures and trains others on data entry requirements for multiple applications. Reviews and troubleshoots errors including working with programmers and analysts to resolve issues.

DISTINGUISHING CAREER FEATURES
Systems Operations Technician position requires the ability to interpret reporting requirements and prepare district systems for compliance including coordination of training of individuals interfacing with systems on the front and back ends regarding procedural or structural changes. Must be able to troubleshoot scripting errors and coordinate resolutions with programmers and outside vendors.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Generates a variety of reports to meet internal and external requirements such as, but not limited to, general administrative, financial, and academic information; and CBEDS, ELC, Language Census, SNORS, UMIRS, and Con-Ap.

Interprets reporting requirements and works with other staff to customize database instructions for new or changed reporting requirements. Runs test report and reviews data for accuracy.

Troubleshoots data errors including reviewing and correcting scripts, analyzing table structures for conversion compatibility and working with programmers and outside vendors as needed.

Trains data processors and staff on data entry protocols and requirements to ensure reporting accuracy and ease of data conversion from one set of tables to another.

Provide problem-solving support for users having trouble accessing information from various data centers such as Zangle, HRIS, SIS and CSIS.

Participate in internal and external committees related to reporting requirements. Stays up-to-date regarding new and changing requirements and inform effected staff as appropriate.

May build new queries and do basic script writing.

Responds to requests and inquiries from system users. Provides training in data processing systems and report/data generation procedures and steps.

Participates in planning for new projects and programs and evaluation of procedures. May devise new procedures.

Maintains activity records for production, troubleshooting, and changes.

Performs other duties as assigned that support the overall objective of the position.

QUALIFICATIONS

Knowledge and Skills: Requires a technical understanding of relational database structure, various district data centers and the full array of state and district reporting requirements. Requires knowledge of report generation processes including troubleshooting system and data errors. Requires a working knowledge of at least one of the following programming languages: Query, Crystal Reports or equivalent ODBC type, SQL. Requires the knowledge and skill to set up and maintain files for report production within an integrated relational database. Requires knowledge of data conversion requirements from multiple sources. Requires well-developed data entry and keyboarding skills. Requires sufficient math skills to compute totals, percentages, products, and quotients. Requires sufficient human relations skills to train small and large groups of employees, provide work direction, and serve customers in all departments.

Abilities: Requires the ability to perform all aspects of the position. Requires the ability to perform recurring and time-dependent tasks. Requires the ability to explain and interpret reporting requirements and data interface protocols on the front and back end of systems. Requires the ability to determine the needs of individual departments, and to work with other departments to schedule work. Must be able to operate computer equipment and applications associated with data processing operations. Must be able to identify errors, make appropriate corrections and work with programmers and vendors on resolving issues.

Physical Abilities: Position involves light to medium walking, standing, stooping carrying and lifting of light weight materials (under 25 pounds). Requires visual acuity to read numbers, letters, and images; depth perception; hand and finger dexterity to use a keyboard, and hand-eye coordination. Requires speaking and hearing ability sufficient to hear over phone and carry on routine conversations.

Education and Experience: The position requires Associates degree and one year of applicable experience. Additional experience can be substituted for higher education.

Licenses and Certificates: May require a valid driver’s license.

Working Conditions: Work is performed indoors where minimal safety considerations exist.