About Roxbury Community College:
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: Data & AI Engineering Consultant
Unit: Non-Unit Professional (NUP)
Department: Office of the CIO, Information Technology Services
Reports to: Chief Information Officer
Schedule: Hybrid: 4 days per week in office, 1 day remote.
Date: November 2026
Scope of work/position summary: The Data & AI Engineering Consultant is responsible for building, owning, and maintaining the Roxbury 2030 Data Portals, RCC's strategic data platform: a governed Databricks-on-Azure lakehouse fed by Jenzabar J1, Slate CRM, and Canvas. Phase 1 delivers four parts (Student Portal, SAP Portal, Finance Hub, and Learning Hub), each providing detailed insight into confidential student information, live in production. The role takes ownership of the platform in-house from the implementation partner and extends it with new views and better data.
Essential Duties and Responsibilities
- Portal development and ownership: Own and enhance the Data Portals in production, starting with the Student Portal Databricks App, including UI, queries, performance, and the release cycle; ensure alignment with RCC Institutional Learning Outcomes and departmental workflows.
- Data engineering: Build and maintain Silver and Gold layer tables and Unity Catalog metric views, and work with Lakeflow Connect and Auto Loader pipelines bringing in confidential student information from Jenzabar J1, Slate, and Canvas; maintain records, coordinate cross-departmental operations, and utilize college ERP/SIS platforms.
- Query development: Work with SQL Developer and Reports specialist to write, tune, and set standards for SQL against the lakehouse (Serverless SQL Warehouse) for new portal views, reports, and extracts.
- Data quality and integration: Identify and resolve duplicate, incomplete, and inconsistent records. Build validation and reconciliation checks across Jenzabar, Slate, and Canvas, and define record-matching rules between systems.
- Security and FERPA: Implement and test Unity Catalog row filters and column masks, verifying that each user sees only the data they are authorized to see. Review and approve data access requests under FERPA, GLBA, and College policy.
- Supervision and vendor management: Supervise and mentor co-ops, interns, and student workers assigned to the portal program. Manage the implementation partner's handoff and recommend technology purchases.
- Documentation: Document pipelines, data definitions, report logic, and operating procedures, and set documentation standards so others can pick up the work.
- Non-unit designation: This position is designated a Non-Unit Professional (NUP) position and is excluded from all College collective bargaining units because it carries the managerial and confidential responsibilities below, consistent with M.G.L. c. 150E, 1. These responsibilities are a regular and substantial part of the role.
- Access to confidential student information: Has access to confidential student information, including but not limited to student personal details, financial aid information, and payments.
- Confidential capacity: Views confidential data across the College's systems and displays it in our shell account.
- Independent judgment and authority: Exercises independent judgment in approving or denying data access requests, setting data standards, and directing the work of the implementation partner and vendors.
- Supervisory authority: Assigns, directs, and evaluates the work of co-ops, interns, and effectively recommends their hiring, extension, or release.
- Confidentiality obligation: Must hold all confidential student information, including personal details, financial aid information, and payments, in strict confidence. Disclosing it to any unauthorized person is grounds for immediate termination of the engagement.
- Changes in duties: Any material change to these duties will be reviewed by Human Resources to confirm the position's non-unit status.
- Backup for this position will be the CIO. Additional backup will be a full stack developer which is a Union position.
- Compliance & Governance: Perform duties in strict compliance with the Commonwealth of Massachusetts regulations, NECHE accreditation criteria, and individual collective bargaining agreements (if applicable).
- Perform other related job-related duties as assigned.
Requirements:
Qualifications:
- Required Minimum Education: Master's degree in computer science, data science, information systems, or a related field, or equivalent experience. A master's degree is preferred.
- Required Minimum Experience: Three or more years of hands-on data engineering or SQL development, including at least two years leading or owning a project.
- Core Competencies:
- Demonstrated excellence in written, verbal, and digital communication skills, including the ability to communicate information clearly and professionally to students, faculty, staff, administrators, union representatives, and community partners while maintaining confidentiality and professionalism.
- Demonstrated commitment to working in a culturally diverse, urban community college setting.
- Strong SQL, including complex joins, common table expressions, window functions, and query tuning.
- Proficiency in Python.
- Experience building and maintaining production data pipelines or data applications.
- Comfort with Git-based workflows, code review, and CI/CD.
- Ability to read a data model, trace a field back to its source, and reason about how records move between systems.
- Ability to translate needs from senior leadership and non-technical staff into clear specifications and priorities.
- Experience developing data governance policies or standards.
- Demonstrated ability to handle highly confidential information with discretion, and willingness to complete FERPA training before accessing production data.
- Consistent documentation habits.
- Practical experience using AI coding assistants such as Claude, with sound judgment about verifying generated output.
- Substitution Statement: An equivalent combination of education, training, and experience may be considered.
- Preferred Qualifications (optional):
- Hands-on experience with Databricks, Spark, Delta Lake, and Unity Catalog.
- Azure experience: ADLS Gen2, Entra ID, Key Vault, and Azure DevOps.
- Experience with Databricks Apps, Streamlit, Dash, or similar Python app frameworks.
- Dimensional modeling and medallion architecture.
- Experience building with LLMs: retrieval-augmented generation, prompt engineering, or agent frameworks.
- Higher education experience, particularly with Jenzabar J1, Slate, or Canvas data.
- Understanding of FERPA and GLBA obligations for PII and financial data.
- Experience with Power BI, Tableau, or similar reporting tools.
- Experience mentoring students or interns, or managing vendor relationships.
Additional Information:
Benefits
This position is a Consulting position and is exempt of benefits given to RCC employees.
Location: 2nd Floor, 1234 Columbus Ave, Roxbury Crossings, MA 02120
Anticipated Start Date: November, 2026
Compensation: $55 per hour
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.