Data Director

Responsibilities

Database & Warehouse Management (40%)

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

Data Visualization & Analysis (30%)

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

Team Management (30%)

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

Skillset

• A minimum 8 years’ 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.
• Has the 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.