SQL & Reporting Co-Op – Production Data & Dashboards

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

Job summary

Roxbury Community College invites applications for a SQL & Reporting Co-Op, an internship in the Office of CIO, Information Technology Services. The role focuses on writing and tuning SQL against Jenzabar J1 and the RCC lakehouse, and building reports for Registrar, Financial Aid, Admissions, Finance, and Academic Affairs.

You will support federal and state compliance reporting, develop dashboards with Databricks AI/BI, Power BI or Tableau, and translate requests from non-technical staff into

Qualifications

• 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.
• Willingness to complete FERPA training before working with production data.

Responsibilities

• 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 datapulls, 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 follow-up questions 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 shadowqueries 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.

Skills

SQL queries

Complex joins

Window functions

CTEs

Schema reading

Attention to detail

Business user communication

FERPA training

Education

Master's in Data Science

Master's in Analytics

Master's in CS

Tools

Databricks

Spark SQL

Delta Lake

Power BI

Tableau

Unity Catalog

Python

Git

Claude AI tools

Job description

Roxbury Community College invites applications for a SQL & Reporting Co-Op, an internship in the Office of CIO, Information Technology Services. The role focuses on writing and tuning SQL against Jenzabar J1 and the RCC lakehouse, and building reports for Registrar, Financial Aid, Admissions, Finance, and Academic Affairs.

You will support federal and state compliance reporting, develop dashboards with Databricks AI/BI, Power BI or Tableau, and translate requests from non-technical staff into