Information Systems Specialist 5 (Database Analyst)
Education-Office of Assessment & Information Services - Salem, OR

This job posting is no longer available on State of Oregon. Find similar jobs: Information System Specialist jobs

Oregon Department of Education The Oregon Department of Education fosters excellence for every learner through innovation, collaboration, leadership, and service to our education partners.
The Oregon Department of Education provides statewide leadership for all elementary and secondary students in Oregon’s public school districts and education service districts. Responsibility also extends to public preschool programs, the state School for the Deaf, regional programs for children with disabilities, and education programs in Oregon youth corrections facilities.

There is currently one permanent, full-time position available with the Office of Office of Assessment and Information Services at the Oregon Department of Education in Salem. This position is classified and represented by Service Employees International Union ( SEIU ).

The Office of Assessment and Information Services has two primary functions: student assessment; and the collection, validation, and reporting of data for education research, policy-making, and operations. The technical expertise of staff in this unit is available to districts to support business and financial functions. The work of OAIS affects every school, program, school district, and education service district (ESD) in the state. Nearly all students in the Oregon public school system are affected by the work in these units. Data is collected from nearly every educational administrative unit.

Duties & Responsibilities:
The purpose of this position is to maintain and evolve the enterprise data/application resources for the Department of Education. Duties include: Author code to enhance and maintain database applications using defined detailed system and application requirements. Coordinate changes to code using T-SQL stored procedures, triggers, functions, and views to apply to .NET/VB front-end interfaces. Utilizes established OAIS standards and procedures for data base and programming design. Follow rollout processes to ensure successful code deployments to development, test and production environments. Assist business analysts to work with a diverse user base in gathering requirements. Work with ODE Helpdesk to resolve database application issues. Study and maintain system documentation in preparation for coding. Maintains knowledge of state-of-the-art technologies and innovations through training, professional journals and publications, contact with other Information Systems professionals, and self-initiated study. Attends training and other developmental activities. Reviews technical journals and relevant literature to stay current with technology and trends. Provides weekly updates to team lead on status of assigned projects. Enters progress in system development tracking system on a regular basis. WORKING CONDITIONS Typical office environment. May spend majority of workday using video display terminal. May require occasional evening or weekend work to meet deadlines or resolve problems. At times may be requested to be on call to resolve technology issues to ensure uninterrupted network services to staff and school district users. Occasional travel to other agency sites.

Qualifications & Desired Attributes:
Three years of professional, consultative, technical, or administrative experience which includes designing, constructing or analyzing information systems. Experience must include activities in: Software : Software means the programs, procedures, rules, and associated
documentation concerned with operating a system and covers both applications and operating software. Data : Data means data bases and associated master files; AND EITHER

(a) at least 30 quarter (20 semester) credits in computer science; OR (b) two more years of experience providing a knowledge of information systems theory and principles.

Examples of experience providing a knowledge of information systems theory and principles are : Providing technical consultation and advice to managers, technical and professional IS staff, and system users in planning, analyzing, developing, and implementing the operation, maintenance, installation, modification, and construction of information systems; OR Working with vendors and contracted personnel to assess new technology, provide oversight, exchange information, and solve problems. 15 quarter (10 semester) graduate-level computer science, software engineering, information systems, or equivalent credits may substitute for one year of the professional experience. DESIRED ATTIRBUTES • one year of experience writing T-SQL (Transact Structured Query Language) queries • experience using Microsoft SQL Server, Microsoft SQL Server Management Studio (SSMS), Team Foundation Server (TFS), Visual Studio for Database Developers (VSDB), Microsoft SQL Reporting Services (SRS), Microsoft SQL Server Integration Services (SSIS), and Microsoft SQL Server Analysis Services (SSAS)

  • experience with school district operations and work supprting student information systems
Additional Information:
To apply: follow the “Apply” link above and complete the Oregon employment application online. Only complete applications submitted online will be considered . We do not accept paper or e-mail applications. The state of Oregon is requires all applications have a valid email address. If you do not currently have an email address and do not know where to go to get one please refer to our Applicant E-Recruit FAQ's web page. The state of Oregon does not endorse any particular provider. ODE will communicate with all applicants by e-mail. Depending on the volume of applications received for this recruitment, you should allow two weeks after the close date to be notified concerning the review of your application. This job announcement may be used to fill future vacancies in this class of work. This job posting may be closed at any time. Apply now if you are interested in this/or future vacancies. Determining Minimum Qualifications: Your application materials must clearly describe how you meet these qualifications. Answers to the supplemental questions must be supported by the “Work Experience” section of your Oregon E-Recruit application or you may not be considered for this position. A resume (text or attached) will not be reviewed for work history unless stated in the job posting that it is a required attachment.

Only complete applications will be considered. Be sure to answer all supplemental questions and attach all required documents. Late submissions or attachments will not be accepted. Supplemental Questions: In order to evaluate your experience as it relates to this position, we need your responses to the supplemental questions. They will be the sole basis for determining which applicants, among those who meet the minimum qualifications, will be provided an interview. Failure to respond to each question in the space provided for that question may result in disqualification of your application. The space provided will expand to accommodate additional text beyond the area shown. You may cut and paste text into the space provided from a word processing program, such as Word, WordPerfect, or Notepad. Please note that your responses will also be evaluated for English usage, grammar, spelling, and punctuation.
Attachments: This position may require additional attachments (see Qualifications & Desired Attributes). If you need assistance with adding attachments to your profile or to a specific job posting please go to ddingRemovingAttachments.pdf for further instructions. This quick help guide can also be found on the State Jobs Page by clicking in the Applicant E-Recruit FAQ's then click on Applicant Profile Maintenance. If you are unable to upload attachments, please contact Recruitment Services to discuss possible alternatives. Interviews: Qualified applicants whose responses most closely match the minimum qualifications and desired attributes for this position will be invited to an interview. If called for an interview, applicants will be asked to sign a reference authorization and release form at the time of interview. Background Check: Applicants will be subject to a thorough background investigation including driving record. Adverse background data may be grounds for immediate disqualification. Applicants will be subject to a Computerized Criminal History check. Conviction of a crime will not automatically preclude an appointment. The circumstances involved in the conviction will be considered. If you require an alternate format in order to complete the employment process, you may call Recruitment Services at (503) 947-5635. Please be prepared to leave a message describing the alternate format needed. Recruitment Contact: Cassie Graham, Recruitment Manager Oregon Department of Education 255 Capitol Street NE Salem, OR 97310 Ph: 503-947-5635 Email: For more information on veterans’ preference points, please visit For more information about the Oregon Department of Education visit: The pay and benefits on all announcements may change without notice. Please be aware that due to the economic downturn and subsequent state budget shortfall, the Governor has ordered mandatory unpaid furlough days for employees. This position will be required to take furlough days in the 2011-13 biennium. The Oregon Department of Education is an affirmative action equal opportunity employer and encourages qualified women, persons of color, persons with disabilities, and any other classification protected under state or federal law to apply for this opening. NOTE: The Oregon Department of Education does not offer visa sponsorships. Within three days of hire, the successful candidate will be required to complete the U.S. Department of Justice form I-9 confirming authorization to work in the United States. Applicant E-Recruit FAQ's

State Directories

Agencies A to Z

Oregon Administrative Rules

Oregon Revised Statutes


Web Site Links

State of Oregon - 23 months ago - save job