Roxbury Community College

Location: 1234 Roxbury Crossing, MA Category: Student Job Type: Per diem Posted On: Wed Sep 23 2026 Job Description: 
Job title: SQL &amp; Reporting Co-Op, Internship
Unit: Non-unit
Department: Office of CIO, Information Technology Services
Reports to: CIO
Schedule: Four days per week, one remote day
Anticipated start date: Fall 2026
End date: January 31, 2027
About the work RCC runs on Jenzabar J1 (SIS/ERP, including Financial Aid), Canvas, and Slate, and is building a governed Databrickson-Azure lakehouse that will carry the college's reporting and KPI layer going forward. Almost every question the college needs answered enrollment, retention, satisfactory academic progress, financial aid, federal compliance? comes down to someone writing a correct query against that data. This co-op is for a graduate student who is genuinely good at SQL and wants to see what production reporting looks like: real stakeholders, real deadlines, numbers that have to be right the first time. You will work alongside the IT team with direct access to the CIO and to the offices that consume the reports. What you'll do
Write, tune, and maintain SQL queries and views against Jenzabar J1 and the RCC lakehouse
Build operational and ad hoc reports for Registrar, Financial Aid, Admissions, Finance, Academic Affairs, and Institutional Effectiveness
Support federal and state compliance reporting IPEDS, FVT/GE, and state submissions including the data pulls, reconciliation, and validation behind them
Develop and maintain dashboards and KPI reports (Databricks AI/BI, Power BI, or similar)
Translate requests from non-technical staff into precise data requirements, and ask the follow-up question when a request is ambiguous
Reconcile discrepancies between source systems and reported figures, and document the resolution
Help migrate existing reports onto the new Databricks lakehouse, retiring one-off spreadsheets and shadow queries along the way
Document report logic, definitions, and refresh schedules so reports survive turnover
Handle student and financial data in line with FERPA and RCC data governance policy
 Job Requirements:
What we're looking for Currently enrolled in or recently completed a master's program in Data Science, Analytics, Computer Science, Information Systems, Statistics, or a related field Strong SQL complex joins, aggregation, window functions, CTEs; you can write, read, and debug non-trivial analytical queries Ability to read an unfamiliar schema and figure out where the truth lives Attention to detail reconciliation, row counts, and edge cases matter more here than speed Comfort talking directly with business users to scope a reporting request Clear written communication and a habit of documenting Willingness to complete FERPA training before working with production data Preferred Prior internship, assistantship, or coursework building reports someone else actually used Higher education data exposure Jenzabar, Banner, Colleague, Workday Student, or similar SIS/ERP Familiarity with IPEDS or other federal compliance reporting Databricks, Spark SQL, Delta Lake, or Unity Catalog exposure (coursework counts) Power BI, Tableau, or Databricks AI/BI dashboard development Python for data work; Git-based version control Fluency using AI assistants such as Claude to draft, review, and debug SQL we expect you to use these tools
 Additional Information:
What you'll get Production reporting experience against a live SIS the part of data work that coursework rarely covers Hands-on time with a modern governed lakehouse: Databricks, Unity Catalog, Azure Direct mentorship from the CIO and exposure to how an institution makes decisions from its data Work you can point to and explain end to end in an interview
Pay: $20

SQL & Reporting Co-Op, Internship - Roxbury Community College

SQL & Reporting Co-Op, Internship - Roxbury Community College

This job is no longer available

Talents

Recruiters

About