Systems Analyst

Fort Smith Public Schools•Fort Smith, AR

4d•Onsite

About The Position

The Systems Analyst role is a full-time, exempt position reporting to the Director of Information Systems. This role requires a Bachelor's degree in a relevant field such as Computer Science, Management Information Systems, or Information Technology. The analyst must have expertise in relational database design, SQL programming, database management systems, and scripting. Proficiency in Microsoft Excel, including advanced functions, pivot tables, data visualization, and queries, is essential. The position involves developing, updating, and managing reporting solutions for district, state, and federal requirements, designing and generating complex reports, and implementing integrations between various data systems. The analyst will manage projects independently, serve as a liaison between business units and technology teams, and train end-users. Key responsibilities include writing scripts for data processing and automation, documenting processes, ensuring data quality and security, troubleshooting data inaccuracies, and developing/maintaining databases. The role also involves supporting applications, investigating system issues, assisting in software evaluations, and refining business rules for information systems. The analyst must be adaptable, able to manage interruptions and competing priorities, and maintain positive professional relationships while adhering to district policies and state statutes. Occasional lifting of at least 20 pounds and prolonged standing, walking, sitting, kneeling, reaching, bending, and squatting may be required.

Requirements

Bachelor’s degree at an accredited university in Computer Science, Management Information Systems, Information Technology, Engineering or relevant field.
Training in relational database design.
In-depth understanding of SQL programming language, database management systems, and scripting.
Experience or training in working with databases, reporting/analytics, or programming.
Advanced proficiency in Microsoft Excel, including formulas, pivot tables, data visualization, and data queries.
Excellent written and verbal communication skills.
Strong analytical skills with a problem-solving mindset.
Experience in serving as a liaison between business units, technology teams, and various departments.
Excellent customer service skills.
Ability to work with a wide diversity of individuals.
Ability to work with a variety of data.
Ability to utilize specific, job-related equipment.
Ability to quickly learn and adapt to new applications independently, using available resources to troubleshoot and master functionality.
Ability to design, implement, and maintain data integrations between systems.
Ability to translate stakeholder requirements into technical solutions.
Understanding of system security, secure file transfer processes, and maintaining data integrity.
Ability to manage projects from initiation to completion.
Ability to work independently with minimal supervision.
Flexibility and ability to effectively manage multiple competing priorities while effectively prioritizing and executing tasks.
Sound reporting, data validation, and process automation skills.
Ability to handle interruptions well and move between tasks with ease while still meeting a deadline.
Ability to manage multiple projects simultaneously and work both independently and collaboratively.
Maintains prompt and regular attendance.
Demonstrates the ability to maintain positive professional working relationships with others.
Abide by state statutes, school board policies, and regulations.

Nice To Haves

Knowledge of business intelligence technologies (e.g., Cognos) and data warehousing.

Responsibilities

Develop, update, and manage reporting solutions to meet district, state, and federal needs.
Design and generate complex reports proactively and upon request.
Design, implement, and maintain integrations between various data sources and systems.
Manage projects independently from start to finish, including planning, execution, and evaluation, ensuring timelines are met.
Work independently with minimal supervision, taking full ownership of projects from start to finish, including problem-solving, decision-making, and prioritizing tasks effectively.
Lead and coordinate cross-departmental collaborations for projects and system improvements, ensuring all stakeholders are aligned and informed.
Serve as a liaison between departments, ensuring clear communication and technical understanding.
Translate stakeholder needs into technical solutions and reporting deliverables.
Train end users on new tools, reports, and data processes as needed.
Write and maintain scripts for data processing, integration, and reporting.
Automate reporting processes and data workflows to improve efficiency.
Develop and maintain secure file transfer procedures.
Document processes, system configurations, and troubleshooting procedures in the ticket system.
Make recommendations, develop processes, access resources, and implement other mechanisms that will ensure the quality, integrity, and security of data.
Troubleshoot data related to district, state, and federal reporting and develop reporting solutions to help identify data inaccuracies.
Develop and maintain databases and data systems as necessary.
Translate stakeholder requirements into reporting deliverables and technical solutions.
Analyze data to ensure the accuracy and integrity of system data.
Manage and support integrations of information retrieved from management systems with regard to software vendors.
Provide support for various applications and ensure seamless functionality.
Investigate and resolve complex system and data-related issues.
Assist in evaluating new software solutions and their alignment with district needs.
Investigate and resolve issues impacting data reporting and analysis by conducting thorough research and root cause analysis.
Implement corrective actions to ensure data accuracy and reliability.
Define and refine business rules for the development and optimization of information systems, ensuring consistency, accuracy, and alignment with organizational needs.
Collaborate in designing and analyzing data to provide actionable insights and recommendations that inform and guide decision-making processes.
Ensure the accuracy and confidentiality of sensitive data, establishing and maintaining effective working relationships with team members and stakeholders.
Adapt to changing priorities and manage frequent interruptions, maintaining professionalism and emotional control under stress.
Maintain strong customer service and problem-resolution skills.
Prepare and maintain accurate records.
Plan and manage projects.
Utilize pertinent software applications.
Work with a wide diversity of individuals.
Work with a variety of data.
Utilize specific, job-related equipment.
Quickly learn and adapt to new applications independently, using available resources to troubleshoot and master functionality.
Design, implement, and maintain data integrations between systems.
Translate stakeholder requirements into technical solutions.
Understand system security, secure file transfer processes, and maintain data integrity.
Manage projects from initiation to completion.
Work independently with minimal supervision.
Effectively manage multiple competing priorities while effectively prioritizing and executing tasks.
Utilize sound reporting, data validation, and process automation skills.
Handle interruptions well and move between tasks with ease while still meeting a deadline.
Manage multiple projects simultaneously and work both independently and collaboratively.
Maintain prompt and regular attendance.
Demonstrate the ability to maintain positive professional working relationships with others.
Abide by state statutes, school board policies, and regulations.
Perform other duties as assigned by administration.