Fundraising Data Manager

MissionWired is looking for a fundraising data manager to join our data services team to manage movement and processing of data for our clients – supporting everything from electing Democrats to combating climate change throughout the world. In this role, you will work alongside our client services team to ensure the proper ingestion, extraction, segmentation, and automation of our client’s data. Successful candidates will be responsible for: Developing custom SQL scripts within client owned data warehouses, based on agency supplied marketing segmentation plans, (Civis Platform, SQL Server, BigQuery, etc.); Creating the applicable reporting required by the internal account team, and/or client, based on the data captured in the marketing segmentation plan; Extracting final data segments as CSV files from the data warehouse and posting them to the applicable file transfer system; Creating marketing campaigns, efforts, source codes, segments, packages, and/or panels within the client’s CRM; Ingesting 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; Monitoring and maintaining the client’s warehouse ETL/ELT processes; Extracting data directly from the client’s CRM; Creating and maintaining automation workflows and processes within data warehouse platforms; Building 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; Setting up version control in GitHub; and Creating and/or making updates to analytical dashboards, such as Tableau.