Data Analyst (West Lafayette, Indiana) en Purdue Research Foundation
Purdue Research Foundation · West Lafayette, Estados Unidos De América · Hybrid
- Professional
- Oficina en West Lafayette
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.
Responsibilities
- Manage data requirements associated with central broad-based campaigns as well as other university department and unit campaigns in Marketing Cloud.
- Write and maintain complex queries to support targeted solicitation and stewardship efforts, ensuring accurate inclusion/exclusion logic and alignment with campaign goals.
- Collaborate with the Broad-Based Campaigns and Digital Engagement team, to advance the strategic 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, build, and implement custom data tools and workflows, including reconciliation systems, validation processes, match/merge logic, and batch upload mechanisms that support efficient and scalable operations.
- Develop and execute custom queries to support unit-level solicitation strategies, ensuring audience segmentation aligns with specific campaign goals, donor engagement plans, and institutional priorities.
- Provide support for campaign segmentation and query development to ensure seamless execution of solicitation and stewardship efforts
- Contribute to team and organizational success by producing high-quality work, collaborating effectively, and supporting continuous improvement initiatives across mass communication operations.
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 the Broad-Based Campaigns leadership team 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.
- Participates in problem-solving and process improvements
Required Skills, Knowledge and Abilities
- 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.
- Ability to work a hybrid schedule with up to 3 days onsite in West Lafayette, Indiana.
Required Education, Experience and Benefits Summary
- Bachelor's degree required in Business Administration, Marketing, MIS, Informatics, Computer Science, or a related field.
- 3 years minimum experience in business analysis and data gathering, 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 required.
- Salesforce CRM experience strongly preferred.
Job Level: Professional 2 IT
Benefits Summary for eligible employees:
- 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 $450 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.
