State and Federal Reporting Coordinator

Job Description:

The Coordinator of State and Federal Reporting works with Alexandria City Public Schools (ACPS) staff to develop, analyze, review and submit data reports to the local, state and federal authorities. This 12-month Support position reports to the Director of Technology Services.

• Education: A Bachelor's degree in job related area required; A Master's degree preferred.

• Certifications & Licenses: Not applicable

• Experience:

• 2-5 years of experience in data extraction, analysis, and reporting
• Experience in K-12 education and/or state educational reporting and working with large data sets from different sources
• Experience establishing procedures for data management and quality control

• Key Competencies:

• Exceptional attention to detail and organization skills, the ability multi-task, meet deadlines, work unsupervised and be a flexible, creative problem solver are essential to this position.
• Familiarity with IT systems, databases, and technical support.
• Analytical skills to aggregate large data sets from multiple sources.
• Knowledge of reporting data such as the Oracle Business Intelligence Enterprise Edition suite (OBIEE). Knowledge of Structured Query Language (SQL), query building tools, and database tools such as Microsoft Access.
• Advanced knowledge of Microsoft Office products, most notably Microsoft Excel.
• Knowledge of the quality assurance and quality control principles, methods, and practices used to ensure reports meet requirements and quality standards.
• Ability to summarize data using Microsoft Excel pivot tables and other methods.
• Ability to quickly learn new systems and processes.
• Ability to adhere to guidelines of confidentiality as outlined in federal and state laws and School Board Policies and Procedures.

Essential Functions:

• Acts as the key data reporting liaison between VDOE and ACPS.
• Interfaces with the VDOE to clarify data requirements and timeline expectations.
• Develops timelines and tracking systems for all required local, state and federal reports and ensures timely submission of all reports.
• Plans, develops, coordinates, and manages multiple data gathering and reporting projects simultaneously that may cut across functional and organizational lines.
• Provides data to support the academic and financial operations of ACPS.
• Extracts, translates and loads student data from school data systems to VDOE reporting systems
• Prepares regular reports that summarize data on students and staff including but not limited to enrollment, demographics, performance, courses, etc. for local, state and federal reporting.
• Works with ACPS stakeholders to monitor and track data for irregularities; researches data irregularities to determine cause and develops plan for correction and future prevention.
• Ensures the provision of excellent service to internal and external customers and stakeholders.
• May perform other additional duties or tasks as designated by supervisor.

Compensation:

• Salary Placement for this position is Grade 35; $39.66 to $48.76 hourly, determined by The ACPS Support Staff Salary Scale

Clearances:

• Criminal Justice Fingerprint/Background Clearance.
• Tuberculosis Skin Test.
• Public Health Compliance - Must follow safety and health protocols.

WP

Required

Preferred

Job Industries

• Other