Data and Software Analyst

Job Summary: MS SQL Database operator, including Reporting Services, support of Infinite Campus, including end user training and mentoring of building support staff. Support for a broad range of networked applications, including back end database support as well as maintenance and support of the network application and supporting software. Project management on new software rollouts, from user requirements to maintenance, designing and implementing custom tools.

SALARY: APT Salary Schedule, Range 5, starting at $77,264 annually, depending on recent relevant experience, 8 hours per day, Monday through Friday, 260 day / 12 month work schedule, paid over 12 months. Position is eligible for benefits.

Duties And Responsibilites

• Resolve problems reported by and special requests from end-users with existing production systems, including create and maintain maintenance plans; troubleshoot root cause failures; create and maintain SSIS packages; monitor database and log file growth to ensure adequate storage capacity is available for optimal performance and expand when necessary; work with vendors and end users to ensure proper access is provided to the SQL server environment.
• Data integration between Infinite Campus, VersaTrans, Destiny, Alpine, A , Naviance, Lexia and other curriculum programs, including RevTrak and College in Colorado.
• Design, develop, deplay and support large scale SSIS packages, including data quality and testing.
• Design, develop, test, deploy and support customized reports, using Microsoft SQL Reporting Services and Microsoft Visual Studio, integrating data from multiple sources, including, but not limited to, government reporting to CDE and Civil Rights Data Collection.
• Manage VersaTrans RoutePlanning and FleetVision data and applications in conjunction with the Transportation and Finance departments.
• Manage and monitor database performance and resolve production data load issues as they occur. Provide technical and application support for databases and programs.
• SQL Server administration, maintenance and management in support of multiple network applications including Infinite Campus, VersaTrans, Destiny and Alpine.
• Analyze and evaluate software updates, changes and enhancements, identify user impact, and decide on schedule and implementation of the updates.
• Compare and analyze data to support the data integrity of the District’s student information database system.
• Champion data quality standards and ensure those standards are incorporated into the design and data processing for data warehouses.
• Develop and keep current the business standards, programming procedures and techniques. Maintain software versioning and continuity.
• Other duties as assigned.
  
  

Qualifications

• Bachelor’s degree or above or the equivalent experience and/or training in computer science or a related field.
• Over 3 years of experience with Infinite Campus as a database administrator and application manager, Database management with Microsoft SQL Server 2005 and 2008, including SQL Reporting Services (SSRS), iSeries OS V5R3, IIS and Apache Tomcat web/application servers, project management, and technical training and writing/document preparation.
  
  

Application Procedure

Apply online at www.workat27j.com.

Links To Important Job Information

Benefits Information

Salary Schedules

Leaves Information

Non-Discrimination Notice

All future correspondence will be handled via the email address you provided in your online application. Check your In-Box and your SPAM folder.

All 27J postings close at 4:00 Mountain Time