Data Analyst
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.
District Performance Office Specialty
- Serves to focus District leadership and school staff on the appropriate data in a timely fashion, in order to make improvements in student and school outcomes.
- Supports and validates systems for monitoring patterns in school data and elevating them monthly and quarterly around the District’s anchor and outcome goals.
- Focuses on data related to student attendance, reading levels, benchmarks, credit accumulation, grades, employee attendance and retention.
- Supports production of performance frameworks and strategic analytic products using statistical (e.g., Stata, R, Python, and / or SPSS) and data visualization (e.
g., Qlik and Tableau) software.
- Recommends, implements and process improvements for internal and external district data sharing (Open Data, Data Requests) to facilitate ongoing transition from manual to automated workflows using Google Drive, Qualtrics, and other applications.
- Supports the development and maintenance of training and documentation material for the district’s business intelligence (BI) platform Qlik.
- Obtains and reviews data from database and information systems to verify information and / or check for inconsistencies.
Qualifications
Minimum Requirements
- Bachelor’s degree 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.
- 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
District Performance Office Specialty
Demonstrated knowledge of : statistical software packages, such as Stata, R, and / or SPSS, required. Google Drive system and product suite.
applied statistics electronic data processing methodology and software for the collection, cleaning and manipulation of data, statistical analysis and report generation best practices in data management, including storage, security, documentation and database design and management.
administrative policies and practices. relational database management systems (RDBMS).
- Demonstrated ability of :
- create and generate reports through District reporting tools, analyzing data from the District’s data warehouse.
- complete comprehensive data cleansing in large sets and prepare reports using statistical software such as Stata, R, Python, and / or SPSS, and data visualization software such as Qlik and / or Tableau.
- meet deadlines within a high-volume work environment
- perform as a valuable team member to accomplish goals.
- think analytically and logically.
- support administrators in the attainment of District goals and objectives.
- operate a personal computer.
- maintain electronic document management systems.
- present 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 and practice.
Bus Dispatcher
Job Summary
The School District of Philadelphia operates three bus garages to transport students to and from schools and other related educational activities.
This is administrative work supporting the daily operations at the direction of a Transportation Program Manager / Garage Supervisor.
An employee in this class is responsible for dispatching bus and truck chauffeurs to various locations within Philadelphia and the surrounding five counties.
Ensures adequate coverage for regular transportation routes and supplemental transportation. Dispatchers stay in touch with drivers on the road, communicating by phone or two-way radio.
Monitors the schedule of their assigned bus fleet and addresses any problems that arise during their operation. Dispatchers answer questions and solve problems adhering closely to the policy and procedures outlined by the School District of Philadelphia as well as federal, state, and local regulations.
Essential Functions
Assigns the bus chauffeurs to regularly scheduled bus routes or special trips; explains nature and destination of different trips or other typical assignments;
ensures adequate coverage is provided for regular bus routes; answers questions or resolves problems posed by drivers.
- Receives and answers emergency and non-emergency calls.
- Assists transportation supervisor by preparing the assignment board, sign-in sheets and the report of operations; prepares attendance records;
prepares other reports formatted on a personal computer for submission and related materials.
- Maintains up to date records essential to the operations.
- Inputs data into bus tracking software.
- Handles heavy phone and radio traffic.
- Performs duties professionally and resolves any issues that may arise as directed by the supervisor.
- Posts field trips and extra-curricular trips; assigns drivers and substitute drivers to cover assignments.
- Performs other duties as assigned.
Qualifications
Minimum Requirements
- High school diploma or equivalent.
- Three years of full-time, paid experience as a Bus Chauffeur or Truck Chauffeur.
- Bilingual or Multilingual experience, desired.
- Any equivalent combination of training and experience determined to be acceptable by the Office of Talent
Knowledge, Skills and Abilities
Demonstrated knowledge of : the principles, methods and procedures governing the operation of school buses and trucks.
the traffic laws of the Commonwealth of Pennsylvania, Federal Department of Transportation (DOT) regulations, Occupational Safety and Health Administration (OSHA), Hazardous Materials (HAZMAT and other relevant governmental and industrial standards and policies.
the geography of the city and current traffic conditions. Geotagging technology.
- Demonstrated ability to :
- assign the work of a group of employees engaged in operating buses or other vehicles to ensure maximum coverage on the various transportation routes.
- maintain records and prepare reports.
- understand and follow oral and written instructions.
- establish and maintain effective working relationships.
- analyze and evaluate routing patterns for efficiency of operation.
- utilize two-way radio and state-of-the-art communications and electronic equipment.
- work under pressure and handle a high work volume.
- use Geotagging technology.