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

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 (RCC) is a public institution of higher education offering associate degrees, certificate programs and lifelong learning opportunities to the Greater Boston community. The Department of Education recognized RCC as a Predominantly Black Institution (PBI) and as one of the top 100 community colleges in the country for student outcomes through the Postsecondary Success Recognition Program, making it the only community college in Massachusetts with these designations.

RCC offers 24 associate degree programs, 6 credit-based certificate programs, 13 non-credit professional certification programs, 30+ lifelong learning and fitness classes, and customized incumbent worker training programs. The college hosts hundreds of civic and community events at the Reggie Lewis Track and Athletic Center each year. RCC is committed to providing all learners with the academic and non-academic support required for degree completion and long-term success.

Roxbury Community College is guided by our six core values of Accountability, Equity, Excellence, Honesty, Integrity, and Respect. RCC is also an AA/EO employer and strongly encourages applications from candidates who would enhance the diversity of its staff. Reasonable accommodation may be provided to enable individuals with disabilities to perform essential job functions. The Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act requires all institutes of higher education to disclose campus policy statements and crime statistics. Our annual report is available at https://www.rcc.mass.edu/explore/public-safety/index.html .

Job Description:

Job title:SQL & Reporting Co-Op,Internship

Unit: Non-unit

Department: Office of CIO, Information Technology Services

Reports to: CIO

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 thecollege 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, andInstitutional Effectiveness

Support federal and state compliance reporting IPEDS, FVT/GE, and state submissionsincluding 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 the follow-up question whena 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

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 SQLwe 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

ADA Compliance:

The Massachusetts Board of Higher Education - Roxbury Community College is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, The Massachusetts Board of Higher Education - Roxbury Community College will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.

Roxbury Community College only accepts application materials through our online application system. We are unable to accept application materials through mail, email, fax, or hand delivery. If you do not have access to a computer, please contact Human Resources at [e-mail].