> Markdown version of [/jobs/ext/1832733-membership-data-analyst](https://www.wearedevelopers.com/jobs/ext/1832733-membership-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Membership Data Analyst - **Company:** University of Michigan - **Location:** Ann Arbor, MI, United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Auditing, Data Integration, DataOps, SQL Databases, Transaction Data, Data Processing, Core Data, Data Analytics, Dart - **Published:** July 3, 2026 - **Apply:** https://www.jobmonkeyjobs.com/career/27818709/Membership-Data-Analyst-Michigan-Ann-Arbor-1233 ## About the Role * 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 . ## Description 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. Reporting to the Membership Manager, the Analyst owns CRM functions, campaign list management, and routine system outputs, keeping data accurate, timely, and ready for use across direct mail, email, on-air, and emerging fundraising campaigns. As this person grows into the role, they will contribute beyond the core data operations, helping identify areas of the membership program that are not fully optimized, supporting colleagues with limited technical backgrounds, and surfacing new opportunities to strengthen donor engagement and program performance. This is a technically focused role for someone who is detail-oriented, data-savvy, and takes ownership of recurring processes with minimal oversight. This is an onsite position and requires in-person training. A hybrid schedule may be determined upon discretion of the hiring manager. Responsibilities* * Execute daily and monthly data operations including gift imports, renewal files, suppression lists, thank you lists, and end-of-month functions. * Develop and execute complex queries and programmatic logic to integrate and analyze CRM export data. * Create and manage marketing efforts per campaign specifications and timelines. * Pull and manage data lists for fund drives and internal stakeholder requests. * As familiarity with systems and fundraising processes develops, help identify areas of the membership operation that are not fully optimized and recommend practical solutions. * 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., Michigan Public is 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Dart - a language believed dead, experiences a new bloom](https://www.wearedevelopers.com/videos/442-dart-a-language-believed-dead-experiences-a-new-bloom) - [Your organization as a Graph](https://www.wearedevelopers.com/videos/2051-your-organization-as-a-graph) - [Dart - a language believed dead, experiences a new bloom](https://www.wearedevelopers.com/videos/955-dart-a-language-believed-dead-experiences-a-new-bloom) - [Building Multi-Tenant ASP.NET Core Applications: Best Practices and Real-World Solutions](https://www.wearedevelopers.com/videos/1552-building-multi-tenant-asp-net-core-applications-best-practices-and-real-world-solutions) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [React Developer Salary [2023]](https://www.wearedevelopers.com/magazine/198-react-developer-salary-2023)