Position: Systems Analyst/Developer - Special Education Support
Location: Teacher Administrative Center, 3215 Cuming Street, Omaha, NE 68131
Reports To: IMS Technical Support Coordinator
Work Schedule/FLSA Status: 261 day 12-month / Exempt
Salary Schedule: 92D
Position Purpose: The Omaha Public Schools (OPS) is seeking a Systems Analyst/Developer with strong SQL skills for Special Education Support. This position will be the main Special Education contact working closely with them to make sure development and reporting are not delayed so deadlines can be met. The position will work with users and technical staff to develop methods to handle ad hoc requests for students' special education data from information systems. This position will 1) Develop and ensure that processes are well documented, 2) Assist users when additional information, functionality, or services are needed, 3) Convey analysis information to the appropriate technical staff through standard information systems products, including work requests and requirements specifications, and 4) Analyze, design, develop, test, deploy, and support solutions.
Essential Performance Responsibilities
- Code and maintain stored procedures, data movement/population, data clean up, data accuracy, new functionality and troubleshooting (Infinite Campus Support focused on Special Education data)
- Develop reports (SSRS development) for student data focusing on Special Education
- Technical support of Special Education processes including, but not limited to: Ed-Fi State Reporting, 504 ADA Eligibility Determination and Conflict Reporting, IEPs, MiPS timesheets, Non-Public Reporting, Special Education Calendar, Psychologist Caseload, Proportionate Share, and Alternate Assessment
- Write documentation for Infinite Campus data manipulation, including comparison and recovery of data within a school year and across years
- Import data into and export data from Infinite Campus
- Document critical processes, repeatable processes, work requests and instructions for technical support or end users and stored procedures
- Identify areas for improvement and make recommendations
- Escalate problems to the SDIS Lead and as appropriate to IT management
- Provide input and knowledge as needed to others on the SDIS and Data Analytics team
- Investigate and assist with problem resolution
- Analyze and evaluate performance problems
- Perform TFS duties
Additional Duties Performs other related tasks as assigned by supervisor and other central office administrators as designated by the Superintendent.
Equipment: This position may require the ability to use basic office equipment such as computers, copiers, scanners, and fax machine. Must always comply with OPS's guidelines for equipment use.
Travel: Limited local travel may be required.
Physical and Mental Demands, Work Hazards:
- Must be able to respond in a timely manner.
- Must have organization, time management, communication, and interpersonal skills.
- Work in school building and central office environments.
- Contact with personnel within the district and with customers and vendors.
- Will be working under the direct supervision of the department supervisor to complete day to day tasks.
- Will be working with a diverse population requiring the ability to handle all situations with tact and diplomacy.
- Must understand and respond appropriately to customer needs and maintain a positive attitude with all customers and colleagues.
- Expected to interact with all internal and external customers in a friendly, professional manner and provide quick, responsive customer service.
Employee Punctuality and Appearance
- For schools and district departments to operate effectively, employees are expected to perform all assigned duties and work all scheduled hours during each designated workday, unless the employee has received approved leave.
- Any deviation from assigned hours must have prior approval from the employee's supervisor or building administrator.
- All employees are required to report to work dressed in a manner that reflects a positive image of Omaha Public Schools and is appropriate for their position.
Knowledge, Skills, and Abilities:
- Minimum of bachelor's degree in a technology related field or equivalent experience
- Minimum of three years of coding advanced SQL queries preferred
- Knowledge of Infinite Campus student software
- Knowledge of district and state reporting requirements for Special Education students preferred
- Knowledge of Team Foundation Server (TFS) and Tableau software preferred
- Proficiency with Microsoft SQL Server including: coding, writing complex queries, scripts and jobs
- Demonstrated ability to follow a development methodology which includes discovery & analysis, designing, developing & testing, and delivery & support maintenance
- Advanced experience using strong analytical, problem-solving, and organizational skills
- Experience with stored procedures, views, indexes, foreign keys, etc.
- Advanced skill in Microsoft: Windows Operating Systems, Office Suite versions, Visio, Project, etc.
- Ability to conduct analysis (plan, organize, problem-solve, and think abstractly/ conceptually) in an educational environment
- Ability to effectively develop in and use many of the following: Microsoft SQL Server, SQL Server Reporting Services, Infinite Campus, Microsoft Suite, Visual Studio
- Ability to translate customer requests into comprehensive technical requirement documents
- Exhibit strong attention to detail and accuracy
- Develop and execute a rigorous test plan for all development, data changes and data analysis
- Strong ability to follow tasks through to completion and meet deadlines
- Ability to work independently or with a team to research and solve critical issues
- Strong communication skills; ability to convey accurate and timely information both verbally and written
- Ability to understand technical manuals and procedural documentation
- Ability to thoroughly document development work efforts (both new and existing)
- Ability to work through difficult issues and maintain a positive attitude when communicating with others
- Ability to work hours outside of normal schedule with little or no advance notification
- Skills pertinent to positive human relationships and the ability to work effectively with staff members in a multicultural urban setting
Terms of Employment
This position is treated as a full-time, exempt classified position. The terms of your employment will be governed by applicable state laws regulating employment in a Nebraska public school and Board of Education policies, as those laws and policies may change from time to time. If your position is represented by a collective bargaining representative, then your employment will also be governed by a negotiated agreement between OPS and that collective bargaining representative.
The offer of employment is contingent upon:
- Obtaining and providing verification of all licenses, certificates, and other requirements for the position (e.g., Paraprofessionals obtaining Highly Qualified status, etc.), as identified and maintaining all licenses, certificates, and requirements for your position throughout employment.
- A background check which demonstrates to OPS that background is acceptable for the position.
- Verification of U.S. citizenship or legal authorization to work in the United States.
- Successful completion of a pre-employment drug test (if required for position offered).
- Successful completion of a tuberculosis skin test (if required for position offered).
Omaha Public Schools does not discriminate on the basis of race, color, national origin, religion, sex (including pregnancy), marital status, sexual orientation, disability, age, genetic information, gender identity, gender expression, citizenship status, veteran status, political affiliation or economic status in its programs, activities, employment, and provides equal access to the Boy Scouts and other designated youth groups. The following individual has been designated to handle inquiries regarding the non-discrimination policies: Director for the Office of Equity and Diversity, 3215 Cuming Street, Omaha, NE 68131. (531-299-0307)
The Omaha Public School District is committed to providing access and reasonable accommodation in its services, programs, activities, education and employment for individuals with disabilities. To request disability accommodation in the application process please contact the Human Resources Department at 531-299-0240.