Data Engineer Intern

What You'll Do

As a Data Engineer Intern, you will play a crucial role in supporting ezCater's data platform. Your responsibilities will include:

• Provide timely, well-documented responses to data questions from stakeholders across Engineering, Marketing, Business, Data Science, and Analytics, escalating when appropriate and keeping requesters informed.
• Take on well-scoped, small data modeling requests in our warehouse: update or add dbt models and tests, write clear model documentation, and open PRs with thoughtful descriptions and checks.
• Support the health of our data platform by pairing with the on-call engineer to monitor job runs and alerts, triage issues, and execute playbooks; escalate quickly when outside scope.
• Proactively monitor nightly and hourly pipelines (e.g., Airflow DAGs, dbt Cloud runs, AWS DMS replication tasks) and remediate common failures (retries, backfills, simple config fixes) under guidance.
• Help maintain data reliability by responding to Monte Carlo observability alerts, validating anomalies, and creating or refining data quality tests.
• Partner with engineers to simplify and automate routine remediation steps; contribute small improvements that make our pipelines more robust and observable.
• Document what you learn: improve runbooks, add troubleshooting steps to our internal knowledge base, and keep tickets updated with clear status and outcomes.

What You Have

We are looking for a Data Engineer Intern who brings the following qualifications and characteristics:

• Proficiency in SQL and comfort working with large datasets; basic scripting in Python is a plus.
• Foundational understanding of data warehousing and ELT concepts; interest in data engineering best practices (version control, code review, testing).
• Familiarity with or eagerness to learn modern data stack tools such as Snowflake, dbt Cloud, Airflow, AWS DMS, Monte Carlo, and Hightouch; exposure to Kubernetes/Docker is a plus.
• Strong communication and collaboration skills; you ask good questions, document your work, and follow through.
• Growth mindset: open to feedback, willing to debug unfamiliar systems, and comfortable working within a defined on-call shadow/assist rotation.
• Currently pursuing a degree (or equivalent experience) in Computer Science, Data Science, Engineering, or a related field.

What You’ll Get From Us

Joining ezCater means becoming part of an innovative and high-performing environment. You will enjoy:

• A terrifically compelling experience in an innovative, high performing environment.
• Working with engaged and passionate colleagues on challenging and impactful projects.
• Opportunities to grow in your career, and work in a place that values work/life harmony.

Oh, and you’ll get all this:

• Market competitive salary, stock options that you’ll help make worth a lot, 12 paid holidays, flexible PTO, 401K with ezCater match, health/dental/FSA, long-term disability insurance, mental health and family planning resources.
• Remote-hybrid work from our awesome Boston office OR your home OR a mixture of both home and office.
• A tremendous amount of responsibility and autonomy, wicked awesome co-workers.
• Relish (and many more goodies) when you’re in our office.
• Knowing that you helped transform the food for work space.

Key skills/competency

• SQL
• Python Scripting
• Data Warehousing
• ELT Concepts
• dbt Cloud
• Snowflake
• Airflow
• AWS DMS
• Monte Carlo
• Data Reliability