Scope of Work
The selected contractor will be expected to provide services that include, but are not limited to, the following:
Data Warehouse and Database Administration
• Design, build, and administer a centralized data warehouse environment in Google Cloud Platform
• Manage database performance, structure, permissions, reliability, and overall data integrity across core systems
• Support backup, recovery, and general database operational stability
• Define and maintain schemas, naming conventions, metadata structures, and data organization standards
Systems Integration and Data Flow Management
• Build, maintain, and troubleshoot integrations between source systems and the central warehouse using APIs, connectors, and MCP-based integration methods where appropriate
• Connect and manage data flows from key institutional and platform systems, including the LMS, HubSpot, and the custom AI platform being developed in GCP
• Monitor pipelines and integrations for failures, inconsistencies, or reliability issues and resolve issues affecting data quality, availability, and continuity
LMS and Platform Data Administration
• Support LMS-related data administration needs, including platform connectivity, user and course data structures, and reporting dependencies
• Coordinate data systems in a way that supports broader RGI platform architecture and downstream analytics or application use
Security, Governance, and Documentation
• Implement and maintain appropriate database and platform security practices, including role-based access controls, permission management, credential hygiene, and related administrative safeguards
• Document data flows, structures, integration logic, administrative procedures, and other technical materials required for maintainability and continuity
• Contribute to the development of a scalable and maintainable data environment that can support both current operations and future growth
Desired Qualifications
Proposers should demonstrate experience and capability in the following areas:
Required Qualifications
• Experience in database administration, data platform administration, or a closely related technical role
• Strong SQL and relational database experience, preferably PostgreSQL
• Experience designing, building, or administering cloud-based data warehouse environments
• Experience working in Google Cloud Platform or a comparable cloud environment
• Experience building and maintaining API-based integrations across multiple systems
• Familiarity with data modeling, schema design, data governance, and data quality management
• Experience managing permissions, access controls, and related core security responsibilities within a data environment
• Strong troubleshooting ability and comfort working independently in a fast-moving environment
• Ability to communicate clearly with both technical and non-technical stakeholders
• Strong attention to detail
Preferred Qualifications
• Experience working with LMS platforms and related data structures
• Experience with HubSpot data architecture and HubSpot APIs
• Experience with GCP services relevant to this engagement, such as BigQuery, Cloud SQL, Cloud Storage, Pub/Sub, Workflows, or related tools
• Familiarity with data environments that support AI or agentic application workflows
• Experience supporting an early-stage or rapidly evolving platform buildout within a university, institute, or similarly mission-driven organization
Pay: $50.00 - $90.00 per hour
Work Location: Remote
Apply tot his job
Apply To this Job