Associate Data Analyst, Digital Engagement

Associate Data Analyst, Digital Engagement

Department: Broad-Based Campaigns and Strategic Engagement

Employment Type: Full Time

Location: Purdue for Life Foundation

* This position is hybrid with up to 3 days a week working in the office in West Lafayette, Indiana.

Working for the Purdue For Life Foundation offers a unique opportunity to be part of an organization dedicated to empowering Purdue University alumni and fostering a lifelong connection to the institution. By joining our team, you'll have the chance to contribute to a mission that supports educational initiatives, scholarships, and programs that positively impact the lives of Purdue students and graduates.

The Foundation's commitment to education and community engagement provides a fulfilling work environment where you can make a meaningful difference in the lives of individuals and the broader community. Additionally, you'll have access to a network of passionate colleagues and the resources needed to drive positive change, making the Purdue For Life Foundation an inspiring and rewarding place to build your career.

Your next giant leap starts here.

As the Associate Data Analyst, Digital Engagement, you will join the Broad-Based Campaigns team in a role designed for an early-career professional (0–3 years of experience) ready to apply and grow their technical expertise. In this position, you’ll leverage SQL, Salesforce Marketing Cloud, and campaign analytics to directly support digital fundraising and engagement strategies that drive meaningful impact. If you are detail‑oriented, analytically curious, and motivated to contribute high‑quality work in a collaborative environment, this role offers meaningful responsibility and strong opportunity for growth.

• Support data requirements associated with central broad-based campaigns as well as other university departments and unit campaigns in Salesforce Marketing Cloud (SFMC).
• Write and maintain SQL queries to support targeted solicitation and stewardship efforts, following inclusion/exclusion logic and alignment with campaign goals.
• Collaborate with the Broad-Based Campaigns and Digital Engagement team to support marketing data and campaign execution.
• Perform routine data management tasks, including basic data modeling, conversion, de‑duplication, migration assistance, and identification of data quality issues.
• Assist in building and maintaining data workflows, including reconciliation processes, validation checks, match/merge support, and batch upload processes under guidance.
• Support campaign segmentation and query development to ensure timely execution of solicitation and stewardship efforts.
• Contribute to team and organizational success by producing high‑quality work, collaborating effectively, and supporting process improvement initiatives.

• Create and modify SQL queries and stored procedures for data extraction and reporting.
• Support the maintenance of the data production calendar to ensure timely completion of assignments.
• Coordinate with team leadership to meet data deadlines for electronic and printed fundraising appeals/materials.
• Assist in troubleshooting data‑related issues and escalating complex problems as appropriate.
• Learn and apply established data best practices and security standards.
• Maintain and update components of Marketing Cloud data model under supervision.
• Fulfill data segmentation requests for partners to use in their email campaigns.
• Translate plain‑language requests into SQL queries with guidance and support on‑time delivery of requests.
• Support API‑based integration with Salesforce as directed.
• Assist monitoring/tracking overall performance of campaigns and generating performance reports.
• Contribute to basic forecasting and reporting efforts.
• Support development and maintenance of statistical and performance reporting dashboards.

• Track assigned tasks withing the data production calendar.
• Ensure deadlines for assigned work are met.
• Assist with data proofing and validation to ensure accuracy.
• Participate in team problem‑solving discussions and process improvements.

• Foundation…