Data & AI Engineer: Redshift, ETL & AI Reporting

USHG - Home Office

New York (NY)

Hybrid

USD 110,000 - 140,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health coverage
Paid time off
401(k) plan match
Life insurance
Employee relief fund
Dining discount

Job summary

USHG Home Office is seeking a Data and AI Engineer to own the data stack end-to-end, including AWS Redshift and an AI layer. You will partner with FP&A, Operations, and Marketing to deliver trusted reporting and insights.

You will build ETL pipelines, design data models, monitor quality, and develop an internal analytics agent to answer questions in plain language. This is a hybrid role across two disciplines.

Qualifications

  • 2-4 years of experience in data engineering or analytics engineering.
  • Hands-on production experience with AWS Redshift or comparable warehouse.
  • Strong SQL and Python skills.

Responsibilities

  • Design, build, and maintain the AWS Redshift environment for consolidated data.
  • Build and maintain ETL pipelines to ingest, transform, and load data reliably.
  • Develop an internal analytics agent to allow natural language data queries.
  • Prototype and productionize agentic AI workflows with guardrails and reliability.

Skills

SQL
Python
ETL/ELT
AWS Redshift
LLM/AI tooling

Tools

AWS Redshift
Snowflake
Airflow
LangChain
LangGraph

Job description

USHG Home Office is seeking a Data and AI Engineer to own the data stack end-to-end, including AWS Redshift and an AI layer. You will partner with FP&A, Operations, and Marketing to deliver trusted reporting and insights.

You will build ETL pipelines, design data models, monitor quality, and develop an internal analytics agent to answer questions in plain language. This is a hybrid role across two disciplines.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer: ELT Pipelines & Redshift Expert (NYC)
Senior Data Engineer: ELT Pipelines & Redshift Expert (NYC)

FORTUNE • New York (NY)

On-site
USD 155,000 - 175,000
20 vacation days
2 personal days
11 company holidays
+2
Senior Data Analytics Engineer - Redshift, Airflow & BI
Senior Data Analytics Engineer - Redshift, Airflow & BI

Harvey Nash • Arlington (VA)

On-site
USD 91,000 - 129,000
RedShift Data Engineer
RedShift Data Engineer

Vantage Point Consulting Inc. • Alpharetta (GA)

Hybrid
USD 100,000 - 130,000
Data Engineer II — AI-Powered Data Platforms
Data Engineer II — AI-Powered Data Platforms

Amazon Inc. • Berwick

On-site
USD 132,000 - 179,000
RSUs
Health insurance
PTO
+3
Staff Data Engineer
Staff Data Engineer

Join9am • United States

Remote
USD 150,000 - 190,000
Remote work options
Professional development budget
Health, dental, and vision coverage
Cloud Data Architect & AWS ETL Engineer (Redshift)
Cloud Data Architect & AWS ETL Engineer (Redshift)

INTELLISWIFT INC • Wyomissing

On-site
USD 110,000 - 160,000
Senior Data Engineer: Redshift, Glue & AWS ETL
Senior Data Engineer: Redshift, Glue & AWS ETL

RxCloud • Alameda (CA)

On-site
USD 100,000 - 130,000
Senior Data Engineer - AWS Analytics & Pipelines
Senior Data Engineer - AWS Analytics & Pipelines

Amazon Development Center U.S., Inc. • Seattle (WA)

On-site
USD 132,000 - 179,000
Health insurance
401(k) matching
Paid time off
+2
Data Engineer
Data Engineer

Compunnel Inc. • Boston (MA)

On-site
USD 110,000 - 140,000
Data Engineer, AI Infra & GenAI Pipelines (Seattle)
Data Engineer, AI Infra & GenAI Pipelines (Seattle)

Amazon Development Center U.S., Inc. • Seattle (WA)

On-site
USD 132,000 - 179,000
Sign-on payments
Restricted stock units (RSUs)
Health insurance (medical, dental, and
+4