Database Administration (60%)
Execute regular data imports & exports, adhering to all deadlines and in coordination with outside vendor support.
Perform regular data checks and hygiene of online donor records through deduplication, assignment of constituent activist codes, and other one-off hygiene projects.
Partner with the Program Manager of Email Operations and the Development Operations team on synchronizing data between our primary donor database (BBEC) and our online marketing CRM (EveryAction) through weekly and ad hoc data syncs.
Serve as part of a multi-disciplinary team tasked with synchronizing data across CRMs using Civis Platform, an external vendor.
Perform data quality checks on incoming data from surveys and external sources such as Google Analytics, advertising pixels, and Civis Platform.
Assess current hygiene and tracking processes and propose improvements to increase efficiency, automation, and ease of reporting.
Support Development sub-teams in answering data questions as they relate to specific constituent records.
Update and document Digital Fundraising data procedures as related to the role.
Reporting and Analysis (40%)
Execute weekly and monthly reporting dashboards for digital fundraising using Google Data Studio and Tableau.
Work with vendors to set up data pathways to reporting tools.
Prepare and clean raw data for analysis.
Produce detailed analysis on past strategies to help the team improve future campaigns.
Write SQL queries using Civis Platform to build a more complete picture of online donor engagement (on-the-job training available).
Furthering Diversity, Equity, and Inclusion (DEI) at Earthjustice (Ongoing)
Proactively pursue and utilize internal and external resources to support a personal and professional development journey that increases awareness and sensitivity to the needs and concerns of individuals from diverse cultures, backgrounds and orientations.
Participate in internal committees and working groups to further institutional priorities and build an inclusive and equitable work environment that encourages and celebrates differences.
Ensure the incorporation of inclusive practices in all duties and responsibilities, on a consistent and ongoing basis, including but not limited to verbal and written interactions with constituents and Earthjustice staff.
2+ years relevant experience or College degree in Statistics (or similar field) preferred
Experience working with a donor database, email service provider database, or constituent relationship management system, preferably Blackbaud and/or EveryAction.
Experience in data interpretation in support of digital marketing strategy.
Highly experienced using Excel for data manipulation.
Experience with developing and auditing SQL queries a plus.
Ability to analyze data across multiple constituent management systems.
Adept in querying data, identifying critical information, performing analysis, and then making recommendations in support of digital fundraising strategy.
High level of proficiency with Microsoft Excel, as well as Google Data Studio or Tableau.
Prior experience in data administration and familiarity with fundraising practices and principles.
Strong time management skills and ability to set and manage competing priorities and requests.
Ability to work collaboratively with technical and non-technical roles, communicating data problems and solutions.
Meticulous attention to detail and comfort with manual and systematized data hygiene workflows.
Demonstrates an awareness and sensitivity to the needs and concerns of individuals from diverse cultures, backgrounds, and orientations.
Background and interest in environmental issues, racial justice, or social justice preferred.
We offer a competitive salary and excellent benefits that are comprehensive and competitive. We also offer an extremely congenial work environment and a casual dress code. As a 501(c)(3) organization, Earthjustice is a qualifying employer for purposes of the Public Service Loan Forgiveness (PSLF) Program.