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 global research and teaching institution is a prestigious private university operating across campuses in Boston, Massachusetts, and academic programs in 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, placing it among the leading research institutions in the country. The organization received more than $574 million in sponsored research funding in a recent fiscal year, and 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