The Fundraising Data Manager will manage data processing for clients, develop custom SQL scripts, create reports, and manage client CRM.
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.
We help our partners tell big, ambitious stories that invite their supporters into communities to raise mission-changing 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 single-minded in pursuit of your success.
We’re innovative, progress-obsessed, do-gooders 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 equal-opportunity 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, 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.
Must-have 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 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; and
- Highly self-motivated and always looking for opportunities to make things better.
Nice-to-have 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; and
- Marketing agency experience.
Salary range for this role is $75,000 to $82,500 per year, depending on experience.
This position is included in a union-represented 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, DE, FL, GA, IL, IN, LA, MA, MD, MI, MN, MO, NE, NC, NJ, OR, PA, SC, TN, TX, and VA. Due to FL legislation, MissionWired is required to participate in e-verify.
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
*Supporting your team on some nights and weekends as we approach high-volume times such as elections may be required.
If you feel you can do the job and are excited about this opportunity but are not sure if you meet all the qualifications, consider applying anyway. We’d love to hear from you!
Top Skills
BigQuery
Civis Platform
Git
JavaScript
MySQL
Ngp Van
Postgres
Python
SQL Server
Tableau
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Senior Intelligence Analyst conducts investigative and contextual analysis of cybersecurity threats, especially from state-affiliated actors in Asia-Pacific. Responsibilities include OSINT investigations, composing intelligence reports, and responding to customer inquiries.
Top Skills:
Open Source Intelligence (Osint)
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Sr. Data Engineer, you will design and implement data processes for Adobe's CDP, ensuring integration, reliability, and compliance with data protection standards.
Top Skills:
Adobe Experience PlatformAdobe Journey OptimizerAWSAzureCustomer Journey AnalyticsGitGitlab Ci/CdJenkinsPythonSQL
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
This role focuses on enhancing CrowdStrike's Falcon sensor's detection and response functions, requiring collaboration across teams and complex system understanding.
Top Skills:
Asynchronous ProgrammingC++LinuxPythonSystem Programming
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
