Senior Analyst – Fundraising Data & Analytics

The fundraising team at the Wikimedia Foundation conducts worldwide campaigns across nearly 40 countries and 20 languages, collecting small donations (averaging about $11) as well as larger offline donations to support the Wikimedia Foundation’s mission to empower and engage people around the world with free knowledge. The Fundraising Operations team has an opening for an experienced Senior Data Analyst on our team, to support data-driven decisions to improve the effectiveness of our fundraising strategies, while staying true to our values of openness, transparency, and respect of user privacy. This will be a full-time (40 hours/week) employee position.

As the Senior Data Analyst, you will be reporting to and working closely with the Senior Manager, Fundraising Data & Analytics to give insight into the most important questions for fundraising at Wikimedia—supporting our fundraising teams, from online fundraising to donor relations and major gifts. You’ll be part of a small collaborative analytics team, supported by an analytics engineer and a fellow analyst. Data tools you’ll be working with include dbt, Metabase, Superset, and Jupyter notebooks. The rest of the data stack includes MariaDB, Trino and MinIO.

You will be responsible for:

• Delivering actionable insights and analysis on global fundraising campaigns and fundraising strategic objectives to technical and non-technical stakeholders
• In collaboration with fundraising leadership, developing and tracking key performance indicators across different fundraising channels
• Partnering with colleagues in fundraising and finance to develop multi-year revenue forecasting
• Delivering reporting, statistical analysis and providing guidance on test setup within our iterative A/B testing program
• Transforming and cleaning data to support analytics needs, making it more easily and quickly accessible
• Peer reviewing your teammates’ work to ensure data quality and reliability

Some examples of the work you may do in the role:

• Strategizing with the online fundraising team on how to best turn a question or hypothesis into an A/B test to optimize their outcomes and the donor experience
• Updating a donor history table in dbt with donor email interactions to give the online fundraising team visibility into a donor’s full journey
• Building and maintaining a donor propensity model to drive revenue across the fundraising program
• Deriving key metrics to represent Wikimedia Foundation’s efforts in the annual report
• Designing a compelling visualization for the fundraising team’s monthly progress on OKRs
• Building out donor segments in a reverse-ETL tool such as Hightouch

Skills and experience for success in the role:

• Highly proficient in SQL for data transformation and queries
• Skilled in developing impactful data visualizations in a business intelligence platform (e.g., Tableau, Power BI, Metabase, or other tool)
• Practical statistical expertise and an understanding of digital campaigns
• Comfortable working with data-related Python and/or R packages for ad hoc analysis

• Experience using predictive modeling to answer actionable business questions
• Comfortable with giving and receiving code reviews through git (GitLab, GitHub, Gerrit, BitBucket, etc.)
• A record of clearly documenting your work for the benefit of your teammates and stakeholders
• Experience efficiently troubleshooting SQL queries and pipelines to find the root cause of a data anomaly
• A record of estimating work accurately and surfacing obstacles to on-time delivery in a timely way
• A practice of reaching out for support when stuck or blocked
• A growth mindset, enjoy experimenting with new tools and methods
• Excellent verbal and written communication skills including the ability to clearly communicate technical concepts to non-technical stakeholders

Qualities that are important to us:

• Strong value and mission fit with the Wikimedia movement and Wikimedia Foundation values
• Highly collaborative, comfortable working in a consensus-oriented environment
• Ability to work effectively in multiple cultural contexts

Additionally, we’d love it if you have:

• Experience working in a large, international fundraising program
• Worked effectively in a remote work environment
• Experience with open source technologies and communities
• Ease working in a terminal / command line environment
• A conceptual understanding of orchestration tools
• Experience working with noSQL and non-structured data