EDUCATIONAL SYSTEMS DATA ANALYST

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.

Do you have experience in Research?, Do you have a Bachelor’s degree?, 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., * 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

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.