Data Analyst

Job Title: Data Analyst, RevenueDepartment: Strategy - Data & AnalyticsLocation: Remote within the USReports To: Deputy Chief of Data AnalyticsSupervises: 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.

Job activities include but are not limited to:

• 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.

The successful candidate must demonstrate the following skills, experience and competencies:

• 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.