EDUCATIONAL SYSTEMS DATA ANALYST II (SY 26-27)

Columbus City Schools - Ohio; Columbus, Northern (OH, KY); Hybrid; USD 88,000 - 95,000; Full time

Job summary

Columbus City Schools seeks an Educational Systems Data Analyst II to perform advanced data analysis on student information and educational systems. The role involves developing ad hoc and automated reports, dashboards, and data visualizations to support planning and compliance.

The ideal candidate holds a bachelor's degree in CS, mathematics, or a related field with at least three years of data analysis experience and strong SQL/Excel skills.

Qualifications

• Bachelor's degree in computer science, mathematics, or a closely related field and 3+ years of data analysis experience.
• Experience using analytic software in student information or educational management systems.
• Ability to write complex queries and reports for mandated reporting.

Responsibilities

• Writes complex queries to extract data from multiple databases and prepares reports for local, state, and federal agencies.
• Analyzes complex data sets to support ad hoc information requests.
• Develops ad hoc and regular reports, dashboards, and graphs to aid decision-makers.
• Ensures data submissions to external agencies meet applicable laws and deadlines.
• Trains staff on specialized reporting systems and maintains documentation for data retrieval processes.
• Collaborates with District personnel to improve workflows and reporting requirements.

Skills

Data analysis

SQL

Excel

GIS data handling

Data visualization

Education

Bachelor's degree in computer science, mathematics, or related field

Tools

ArcGIS Pro

ArcGIS Online

Enterprise GIS databases

Python (ArcPy, Pandas)

Job description

EDUCATIONAL SYSTEMS DATA ANALYST II (SY 26-27)

Job Description

Job Title: EDUCATIONAL SYSTEMS DATA ANALYST II

Salary: $42.64 Hourly

Job Type: Full Time

Location: Columbus, Ohio

Department: Student Support

Definition:

This job posting is for a noncompetitive position and will create a new list. The hiring department will conduct a preliminary review of your application to determine who to interview. It is the responsibility of all applicants to provide a complete list of relevant work experience (previous and current) on the application. Resumes will not be accepted in lieu of listed work experience.

This is not a remote position.

Under direction, is responsible for performing fully skilled analysis, interpretation, and validation of data from student information and specialized educational management information systems; performs related duties as required.

Examples of Work (Any one position may not include all the duties listed nor do the examples cover all the duties that may be performed):

• Writes advanced or complex queries and programs to extract data from a variety of databases; integrates data into required reporting formats; provides required reporting documentation to local, state, and federal agencies.
• Performs analysis of complex data sets in support of ad hoc and specialized information requests.
• Develops ad hoc, custom, and/or complex reports, tables, and graphs; provides assistance to staff in interpreting and analyzing results.
• Compiles data into mandated reporting formats; ensures that data submitted to external agencies meets all applicable laws, regulations, and dates, as they relate to reporting requirements.
• Analyzes reporting processes to recommend procedures to support effective and efficient compilation of data necessary for mandated reporting requirements.
• Trains personnel on the specialized educational reporting systems.
• Participates in developing standards, policies, and procedures for data retrieval and reporting; identifies ways to facilitate processes to eliminate recurring types of errors; instructs users in new methods.
• Partners with District personnel to improve workflow processes and ensures an understanding of data needs and reporting requirements.

DEPARTMENTAL PREFERENCES: DEPARTMENT OF STRATEGY & PERFORMANCE

• Design and evaluate school attendance boundary scenarios, including redistricting analyses to optimize facility utilization, manage overcrowding, and assess impacts on student demographics.
• Maintain and analyze facility capacity and utilization data by integrating spatial student data with building capacity data to identify current and projected space deficits or surpluses.
• Develop, maintain, and automate geospatial data integration processes between student information systems, facility databases, and GIS platforms.
• Configure and support automated geocoding and spatial updating processes to ensure accurate alignment between student enrollment data and geographic planning datasets.
• Conduct enrollment forecasting using geospatial and demographic data, incorporating census trends, birth data, and residential development activity.
• Develop maps, dashboards, and visualizations that communicate planning scenarios, boundary proposals, and facility capacity analyses.
• Manage and maintain GIS data layers and geodatabases to ensure spatial data integrity and quality control.
• Department-specific qualifications:
• Three (3) years experience in spatial analysis, demographic modeling, facility planning, or related geospatial work;
• Advanced proficiency with ArcGIS Pro, ArcGIS Online, and enterprise GIS databases, Python (ArcPy, Pandas) for spatial data processing and automation;
• Knowledge of spatial data management and GIS integration with enterprise systems;
• Understanding of FERPA and data governance requirements for student data.
• Preferred GISP or AICP certification.

Minimum Required Qualifications:

Possession of a bachelor's degree with significant coursework (21 semester or 32 quarter hours) in computer science, mathematics, or a closely related field, and three (3) years of experience in data analysis and research, one year of which includes experience using analytic software in a student information and/or educational management information system.

Substitution:Additional years of the specified experience may substitute for the educational requirement on a year-for-year basis.

Knowledge, Skills, and Abilities:

Considerable knowledge of data analysis processes and procedures; considerable knowledge of data quality assurance processes and procedure; considerable knowledge of relational databases and data retrieval methods; considerable knowledge of research and problem-solving techniques; considerable knowledge of SQL; general knowledge of documentation and report writing procedures; general knowledge of Microsoft Office software, including Excel; general knowledge of the techniques used to write queries and simple programs; ability to retrieve and manipulate large data sets to identify patterns, problems, and errors; ability to use logic and analysis to solve problems; ability to develop priorities and work sequences; ability to prepare and maintain records; ability to organize and summarize information in written format; ability to communicate effectively, both orally and in writing; ability to develop and maintain working relationships with others.

Columbus City Schools (CCS) is an equal opportunity employer and does not discriminate against individuals regardless of race, sex, sexual orientation, religion, national origin, age, gender identity or expression, ancestry, familial status, military status or disability in its educational programs, activities, and employment policies. CCS fully supports the hiring and employment of individuals with physical or mental disabilities who meet the job qualifications, so long as the individuals are able to perform the essential duties of the position with or without reasonable accommodation.

Email: [e-mail]