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

FORTUNE

New York (NY)

On-site

USD 155,000 - 175,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

20 vacation days
2 personal days
11 company holidays
Health, dental, vision
401(k) plan

Job summary

Fortune is hiring a Senior Data Engineer to design, build, and run ELT pipelines that load data into our Amazon Redshift warehouse. You will pull data from REST APIs, reports, and portals, and own data migrations across CRM and subscription platforms.

You will mentor engineers and collaborate with marketing, sales, product, and finance teams. You will optimize Redshift performance, maintain analytics tables, and deliver reliable data for Looker-based reporting, while contributing to testing,

Qualifications

  • 5+ years of data engineering experience with ownership of production pipelines.
  • Strong Python and SQL.
  • Experience with cloud data warehouses (Redshift preferred).
  • Experience with AWS data services (Glue, S3, Lambda, IAM).
  • Experience leading data migrations and data mapping, cleaning, deduplication and validation.
  • Dimensional modeling and building tables for Looker.

Responsibilities

  • Design, build and maintain production ELT pipelines in Python.
  • Ingest, clean and upsert data into Fortune's Redshift warehouse.
  • Pull data from REST APIs, reports, and third-party portals.
  • Own data migrations between systems (CRM, event, subscription platforms).
  • Develop aggregated analytics tables and data models for reporting in Looker.
  • Add testing, monitoring and documentation; improve pipeline reliability.

Skills

Python
SQL
Data modeling
Mentoring
Communication

Tools

Airflow
Git
CI/CD
Looker
dbt
Playwright

Job description

Fortune is hiring a Senior Data Engineer to design, build, and run ELT pipelines that load data into our Amazon Redshift warehouse. You will pull data from REST APIs, reports, and portals, and own data migrations across CRM and subscription platforms.

You will mentor engineers and collaborate with marketing, sales, product, and finance teams. You will optimize Redshift performance, maintain analytics tables, and deliver reliable data for Looker-based reporting, while contributing to testing,

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 (Hybrid NYC)
Senior Data Engineer: ELT Pipelines & Redshift (Hybrid NYC)

Fortune Media (USA) Corporation • New York (NY)

Hybrid
USD 155,000 - 175,000
Health, dental, and vision coverage
401(k) plan
Generous parental leave
+2
Senior Data Engineer: Real-Time Pipelines & Analytics
Senior Data Engineer: Real-Time Pipelines & Analytics

Tillster • Seattle (WA)

On-site
USD 96,000 - 165,000
Health benefits
Holidays
401(k) Plan
+2
Senior Data Engineer - Real-Time Pipelines
Senior Data Engineer - Real-Time Pipelines

Tillster • San Diego (CA)

On-site
USD 135,000 - 155,000
Health benefits
10 paid holidays
PTO 15 days (first year)
+3
Senior Data Engineer: Build Scalable Data Pipelines
Senior Data Engineer: Build Scalable Data Pipelines

EliseAI • New York (NY)

On-site
USD 240,000 - 300,000
Equity in the company
Medical, Dental and Vision premiums
Fully paid parental leave
+3
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
Senior Data Engineer - Real-Time Pipelines & dbt
Senior Data Engineer - Real-Time Pipelines & dbt

Tillster • Las Vegas (NV)

On-site
USD 165,000 - 193,000
Health benefits
Paid holidays
401(k)
+1
RedShift Data Engineer
RedShift Data Engineer

Vantage Point Consulting Inc. • Alpharetta (GA)

Hybrid
USD 100,000 - 130,000
Senior Data Engineer: Scalable Snowflake ETL Pipelines
Senior Data Engineer: Scalable Snowflake ETL Pipelines

Software Mind • United States

Remote
USD 120,000 - 180,000
Senior Data Engineer: Cloud ELT & Data Pipelines
Senior Data Engineer: Cloud ELT & Data Pipelines

Randstad USA • Smithfield (RI)

On-site
USD 95,000 - 96,000
Medical insurance
Prescription coverage
Dental insurance
+5
Senior AWS Redshift Architect & Data Migration Lead
Senior AWS Redshift Architect & Data Migration Lead

Implify Inc • Houston (TX)

On-site
USD 120,000 - 180,000