Database Analyst/Developer

State of Oregon

2d • Hybrid

About The Position

We are seeking a Database Analyst/Developer (Information Systems Specialist 7) to join our Office of Finance and Information Technology (OFIT) at the Oregon Department of Education. This is a limited duration position ending 6/30/2027 and represented by the Service Employees International Union (SEIU). This position follows a hybrid work model. Onsite presence will be required when business or operational needs are best supported in person, such as collaboration, training, or work that requires access to onsite resources. Employees approved to work remotely must have a reliable and secure internet connection and maintain a professional work environment that supports productivity. While working remotely, employees are expected to maintain the same level of performance, responsiveness, communication, and availability as they would in the office. The Oregon Department of Education is seeking a Database Analyst/Developer to maintain and evolve the enterprise data/application resources for the Department of Education. This position is located in the Office of Finance and Information Technology (OFIT), and specifically in the Application Development - IT Unit of the Oregon Department of Education (ODE). This unit's primary functions are the support of technology to deliver on initiatives and meet ODE's technology needs in support of the ODE mission to foster excellence for every learner through innovation, collaboration, leadership and service to our education partners. The technical expertise of staff in this unit are available to districts to support business and financial functions. The work of OIT affects all internal staff and every school, program, school district and ESD in the state. Nearly all students in the State of Oregon public school system are affected by the work produced by this unit. This position is an integral part of the collecting and reporting of the data the ODE collects from all 197 school districts.

Requirements

• Six (6) years of information systems experience in: Complex joins and subqueries Optimizing queries and indexing strategies Creating stored procedures, triggers, views ETL experience (SSIS) Understanding of performance tuning Working with large datasets
• An Associate's degree in computer science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or Database administration or SQL Server programming field; AND four (4) years of information systems experience in: Complex joins and subqueries Optimizing queries and indexing strategies Creating stored procedures, triggers, views ETL experience (SSIS) Understanding of performance tuning Working with large datasets
• A Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of information systems experience in: Complex joins and subqueries Optimizing queries and indexing strategies Creating stored procedures, triggers, views ETL experience (SSIS) Understanding of performance tuning Working with large datasets
• Master's degree in Information Technology, Computer Science, or related field may substitute for all of the above.

Nice To Haves

• Strategic planning and documentation of complex data processing systems
• High understanding SQL Server
• Highly skilled T-SQL Programming
• Preparing detailed system and program technical specifications
• Deployment of database applications
• Ensuring data integrity, security, and conformance to ODE and state standards

Responsibilities

• Write, optimize and maintain SQL queries, views and functions
• Analyze and improve query performance.
• Ensure data integrity, consistency and accuracy across systems
• Write and maintain technical documentation

Benefits

• Oregon State provides amazing benefits!
• Eligible veterans and Oregon National Guard service members (current and former) who meet the qualifications of the position will be awarded candidate preference.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree