Database Analyst

The Crohn’s & Colitis Foundation is a non-profit, volunteer-fueled organization whose mission is to cure Crohn’s disease and ulcerative colitis and improve the quality of life for the children and adults affected by these diseases. Our work is dramatically accelerating the research process through our varied research initiatives; we also provide extensive educational and support resources for patients and their families, medical professionals, and the public. In addition, we lead federal and state-based advocacy campaigns to support medical research funding and improve patient access to care. The Foundation’s core values of compassion, integrity, leadership, collaboration, and inclusion inspire and drive every member of our highly performing team.

Position Summary:

The Database Analyst will perform key data management activities to ensure smooth business operation of Foundation’s Constituent Data management platforms which include Salesforce CRM (NPSP), Salesforce Marketing Cloud, DonorDrive and other platforms.

Essential Functions & Responsibilities:

• Perform daily review and updates of constituents, events, registrations data files between Salesforce CRM, DonorDrive, Form Assembly and other systems involved.
• Analyze and address errors in data sync logs and revenue batch exception logs
• Download, review, clean and import donation data from external sources to Salesforce
• Collaborate closely with support staff to resolve data discrepancies, correct mapping issues, troubleshoot & fix errors
• Create and manage Salesforce CRM user accounts
• Act as level 1 helpdesk partner for Salesforce CRM issues
• Have a good understanding of Salesforce CRM, DonorDrive, Marketing Cloud in all aspects of the sync in order to participate in systems’ maintenance and upgrade
• Create and perform test cases for our various environments (Build, QA, Test)
• Actively participate in vendors’ calls and discussions for on-going projects
• Analyze support requests and come up with topics and conduct on-going scheduled training sessions and FAQ forums
• Strengthen the culture of data and technology throughout the organization through user engagement, accurate data, analytics, and reporting in Salesforce CRM, PowerBI, etc.
• Collaborate with users and stakeholders and look for ways and opportunities to improve user experience in Salesforce CRM
• Assist with queries creation and revision to build/enhance data extensions in Salesforce Marketing Cloud to deliver target audiences for email campaigns
• Other duties as required.

• Bachelor’s degree or equivalent experience.
• Experience in the non-for-profit industry, with knowledge of the administration and troubleshooting of Salesforce CRM (NPSP).
• Experience with Marketing Cloud, DonorDrive, Form Assembly is a plus.
• Experience providing technical support to remote field staff.