Data Engineer I: Snowflake Pipelines & SQL

ECPI University; Virginia Beach (VA); On-site; USD 70,000 - 82,000; Full time

Job summary

ECPI University is building and maintaining a cloud data platform on Snowflake, and the Associate Data Engineer role supports that work end to end. In this entry-level position, you will develop and maintain pipelines that move data from the University’s enterprise systems into Snowflake so teams can deliver reporting, analytics, and data-driven decision making in a highly regulated environment.

Working alongside experienced engineers under the Senior Director of Solution Architecture, you will

Qualifications

• Bachelor’s degree in a related field.
• Zero to two years of professional experience.
• Working knowledge of SQL, including joins, aggregation, and subqueries.
• Foundational understanding of relational database concepts and data modeling.
• Familiarity with Python or a comparable language used in data work.
• Version control with Git, including branching and pull requests, and willingness to work within a code review process.
• Practical use of AI coding assistants with sound validation judgment.
• Understanding of CI/CD concepts and willingness to work where automated tests must pass before deployment.

Responsibilities

• Build and maintain data ingestion and transformation pipelines loading data into Snowflake from enterprise source systems.
• Write, test, and tune SQL for transformation, validation, and reconciliation tasks.
• Support scheduled data loads, monitor job execution, and escalate failures with clear diagnostic detail.
• Reconcile data between source systems and Snowflake to confirm completeness and accuracy.
• Create and run automated data quality checks, documenting exceptions for resolution.
• Investigate reported data discrepancies, trace to origin, and communicate findings clearly.
• Use AI coding assistants as part of daily work, validating every generated query before committing.
• Submit changes through pull requests in GitHub and move work through automated build, test, and deployment processes.
• Automate recurring manual tasks and apply native AI capabilities in the platform under senior direction.
• Follow University guidelines for AI-assisted development, including keeping sensitive data out of external tools.
• Document pipeline logic, data lineage, and table definitions for team maintenance.
• Participate in code reviews, design discussions, and Agile ceremonies with analysts and staff.

Skills

SQL

Python

Git

CI/CD

Data modeling

QA validation

AI coding assistants

Agile (Scrum)

Education

Bachelor’s degree

Tools

Snowflake

GitHub

GitHub Copilot

Snowflake Cortex

GitHub Actions

Azure DevOps

Azure

AWS

dbt

ELT

ETL

Power BI

Tableau

Job description

ECPI University is building and maintaining a cloud data platform on Snowflake, and the Associate Data Engineer role supports that work end to end. In this entry-level position, you will develop and maintain pipelines that move data from the University’s enterprise systems into Snowflake so teams can deliver reporting, analytics, and data-driven decision making in a highly regulated environment.

Working alongside experienced engineers under the Senior Director of Solution Architecture, you will