EDUCATIONAL SYSTEMS DATA ANALYST II (SY 26-27)

Columbus City Schools - Ohio; Columbus (OH); On-site; USD 75,000 - 102,000; Full time

Job summary

Columbus City Schools is seeking an Educational Systems Data Analyst II to perform advanced data analysis, reporting, and data quality assurance for student information systems. The role includes writing complex queries, generating mandated reports, and supporting data-driven decision making in the Student Support department.

The candidate should have a bachelor's degree in a related field and at least three years of data analysis experience, with proficiency in SQL, Excel, and Python (Pandas).

Qualifications

• This position requires a bachelor's degree in computer science, mathematics, or a closely related field and three years of data analysis experience.
• Experience with analytic software in student information and/or educational management systems is preferred.
• Strong SQL, data retrieval, and reporting skills are essential.

Responsibilities

• Writes advanced queries and programs to extract data from databases and generate required reporting formats.
• Analyzes complex data sets to support ad hoc information requests and mandated reporting.
• Develops ad hoc and automated reports, dashboards, and visuals for staff interpretation.
• Ensures data submitted to external agencies meets applicable laws and deadlines.
• Trains staff on specialized educational reporting systems and processes.
• Collaborates with District personnel to improve data workflows and reporting requirements.

Skills

SQL

Data analysis

Excel

Communication

Python (Pandas)

Data governance

Education

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

Tools

ArcGIS Pro

ArcGIS Online

ArcPy

Pandas

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.

Duties

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.

Test/Job Contact Information

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

Unless otherwise indicated, any year of required experience is based on 12 months of full-time employment. Anything under 35 hours/week (or seasonal work) will be prorated. Please be sure that the job experience and education information in your profile is up to date and accurate before submitting your application.

The qualifications listed above are intended to represent the education, experience, skill, and ability levels typically needed to successfully perform the essential duties contained in this job description. 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.