support the building and maintaining of data pipelines, transformations, staging processes, and star-schema data models.
support ELT/ETL processes in Snowflake, SQL Server, and related tools to ensure timely and accurate data availability.
monitor data workflows and assist with troubleshooting and resolving pipeline or data issues.
assist with automating data ingestion from institutional systems including ERP, CRM, LMS, and other sources.
develop and maintain data tables, views, and transformations that support analytics and reporting needs.
assist in building and maintaining data marts and reusable datasets following established modeling standards.
identify and help resolve data integrity issues across integrated systems (ERP, CRM, and LMS platforms).
perform data validation and quality checks to ensure accuracy and consistency.
maintain documentation for data pipelines, transformations, and processes as directed.
collaborate with the Data & Analytics team to support data needs across the University.
participate in cross-functional projects requiring data integration or data preparation.
learn and apply best practices related to SQL development, data modeling, and data warehouse operations.
contribute to continuous improvement efforts within the Data & Analytics team.

Requirements

A Bachelor’s degree in Computer Information Systems, Data Analytics, Information Systems, Computer Science, or a related field, or equivalent professional experience.
2+ years of experience building data pipelines, ETL/ELT processes, and developing star-schema data models in a data warehouse environment.
Working knowledge of SQL, with the ability to write queries and support data transformations in SQL Server, Snowflake, or similar platforms.
Exposure to data integration across enterprise systems (ERP, CRM, LMS) and familiarity with structured data concepts.
Experience in higher education and familiarity with Oracle ERP and Salesforce CRM platforms preferred.
Ability to follow established data modeling and engineering standards while implementing solutions accurately and efficiently.
Strong problem-solving skills and attention to detail when troubleshooting data or pipeline issues.
Effective communication skills and the ability to collaborate with technical and non-technical team members.
A desire to learn, grow, and contribute positively in a fast-paced, team-oriented environment.
Flexibility to work outside normal business hours as needed for scheduled data loads or issue resolution.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

data pipelinesETLELTdata modelingSQLdata validationdata transformationsdata martsdata integritydata warehouse

problem-solvingattention to detaileffective communicationcollaborationdesire to learnflexibility