Poway Unified School District
Receive alerts when this company posts new jobs.
Programmer Analyst II
at Poway Unified School District
- 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. ETrain and coordinate the efforts of programmers and other appropriate staff. EDiscuss user problems and test possible solutions contacting software vendors as necessary to troubleshoot problems; provide recommendations on software and hardware purchases. ECoordinate the efforts of other IT staff and school personnel in assigned projects; delegate tasks and provide instruction to other staff as assigned. ERespond to technical questions from staff and users regarding programming matters. EProvide training to staff and users on assigned applications; prepare and instruct in-service sessions regarding assigned programs; travel to user site as necessary. ELearn new operating systems, utilities and languages and remain current with computer technologies. EDevelop, write and present system proposals. EDesign and develop report specifications. EWrite and test computer programs, scripts and SQL stored procedures. EDevelop documentation for procedures, applications, programming and database; prepare and document data standards, procedures and definitions for the data dictionary (metadata). EDevise controls and procedures to assure accuracy and auditability of implemented systems. EMaintain continuing contact with users to assure implementation and maintenance of systems. EEstablish and maintain Extract Transfer and Load procedures and protocols and develop procedures for data security, backup and recovery. EPlan data flows for new or revised databases. EDefine the 'physical design' to meet system storage requirements. EAssess users' access requirements and resolve access problems. EAssure that business rules governing data are clearly defined and routinely monitored; maintain data standards including adherence to the Data Protection Act. ECommunicate with technical, applications and operations staff to ensure the integrity and security of all data. ETest 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:
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.
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).
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.
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