Membership Data Analyst

Job Summary

The Membership Data Analyst is responsible for the technical execution and integrity of data operations across two critical systems: Michigan Public's CRM (Allegiance Fundraising) and U-M's Blackbaud CRM (DART). This role ensures accurate and reliable data translation between these systems, keeping membership data consistent, timely, and ready for use.

Responsibilities*

• Execute daily and monthly data operations including gift imports, renewal files, suppression lists, thank you lists, and end-of-month functions.
• Create and manage marketing efforts per campaign specifications and timelines.
• Pull and manage data lists for fund drives and internal stakeholder requests.
• Translate data insights into clear guidance for non-technical colleagues to help surface new opportunities to strengthen donor engagement.
• Confirm and troubleshoot routine system outputs including pledge reminders, premium fulfillment, and gift acknowledgments.
• Maintain data hygiene standards across the membership CRM including biographic, demographic, and transactional data by conducting data audits, integrity checks, and cleanup projects.
• Support documentation of recurring data processes and standard operating procedures.
• Run and distribute reports on schedule.
• Manage recurring processes independently with minimal oversight.

Required Qualifications*

• Bachelor's degree, or 4 years of relevant experience.
• Experience administering or managing a CRM database.
• Experience writing SQL (or equivalent) queries for data extraction and analysis.
• Experience with data integration between multiple systems.
• Experience using Microsoft Excel for data manipulation and reporting.
• Experience identifying and resolving data discrepancies.
• Experience conducting data audits, integrity checks, and cleanup projects.
• Experience managing campaign or marketing data operations (e.g., list pulls, suppression, segmentation for direct mail and email).

Desired Qualifications*

• Allegiance Fundraising experience.
• DART (Blackbaud) CRM experience.
• Familiarity with direct mail, email, and emerging digital fundraising campaign operations.
• Experience in the nonprofit sector.

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

Additional Information

• Benefits
• Generous time off
• A retirement plan that provides two-for-one matching contributions with immediate vesting upon meeting eligibility requirements
• Many choices for health, dental, and vision insurance
• Life insurance
• Long-term disability coverage
• Flexible spending accounts for healthcare and dependent care expenses

Application Deadline

Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled any time after the minimum posting period has ended.

Michigan Public EEO Statement

We are committed to attracting and retaining a creative workforce filled with varied perspectives and experiences to enhance and continue our mission of producing trusted content to grow a diverse community of listeners. We are committed to fostering a diverse, equitable, and inclusive environment for people from all backgrounds, identities, and ages.

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.