The Data Analyst for the Strategy & Impact department will provide professional support in the data collection and analysis of programs funded through the Jewish Federation of Greater Philadelphia’s various funding sources. This position provides research support for Jewish Federation staff around priority areas and manages the day-to-day details of monitoring each grant. This position acts as a resource to the staff around evaluation. This position reports directly to the Chief Strategy and Impact Officer. The individual in this role has the authority to act on behalf of the Jewish Federation on matters related to the monitoring and evaluation of community needs and programming, and relationships with key community audiences and professionals in the field. The Data Analyst has shared accountability for activities and operating results in this area of the Jewish Federation effort. The Analyst has no direct supervisory responsibility but maintains strong working relationships with the Jewish Federation’s program, fundraising, and engagement staff in the design and implementation of their grantees’ evaluation plans, and a consulting relationship with the staff of organizations that receive Jewish Federation funding.
Major responsibilities Include
Data, analysis, and reporting
- Create and manage ad hoc and scheduled reports for each grant process and in aggregate across funding sources
- Analyze evaluation reports and generate high-level summaries for each grantee, aggregate trend tables for comparison, a list of capacity issues, and a summary of initiative level recommendations based on data
- Provide summaries of themes or trends in funding priorities and gaps as well as the performance of grantees across grant processes, priority areas or other parameters
- Assist the department in writing evaluation reports and presentations of grant performance and findings to key community stakeholders
- Develop user expertise in PowerBI and/or Tableau visual reporting dashboards
- Fulfill ad-hoc data requests from Strategy & Impact, FRD, or Marketing teams as necessary
Community Research Activities
- Implements and maintains data collection and analysis systems in support of research protocol; may coordinate the collection and analysis of research data
- Recruits, instructs, and coordinates research subjects and/or volunteers, as appropriate to specific study objectives and work scope
- Ensures the smooth and efficient day-to-day operation of research and data collection activities; acts as the primary administrative point of contact for other Federation staff and as the principal operational liaison for other organizations and stakeholders
- Monitors the progress of research activities; develops and maintains records of research activities and prepares periodic and ad hoc reports as needed
- Plans and coordinates any related committee meetings
Supporting Systems and Workflow
- Oversee the quality and accuracy of data pulled from donor CRM and within grants management database
- Work with the Grants Coordinator to oversee data collection and entry related to grantee evaluation reports
- Manage data requests and regular data responsibilities utilizing our project management platform Airtable
Ensuring Data Quality and Segmentation Accuracy
- Provide data quality control for the department
- Perform quality control checks on grantee data and quality control audits on key dashboards and reports
- Ensure results from all grant processes across are visualized into reports that can be accessed by members of Strategy & Impact, FRD or Marketing teams as well as others in the organization as needed
- Audit data synchronization between grants management database and other donor CRM and fundraising or financial systems and troubleshoot problems
- Troubleshoot errors and source data or identify transformation problems
Performance Measures
- Accuracy, timeliness and professional presentation of all work
- Limitations of data or interpretations are clearly described
- Best practices are researched and communicated
- Results and recommendations are plausible, accurate, and based on appropriate data analysis
- Results are delivered in a clear, comprehensible manner in oral and written format when necessary
- Databases and tools are used in most efficient manner
- Effort to continuously improve processes and procedures
Successful Candidates Will Possess the Following Skills, Experience and Knowledge
- 1-3+ years of experience building analytics reports and visualization using a variety of tools in a business/marketing or nonprofit setting
- Ability to think through problems systematically, integrate information from multiple sources, propose and implement solutions
- Bachelor’s degree or higher in social sciences or related field
- Ability to develop and conduct program evaluation plans, design and administer assessment instruments, collect and analyze data, and write reports
- Knowledge of research methods, principles, and applications
- Demonstrated ability to apply and interpret basic statistical analyses
- Ability to conduct literature reviews and critique research studies
- Strong interest in research and social services
- Excellent interpersonal skills to work effectively with Jewish Federation staff and external organizations
- Strong oral and written communication skills to present information to both lay and professional audiences
- Strong analytical, leadership, and time management skills
- Proficiency in Microsoft Office Suite
- Attention to detail and ability to organize own work processes
- Demonstrated ability to produce deliverables accurately, with minimal oversight, reliably, and in a timely manner
- Data visualization skills, able to turn data into clear charts that tell the story
- Advanced skills in Excel, at least beginner skills in Tableau or Power BI, advanced PowerPoint skills, and strong computer literacy overall
Preferred
- Intermediate to advanced SQL skills
- Familiarity with Blackbaud CRM and GivingData platforms preferred
- Familiarity with data storage and analysis systems such as SPPS is an asset
- Familiarity with compiling and editing audio files is an asset.
If this is the right fit for you, let’s connect!
If you are interested in being considered for this position, please send a resume and cover letter, detailing your qualifications and salary requirements to jobs@jewishphilly.org
Jewish Federation of Greater Philadelphia offers a competitive compensation and benefits package, including a hybrid work schedule, medical, dental, vision, prescription drug program, life insurance, generous paid time off and 403 retirement savings program.
OUR MISSION
The Jewish Federation of Greater Philadelphia mobilizes financial and volunteer resources to address the communities’ most critical priorities locally, in Israel and around the world.
COMMITMENT TO DIVERSITY
We deeply value the diversity of insight, perspective, and experience brought by people from backgrounds typically underrepresented in Jewish institutions. This includes Black, Latinx, and Asian people, Black Jews, Jews of Color, lesbian, gay, bisexual, trans, and gender non-conforming people, and people with disabilities. We also welcome applications from people of diverse religious, spiritual, and cultural backgrounds.