Fundraising Data Manager

Summary

Join MissionWired's data services team as a fundraising data manager, contributing to impactful campaigns for nonprofits and Democratic organizations. You will manage data movement and processing, ensuring proper ingestion, extraction, segmentation, and automation of client data. Responsibilities include developing custom SQL scripts, creating reports, extracting data segments, managing CRM campaigns, ingesting datasets, batching gifts, monitoring ETL/ELT processes, building custom integrations, and maintaining automation workflows. The ideal candidate possesses 2+ years of experience in data warehousing and SQL, experience with fundraising CRMs, and proficiency in version control. Additional skills in data ETL/ELT, JavaScript/Python, and dashboard creation are preferred. The salary range is $73,000 to $80,000 per year.

Requirements

• 2+ years of experience developing tables, views, functions and scripts within data warehouse systems such as Civis Platform (Redshift), SQL Server, MySQL or BigQuery
• 2+ years of advanced reading, writing and updating SQL statements in one of the following languages: SQL Server, PostgreSQL, MySQL or BigQuery
• Experience with NGP VAN or another fundraising CRM platform such as Salesforce NPSP, Blackbaud CRM, EveryAction or Raiser’s Edge
• Experience using version control tools, such as GitHub or BitBucket
• Experience working with fundraising direct marketing data
• Experience managing data conversion, manipulation, cleansing, standardization, and reporting
• Ability to maintain relationships and communicate clearly with technical and non-technical stakeholders
• Comfortability solving complex technical problems in a high volume environment
• Comfortability working independently as well as within and across teams
• Excellent organizational skills, attention to detail and ability to manage and prioritize short and long term goals
• Highly self-motivated and always looking for opportunities to make things better

Responsibilities

• Develop custom SQL scripts within client owned data warehouses, based on agency supplied marketing segmentation plans, (Civis Platform, SQL Server, BigQuery, etc.)
• Create the applicable reporting required by the internal account team, and/or client, based on the data captured in the marketing segmentation plan
• Extract final data segments as CSV files from the data warehouse and posting them to the applicable file transfer system
• Create marketing campaigns, efforts, source codes, segments, packages, and/or panels within the client’s CRM
• Ingest datasets into the client’s CRM using built-in CRM tools, 3rd party ingestion tools and/or data warehouse connectors
• Batching new fundraising gifts into the client’s CRM
• Monitor and maintain the client’s warehouse ETL/ELT processes
• Extract data directly from the client’s CRM
• Create and maintain automation workflows and processes within data warehouse platforms
• Build custom integrations to ingest or extract data to/from different systems. I.e. Build a custom Python script that opens a SFTP connection, extracts a CSV file, converts the binary data into a dataframe and ingests the dataframe into a data warehouse table
• Set up version control in GitHub
• Create and/or make updates to analytical dashboards, such as Tableau

Preferred Qualifications

• Experience developing/managing data ETL/ELT in a modern data warehouse
• Experience reading and writing JavaScript and/or Python
• Experience creating, updating and maintaining dashboards in Tableau, Klipfolio or PowerBI
• Marketing agency experience

Benefits

• 100% employer-paid premiums for platinum-level medical plan on a national health care network
• 100% employer-paid life insurance and short term disability
• 50% employer-paid vision and dental insurance
• 401(k) with 3% employer contribution
• 17 vacation days in addition to 12 paid holidays, sick days, bereavement leave, and a volunteer day off
• Paid parental leave at 100% of your salary
• Financial support for reproductive and transgender care
• Flexible telecommute and remote work policies
• Company issued Mac products for home offices
• Cell phone service reimbursement, meal and ride-share reimbursement, and other perks available