AI Consultant Jobs in Massachusetts

Location: 1234 Roxbury Crossing, MA Category: Other Job Type: Contract Posted On: Thu Oct 22 2026 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.

Job 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