Database Administrator

Title:                            Database Administrator

Reports To:                 Director of Grants Management

Location:                    Philadelphia

Travel:                         0-5%

Direct Reports:          None

Preparation Date:      September 2017

 

The William Penn Foundation is a leading American philanthropy located in Philadelphia. With over $2 billion in assets and a $100+ million annual grant budget, the Foundation is a vital part of the civic life in one of the country’s most important and historically significant regions.  The Foundation has charted a vision consistent with its enduring focus on education, the environment and the cultural vitality of Greater Philadelphia.

The Foundation’s core strategies include:

  • Increasing the number of low-income children receiving a high-quality education
  • Ensuring clean water by protecting the Delaware River watershed
  • Fostering a vibrant city through support to arts and culture organizations, arts education programs, and creating great public spaces

The Foundation believes that successful execution of these strategies is critical to the success of the region and seeks candidates who will operate with a sense of urgency, leadership and entrepreneurship in advancing this work.

 

Position Summary

The William Penn Foundation seeks a Database Administrator to join its Grants Management team, supporting grantmaking activities, evaluation, and learning in service of the Foundation’s mission.  Reporting to the Director of Grants Management, this positon will work in collaboration with Programs, IT, and Evaluation to manage WPF’s grants database and CRM using Salesforce and roundCorner’s foundationConnect.

 

Responsibilities

  • Build, test, and deploy solutions related to WPF’s implementation of Salesforce and related applications, including custom objects/fields, page layouts/views, workflows/flows/process builder, and other configurations as needed.
  • Maintain, create and update user roles, security, profiles, workflow rules, etc.
  • Responsible for the accuracy, quality, integrity and definition of internal data collection and internal code structures.  
  • In collaboration with IT:
    • Ensure inter-operability and reliability across platforms
    • Responsible for developing and updating system documentation and related materials, including procedures and maintenance of the Salesforce data dictionary
    • Implement, deploy, and maintain integrations to other systems
    • Stay current with Salesforce releases and leverage updates applicable to the Foundation’s needs
    • Manage ongoing support requests and administrative needs of users such as: building customized reports and dashboards, setting up automation, troubleshooting issues, etc.
  • Create new reporting capabilities and respond to ad hoc reporting requests, as needed, for internal grant reports, evaluation and opportunity analysis, and forecasting.
  • Maintain data integrity. Ensure data is clean, accurate, and complete; includes scheduling regular data cleaning activities and ensuring users have the training they need to properly input data.
  • Plan, review, and customize Salesforce and associated products to optimize productivity and meet the changing needs of the organization and industry best practices
  • In collaboration with the Director of Evaluation and Learning:
    • Manage the data on grant center metrics, key performance indicators, and other grant-related activities
    • Develop reports, dashboards, and data visualizations for presentation and analysis to WPF staff and board.
    • Work with internal teams to understand and resolve specific data collection and/or analysis needs.

 

Requirements

  • Critical Thinking - the ability to monitor, assess, respond to, and create changes to internal systems if data and/or internal/external factors indicate the need to make a shift in programmatic decision-making.
  • Project Management – the ability to utilize time and resources effectively and efficiently.
  • Technical Capacity – the resources, skills, experience, knowledge, and aptitude to utilize data and analytical tools to solve issues
  • Interpersonal Communications - the ability to effectively engage and communicate with non-technical staff on the execution of solutions to various needs.
  • Flexible/Adaptable/Service Oriented – Able to support the needs of different types of users/personalities across multiple functions and independently manage shifting priorities. Can quickly move from report building to automation to troubleshooting mode to end user support to systems planning. Able to communicate openly about shifting priorities, timelines and workload.

 

Education, Training, Skills and Experience

  • 3-5 years related and relevant work experience required
  • Prior experience in a nonprofit or philanthropy environment preferred
  • Strong detail orientation and quantitative skills
  • Good interpersonal skills, sense of urgency, and ownership
  • Excellent organization, prioritization, follow-up, analytical, and time management skills
  • Ability to handle multiple priorities, deadlines, and challenging situations
  • Dependable, with strong work ethic and personal integrity

 

Physical Demands/Work Environment

The physical demands and work environment characteristics described are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to walk, bend, sit, talk, lift, or hear. The employee is regularly required to stand, walk and use hands and arms to operate general office equipment (PC, telephone, file cabinets, copier, fax machine and printer). The employee may occasionally lift and/or move up to ten (10) pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.  The noise level in the work environment is usually low to moderate.

The William Penn Foundation is an equal opportunity employer and considers applications without regard to race, color, religion, creed, age, gender, marital status or sexual orientation. All who believe they meet the stated qualifications are invited to apply. Applications may be submitted to wpfjobs@williampennfoundation.org