Associate Data Analyst, Digital Engagement

Purdue Research Foundation • West Lafayette, IN

17h • Hybrid

About The Position

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.

Requirements

• Foundational SQL and data analysis skills.
• Knowledge of relational databases
• Strong attention to details and high commitment to data accuracy.
• Ability to follow established processes, standards and procedures.
• Strong written and verbal communication skills.
• Demonstrates initiative in learning systems, tools and best practices.
• Reliable, dependable and able to manage multiple assignments with guidance.
• Bachelor’s degree required in Computer Science, Management Information Systems, Business Administration, Marketing or related field required.
• 0-3 years of relevant business analysis, data or related experience. New graduates with less than 1 year experience are welcome to apply.

Nice To Haves

• Experience with SQL databases and writing queries preferred.
• Exposure to Salesforce preferred.

Responsibilities

• 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 store 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 escalate 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

Benefits

• 10 paid holidays per year.
• Accrue up to 22 vacation days a year.
• Traditional pre-tax 403(b) and Roth retirement plans available.
• 10% employer contribution to your retirement plan and immediate vesting.
• Health Savings Account- earn up to $700 annually towards medical expenses.
• Employer funded Preventative Dental and Vision insurance.
• Tuition discounts on eligible programs at Purdue University and Purdue Global for qualified employees, spouses, and dependents.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level