Data Analyst

Stand.earth Published: June 22, 2020
Location
San Francisco, CA
Skill Level
Mid Level
Job Type
Full-time
Categories
Analyst / Research / Information Technology

When you apply for this position, please say you saw this job on Green Dream Jobs!!

Description

~ Stand.earth was created to challenge corporations and governments to treat people and the environment with respect, because our lives depend on it. ~

Born as Forest Ethics, we were founded nearly twenty years ago by a group of dedicated people who were working day in and day out to solve a big problem: What do you do when the health and foundation of communities and their environment are being undermined? Over the years, our work and our approach has evolved from a dedicated focus on forest protection to taking on some of the root causes of climate change and environmental injustice.

As we’ve done since the start, we pursue audacious solutions, campaign for as long as it takes to see them through, punch way above our weight, and treat everyone, including our adversaries, with respect. From keeping communities safe from dozens of proposed oil by rail terminals to protecting more than 65 acres of forest from logging, our work has resulted in sweeping industry-wide changes and environmental protection on a massive scale.

Position Overview

We are hiring a Data Analyst to take on a key role in our digital team, and help us hold some of the world’s biggest corporate polluters to account. If you find data fascinating, are passionate about observing and sharing data trends, are obsessive about process, efficiency and precision, and want the option to work from the comfort of your own home, then read on! This might be the perfect role for you. We encourage applicants to apply by July 8, 2020. This position is open until filled.

Reporting to the Digital Innovations and Analytics Director and working closely with Stand.earth’s Fundraising, Digital, and Campaign departments as well as outside consultants, the Data Analyst is responsible for designing and maintaining the sensory feedback loop that is important for critical organizational functions like digital campaigning and offline/online fundraising.  The ideal candidate will have foundational experience in migrating and analyzing large data sets, be proficient managing a Salesforce NPSP database, thrive in a demanding, mission-driven work environment, and demonstrate an interest in learning new tools and platforms.

This role will be based in the US or Canada, ideally in Pacific or Mountain time zone (working hours are 9am-5pm Pacific time). At least to start with, the role will be remote from the comfort of the candidate's own home. Once the threat of the COVID-19 pandemic has passed, we hope there will also be the option to work out of one of our hub offices.

Responsibilities

  • Maintain and optimize the operation of Stand.earth’s databases and e-campaigning tools. To give you a sense of what you’d be working with, our current tech stack is built around Engaging Networks and Salesforce, and we also use NewMode, ThruText, Payflow/Paypal/Authorize and Google Big Query.
  • Supervise and ensure the accuracy and smooth operations of gift intake and fundraising reporting procedures and supervise the delivery of consistent, accurate revenue and reconciliation reports for international fundraising and finance teams.
  • Critically examine and optimize existing table structures, relationships and processes that capture and produce information for accurate decision-making for our fundraising and digital engagement teams.
  • Maintain, troubleshoot and improve existing data pipelines between various apps and tools like Engaging Networks, Salesforce, Paypal, New Mode, and Google Big Query.
  • Use data visualization/query methods/dashboards to help the team unravel insights, make strategic recommendations and deepen the impact of their campaigning work.
  • Import and export lists for telecalling, direct mail, list swaps and online ads.
  • Produce fast and accurate data to feed into a robust six monthly budgeting, forecasting and planning process.
  • Suggest, test and implement improvements in our entire fundraising systems to bring in process efficiency and accuracy.
  • Respond to a range of priority data support requests from our digital campaign team.
  • Manage data quality by working across our teams and campaigns to make sure we have the best, cleanest, and most up-to-date information about our supporters and their actions (source codes, UTM parameters, etc.)

Qualifications

  • A minimum of 2 years’ experience working with Salesforce NPSP focusing on fundraising or digital engagement and the ability to build custom apps and objects, formula fields, workflows, custom views, and other content of intermediate complexity.
  • At least 2 years’ in-depth experience working with E-campaigning tools like NGP/VAN, ActionKit, or Engaging Networks.
  • Advanced Excel skills, including VLOOKUPS, pivot tables, nested formulas, and other Excel secrets.
  • Understanding of how basic applications are configured with various downstream and upstream dependencies.
  • There isn’t a formal educational requirement for the role, and there will be opportunities for learning and mentorship within our digital team. 

Nice to have or willing to learn:

  • A background in writing and using SQL, Python or R queries for data management or creating APIs.
  • Experience with data visualization tools like Google Data Studio, Tableau, Power BI.
  • Experience with  Google Analytics or/and Google Tag Manager Using A/B testing platforms like Optimizely or Google Optimize. 
  • Experience working or volunteering on issues of climate, environmental protection and/or environmental justice.

Personal Characteristics:

  • Passionate about climate justice and environmental protection, and juiced up by the thought of convincing governments and corporations to make meaningful and lasting change.
  • Curious to research/learn new tools, develop new professional skills, and stay on top of trends in data analytics.
  • Self-motivated and able to operate independently with minimal supervision in a remote work environment.
  • Maturity of judgment and operating talent to achieve credibility and influence with senior management, staff members, and peer organizations.
  • Committed to the values of equity, authentic communication, and collaboration.
  • A sense of humor and ability to find fulfillment in engaging with a dynamic team.

Compensation

  • This is a full-time exempt position with excellent benefits.
  • Salary will be commensurate with experience and location, and will likely be within the range of $41,250 to $65,000.00 USD or $53,625.00 - 76,500.00 CAD. 

To Apply

  • Please click "Apply" below to email a 1-page cover letter and resume with your name in the subject line and on each attachment.
    In your cover letter, include a listicle of your top five data management tools.
  • Please also make sure to let us know how you heard about this position.
  • The recruitment and interview process includes a time-bound anonymous task and two rounds of interviews.
  • No phone calls, please. Only those who will be interviewed will be contacted. 

When you apply for this position, please say you saw this job on Green Dream Jobs!!

(Visited 1 times, 220 visits today)