Overview
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 $700 million annually in funds in order to meet the financial needs of our organization. The Data Analytics team is responsible for supporting all fundraising teams on their individual fundraising goals through strategic segmentation, real-time analytics, and building out complex data sets and dashboards. The team will be tasked with creating or reproducing a large number of data sets and dashboards with the creation of a new data warehouse.
Project
Are you a proactive, collaborative and detail-oriented problem-solver who can help us take our fundraising to new heights? Can you ensure the Fundraising Team at Doctors Without Borders has the impeccable data we need to shape our strategies, reach the right donors with the right messages, and raise big funds for our lifesaving work? If so, we would like to hear from you.
As the Data Analyst, Fundraising you will collaborate across the fundraising teams, vendors and other departments to tackle our trickiest data challenges, drive data objectives and revenue growth. This will be achieved by mining, transforming, and reporting on the data from our CRM and data warehouse.
You will have the critical job of ensuring we are reaching the right donor segments in a campaign or donor journey. You will also lead efforts to effectively and efficiently measure and report on campaign performance and testing in order to make data-driven business decisions.
How you’ll make an impact:
• mining, transforming and reporting on data from our donor database and data warehouse;
• build complex data sets that refresh daily, weekly, and monthly;
• reviewing and giving feedback on campaign segmentation plans to ensure top down logic is in line with strategy
• creating ad hoc reports for a marketing campaign or fundraising event to help drive smart decisions
• participating in a kickoff meeting for an innovative new fundraising campaign to ensure we will be able to accurately execute on segmentation and report on data
• use different coding languages (SQL, Python, etc) and data visualization tool (Tableau) to report and present KPIs regularly
• and build predictive models to help inform the future of fundraising at MSF. This is an opportunity for someone with a head for data, strong communication abilities, and an interest in fundraising to work with massive amounts of data to execute strategic fundraising plans. You will be an integral part of an energetic, supportive and innovative team dedicated to taking our fundraising to the next level
Tasks
In this role you will report to the Senior Manager, Data Analytics. Your responsibilities will include:
Supporting segmentation, planning, execution and analysis
• Project manage the many and various 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.
• Collaborate with the audience managers and analytic vendors to assess donor retention trends across key data points, ensuring all donor metrics are available and accurate for this analysis
Ensuring data quality and segmentation accuracy
Ensure results from all campaigns across all channels are uploaded into donor CRM database.
• Lead implementation of all vendor data models and overlays; manage updates and reporting of quarterly index data
. • Troubleshoot errors and fixes source data or identify transformation problems
Mining , transforming and pulling data
•Ensure campaign data files uploaded to donor database are accurate.
• Fulfill ad-hoc data requests from fundraising teams as necessary.
• Build complex data sets to be used in a suite of analytic reports and dashboards
• Utilize available tools to create predictive models to assist in the departments strategic initiatives
Analysis & 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 various data visualization tools to build new reports/dashboards and assist teams in usage and comprehension to increase user engagement.
• Assist in implementation of a new data warehouse and development of internal analytics strategy
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:
• Minimum 2-4 years relevant experience, preferably in a non-profit and/or marketing environment.
• Minimum 1-3 years of experience building complex data sets and reports using SQL (Python or another querying/coding languages can be considered relevant experince)
• Minimum 1-3 years using a data visualization (Tableau preferred)
• Ability to understand and interpret processes and data needs, utilizing strong stakeholder relationship skills, consensus-building skills and ability to establish effective working relationships in a diverse environment.
• Strong written and oral communications skills and an ability to translate complex data requirements into plain language for marketing staff and vendors.
• Advanced skills in Excel, solid PowerPoint skills and strong computer literacy overall.
• Solid project management skills. Ability to track multiple projects at a time and to prioritize appropriately
Preferred
•Experience with Salesforce Non-Profit Success Pack (NPSP) donor database or similar
• Experience or willingness to learn data modeling
Please note that relocation assistance and visa sponsorship will be offered for this position.
Expected to work in a hybrid work environment with the ability to come into either the NYC office or regional hub (Washington, DC or Bay Area, California) a minimum of 2 times a week.
Application Deadline: Open Until Filled
No phone calls and emails please. Only shortlisted candidates will be contacted.
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
Regular FT Salaried Exempt
Compensation
Starting salary low to moderate 80’s (commensurate with experience)
Working Time (Hours Per Week)
35