Data Analyst
Department: Broad-Based Campaigns and Strategic Engagement
Employment Type: Full Time
Location: Purdue for Life Foundation
Description
*We will not sponsor employment authorization for this position.
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. Apply today!
Essential Functions
Manage all data requirements associated with central broad-based campaigns as well as other university department and unit campaigns.
Working directly with the Senior Director of Broad-Based Campaigns and Strategic Digital Engagement team, help evolve usage of Salesforce Marketing Cloud (SFMC) by managing marketing data and campaigns, as well as supporting advanced data needs broadly across Salesforce systems and the organization.
Perform data management tasks, including experienced data modeling, conversion, de-duplication, migration, and identification and repair of data quality issues.
Design, develop, and implement custom data systems and reconciliation tools, processes, rules, solutions, etc. to validate data, match/merge, and upload batch lists.
Data Management and Analysis Create and tune complex stored procedures and queries for data management and extraction.
Establish, monitor, and manage a data production calendar to ensure timely completion of data requirements.
Work in cooperation with the Senior Director of Broad-Based Campaigns and Strategic Engagement, Senior Director of Broad-Based Campaigns and Strategic Digital Engagement, and Project Managers to coordinate data schedules and delivery of data for electronic and printed fundraising appeals/materials.
Provide experienced troubleshooting and problem analysis/resolution for data related issues; perform experienced scripting and modifications of application and products for corrective action.
Research and stay up to date with data engineering best practices and approaches; stay abreast of latest security threats and risks to proactively address potential exposures.
Create and maintain a complex data model in Marketing Cloud for use in campaigns across Purdue University.
Fulfill data segmentation requests for partners to use in their email campaigns.
Translate plain-language requests into complex SQL queries and support on-time delivery of requests.
Use APIs to connect to Salesforce. Use data and analytical skills to assess existing programs and segments; recommend strategic changes.
Responsible for monitoring/tracking overall performance of campaigns.
Provide projections and forecasting as it relates to its goals.
Work with Broad-Based Campaigns team to design and implement statistical reporting and analysis on key performance indicators and/or enhancements to current reports.
Project Management Manage and track a data production calendar.
Ensure priorities are clearly established and communicated and all data needs are completed in a timely fashion.
Provide/assist with data proofing to ensure accuracy of requests and make/recommend adjustments as needed.
Use data and analytical skills to assess existing programs and segments; recommend strategic changes.
Skills, Knowledge and Expertise Excellent project management and organizational skills.
Understanding of marketing or sales strategies, with strong background in marketing technology, analytics, and digital strategies.
Excellent communication skills.
Experience working with large data sets on any business intelligence data analytics and visualization tools.
Demonstrated time management, project management, analytical, and priority setting skills.
Demonstrates a high commitment to quality.
Possesses flexibility to work in a fast paced, dynamic environment.
Seeks to acquire knowledge in area of specialty.
Highly thorough and dependable.
Demonstrates a high level of accuracy, even under pressure.
Possesses strong technical aptitude.
Ability to quickly troubleshoot and resolve problems and find creative, scalable technical solutions.
Excellent collaboration and team building skills, including the ability to effectively communicate and exchange information.
Regular and reliable attendance are requirements of this position.
Required Education/Experience Bachelor's degree required in Business Administration, Marketing, MIS, Informatics, Computer Science, or a related field.
A minimum of three years of business analysis and data gathering experience, or related experience.
Experience designing, creating, and maintaining program assessment reports.
Required: experience working with large scale SQL databases and ability to extract data by designing and executing complex SQL queries.
Preferred: Salesforce experience
*We will not sponsor employment authorization for this position.
