General Summary:  The Systems Analyst/SQL Developer partners with key stakeholders and users within the district to understand their needs and processes in order to design, develop, implement, and maintain solutions that leverage new or existing applications and technology.

Data Systems

• Responsible for extracting and submitting district data per the Nebraska Department of Education State Reporting business rules.
• Assists with the maintenance of the Student Information System (SIS) database and other District databases both in-house and hosted services. This includes but is not limited to student food service and transportation programs.
• Design, develop, and maintain SQL database systems, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) packages. 
• Develops stored procedures, functions and triggers as needed in order to accommodate specific data needs of the District.
• Configure and maintain third-party software applications.  Participate in vendor/software/system upgrades.
• Responsible for collecting thorough business/operational, compliance, and integration (data/system) requirements that are defined and owned by various department subject matter experts (SMEs) and/or stakeholders.
• Become the systems and application process expert to include implementation, configuration, integration, testing, rollout, and ongoing production support. 
• Evaluate current and future needs to recommend applicable solutions to improve current processes, workflows, and usage of district applications.
• Develop and maintain functional specifications for new or modified systems.  These specifications should include business objective, process, and workflow considerations, templates, data scope/definitions/mapping, custom development requirements, configuration, and security requirements.
• Determine and document data mapping rules from medium to complex source data fields to their related target data fields. 
• Understand and work with data models, schemas, SQL objects and data object model. 

Teamwork

• Promote and facilitate collaboration with District leadership teams, project stakeholders and team members, third party solution providers, etc.
• Ability to manage multiple projects and meet deadlines.
• Work with teammates and internal and external partners to coordinate activities to meet District and department goals.
• Keep abreast of technology developments relating to current trends, issues, and educational needs (such as training, reading professional literature, participating in professional organizations).  Share knowledge with others.
• Engage in meetings and trainings as requested, react to change productively, and perform other duties as assigned.

Customer Service

• Continuously evaluate and identify opportunities to drive process improvements that positively improve the data and our customer experience. 
• Provide professional, timely response to all district inquiries.
• Adhere to departmental guidelines for communication and meetings.
• Meet all commitments.

Qualifications:

1. Education Level:  Bachelor’s Degree in a technology related field or equivalent experience
2. Certification or Licensure:  None required
3. Required Skills/Experience:
• Relational database concepts
• Advanced SQL skills including but not limited to complex queries, joins, stored procedures, functions, and job scheduling
4. Preferred Skills/Experience:
• Microsoft SQL Server, Windows Server, and scripting
• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• K-12 Student Information System
• Tableau
5. Other Requirements:
• Commitment to ethical practices
• Good knowledge of applicable data privacy practices and laws
• Ability to be flexible
• Ability to meet deadlines
• Ability to work cooperatively with people
• Exceptional analytical, conceptual, and problem-solving abilities
• Strong written and oral communication skills
• Ability to effectively prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment

Special Requirements:

The statements herein are intended to describe the general nature and level of work being performed by employees assigned to this classification.  They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. Responsibilities and duties assigned are at the discretion of the supervisor (or superintendent).