> Markdown version of [/jobs/ext/3998012-data-ai-engineer](https://www.wearedevelopers.com/jobs/ext/3998012-data-ai-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data AI Engineer

- **Company:** Union Square Hospitality Group
- **Location:** New York, NY, United States
- **Experience:** Experienced
- **Salary:** $110,000.0
- **Contract:** Permanent contract
- **Skills:** LangGraph Framework, Sql Data Warehouse, Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, BigQuery, Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Warehousing, Python (Programming Language), Performance Tuning, Standard Sql, Retrieval-Augmented Generation, Large Language Models, Snowflake, Prompt Engineering, Data Lineage, AWS Glue, Operational Systems, Claude, Data Pipelines, Amazon Redshift
- **Published:** October 28, 2026
- **Apply:** https://www.nettemps.com/us/en/W7CB815697F9D4EF058.ntap

## About the Role

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 - eg 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

## Description

The Data and AI Engineer will own the data infrastructure that powers reporting and decision-making across every concept in the USHG portfolio. This is a hybrid role split evenly between two disciplines: building and maintaining our AWS Redshift data warehouse, and building and maintaining the AI layer on top of it.

You will be the first dedicated owner of this stack end-to-end: source APIs in, clean and modeled data in Redshift, and an AI-driven experience out. You will work closely with FP&A, Operations, Marketing and others to understand the data they need and the questions they want to answer, and you'll be the one who helps build the solutions needed.

What you'll do:

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 (eg 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