University of Massachusetts Foundation - Data Quality Assurance & Integration Intern

Data Quality Assurance & Integration Intern

Overview

The Data Quality Assurance & Integration intern will support key data initiatives within our IT data team, contributing to data validation, QA testing,  integration documentation, and reporting enhancements. This role requires a balance of independent work and collaboration with cross-functional teams to ensure data accuracy and process efficiency.

Responsibilities:

• Work with Data and CRM teams to understand data requirements and business needs.
• Assisting in validating and reconciling data between Salesforce and Snowflake Data Warehouse to ensure consistency and accuracy.
• Supporting data ingestion, transformation, and schema validation processes.
• Verifying data integrity and consistency as part of our transition from legacy systems.
• Documenting integration processes within MuleSoft and existing system integrations.
• Assisting in report creation to support a system migration project and ensure accurate data reporting.
• Contributing to process documentation and conducting code reviews to maintain quality and best practices.

Qualifications:

• Currently pursuing or recently completed a degree in Data Science, Computer Science, Information Systems, or a related field.
• Proficiency in Tableau for data visualization and reporting.
• A strong understanding of SQL and foundational data analysis concepts is essential, including experience with data validation and quality assurance.
• Interest in learning about Snowflake, MuleSoft, or Salesforce, or prior exposure to similar data warehousing, integration, and CRM tools, with an emphasis on documenting data processes and system integrations.
• Strong analytical and problem-solving skills, particularly in identifying data inconsistencies and improving data accuracy.
• Excellent communication and teamwork abilities, with experience or interest in documenting technical processes and collaborating across teams.

What You’ll Gain:

• Hands-on experience with Snowflake and Salesforce, a leading cloud-based data platform.
• Insight into data validation processes, data governance principles, and best practices.
• Exposure to developing and standardizing reporting metrics.
• Mentorship from experienced IT and analytics professionals.
• A chance to contribute to impactful, real-world projects and agile methodology 
• Valuable experience for careers in data analytics, data engineering, or business intelligence.

Duration: 3 months with potential extension