SQL Developer, Contract

Company 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:

Title: SQL Developer (Contract)

Department: Office of Information Technology

Reports to: Enterprise Data Architect

Contract: 6-12 months

Hours: 37.5 hours per week

Location: 4-days On-site in Roxbury, MA, 1 day remote.

Anticipated Start date: September 2026

Key Responsibilities

• Query and report development: Write, optimize, and maintain SQL queries, views, and stored procedures. Build recurring and ad hoc reports and data extracts for Enrollment, Financial Aid, Student Accounts, Academic Affairs, and Institutional Research.
• Data quality and cleanup: Identify and resolve duplicate, incomplete, and inconsistent records. Build validation scripts and reconciliation reports across Jenzabar, Slate, and Active Directory.
• Integration support: Support the automated Slate-to-Jenzabar applicant integration, including exception reporting, record-matching logic, and reconciliation of records that fail to process.
• Compliance and institutional reporting: Build and maintain the data extracts behind federal and state reporting obligations, including IPEDS and U.S. Department of Education requirements, and support KPI reporting for institutional leadership.
• Access and security: Implement database access and permission changes within established controls, and handle student and financial data in accordance with FERPA, GLBA, and College policy.
• Documentation: Document queries, data definitions, report logic, and operating procedures. Written documentation is a core deliverable of this role, not an afterthought.
• AI-assisted development: Use Claude or comparable AI tools to accelerate query drafting, refactoring, code review, and documentation, while independently verifying and testing all output before it reaches

Requirements:

Qualifications

• Two to three years of hands-on, in-depth SQL development experience.
• Strong command of T-SQL or PL/SQL, including complex joins, common table expressions, window functions, aggregation, and set-based logic.
• Demonstrated ability to tune queries and read execution plans.
• Experience working directly against a transactional system to build reports and extracts.
• Ability to read a data model, trace a field back to its source, and reason about how records move between systems.
• Comfort working with non-technical staff to turn a business request into a clear specification, including asking the questions that surface unstated requirements.
• Consistent documentation habits and disciplined version control of scripts.
• Practical experience using AI coding assistants such as Claude, with sound judgment about when to rely on generated output and how to verify it.

Preferred Qualifications

• Experience in higher education, particularly with Jenzabar J1 or a comparable student information system.
• Familiarity with Slate or related CRM and its data structures.
• Experience with reporting tools such as SSRS, Power BI, or a reports server.
• Scripting in Python or PowerShell for data movement and automation.
• Exposure to cloud-hosted database environments, including Google Cloud.
• Understanding of FERPA and GLBA obligations around student and financial data.

Additional Information:

First 90 Days:

A successful contractor in this role will, within the first ninety days, take over recurring report production from existing staff, complete an initial pass at reconciling exception records from the Slate-to-Jenzabar integration, and leave behind documented, runnable queries for each report they own.

Application Instructions:

All applicants must apply online by submitting:

Cover Letter Resume Names and contact information for three (3) professional references

Successful applicants will be required to complete a Criminal Offender Record Information (CORI/SORI) request.

After completing all the steps above, please go back into the newly created account and double check that your resume and cover letter uploaded as you intended.

Roxbury Community College understands that persons with specific disabilities may need assistance with the job application process and/or with the interview process. For confidential assistance with the job application process, please contact Pat Noel, ADA Coordinator, at 857-701-1290 or pnoel1@rcc.mass.edu.

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 hrstaff@rcc.mass.edu.

Tagged as: CSS