Data Analyst

POSTED: August 9, 2021
BUSINESS: Purdue for Life Foundation
POSITION TYPE: Part-time
START DATE: Immediate Availability

 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. 

Additional Responsibilities

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 makes/recommends adjustments as needed.  
  • Use data and analytical skills to assess existing programs and segments; recommend strategic changes. 

Knowledge, Skills 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. 
  • 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. 
  • Possess 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.

Education/Experience

  • Bachelor’s degree required in Business Administration, Marketing, MIS, Informatics, Computer Science, or a related field. Advanced degree preferred.
  • 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.

 

If you are interested in applying, please click here to begin the process: https://www.applyatprf.com.The application deadline is Monday, August 30, 2021.

A criminal conviction check and negative controlled substance test are required for employment in this position. 

Purdue Research Foundation is an equal opportunity, affirmative action employer. PRF views, evaluates, and treats all persons in all Foundation-related activities solely as individuals on the basis of their own personal abilities, qualifications, and other relevant characteristics.  All qualified applicants for employment will receive consideration without regard to race, religion, color, gender, national origin or ancestry, genetic information, marital status, parental status, sexual orientation, gender identity and expression, disability, or status as a veteran.

 

  • Job Listings

Kurz Purdue Technology Center, 1281 Win Hentschel Blvd., West Lafayette, IN 47906, 765-588-3470

© 2020 Purdue Research Foundation | Maintained by Purdue Research Foundation

Trouble with this page? Please contact Purdue Research Foundation by Phone, 765-588-3470, or FAX, 765-463-3501.