Data Analyst

Purdue Research Foundation; West Lafayette (IN); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Purdue For Life Foundation in West Lafayette, IN is seeking a Data Analyst to create and maintain analytics reports and dashboards. You will work with Salesforce CRM Analytics, Salesforce Reports, Tableau, Snowflake and SQL, taking data projects from requirements to deployment.

Responsibilities include collaborating with end users, gathering requirements, and ensuring data quality while expanding knowledge of BI tools. This is a hybrid role with on-site work up to 2 days per week.

Qualifications

• Bachelor's degree in a related field is preferred.
• 3–5 years of data analysis and reporting experience.
• Experience with large relational databases and Salesforce CRM analytics is preferred.

Responsibilities

• Create and maintain data analytics reports and dashboards.
• Work with end users to gather requirements and provide training on tools.

Skills

Analytical thinking

Data mining

Query design

Communication

Confidentiality

Learning agility

BI tools familiarity

On-site work readiness

Education

Bachelors Degree in Computer Science / MIS / related field

Tools

Salesforce CRM Analytics

Salesforce Reports

Tableau

Snowflake

SQL

Python

Job description

Data Analyst

Department: IT

Employment Type: Full Time

Location: Purdue for Life Foundation

*This position is Hybrid. Only candidates within reasonable driving distance of West Lafayette, Indiana will be considered.*

*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.

Responsibilities

Position Summary

This Data Analyst position is responsible for creating and maintaining data analytics reports and dashboards as well as associated data management tasks. Working closely with both technical colleagues and end users, and leveraging a variety of tools including Salesforce CRM Analytics, Salesforce Reports, Tableau, Snowflake and SQL, this position will take data projects from requirements gathering to development to deployment.

Data Analyst Key Functions

• Work with end users to assess needs, develop requirements and solutions. Support and train end users on created tools.
• Perform data management tasks, including querying, modeling, conversion, de-duplication, repair, light ETL support, and data back-up tool management.
• Provide experienced troubleshooting, problem analysis, and resolution for data related issues.
• Set objectives and work independently on small to moderate sized projects or assignments.
• Responsible for improvements of processes, systems, and products to enhance performance of area and broader organization.
• Support overall data quality and work product quality from team through QA processing and peer reviews.
• Create and maintain current documentation for data, reporting solutions, and tools.
• Help maintain, research, and evolve the use of data and reporting tool sets through innovative and emerging technologies.

Skills, Knowledge and Abilities

• Proficiency in advancement user requirements and solutions.
• Knowledge and understanding of relational databases and related knowledge management techniques, including data mining and management report generation.
• Analytical skills to design queries/programs and analyze data to present accurate and useful reports.
• Problem solving, resolution and customer service skills.
• Excellent interpersonal, organizational and verbal/written communication skills.
• Ability to maintain confidentiality with sensitive data.
• Capacity to quickly learn new analytical Business Intelligence Tools.
• Must have the ability to work on-site in West Lafayette up to 2x a week.

Requirements & Benefits Summary

• Bachelors Degree in Computer Science, Computer Technology, Management Information Systems, or related field preferred.
• 3-5 years experience in data analysis and reporting required.
• Experience working with large relational databases required.
• Experience with Salesforce CRM and/or Salesforce CRM Analytics strongly preferred.
• Experience with Python and Snowflake strongly preferred.
• Development operations experience in an academic environment and experience with data visualization tools is preferred.

Position Level: Professional 2

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 $550 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.