SYSTEMS INTEGRATION ANALYST

ESCONDIDO UNION SCHOOL DISTRICT

CLASS SPECIFICATION

SALARY RANGE 53

DEFINITION

Under the direction of the Chief Technology Officer, analyzes, integrates, and supports a variety of computing platforms, software, and programs; researches system capabilities and analyzes effectiveness of existing and potential software applications; performs analytical duties in the planning, development, interoperability and optimization of technology systems; develops reporting, automation and export capabilities; modifies and develops various database systems in support of special projects as required; and performs related duties as assigned.

TYPICAL DUTIES

Performs analysis of new and existing computer systems to enhance capabilities, efficiencies and interoperability; identifies opportunities for the integration of data between database systems; plans, manages and facilitates the migration of data between systems; expands and modifies systems to improve functionality in reflection of district processes and requirements.

Assists in the development and optimization of computer systems; conducts application testing; plans and implements system integration and interoperability; identifies and diagnoses data and system inaccuracies and anomalies; ensures compliance with District, State and Federal student database requirements.

Inputs and compiles data from a wide variety of sources; manages large data sets; submits data and reports to governmental and oversight agencies as directed; coordinates and supports the implementation of customized databases using data extracts from multiple sources; improves functionality of designated databases by scripting, automating, and integrating with other computer systems; designs and develops new applications and computer functions as required.

Assesses end user capabilities of various systems; develops and updates documentation specific to support databases, reporting activities, and other applications; informs related procedures and logistics; provides training, technical assistance, and support to district personnel as required.

Supports district activities as directed by assisting end-users throughout the district with the installation, configuration, troubleshooting, diagnosis, repair, restoration and maintenance of desktop and laptop computer hardware and software; troubleshoots program and system malfunctions; provides work guidance to staff as assigned to resolve hardware and software problems; instructs users with resolving hardware and software challenges.

Participates in trainings and workshops to keep informed of emerging trends and technologies; meets with various departments, personnel, school sites and outside agencies to exchange information, provide necessary support, coordinate activities and resolve difficulties; consults with management to plan updates in reflection of district needs and requirements; and collaborates with others to gather information relevant to system integration and optimization duties and support related planning and activities.

Communicates with vendors, suppliers, District administrators and personnel concerning program operation and new technology; researches, plans, tests, documents, and optimizes new software and hardware configurations for use on the District network and verifies interoperability; backs up, restores, archives and optimizes data as needed.

Establishes processes to improve manageability of desktop assets and creates and automates deployment of system and software updates and computer configurations.

Ensures compliance with safety regulations; follows instructions; schedules and performs work efficiently; maintains records of work activities; responds to emergency requests for equipment repairs as directed.

Performs related duties as assigned.

DISTINGUISHING CHARACTERISTICS

Systems Integration Analyst performs technical duties in the integration and optimization of a variety of technology systems; is distinguished by its specialization in database design, planning and analysis to ensure system interoperability. The Computer Technician II performs technical and complex work to install, manage, repair, optimize, and maintain a variety of computing platforms and peripheral equipment with minimal supervision and direction. The Computer Technician I performs less complicated and technical work to upgrade, configure and maintain a variety of computers and peripheral equipment. The School Computer Technician provides first-level support related to the use of computers by students, faculty and staff. The School Computer Technician class is distinguished by its classroom technology support function and by less complex computer repairs and maintenance than the work performed by those assigned as Computer Technician II.

EMPLOYMENT STANDARDS

Knowledge of: Windows and Macintosh computer platforms, applications, operation and peripheral equipment; repair and maintenance of Macintosh and PC-based computers, local area networks (LAN); operations and software such as Powershell, SQL, VBA, Apple Script, Java, and javaScript, multiple table relational database concepts, methods, procedures, applications such as Oracle, SQL Server, and Windows Server; data processing principles, practices, and capabilities; Specifications and formatting of reports utilizing student information systems and other database software; spreadsheets and data processing systems; computer logic and flow-charting skills; principles of training; oral and written communication techniques; report generation as required; interrelationship of district business processes and computerized systems.

Ability to: install, manage, maintain and repair a wide variety of Macintosh and PC-based desktop/laptop computers and peripheral equipment; train and provide technical support to users in computer operation, software, networked systems; learn and effectively use software specific to District needs; maintain records and files; schedule and perform work to meet established timelines; Maintain complex, real-time, District-wide database systems; analyze complex data; extract data by developing complex queries requiring logic; write program and process documentation and user manuals; present technical concepts clearly and concisely both orally and in writing; respond to emergencies without delay; work independently with minimal supervision; establish and maintain effective and cooperative working relationships with others; communicate technical information effectively with others unfamiliar with the terminology.

Essential Physical Activities and Work Environment: Work is performed in a computer repair environment or on site at various District or school locations. Sufficient visual acuity to read manuals, see contents on a computer screen and see circuitry inside a computer system; sufficient hearing to comprehend low level beeps from computers; sufficient strength and agility to lift, move, install and maintain computers and peripheral equipment weighing up to 60 pounds. Incumbents are subject to traveling to District sites, noise from equipment, fumes from chemicals, and exposure to high voltage; must operate insured personal vehicle to transport computers, parts, and repair equipment to various District or school locations. The job generally requires 50% sitting, 25% walking, and 25% standing.

Mental Functions: Sufficient ability to solve moderately complex, non-routine problems; read highly technical material.

Typical Background: Bachelor’s Degree (or equivalent combination of education and experience) with major course work in computer science, information systems or related field and at least three years of experience in relational database or software development or at least three years of experience performing multiplatform support, installation and troubleshooting that includes system analysis and development. Experience with student database systems is desirable.

Licenses and/or Certificates: Valid California driver's license. A+ certification prior to the completion of the probationary period is required; A+ certification at the time of hire is preferred. Must obtain Apple Certified Macintosh Technician (ACMT) or Apple Certified Associate - Integration and Management certification prior to the completion of the probationary period. May be required to obtain other job-related certificates after appointment.

Qualifications: In order to be considered qualified for a vacancy in this classification, a candidate must possess the required background and successfully demonstrate such background, knowledge, skills and abilities through an examination process.

Established July 2021
Approved by the Personnel Commission 7/8/2021