Advancement Data Analyst

The Advancement Data Analyst will design and produce accurate, timely, and comprehensive reports, analyses, and data visualizations for Advancement and College leadership.

The Analyst will leverage their expertise in data storytelling to effectively communicate and present key findings, insights, and trends to Advancement colleagues, College leadership, Trustees, and other key stakeholders. Additionally, the Analyst will collaborate with colleagues on the broader Advancement team to define and translate data-related business needs, including alumni engagement; marketing and communications; annual giving (the Macalester Fund); philanthropic giving; planned giving; foundation, government, and corporate relations; donor relations; prospect management and research; gift processing and records management; and college events.

This is a full-time position with a hybrid onsite schedule. 

About The Department:
The Advancement team—comprising Communications and Marketing, Development, Engagement, and Advancement Operations—is committed to driving Macalester’s mission forward by ensuring clear, campus-wide communication, creating meaningful opportunities for alumni and friends to participate in the life of the college, and building relationships with donors to secure financial support that aligns with both the college’s mission and the donors’ philanthropic goals. We do so grounded in anti-racism, equity, and social justice, and with a commitment to creating positive social and economic change.

The Data Analyst is part of the Advancement Operations department, and is a member of the Business Intelligence team responsible for managing donor, alumni, parent, and friend data.

• Report Creation and Management 

Develops and executes reports, dashboards, and visualizations that enable data-driven decision-making; manages Advancement data requests, including those submitted through the Staff Request Management tool in Slate; creates and runs queries in Slate (Macalester’s CRM);creates and maintains dashboards in PowerBI.

• Data Analysis 

Provides in-depth data analysis to understand constituent behavior, to inform marketing segmentation strategies, and to measure the effectiveness of solicitation, acquisition, and retention efforts.

• Campaign Support 

Collaborates with the AVP of Advancement Operations and the Director of Business Intelligence to design reports that track campaign progress against key performance indicators.

• Training 

Develops, documents, and delivers training modules on the systems used by Advancement. Trains colleagues throughout the College in Slate for Advancement and additional tools deployed by Advancement to support the division’s goal and mission for the College.

• Documentation  

Manages documentation for our Slate reports library to facilitate ease of use among colleagues.

• Forecasting 

Leverages new data sources and modeling techniques to help improve accuracy of revenue forecasts.

• Education and Innovation 

Stays abreast of the fundraising landscape and philanthropic sector, including knowledge of donor behavior, engagement strategies, revenue generation techniques, and community centric fundraising, and adapts to evolving technologies and methodologies in the field of data analytics and fundraising.

• Bachelor’s Degree required
• 3+ of experience in data analysis, reporting, and visualization tools. Experience in leveraging data to identify opportunities for revenue growth and audience expansion. Experience working with Customer Relationship Management software (we use Slate).
• Strong ability to analyze complex datasets, identify patterns, extract actionable insights and create dashboards, visualizations, and reports to facilitate data-driven decision-making. Understanding of philanthropy (mission, practice, trends) and fundraising practices (the development cycle, prospect management policies and practices, community centric fundraising) preferred
• Ability and experience with Customer Relationship Management software and data visualization/reporting software. Experience with Technolutions’ Slate for Advancement and Microsoft’s Power BI preferred
• Excellent initiative and organizational skills to prioritize complex tasks, projects, and workflow; strong independent judgment regarding best use of time
• Ability to understand complex data sets to produce accurate and actionable outputs. Skills in trouble-shooting and validating data in reports and visualizations
• Understanding of gift accounting fundamentals is necessary
• Strong verbal and written communication skills to effectively present complex analyses and insights to non-technical stakeholders
• Customer-service orientation with the ability to deftly handle sensitive information. Knowledge of the meaning and main principles of equity and social justice and commitment to upholding those principles. Commitment to Macalester’s mission

Compensation:

The annual salary for this position will be $66,000-$69,000, depending on experience.

Benefits:

At Macalester, we are proud to offer excellent comprehensive employee benefits. Here are some highlights:

• 10% employer contributions to the retirement plan. 
• Outstanding vacation and sick time packages, plus an additional 10 holidays.
• Generous employer contribution to Health Savings Account.
• Tuition assistance which pays between 75% - 100% of eligible tuition for employee dependents at select institutions.
• Free primary care for most services through Nice Healthcare when enrolled in a Macalester health plan.
• Access to the athletics fitness facility, wellness coaching, and activities.

These are just some of the great benefits Macalester has to offer! To see our full benefits packages and options, please visit our Benefits Page.

Satisfactory completion of a criminal background check is a condition of employment.

Application Guidelines:

For best consideration, please submit your cover letter and resume through the Macalester Employment Opportunities webpage by January 9th, 2025. This job will be posted until filled. 

Jaclyn Howard

Talent Acquisition Manager

jhoward3@Macalester.edu

Founded in 1874, Macalester College provides students with the inspiration, insight, and experience to become successful and ethical leaders. Located in flourishing St. Paul, Minnesota, Macalester enrolls over 2,000 students from across the country and around the world. Macalester is a preeminent liberal arts college recognized for its student service and celebration of internationalism.

At Macalester, we look at our employees through a whole-person, holistic lens. With comprehensive benefits and well-being programs, we provide and enable our community members to grow and care for themselves, their families, and one another. Our whole-hearted fidelity to community-building and social justice exemplify these ideals. Macalester College continuously prioritizes a culturally diverse and pluralistic community. We value individuals of all backgrounds and lived experiences. 

Our rich blend of people holding varied identities enhances our strong commitment to multiculturalism and global citizenship. We seek candidates who reflect and strengthen our campus environment. Macalester invites and encourages everyone to apply who would add depth to our community including those from all sexual orientations, races, ethnicities, national origins, genders, religions, abilities, and ages.