About the Role
ProPublica is seeking a data analyst to assist the development team in building reporting infrastructure to support donor growth. This 12-month temporary position will focus on strengthening Salesforce reporting, donor acquisition tracking, and fundraising analytics.
Responsibilities
- Assess and strengthen Salesforce reporting capabilities, identifying gaps and opportunities for improvement.
- Build and standardize reporting that supports donor acquisition, retention, recurring giving conversion, upgrades, lapses, reactivation, and donor progression.
- Develop consistent attribution methodologies for donor acquisition and first-gift tracking.
- Create shared reporting definitions, documentation, and business rules to improve consistency across teams.
- Evaluate how donor, campaign, and engagement data flows between Salesforce and connected systems.
- Identify data quality issues, attribution gaps, and reporting inconsistencies, and recommend practical solutions.
- Partner with product and development services to improve reporting reliability, data quality, and donor journey visibility.
- Help define and operationalize donor acquisition pathways across channels.
- Build dashboards and recurring reporting tools to support fundraising strategy, campaign analysis, audience segmentation, and leadership decision-making.
- Reduce reliance on manual spreadsheets and ad hoc reporting by creating scalable, self-service reporting resources.
Requirements
- 5+ years of experience building reports, dashboards, and analytical frameworks in Salesforce.
- Experience with donor databases, CRM systems, and fundraising operations, ideally within nonprofit, membership, or philanthropy organizations.
- Strong understanding of donor acquisition, retention, recurring giving, donor upgrades, and life cycle reporting.
- Experience working across integrated systems such as Salesforce, email service providers, and donation platforms.
- Ability to translate complex business questions into clear reporting structures and actionable insights.
- Strong SQL skills required.
- Comfort working in evolving environments and improving systems incrementally.
- Strong communication and collaboration skills, with the ability to work effectively across technical and nontechnical teams.
- An entrepreneurial approach to problem-solving and stakeholder engagement.
- Applicants must be eligible to work in the U.S.
Skills
- Salesforce reporting
- Fundraising analytics
- SQL
- Python
- R
- Data visualization tools
- Donor databases
- CRM systems
- Fundraising operations
- Donor acquisition
- Donor retention
- Recurring giving
- Donor upgrades
- Life cycle reporting
- Integrated systems
- Email service providers
- Donation platforms
- Communication
- Collaboration
Location
- New York City
- Washington, D.C.
- Atlanta
- Chicago
- Phoenix
- Berkeley, California
- Remote
Work Type
- Full-time
- Temporary
- Remote
Experience Level
- 5+ years of experience
Salary/Compensations
- $95,000 to $115,000
Benefits
- Includes benefits
About the Company
- ProPublica is an independent, nonprofit newsroom that produces investigative journalism in the public interest.
Equal Opportunity
- We are dedicated to improving our newsroom, in part by better reflecting the people we cover. We are committed to diversity and building an inclusive environment for people of all backgrounds and ages. We especially encourage members of traditionally underrepresented communities to apply, including women, people of color, LGBTQ+ people and people with disabilities. We are an equal opportunity employer and prohibit discrimination and harassment of any kind. All employment decisions are made without regard to race, color, religion, sex, sexual orientation, national origin, age or any other status protected under applicable law.
