Poway Unified School District

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Programmer Analyst II

at Poway Unified School District

Posted: 3/3/2020
Job Status: Full Time
Job Reference #: 2714435

Job Description

Overall Job Objective

Description

BASIC FUNCTION: 
Under direction, facilitate the computerized collection, management, manipulation and distribution of data used for decision-making and in the daily operation of schools and departments.
 
DISTINGUISHING CHARACTERISTICS:
 
The Programmer Analyst II is the journey level of the series and works closely with users and works independently on programming projects. The Programmer Analyst III serves as a technical resource for other personnel and leads major complex projects with considerable independence. The Programmer Analyst I designs and implements assigned systems under direction, working closely with users and other personnel.

Examples of Duties

REPRESENTATIVE DUTIES:
Assist in the evaluation of user needs; analyze administrative activities and perform feasibility studies to determine appropriate resolution of user's needs and operating problems. E
 
Train and coordinate the efforts of programmers and other appropriate staff. E
 
Discuss user problems and test possible solutions contacting software vendors as necessary to troubleshoot problems; provide recommendations on software and hardware purchases. E
 
Coordinate the efforts of other IT staff and school personnel in assigned projects; delegate tasks and provide instruction to other staff as assigned. E
 
Respond to technical questions from staff and users regarding programming matters. E
 
Provide training to staff and users on assigned applications; prepare and instruct in-service sessions regarding assigned programs; travel to user site as necessary. E
 
Learn new operating systems, utilities and languages and remain current with computer technologies. E
 
Develop, write and present system proposals. E
 
Design and develop report specifications. E
 
Write and test computer programs, scripts and SQL stored procedures. E
 
Develop documentation for procedures, applications, programming and database; prepare and document data standards, procedures and definitions for the data dictionary (metadata). E
Devise controls and procedures to assure accuracy and auditability of implemented systems. E
 
Maintain continuing contact with users to assure implementation and maintenance of systems. E
 
Establish and maintain Extract Transfer and Load procedures and protocols and develop procedures for data security, backup and recovery. E
 
Plan data flows for new or revised databases. E
 
Define the 'physical design' to meet system storage requirements. E
 
Assess users' access requirements and resolve access problems. E
 
Assure that business rules governing data are clearly defined and routinely monitored; maintain data standards including adherence to the Data Protection Act. E
 
Communicate with technical, applications and operations staff to ensure the integrity and security of all data. E
 
Test new systems as necessary.
 
Perform related duties as assigned.

NOTE: At the end of some of the duty statements, there is an "E" which identifies essential duties required of the classification.

Typical Qualifications

EDUCATION AND EXPERIENCE:
Any combination of education and experience equivalent to: bachelor's degree in information systems, computer science or related field including or supplemented by courses in systems analysis, programming and relational data base systems and three years experience in systems development and programming.

LICENSES AND OTHER REQUIREMENTS:
 Valid California driver's license.
 

Supplemental Information

KNOWLEDGE AND ABILITIES:

KNOWLEDGE OF:
Legal responsibilities and restrictions as they apply to access control and privileges for security.
Project and program planning techniques, scheduling and control.
Capabilities, operation and utilization of computer systems and related equipment.
Systems and procedures analysis and development.
Applicable computer language and software product evaluation such as .NET, JAVA, JAVASCRIPT, SAS and HTML.
Requirements and restrictions of RDBMS (relational database management system) concepts.
Principles and practices of training and providing work direction.
Management information systems.
State codes related to assigned projects.
Spreadsheet and word processing systems.
Conceptual design processes.
Database design, programming languages and management of SQL.
Data modeling and Extract Transfer and Load (ETL).

ABILITY TO:
Work independently on programming projects.
Train and provide work direction to assigned personnel.
Learn and use new program languages and operating systems.
Perform systems analysis activities including the development of cost efficient, auditable, and secure systems.
Design forms, develop test techniques and test computer programs and systems.
Assist users in determining their needs.
Establish and maintain cooperative and effective working relationships with others.
Communicate effectively both orally and in writing.
Troubleshoot and solve problems quickly and accurately. 
Implement a project management plan.
Refine the 'physical design' to meet system storage requirements.
Work well with others as part of a team.
 

WORKING CONDITIONS:

ENVIRONMENT:
Indoor environment.
 
PHYSICAL ABILITIES:
Seeing to perform activities.
Hearing and speaking to exchange information.
Lifting to move computer equipment.
Dexterity of hands and fingers to operate a computer keyboard.

The Poway Unified School District (PUSD) is an equal opportunity employer/program and is committed to an active Nondiscrimination Program.  PUSD  does not discriminate on the basis of race, color, national origin, sex, sexual orientation, ethnic group identification, ancestry, religion, gender, gender identification, mental or physical disability.  

For more information, please contact the Title IX/Equity Compliance Officer, Associate Superintendent of Personnel Support Services, Poway Unified School District, 15250 Avenue of Science, San Diego, CA 92128-3406