Programmer/Analyst

New Trier High School District; Winnetka (IL); On-site; USD 90,000 - 130,000; Full time

Job summary

New Trier High School District is seeking a Programmer/Analyst to lead development and support of our enterprise applications services, including the student information system and custom applications. The role focuses on developing and maintaining .NET and Angular JS modules, APIs, and database integrations with SQL Server and Oracle.

You will ensure security, documentation, disaster recovery planning, and collaborate with the Enterprise Systems team to optimize workflows across finance, HR,

Qualifications

• Degree in computer science, information technology or related field (or equivalent).
• 3+ years of application development experience; .NET development preferred.
• Experience with C#.NET and MS SQL Server.
• Proficiency in SQL queries, stored procedures, reporting, and queries.
• Knowledge of Tableau or Power BI and data visualization.
• Experience with Snowflake or cloud data warehousing preferred.
• Strong understanding of relational databases and data structures.
• Ability to document procedures and develop technical documentation.
• Ability to understand complex systems and stakeholder needs.
• Excellent written and verbal communication; customer-service oriented.

Responsibilities

• Lead development and support of enterprise applications, including the student information system and custom apps.
• Develop APIs and integrate with .NET/Angular JS backend using SQL/Oracle.
• Maintain security, documentation, and disaster recovery planning.
• Collaborate with Enterprise Systems team to enhance processes across Finance/HR/student data.
• Monitor performance and troubleshoot issues; ensure confidentiality of sensitive data.
• Provide world-class service to users and stakeholders.

Skills

.NET development

SQL queries

Data visualization

Cloud data warehousing

Documentation

Team collaboration

Customer service

Education

Degree in computer science or information technology

Tools

Microsoft SQL Server

Tableau/Power BI

Snowflake

.NET development environment

Job description

Supervisor: Enterprise Applications Manager; Chief Technology Officer

General Responsibilities

The Programmer/Analyst is the lead developer and applications analyst, and leads in the operation, support and development of our enterprise applications services, including the student information system and custom applications.

The current environment includes applications developed in .NET, Angular JS with backend in SQL and Oracle. The position will involve developing new APIs and applications in these areas and supporting processes and workflows related to finance/human resources systems, student information, and other areas.

The Programmer/Analyst is responsible for overall maintenance of these systems, including administration, development, documentation, and security. The Programmer/Analyst will also work collaboratively with other Enterprise Systems team members to develop new systems or modify current systems to add or improve functionality.

Develop and implement a plan for ongoing assessment of system performance and the identification of problem areas. Apply adopted security schemes to applications, as well as assisting in disaster recovery if necessary. This position includes access to confidential employee, financial and student data, and requires discretion and confidentiality.

Qualifications

• Degree in computer science, information technology or a related field or an equivalent combination of education and experience.
• Minimum of three years’ experience in application development, preferably in business process / workflow systems and experience with .NET development.
• Experience in developing and maintaining applications using C#.NET with Microsoft SQL Server databases.
• Proficiency in writing SQL queries, stored procedures, reporting and query tools.
• Knowledge of statistical software and data visualization tools such as Tableau, and/or Power BI.
• Experience with cloud data warehouse platforms like Snowflake is preferred.
• Strong understanding of standard relational database structures, theories, principles, and practices.
• Experience in developing documentation and procedures.
• Ability to quickly understand complex systems from a technical, organizational and logical perspective; how they interact with the operation of the school district; and the impact and connection these systems have to different types of users (faculty, administration, support staff) and to departments in the school (Administrative Services, Business Office, Attendance Office, Registrar, etc.).
• Ability to complete multiple, complex projects; multi-task; meet frequent deadlines.
• Ability to work both independently and in teams, demonstrate exemplary interpersonal skills, communicate clearly with staff, students, parents, and the public and be customer-service oriented.
• Excellent oral and written communication skills and the ability to effectively communicate with stakeholders and co-workers on technical topics and project requirements.
• Ability to maintain the highest level of confidentiality regarding employee issues.

Position Expectations

Technical

• Provides advanced technical expertise in application development in .NET environment.
• Design, develop and implement applications while maintaining enhancements and developing new functionality to optimize existing intranet and internet solutions.
• Possesses in-depth knowledge on the functionality of databases of numerous data-driven technical systems, including the business process/workflow, course management, document archiving, content, student, and financial management software; including how these systems interface and move data between each other.
• Maintain a working knowledge of vendor supplied software/utilities pertinent to position functions.
• Demonstrated ability to troubleshoot and diagnose technical problems in a timely and effective manner.

Application Design

• Designs and documents application architecture in accordance with design and functional requirements. Designs, maintains, and develops applications within our Student Information System (PowerSchool), our Special Programs System (PSSP) in accordance with defined specifications, creates system documentation, and resolves problems when they occur on existing systems.
• Defines database schemas, tables, procedures and security as it relates to a specific application.
• Works to develop and apply security standards to data across the enterprise.

On-going Operation

• Monitors and maintains application security and performs security auditing on critical systems, especially as it relates to the school’s HR and financial management systems.
• Coordinates with the other members of the technology team on upgrades, maintenance, support, and backups.
• Provides constant support for critical situations; monitor systems proactively for availability, while working to minimize downtime.
• Proven troubleshooting skills, including analyzing issues, identifying root causes, and implementing effective solutions.

Provide world-class customer service

• Demonstrate any new or enhanced system to users.
• Work with users and technical teams in a professional manner.
• Consult with management to get approval for new applications.
• Contribute to project management requirements.
• Participate in status meetings.

Support and Collaboration

• Provides advanced technical expertise to the development team in support of their role maintaining the district’s websites and custom applications.
• Assist or train other team members in resolving application problems.
• Exhibits a positive attitude and projects a positive image of the district to staff and others.
• Continues job performance enhancement by participating in appropriate professional growth activities

Perform other duties as assigned by the supervisor.