Lead Systems Analyst Programmer

Responsibilities

• Manage the Data Services team consisting of a Systems Analyst Programmer and a Database Specialist
• Evaluate the performance of the team members and recommend professional development and training opportunities
• Manage large scale system projects, systems comparisons and evaluations, software development, and software implementation projects
• Develop project plans and timelines, coordinate personnel involved, track progress of tasks, lead project meetings, and prepare minutes and status reports
• Oversee the requirements gathering and writing of programming specifications for systems enhancements, reporting, and systems integrations
• Oversee the testing and implementation of new systems and system enhancements
• Identify the need for and lead the development and documentation of systems, policies, procedures, workflows, dataflow, and training materials related to systems
• Train end users as needed
• Oversee the District's state and federal student data reporting tasks
• Develop reports and system interfaces using SQL, PowerShell, and other programming languages
• Develop data visualizations of student and staff data using Tableau

Requirements

• Advanced knowledge of database design and programming
• Advanced knowledge of Infinite Campus SIS
• Advanced Excel, Google Sheets, SQL, PowerShell, and Tableau
• Excellent analytical and problem-solving skills
• Strong project management and organizational/time management skills, excellent attention to detail, and ability to effectively prioritize workload
• Able to manage multiple projects simultaneously and independently
• Must be a team player, a supportive manager, be able to influence others without formal authority
• Must possess strong verbal and written communication skills
• Self-starter with ability to anticipate business needs and offer proactive recommendations
• Excellent interpersonal and collaboration skills to interact effectively with all levels of stakeholders
• Knowledge of public schools, their databases and systems preferred

Skills

• Advanced knowledge of database design and programming
• Advanced knowledge of Infinite Campus SIS
• Advanced Excel, Google Sheets, SQL, PowerShell, and Tableau
• Excellent analytical and problem-solving skills
• Strong project management and organizational/time management skills, excellent attention to detail, and ability to effectively prioritize workload
• Able to manage multiple projects simultaneously and independently
• Must be a team player, a supportive manager, be able to influence others without formal authority
• Must possess strong verbal and written communication skills
• Self-starter with ability to anticipate business needs and offer proactive recommendations
• Excellent interpersonal and collaboration skills to interact effectively with all levels of stakeholders
• Knowledge of public schools, their databases and systems preferred

Qualifications

• Either: A Bachelor's Degree* and five (5) years of work experience where the primary function of the position was in the analysis and design of computer or internet based information systems or computer programming, including two (2) years in a supervisory capacity
• An Associate's Degree* and seven (7) years of experience as stated in (a), including the two (2) years in a supervisory capacity
• Graduation from high school or high school equivalency diploma and nine (9) years' experience as stated in (a), including the two (2) years in a supervisory capacity
• Satisfactory completion of a bachelor's degree* in Computer Science, Information Technology, Computer Systems, or a closely related field may be substituted for one year of the above stated work experience
• No substitution for the required two (2) years of experience in a supervisor capacity