Associate Data Analyst, Fundraising & Marketing

Date: Nov 14, 2020

Location: New York City, NY, US, 10006

Company: Doctors Without Borders | Médecins Sans Frontières

Doctors Without Borders/Médecins Sans Frontières (MSF) is an international humanitarian organization that delivers impartial medical care to people affected by conflict, epidemics, disasters, or exclusion from health care in over 70 countries.

We welcome candidates who bring a wide variety of backgrounds and experiences to join us in working toward MSF’s common mission.

 

Department

 

 

Our dynamic Development Department is responsible for raising over $400 million annually in funds in order to meet the financial needs of our organization.

 The Marketing Team is responsible for executing integrated marketing efforts, including prospect, renewal, and cultivation campaigns and activities via all communication channels to maximize the revenue and increase awareness of MSF’s activities, concerns, expertise, and values.

 

 

Project

 

 

MSF-USA is beginning implementation of Salesforce NPSP to replace its legacy donor database, ROI Solutions. This role is term-delimited to conclude in December of 2021, with the possibility of extension.

As Associate Data Analyst, Fundraising & Marketing, you will partner with full-time MSF-USA staff to assume the majority of day-to-day management of data quality and execution for fundraising and cultivation campaigns across all channels, including direct mail, email, digital advertising, and telemarketing. Under the supervision of the Marketing Data Analyst, you will capture reporting needs from internal clients and create deliverables for the marketing team and other departments with support from key vendors.

 

 

Tasks

 

 

In this role you will report to the Marketing Data Analyst, Fundraising & Marketing.  Your responsibilities will include:

 

Analysis and reporting

 

  • Create and manage ad hoc and scheduled reports for a variety of campaigns and activities with an eye to generating actionable insights.
  • Develop power user expertise in the interactive PowerBI visual reporting dashboards. generated by our analytics vendor, in order to (1) support reporting and insight requests from the marketing team and (2) QC updates needed to the tool by the analytics vendor.

 

Uploading, transforming and pulling data

 

  • Ensure campaign data files uploaded to donor CRM are accurate.
  • Fulfill ad-hoc data requests from Marketing team as necessary.

 

Supporting segmentation, planning, execution and analysis

 

  • Oversee the quality and accuracy of data pulled from donor CRM and Salesforce Marketing Cloud, ensuring they are correctly segmented for mail, telemarketing, and digital campaigns.
  • Under supervision of the Marketing Data Analyst, work with our marketing agencies, donor CRM database vendor and analytic vendors to fulfill data requests and troubleshoot pending data issues related to segmentation strategy and execution.
  • Project manage data requests and regular data responsibilities utilizing our project management platform Workfront.
  • Ensure accurate campaign tracking across all channels by creating, managing, and implementing source codes to track behavior and revenue, and ensure accurate data analysis for testing results and fundraising strategies.

 

Ensuring data quality and segmentation accuracy

 

  • Provide data quality control for Marketing
  • Perform quality control checks on campaign data and quality control audits on key dashboards and reports.
  • Ensure results from all campaigns across all channels are uploaded into donor CRM database.
  • Audit data synchronization between donor database of record and third-party fundraising and communication platforms and troubleshoot problems.
  • Troubleshoot errors and fixes source data or identify transformation problems.

 

 

Qualifications

 

Required

 

You have an analytical mind and pay strong attention to quality, detail, and accuracy. You are a quick and adaptive learner, comfortable working in a fast-paced environment with minimal supervision. You should also have:

 

  • 1-3+ years of experience building analytics reports and visualization using a variety of tools in a business/marketing or nonprofit setting
  • Intermediate to advanced SQL skills
  • Knowledge of relational database concepts and technology.
  • Ability to think through problems systematically, integrate information from multiple sources, propose and implement solutions.
  • Experience working to understand business users needs and delivering end-to-end solutions collaboratively
  • Ability to balance multiple priorities, communicate goals and build consensus to work effectively within and across departments
  • Data visualization skills, able to turn data into clear charts that tell the story.
  • Advanced skills in Excel, solid PowerPoint skills and strong computer literacy overall.

 

Preferred

 

  • Familiarity with Salesforce Marketing Cloud and Salesforce platform reporting preferred
  • Experience with Revolution Online (ROI) donor database or similar
  • Experience visualizing data for reports in a tool such as PowerBI or Tableau.

 

Application Deadline: Open Until Filled

Please note that neither relocation assistance nor visa sponsorship will be offered for this position

No phone calls or emails please.  

 

MSF-USA/Doctors Without Borders is an Equal Opportunity Employer. No employee, or applicant for employment, shall be discriminated against in any term or condition of employment because of race, color, religion, national origin, sex, age, or sexual orientation or any other characteristic protected by law. We are constantly striving to make our organization anti-racist. Diversity, equity and inclusion are core values. As an employee, you become part of that mission. We expect this same commitment from our staff

 

 

Type

HQ  

 

Pay Class & Contract Type

Temporary FT Salaried Exempt 

 

Compensation

Starting salary low 60 to mid 60's (commensurate with experience)

 

Working Time (Hours Per Week)

35


Nearest Major Market: Manhattan
Nearest Secondary Market: New York City