Data Coordinator

Company Details

We believe every child in Philadelphia should receive a great ed


Organization Summary

The Philadelphia School Partnership (PSP) works to give every child in America’s fifth largest city the opportunity to attend a great school. We invest philanthropic funds in high-impact schools so they can serve more low-income students—whether they be in the traditional public, public charter or private sectors. Our aim is to catalyze the creation or transformation of enough schools to ensure better options for 50,000 students, or nearly one in four of all Philadelphia schoolchildren. Since 2011 PSP has invested in more than 50 schools, creating new educational opportunity for 21,000 students. PSP also works to create the conditions that enable great schools to grow and thrive, including a strong pipeline of qualified teachers and principals, resources and initiatives to empower parents and families, and policies that enable entrepreneurial school leadership and create opportunity for high-performing schools to grow. Additionally, PSP invests to catalyze collaboration, facilitating the sharing of best practices among schools and support organizations. Nonpartisan and data-driven, we work with government officials, business leaders, education leaders and practitioners, and community groups to pursue the promise of a great school for every child.


PSP believes that in a city as large as Philadelphia, there is not one best or right kind of school. Two hundred forty thousand children need a wide variety of schools from which to choose. The city has numerous examples of high-performing schools, and they span all three primary sectors: charter schools, district schools and private/Catholic schools. Unfortunately, there is a shortage of quality options in all three sectors. More than 35,000 students sit on waiting lists for the city’s best schools—which include private, charter, district magnet, and district neighborhood schools. Our work centers on leveraging philanthropic capital to attract entrepreneurial leadership and overcome inertia and financial and political barriers so that Philadelphia can have more great schools.


Like all cities, Philadelphia has finite resources for K-12 education. PSP believes the route to effectively educating all of the city’s children lies in fomenting and sustaining an educational ecosystem that steers resources toward effective schools, regardless of sector or type of school, so they can grow; increases equity of access to all school choices for families; and utilizes multiple measures of school performance to hold schools accountable for outcomes, thus ensuring support and—if necessary—intervention for struggling schools.


Position Summary

The Philadelphia School Partnership (PSP) believes that helping to empower parents to find, choose, and advocate for higher quality schools of all types (district, charter, and private) is a critical part of our strategy to ensure every child in Philadelphia is enrolled in a great school.  We seek to deepen our relationships with partner organizations including school operators, nonprofits, government agencies, and advocacy groups to empower parents and community members to engage in local education reform efforts. Specifically, we are working to better equip families with information to find and choose great schools for their children.  As part of this work, we have created “GreatPhillySchools,” (GPS) a print and web-based resource giving parents access to data on academics, safety, and more. GreatPhillySchools is working with charters across Philadelphia to implement an online application portal allowing families to apply to charter schools on one website.

The Data Coordinator will be responsible for serving as the system administrator for GreatPhillySchools and the charter application portal – a website which will allow families to submit applications to charter schools. In addition, he/she will serve as the point of contact for participating charter schools regarding technical questions related to the portal. This position reports to the Manager, GreatPhillySchools, with an indirect reporting relationship to the Implementation Manager, ApplyPhillyCharter. He/she will work closely with the entire team including the GPS Coordinator, Interns, Project Manager, and other staff as needed.

PSP is an equal-opportunity employer with good benefits and an entrepreneurial, results-oriented work culture.


This is grant-funded position for up to 12 months, with the anticipation of roles and work moving to a new entity.


Duties and Responsibilities

·       General:

o   Report directly to the Manager, GreatPhillySchools to assist with day-to-day system management, data analysis, and customer service to schools

o   Assist with managing all technical systems including (but not limited to) Salesforce, Excel, GIS, and Google Analytics

o   Many of our internal processes are still being developed with the rollout of a new Salesforce database, so this role will include suggesting and developing efficient ways to manage our systems

·       School data collection and preparation:

o   Support training of school leaders and families on how to use our systems by developing user materials, FAQs, and ‘how to’ guides

o   Serve as a secondary point-of-contact for all schools participating in system to collect school-level data and clean/prepare it for Unified Enrollment (UE) system

o   Respond to any technical or data questions from school representatives

·       Data analysis, cleansing, and macros:

o   Cleanse and troubleshoot large data sets using excel formulas(IF, VLOOKUP, MATCH, INDEX, etc.)

o   Utilize Pivot Tables to analyze data and to guide decision making

o   Write and run Macros and VBA to streamline processes of getting data from aggregate to school level

·       System management:

o   Manage application data by ensuring all applications are complete (contacting families if there are any data errors)

o   Serve as point of contact for technology vendor to troubleshoot school or family related user experience issues

o   Test and troubleshoot enhancements to the School Finder (“GreatPhillySchools”) and the charter application platform

o   Perform some system administrator duties

·       Report Building:

o   Develop and run system-level reports with basic data on website usage, application submission

o   Support school leaders through building reports and dashboards through Salesforce

o   Create school-level Salesforce dashboards to improve school user experience

·       Perform other duties as assigned



·       Commitment to the mission of GreatPhillySchools and the Philadelphia School Partnership

·       Superior and demonstrable problem-solving, analytical, and quantitative skills combined with an inquisitive, investigative nature

·       Capable of cleaning, analyzing, managing, and processing large data sets using complex excel functions

·       Strong communication skills and the capability to synthesize complex data into easily understood e-mails

·       Ability to gather client feedback and customize Salesforce reports and dashboards that serve each client’s need

·       Commitment to finding a quality education for each student in Philadelphia

·       Knowledge of Philadelphia’s education system is a plus

·       Committed to meeting deadlines while multi‐tasking numerous priorities

·       Strong customer‐service/client relationship‐building skills


Education and Experience

·       Bachelor’s degree required

·       Minimum of one to two years’ relevant work experience

·       Fluency in Spanish (written and verbal), strongly preferred

·       Proficient in Microsoft Word, Excel, PowerPoint, and Outlook

·       Proficient in Google Drive products (i.e., Google Sheets, Google Docs)

·       Proficient in Excel with experience developing and maintaining Macros

·       Experience with Salesforce or a similar database, strongly preferred

·       Experience with GIS is a plus

·       Experience with Google Analytics is a plus


Physical Requirements

Ability to physically perform the duties and to work in the environmental conditions required such as:

·       Traveling to schools and community events – valid driver’s license and/or access to transportation when necessary

·       Functioning in office space – reaching file cabinets, filing, faxing, scanning, coping, typing, mailing, making phone calls

·       Must be able to sit for up to two hours looking at a computer monitor, using a keyboard/mouse and typing

·       Must be able to lift up to 25lbs on a frequent basis


Application Instructions

Email resume and cover letter to Molly Farley, Human Resources Consultant, at

Salary commensurate with experience, along with excellent benefits.

A modest relocation package may also be available for out-of-state candidates.