Data Analyst

This is a full-time 12-month, CASA represented position.

Job Summary

Provides administrative and analytic support to internal and external constituents. Designs, modifies, develops, maintains and implements data software and tracking systems. Creates reports/dashboards, develops automated metrics dashboards of key business metrics at requested frequencies and provides ad-hoc data analysis. Trouble shoots, maintains databases and serves as a resource to District personnel and representatives of external organizations.

Essential Functions

All Specialties

• Fulfills data requests from upper District management, media sources, outside benchmarking organizations, government agencies, and other internal and external customers; refines requests for information to provide management with improved decision-making capabilities.
• Designs, implements, maintains, validates and analyzes data maintained in databases to ensure accuracy; identifies areas where data quality requires improvement and collaborates with team members to resolve issues.
• Prepares analytical data reports for multifunctional purposes on a regular and ad hoc basis; identifies maps and integrates new data sources.
• Troubleshoots and provides end-user support for databases in the assigned division.
• Creates reports utilizing the District's data warehouse.
• Serves as a resource for development projects.
• Provides data and technical support to various administrative offices and schools to enable them to make data driven decisions.
• Furnishes data to external constituents to inform and foster positive relationships.
• Develops reporting tools that capture pertinent academic and climate indicators such as school-wide and student-level performance data.
• Develops clear, simple, visual displays of data that inform high-stake decisions.

Food Services Specialty

• Completes and maintains CN-PEARS data for state mandated reporting.
• Performs edit checks on all Point-of-Sale (POS) student meal/ attendance data.
• Prepares meal claim data for all feeding programs for federal reimbursement.
• Prepares all reports needed for outside agencies and surveys requested (Council of Great City Schools, FRAC, Federal Studies, Research Partners, etc.)
• Creates and administers on-line surveys for the Division; synthesizes data obtained from survey tools and generates reports to disseminate information.
• Maintains accurate directory of all serving locations including tracking of programs and services administered at each individual school; generates and tracks the history of programs offered at individual locations.
• Synthesizes data from POS system to write meaningful reports useful for Operations including profit and loss, meal analysis, meals per labor and additional analysis as needed.
• Coordinates and manages the annual afterschool programs application processes.
• Maintains accurate records of program information including monitoring visits, start and end dates of programs and all information required for PDE- CACFP program compliance.
• Coordinates all building data and tracking of weekly Operating Reports of Meals for the Summer meals programs.
• Recommends and implements process flow improvements to facilitate ongoing transition from manual to automated controls.

Minimum Requirements

• Bachelor's degree program from an accredited college or university.
• Three years of full-time, paid, professional experience with database technology, educational data reporting and analysis and/or educational performance data.

OR

• Any equivalent combination of training and experience determined to be acceptable by the Office of Talent in collaboration with the assigned office.

Knowledge, Skills and Abilities

Demonstrated knowledge of:

• various databases such as Filemaker Pro, MS Excel and MS Access.
• reporting applications such as Crystal Reports and District mainframe Disystems.
• Google docs.
• applied statistics and using information to change behaviors and outcomes.
• administrative policies and practices.

Demonstrated ability to:

• create and generate reports through Crystal Reports or other District reporting tools, analyzing data from the District's mainframe system.
• manipulate data using various spreadsheet applications such as MS Excel.
• prepare statistical reports using statistical software such as STTA, SPSS.
• meet multiple deadlines in a fast paced and demanding work environment.
• work independently in a fluid environment as part of a team to accomplish goals.
• think analytically and logically.
• support administrators in the attainment of District goals and objectives.
• operate a personal computer.
• express ideas effectively, both orally and in writing.
• establish and maintain effective working relationships with both internal staff and external partners.
• give attention to detail.
• apply problem solving skills in the maintenance of databases/ tracking systems.
• be passionate about educational equity.
• be passionate about using quantitative analysis to drive policy.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.