Education Systems Data Analyst I (SY26-27)

Job Title: EDUCATIONAL SYSTEMS DATA ANALYST I

Salary: $36.67 Hourly

Job Type: Full Time

Location: Columbus, Ohio

Department: Various - typically this position is located in IT, Dept. of Strategic Performance and Dept. of 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 general supervision, is responsible for performing entry-level analysis, interpretation, and validation of data from the student information and 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):

• Extracts requested data from a variety of databases and integrates data into required file formats;
• Reviews data accuracy and integrity; identifies and analyzes error patterns in data sets; corrects errors by researching sources of information;
• Monitors data entries for timely and accurate completion; identifies issues with methods of data gathering, entry, and reporting by staff and system users, such as duplicate entries and overlapping dates;
• Learns the specialized methods required by state and federal agencies for submission of educational data;
• Assists upper level personnel with identifying ways to facilitate processes to eliminate recurring types of errors; instructs users in new methods;
• Writes queries and simple programs to collect and compile specific data needed for reports, as required by local, state, and federal agencies, staff, and users;
• Develops routine and ad hoc reports, tables, and graphs; provides assistance to staff in interpreting and analyzing the results; develops custom reports as requested;
• Reviews data submitted to external agencies for compliance with all applicable laws and regulations;
• May participate in developing standards, policies, and procedures for data retrieval and reporting.

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 one (1) year of experience in data analysis and research.

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

Must attach official college transcript or degree for educational credit before submitting the application. 30 semester hours or 45 quarter hours = 1 academic year

Preferred Qualifications

• A minimum of Intermediate to advanced experience with Excel
• Previous experience working in the field of education
• Familiarity in transitioning SAS to SQL queries

Department specific duties & qualifications

• Demonstrated experience using databases and related technologies; functional understanding of data warehouse concepts and deliverables
• Write queries using SQL and simple programs to collect and compile specific data needed for reports, as required by local, state and federal agencies, staff and users.
• Collaborate with various internal/external departments and colleagues to gather user requirements in order to document the design of deliverables (reports, dashboards, alerts, visualizations) and obtains feedback on effectiveness of the solutions.
• Candidates must be willing to work ”in person” and have their own transportation

Knowledge, Skills, and Abilities

General knowledge of data analysis processes and procedures; general knowledge of data quality assurance processes and procedures; general knowledge of relational databases and data retrieval methods; general knowledge of research and problem-solving techniques; 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 data sets to identify patterns, problems, and errors; ability to use logic and analysis to solve problems; ability to organize and summarize information in written format; ability to communicate effectively, both orally and in writing; ability to develop and maintain effective 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.