Data & AI Engineering Co-op – Student Portal

Roxbury Community College; Boston (MA); On-site; USD 23,000 - 32,000; Full time

Benefits offered by this job

Pay: $20 per hour

Job summary

Roxbury Community College invites applications for a Data, AI Engineering COOP internship in the Office of the CIO. You will work on the Student Portal within a Databricks-based lakehouse, building views and AI-assisted features, touching J1, Slate, and Canvas data, and maintaining deployment pipelines.

The role emphasizes production ownership of a live system, FERPA training completion, and mentorship from the CIO. Fall 2026 start with through Jan 31, 2027 end date, paid at $20/hour.

Qualifications

• Currently enrolled in or recently completed a master's program in Data Science, Computer Science, Analytics, Information Systems, Software Engineering, or a related field.
• Strong SQL you can write, read, and debug non-trivial analytical queries.
• Python.
• Comfort with Git-based workflows and code review.
• Ability to handle student data responsibly; willingness to complete FERPA training before touching production data.
• Clear written communication—you'll be documenting and explaining decisions to non-technical stakeholders.

Responsibilities

• Own and enhance the Student Portal Databricks App UI, queries, performance, and release cycle.
• Build and maintain silver and gold layer tables and Unity Catalog metric views that feed the portal.
• Write and tune SQL against the lakehouse (Serverless SQL Warehouse) for new student-facing views.
• Implement and test Unity Catalog row filters and column masks that enforce FERPA, ensuring students only see their data.
• Work with Lakeflow Connect and Auto Loader pipelines bringing in J1, Slate, and Canvas data.
• Manage code and deployments through Azure DevOps repos, pipelines, and Databricks Asset Bundles.
• Prototype AI-assisted features for the portal (RAG, natural-language query, advising nudges) as scope allows.
• Document what you build so the next person can pick it up.

Skills

SQL

Python

Git workflows

FERPA training

Written communication

Education

Master's in Data Science or related field

Tools

Databricks

Spark

Delta Lake

Azure

Job description

Roxbury Community College invites applications for a Data, AI Engineering COOP internship in the Office of the CIO. You will work on the Student Portal within a Databricks-based lakehouse, building views and AI-assisted features, touching J1, Slate, and Canvas data, and maintaining deployment pipelines.

The role emphasizes production ownership of a live system, FERPA training completion, and mentorship from the CIO. Fall 2026 start with through Jan 31, 2027 end date, paid at $20/hour.