Database Analyst

Database Analyst

Location: Boston, MA

Onsite Flexibility: Remote

Contract Details

• Position Type: Contract
• Contract Duration: 9 months
• Pay Rate: $50.00 / Hour (USD)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Job Summary

The Analytics Engineer III is responsible for designing, developing, and maintaining the analytics-ready data models, semantic layers, and data pipelines that power reporting, analytics, and AI-enabled solutions. Working at the intersection of analytics engineering, data engineering, and artificial intelligence, this role applies software engineering principles to transform raw data into trusted, well-documented, and reusable data products, and to provide the governed business context that enables accurate AI analytics, agents, and machine learning workflows. The Analytics Engineer III works independently on complex tasks, contributes to data architecture and solution design, and collaborates with cross-functional partners across data engineering, AI engineering, and university business units. As analytics, data, and AI disciplines continue to converge, the scope of this role is expected to evolve alongside emerging technologies and institutional needs. This role does not include formal supervisory or leadership responsibilities but may provide knowledge sharing and technical input as part of project work.

Key Responsibilities

Analytics Data Modeling & Development (35%)

Design, build, test, and maintain analytics-ready data models and transformations that serve as trusted sources for reporting, analytics, and AI.

• Develop modular, reusable data models and transformations using dbt, SQL, and Python in cloud lakehouse environments (e.g., S3, Apache Iceberg, Trino)
• Apply modern data modeling and design techniques (e.g., dimensional, layered/medallion) and contribute to data architecture and design decisions
• Optimize models and queries for performance, cost, and usability, and support enhancements and troubleshooting of existing data assets

Semantic Modeling & Context Engineering (25%)

Build and maintain the semantic and metadata layers that give people and AI systems a consistent, governed understanding of university data.

• Implement metrics, business logic, and entity relationships in a semantic layer to ensure consistent definitions across reporting tools and AI applications
• Develop metadata, documentation, lineage, and structured context (e.g., schema descriptions, example queries, domain knowledge) that enables LLMs and AI agents to accurately interpret and query data
• Test the accuracy of AI-driven analytics (e.g., natural language querying, text-to-SQL) and refine context and models to improve results

Data, AI Analytics & ML Pipeline Engineering (20%)

Develop and support pipelines that deliver data to analytics, machine learning, and AI applications.

• Build and maintain orchestrated data pipelines using Dagster and AWS services
• Prepare curated datasets, features, and embeddings that support ML models, RAG pipelines, and AI analytics, in partnership with Data Engineers and AI Engineers
• Monitor and support the operational health of analytics and ML pipelines

Engineering Standards, Data Quality & Governance (10%)

Apply software engineering best practices to deliver reliable, secure, and maintainable data products.

• Use version control, code review, automated testing, and CI/CD for all analytics code, and contribute to documentation standards
• Implement data tests, data contracts, and observability to ensure data accuracy and integrity
• Follow established practices for security, privacy, and compliance with university data governance standards

Collaboration & Continuous Learning (10%)

Partner with stakeholders and stay current with evolving analytics, data, and AI technologies.

• Partner with faculty, staff, analysts, and technical teams to translate business and research needs into data models, metric definitions, and technical specifications
• Communicate technical concepts and data definitions clearly to a range of audiences
• Evaluate and apply new tools and methods, and participate in professional development opportunities

Required Skills

• Advanced SQL and Python skills, with experience building data models and transformations using dbt or similar tools
• Experience with software engineering practices, including Git, code review, automated testing, CI/CD, and pipeline orchestration
• Experience with data modeling, data architecture, and semantic layer implementation in cloud lakehouse environments (e.g., S3, Apache Iceberg, Trino)
• Ability to analyze technical requirements and independently deliver complex solutions with minimal oversight
• Strong communication skills and a solid understanding of data governance, privacy, and security best practices

Preferred Skills

• Exposure to LLMs, RAG, embeddings, or AI-driven analytics is desirable

Education Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Science, Data Analytics, or a related field (or equivalent combination of education and experience)

Required Experience

• 5 years of professional experience in analytics engineering, data engineering, business intelligence development, or a related technical field

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

About the Client

This client is a global research and teaching institution with campuses in Boston, Massachusetts, and academic programs spanning more than 30 countries worldwide. With nearly 38,000 students, more than 4,000 faculty members, and over 300 academic programs, the institution consistently ranks among the nation's top 50 universities and is a member of the Association of American Universities. It received more than $574 million in sponsored research funding in a recent fiscal year, reflecting its standing as a major engine of scientific discovery and innovation across fields including computing and data science, engineering for health, neuroscience, photonics, and global sustainability. Teams here span faculty researchers, academic administrators, student affairs professionals, and technology and operations staff including software engineers, data engineers, analytics engineers, AI engineers, and business intelligence professionals dedicated to education and discovery at the highest level.

About GTT

GTT is an NMSDC-certified Minority Business Enterprise (MBE) headquartered in Portsmouth, New Hampshire. GTT is a subsidiary of Chenega Corporation, an Alaska-based company and one of the largest Alaska Native-owned corporations. An Inc. 5000 honoree and one of SIA's Best Staffing Firms to Work For, GTT connects professionals with Fortune 500 organizations across IT, engineering, construction, utilities, life sciences, financial services, and healthcare throughout the U.S. and Canada. We're committed to diverse, inclusive workplaces and to placing people in roles where they can do their best work.

Job Number: 26-18516 Industry: Software Engineering

#LI-Remote