At least 2 years of experience developing and managing data warehouse systems like Civis Platform, SQL Server, or BigQuery., Proficiency in writing and updating complex SQL scripts in languages such as SQL Server, PostgreSQL, MySQL, or BigQuery., Experience with fundraising CRM platforms like NGP VAN, Salesforce NPSP, or Raiser’s Edge., Strong skills in data manipulation, cleansing, standardization, and reporting, with the ability to communicate effectively with both technical and non-technical stakeholders..
Key responsibilities:
Develop custom SQL scripts for data segmentation and automation.
Create reports and dashboards based on client data and marketing plans.
Ingest and extract data from various systems, including CRMs and data warehouses.
Maintain and monitor data warehouse ETL/ELT processes and build integrations.
Report this Job
Help us maintain the quality of our job listings. If you find any issues
with this job post, please let us know. Select the reason you're reporting
this job:
At MissionWired, we harness the power of digital storytelling and connectivity. We’ve deployed millions of emails, motivated countless Facebook likes and shares and generated untold tweets and retweets. We’ve crafted strategic communications for dozens of members of both houses of Congress, large national nonprofit organizations and even The White House. We were at the vanguard of digital advocacy, inventing the tactics in wide use today.
We are a full-service agency that can tackle any challenge thrown our way. From online fundraising, acquisition advertising and analytics to coding, graphic design and writing, we have top-flight talent who’ve been recognized as the best in their fields.
Our clients include the Bill & Melinda Gates Foundation, the USO, Sandy Hook Promise, Democratic political committees and members of the U.S. Senate.
At MissionWired, we help our partners create revolutionary fundraising strategies that advance their mission, change our country, and have a positive impact on the world.
MissionWired is the only wholly integrated direct marketing agency for nonprofits and Democratic organizations. We help our partners tell big, ambitious stories that invite their supporters into communities to raise missionchanging revenue. Our results are unrivaled, having converted more than $4.5 billion in donations to the world’s most trusted philanthropies and groundbreaking campaigns. We do it over email and SMS, in the mail, across social media, everywhere. We don’t think in terms of channels; we’re singleminded in pursuit of your success.
We’re innovative, progressobsessed, dogooders who care deeply about social change and continuing to push the limits on what we can accomplish together. We’ve brought strategies to life for nonprofit organizations working around the world, including Sandy Hook Promise, Human Rights Watch, The Humane Society of the U.S., Save the Children, and Friends of the Earth. Over the years, we have worked with various progressive political organizations and believe that each election cycle is an opportunity for us to support organizations across the country and elect Democrats to legislative bodies up and down the ballot.
We’re an equalopportunity employer and take seriously our commitment to equality and equity. Our efforts to be inclusive and create opportunity don’t end when someone joins us – they begin.
We’ve set our sights on changing the world through our work and with our clients, and representation is at the foundation of what we do. We know that diversity of thought and background makes us stronger. That’s why we’re committed to building and maintaining a diverse community.
Every new team member broadens our perspective and allows us to think bigger. We’ll be at our best when people from underrepresented communities and people with a range of perspectives and lived experiences want to come, stay, and push the boundaries of what’s possible.
Overview: 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, andor 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, andor panels within the client’s CRM;
Ingesting datasets into the client’s CRM using builtin CRM tools, 3rd party ingestion tools andor data warehouse connectors;
Batching new fundraising gifts into the client’s CRM;
Monitoring and maintaining the client’s warehouse ETLELT 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 tofrom 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 andor making updates to analytical dashboards, such as Tableau.
Musthave qualifications:
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 nontechnical 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; and
Highly selfmotivated and always looking for opportunities to make things better.
Nicetohave qualifications:
Experience developingmanaging data ETLELT in a modern data warehouse;
Experience reading and writing JavaScript andor Python;
Experience creating, updating and maintaining dashboards in Tableau, Klipfolio or PowerBI; and
Marketing agency experience.
Salary range for this role is $73,000 to $80,000 per year, depending on experience.
This position is included in a unionrepresented collective bargaining unit, and specific employment terms and conditions are subject to collective bargaining.
Location
We are currently working remotely with no return to office date. Applicants may reside in the following states: AZ, CT, DC, FL, GA, IL, IN, LA, MA, MD, ME, MN, MO, NC, NH, NJ, NM, OR, PA, SC, TX, VA, and WI. Due to FL legislation, MissionWired is required to participate in everify.