Data Director

Summary

Join Action for the Climate Emergency (ACE) as their Data Director! This role centers on managing ACE's databases, CRM, and analytics to provide crucial insights for global and US campaigns. You will oversee data architecture, optimize Salesforce and SQL databases, and work with the data team to ensure data accuracy and compliance. Responsibilities also include creating interactive dashboards, compiling reports, and managing a small team. The ideal candidate possesses extensive experience in digital marketing data, SQL, CRM systems, and advanced Excel skills. ACE offers a competitive salary, comprehensive benefits, and a remote work environment.

Requirements

• A minimum eight years of experience working with data related to digital marketing
• At least two years of experience with BigQuery, SQL, or data warehousing
• At least two years’ of in-depth experience working with e-campaigning tools or CRMs like NGP/VAN, ActionKit, Engaging Networks or with large nonprofit databases like Salesforce NPSP or Raiser’s edge
• Advanced Excel skills, including macros, pivot tables, nested formulas, and other amazing Excel secrets
• A background writing and using SQL/R/Python for data management and support
• Demonstrates the curiosity to research/learn new tools and professional skills and stay on top of trends in data analytics
• Ability to understand how an application is configured and its various downstream and upstream dependencies
• Demonstrates excellent presentation and documentation skills
• Possesses strong analytical and communication skills
• Is passionate about climate justice and environmental protection

Responsibilities

• Oversee the data architecture of the organization by adding/streamlining components, automating pipelines, and monitoring for errors
• Strategize and optimize Salesforce CRM and SQL database architecture, including managing objects/tables, workflows, managing automated data merging/cleaning, process builders and other administrative tasks
• Work with our Data Team to spot data anomalies and inaccuracies, take corrective and preventive measures, and ensure process compliance with all stakeholders. Maintain our in-house data compliance tools and continually improve user experience
• Work with our Data Team to design and implement table structures, relationships, integrations, and processes that capture and produce information to enable accurate decision-making in our fundraising and digital engagement teams
• Work with internal teams, contractors, and third-party services to create new data tracking processes, integrations and existing system updates
• Ensure all data ETL pipelines feed into a central location for a 360 degree view of our members and how they engage with us across our different properties
• Bring together data from different sources to create user-friendly interactive dashboards/reports
• Explore data and actively uncover and disseminate and present insights to teams
• Compile standard and ad hoc reports for internal teams and funders
• Manage a small team and several contractors
• Work with team members and leadership across the organization to help track and report relevant data
• Ensure that tasks and capacity are matched and resource additional capacity as needed
• Recruit, onboard and manage staff to meet departmental goals

Preferred Qualifications

• Experience in Salesforce CRM
• Experience working in a non-profit setting
• Professional certifications or training in Salesforce, database management, data reporting & analysis, fundraising basics, or related field(s)
• Experience building AI based applications
• Strong organizational and time management skills
• Analytical and strategic mindset
• Ability to adapt as necessary to fulfill additional roles, responsibilities, and opportunities in development programming as necessary
• Passion for ACE’s mission and our work to educate young people on climate science and empower them to take action
• Commitment toward equity and justice in philanthropy

Benefits

• Medical, Dental, Vision
• 403b retirement savings plan
• Vacation
• Sabbatical
• Paid Parental Leave
• 2 Floating Holidays
• 2 Community Service Floating Holidays
• Sick time
• Two weeks of full-staff time off (July 4 week and Christmas-New Years week)
• 13 observed holidays
• Annual salary range: $110,000-130,000, commensurate with experience
• Remote work