Educational Systems Data Analyst

Entry-level Educational Systems Data Analyst I role at Columbus City Schools analyzes, interprets, and validates data from student information and educational management systems and produces reports to support data-driven decisions.

Responsibilities

• Under general supervision, perform entry-level analysis, interpretation, and validation of data from student information systems and educational management systems, with related duties as required.
• Extract requested data from multiple databases and consolidate it into required file formats.
• Review data accuracy and integrity; identify data error patterns and correct issues by researching sources of information.
• Monitor data entries for timely and accurate completion; identify issues with data gathering, entry, and reporting by staff and system users, such as duplicates and overlapping dates.
• Learn the specialized methods required by state and federal agencies for submission of educational data.
• Assist upper level personnel with identifying process improvements to reduce recurring errors; instruct users in new methods.
• Write queries and simple programs to collect and compile data needed for reports for local, state, and federal agencies, staff, and users.
• Develop routine and ad hoc reports, tables, and graphs; help staff interpret results; develop custom reports as requested.
• Review data submitted to external agencies for compliance with applicable laws and regulations.
• May participate in developing standards, policies, and procedures for data retrieval and reporting.

Requirements

• Location: Columbus, OH (onsite)
• Compensation: USD 36 - 37 per hour
• Bachelor's degree with substantial coursework (21 semester hours or 32 quarter hours) in computer science, mathematics, or a closely related field, and one 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.

Technologies

• Excel
• SAS
• SQL
• Microsoft Office

Examples of Work

• Extracts requested data from a variety of databases and formats data for required files
• Reviews data accuracy and integrity; analyzes error patterns and resolves issues by researching information sources
• Monitors data entry for timely, accurate completion; identifies problems with data gathering, entry, and reporting by staff and system users
• Learns the specialized methods required by state and federal agencies for educational data submission
• Assists senior staff in identifying process improvements to reduce recurring errors; trains users on new methods
• Writes queries and simple programs to assemble data for reports as required by local, state, and federal agencies, staff and users
• Develops routine and ad hoc reports, tables, and graphs; assists staff in interpreting results and creating custom reports
• Reviews data submissions to external agencies for regulatory compliance
• May participate in establishing standards and procedures for data retrieval and reporting

Department Specific Duties & Qualifications

• Demonstrated experience using databases and related technologies; functional understanding of data warehouse concepts
• Write SQL queries and simple programs to assemble data for reports, as required by local, state, and federal agencies, staff and users
• Collaborate with internal and external departments to gather user requirements and document the design of deliverables (reports, dashboards, alerts, visualizations) and obtain feedback on effectiveness
• Candidates must be willing to work in person and have reliable transportation

Knowledge, Skills, and Abilities

• General knowledge of data analysis processes and data quality assurance 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 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