Provide data to support the academic and financial operations for 1-3 schools of varying complexity; Extract, Transform and Load (ETL) student data from school data system to state reporting systems
Interpret technical file specifications, export and import data to fulfill requirements, and document steps for replication and audit preparation
Plan and organize target date/deadline timelines and tracking systems for all required reports and ensure timely submission of all reports
Create and maintain SQL and Power BI Reports to accommodate state reporting and corporate requirements
Assist with developing procedures and oversee implementation of procedures for reporting to external audiences including state agencies, funding sources, school boards, partner organizations, etc.
Manage data sets with students, staff, and course information; partner with school personnel, program and district liaisons to monitor and track data for inconsistencies, research discovered inconsistencies, develop a plan for correction and future prevention
Maintain departmental process and procedure documentation
Prepare ad hoc reports requested by external audiences with short turnaround
Other duties as assigned
Requirements
Bachelor’s degree in Math, Statistics, Education, Social Science, Research, or related field or equivalent experience working in educational reporting
Advanced Excel user
2-5 years professional experience
Experience working with large data sets from different sources
Experience with SQL Server Reports, PowerBI, or similar
Knowledge of project management a plus
Excellent communication skills, both oral and written including leading and owning the relationship with partner-customers
Comfortable with technology and ability to quickly learn new technologies
Ability to interpret technical file specification documents to produce error-free import files
Experience establishing procedures for data management and quality control
Excellent organizational and planning skills with the ability to balance multiple tasks and competing deadlines
Experience in K-12 education and/or State educational reporting a plus
Experience with ETL, report writing, programming, importing and exporting between applications
Ability to communicate effectively with school leaders, district superintendents, and state officials