Data Analyst

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

Benefits offered by this job

Health Savings Account

Employer funded Dental and Vision

Tuition discounts Purdue University

Paid holidays

Vacation accrual

Job summary

Purdue For Life Foundation is seeking a Data Analyst to create and maintain data analytics reports and dashboards, using Salesforce CRM Analytics, Salesforce Reports, Tableau, Snowflake and SQL. You’ll work with both technical teams and end users to move data projects from requirements through deployment.

You will perform data management tasks, ensure data quality, document solutions, and support training for end users. This role requires on-site work up to 2x per week in West Lafayette, Indiana.

Qualifications

• Bachelor's degree in CS/CT/MIS preferred.
• Experience 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.

Responsibilities

• Create and maintain data analytics reports and dashboards.
• Work with end users to assess needs, develop requirements and solutions; train end users on tools.
• Perform data management tasks including querying, modeling, conversion, de-duplication, repair, light ETL support, and data backup tool management.
• Provide troubleshooting, problem analysis, and resolution for data-related issues.
• Set objectives and work independently on small to moderate sized projects.
• Improve processes, systems, and products to enhance performance of area and organization.
• Support data quality and QA across team deliverables.

Skills

Relational databases

Data analysis

Data visualization

Problem solving

Communication

Confidentiality

BI tools

On-site West Lafayette

Education

Bachelors Degree in CS/CT/MIS

Tools

Salesforce CRM Analytics

Salesforce Reports

Tableau

Snowflake

SQL

Job description

*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. Your next giant leap starts here.

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.

About Purdue for Life Foundation

The Purdue for Life Foundation is an equal opportunity, affirmative action employer. Purdue for Life 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.

Purdue for Life will not sponsor employment authorization for this position.

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