Data & AI Engineer

Responsibilities

Cultivate a culture of Enlightened Hospitality for all stakeholders

Design, build, and maintain the AWS Redshift environment that consolidates data from our source APIs (POS, reservations, guest survey, labor/HR, and other operational systems)

Build and maintain ETL pipelines to ingest, transform, and load data reliably and on schedule, using tools such as AWS Glue, Lambda, and/or Airflow

Design efficient schemas and data models (distribution keys, sort keys, incremental models) optimized for reporting and analytics workloads

Monitor pipeline health and data quality; build automated validation and alerting so issues are caught before they reach a report

Manage Redshift performance and cost – right-sizing clusters, tuning queries, and keeping the environment scalable as we add sources and concepts

Maintain clear documentation of data lineage, schemas, and access controls

Design, build, and maintain an internal analytics agent that lets non-technical stakeholders ask questions of our data in plain language and get accurate, trustworthy answers

Build and maintain AI-automated reporting structures (e.g. daily/weekly/ monthly reports) that blend metrics with narration

Prototype and productionize agentic workflows – including retrieval, evaluation, and guardrails – so AI-generated outputs are reliable enough for operators and executives to act on

Evaluate and integrate new AI/LLM tooling as the space evolves, bringing back practical recommendations rather than chasing every new release

Benefits

Eligibility for a performance-based bonus

Medical, dental, and vision insurance, plus flexible spending options for healthcare and dependent care

Generous paid time off and paid parental leave

A matched 401(k) plan

Life insurance, employee assistance programs, and exclusive access to primary care, mental health, and other wellness services

Access to the USHG HUGS Employee Relief Fund, offering direct assistance to team members facing unexpected hardship

Annual dining credit and a 51% dining discount across the entire USHG family of restaurants

Pre-tax commuter benefits for transit and parking

Opportunities for learning, mentorship, and collaboration with some of the most passionate people in hospitality.

Glassdoor

3.8

Union Square Hospitality Group is a restaurant that offers dining, hospitality workshops, and food delivery services.

New York, New York, USA

https://www.ushg.com

Late Stage

Leadership Team

Richard Coraine

Founding Partner

Recent News

Fortune

Inside Danny Meyer’s promote-from-within culture: 80% of his GMs started as hourly staff

2026-09-29

Morningstar.com

Karl-Anthony Towns, Halle Berry, Zac Posen, Danny Meyer and Sara Foster Were Among the Speakers at Today’s Fifth Annual Retail Influencer CEO Forum

2026-09-11

Boston Globe

The big restaurant brands are coming for Boston

2026-07-07

Company data provided by

AI Tools

Qualifications

2-4 years of experience in data engineering, analytics engineering, or a closely related role

Hands-on production experience with AWS Redshift or comparable cloud data warehouse (Snowflake, BigQuery), including schema design and query/performance tuning

Strong SQL and Python skills

Experience building ETL/ELT pipelines and integrating data from multiple third-party APIs

Hands-on experience with LLM/AI tooling – e.g. Claude or another foundation model API, prompt design, RAG, or agent frameworks (LangChain, LangGraph, or similar)

Comfort working with ambiguous, evolving requirements and prioritizing independently

Clear written and verbal communication, and the ability to explain technical decisions to non-technical stakeholders

Required skills

AWS Redshift, SQL, Python, ETL/ELT Pipelines, Third-Party API Integration, AWS Glue, AWS Lambda, Apache Airflow, LLM/AI Tooling, Prompt Design, Retrieval-Augmented Generation (RAG), Agent Frameworks, Independent Prioritization

Experience

2+ years