Data Analyst

Job Title: Data Analyst, Revenue

Department: Strategy - Data & Analytics

Location: Remote within the US

Reports To: Deputy Chief of Data Analytics

Supervises: NA 

Context:  At the Sierra Club, we believe in the power of interdependence. Together, we remain committed to the fight for a healthy climate built on a foundation of environmental, racial, economic, and gender justice – a future where all people benefit from a healthy, thriving planet and a direct connection to nature. As the climate crisis and deeply entrenched systemic racism all fuel injustice, we will continue to fight for a bold, transformational agenda that recognizes the interconnectedness between our planet, our humanity, and our future. By recognizing that our destinies are tied, we continue to name that all things are fundamentally connected, and the overlap between ecology, race, gender, and representative government will move to either advance our collective humanity or to oppress it. Sierra Club has close to 800 staff across the country and a network of 64 local chapters that are led and fueled by thousands of volunteers. We are also proud to be a unionized employer, with three labor unions representing more than half of our employees.

Scope: The Data Analyst, Revenue will help Sierra Club’s revenue teams understand donation patterns, donors, and prospective donors in new ways to increase revenue. They will have ownership over building engaging self-service reports and dashboards that “wow” these teams by showing data and insights from their analysis in meaningful and actionable ways. They will work alongside staff doing fundraising and donor data management to foster and deepen a culture of data-informed decision-making.

• Reporting & Analysis:
• Develop, maintain, and distribute regular revenue reports, dashboards, and forecasts for major giving, tracking progress against goals, and identifying trends.
• Analyze major giving revenue streams, donor segments, and solicitation strategies to identify opportunities for growth and optimization.
• Prepare ad-hoc reports and analyses as requested by leadership 
• Conduct in-depth analysis of all donors to identify prospective mid-level and major donors, understand donor behavior, and estimate future giving.
• Segment donors to facilitate targeted outreach strategies.

• Data Management & Optimization:
• Assist with data imports, exports, and data hygiene within Salesforce and back-end data systems.
• Identify data discrepancies and work to ensure data accuracy and consistency across all platforms.
• Participate in cross-functional projects related to fundraising data management, system integrations, and reporting.

• Business Process Documentation & Improvement:
• Document current data processes, workflows, and policies within Salesforce and other relevant systems.
• Identify opportunities for process efficiencies and improvements related to data collection, organization, and reporting for major gifts and other fundraising work.
• Collaborate with the Advancement team to implement and reinforce data governance policies.

• 3 + years of experience or equivalent in a relevant data and analytics role (data analyst, data scientist, data manager, data engineer) with emphasis on producing meaningful insights 
• 2 + years of experience using common fundraising CRMs for revenue tracking and reporting
• Experience creating reports, dashboards, and visualizations in Tableau, Looker Studio, or similar software tools
• Proficiency using SQL to create and extract custom data sets from multiple tables.
• Proficiency with Microsoft Excel, including utilizing formulas, charts, and pivot tables
• Demonstrated analytical and problem-solving skills with a keen attention to detail
• Strong organizational skills and comfort with dynamic work in a fast-paced, deadline-driven environment
• Comfortable working independently and as part of cross-functional teams
• Committed to evolution. You are committed to continuously deepening and evolving your own understanding of systems of oppression through study, openness, and humility. And you easily recognize your own relationship to privilege and power, examining and shifting your behaviors as appropriate.
• Uplifting and additive. You see mistakes as opportunities for growth; problems as catalysts for solutions, and inspire others along the journey. You carry a constructive approach, can-do attitude, a sense of humor, and authentic kindness wherever you go.

• Proficiency using Salesforce for revenue tracking and reporting
• Experience using Civis Platform
• Proficiency in either Python or R for data cleaning and analysis
• Understanding of Major Donor / Major Giving fundraising work
• Previous work experience in medium-sized nonprofit advocacy organizations or a candidate's political campaign

To Apply

The Sierra Club provides equal employment and advancement opportunities to all staff members. Employment decisions are based on merit, qualifications, lived experience and skills. The Sierra Club does not discriminate in employment opportunities or practices on the basis of race, color, creed, religion, national origin, immigration status, socioeconomic status, ancestry, age, size, sex, sexual orientation, gender, gender identity, familial status, veteran status, disability, AIDS/HIV status, medical condition, prior conviction, arrest history, traits historically associated with race, including, but not limited to, hair texture and protective hairstyles, or any other characteristic protected by law.

The Sierra Club values applicants who are people that identify as Black, Indigenous, and other minoritized groups; women; queer, transgender, gender non-conforming, and gender fluid people.

Explore, enjoy and protect the planet.