EDUCATIONAL SYSTEMS DATA ANALYST II (SY 26-27)

Ccsoh

Columbus (OH)

On-site

USD 65,000 - 90,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Columbus City Schools is seeking an Educational Systems Data Analyst II to perform data analysis, reporting, and data governance within student information systems. The role involves creating complex queries, developing reports, and supporting district reporting requirements.

The candidate should have a bachelor's degree in a related field and at least three years of data analysis experience, including working with education data systems.

Qualifications

  • Bachelor's degree and 3 years of data analysis/education data experience.
  • Experience using analytic software in student information or educational management systems.
  • Substitution: extra years of experience may substitute for education.

Responsibilities

  • Write advanced/complex queries to extract data from multiple databases.
  • Analyze complex data sets to support ad hoc information requests.
  • Develop ad hoc reports, dashboards, and graphs for staff interpretation.

Skills

SQL
Data analysis
Reporting
Communication

Education

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

Tools

ArcGIS Pro
ArcGIS Online
Python (ArcPy, Pandas)
SQL databases

Job description

EDUCATIONAL SYSTEMS DATA ANALYST II (SY 26-27)

Job Description

Job Title: EDUCATIONAL SYSTEMS DATA ANALYST II

Job Type: Full Time

Location: Columbus, Ohio

Department: Student Support

Benefits & Opportunities at Columbus City Schools
Build Your Career. Enjoy Great Benefits. Make a Difference!

Columbus City Schools offers more than just a job! We provide benefits and opportunities designed to support the well-being and professional growth of our employees.

Here are just a few of the benefits and opportunities CCS has to offer:
  • Health, Insurance & Paid Leave Benefits: CCS offers a variety of benefits for eligible employees. For current information regarding coverage, leave options, and eligibility, please visit our Employee Benefits webpage and Human Resources webpage.
  • Professional Growth: Opportunities for professional learning, training, and continued development.
  • Educational Support: Tuition reimbursement and professional development opportunities, subject to eligibility and applicable district policies.
And that's just the beginning!
Join Columbus City Schools—where your contributions make an impact, your professional growth is valued, and your work helps shape the future of our students.

Benefits and opportunities vary based on position, eligibility, applicable collective

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
  • 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.

Prior to application completion, please attach an OFFICIAL transcript or copy of degree indicating field of study, if applicable.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

MANAGER - HUMAN RESOURCES (STRATEGIC STAFFING )
MANAGER - HUMAN RESOURCES (STRATEGIC STAFFING )

Columbus City Schools • Columbus (OH)

On-site
USD 97,000 - 119,000
Health & Insurance
Flexible Spending Accounts
Paid Leave
+2
Accountant (SY26-27)
Accountant (SY26-27)

Columbus City Schools - Ohio • Columbus (OH)

On-site
USD 75,000 - 110,000
Health insurance
Flexible Spending Accounts
Paid leave
+2
Data Analyst, Implementation Office
Data Analyst, Implementation Office

Cleveland Metropolitan School District • United States

On-site
USD 62,000 - 86,000
Educational Data Systems Analyst II
Educational Data Systems Analyst II

Ccsoh • Columbus (OH)

On-site
USD 65,000 - 90,000
Fiscal Operations Specialist
Fiscal Operations Specialist

ESC of Central Ohio • Ohio

On-site
USD 40,000 - 48,000
CAREER PATHWAYS SPECIALIST
CAREER PATHWAYS SPECIALIST

Educational Service Center of Central Ohio (ESCCO)) • Columbus (OH)

On-site
USD 55,000 - 80,000
Fiscal Specialist
Fiscal Specialist

Educational Service Center of Central Ohio (ESCCO)) • Columbus (OH)

On-site
USD 40,000 - 52,000
Executive Secretary & Front Desk Coordinator
Executive Secretary & Front Desk Coordinator

ESC of Central Ohio • Ohio

On-site
USD 36,000 - 56,000
EMIS/ CTE Specialist
EMIS/ CTE Specialist

ACCEL Schools • Cleveland (OH)

Remote
USD 65,000 - 70,000
Medical insurance
Dental insurance
Vision insurance
+5
Executive Secretary/Front Desk Receptionist
Executive Secretary/Front Desk Receptionist

Educational Service Center of Central Ohio (ESCCO)) • Columbus (OH)

On-site
USD 36,000 - 48,000