EDUCATIONAL SYSTEMS DATA ANALYST

Job Title EDUCATIONAL SYSTEMS DATA ANALYST I 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. Examples of Work 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. 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 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 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. Equal Employment Opportunity Columbus City Schools (CCS) is an equal opportunity employer. All qualified applicants for employment will receive consideration regardless of race, sex, sexual orientation, religion, national origin, age, gender identity or expression, ancestry, familial status, military status or disability. #J-18808-Ljbffr Columbus City Schools - Ohio