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

Fortune Media (USA) Corporation

New York (NY)

Hybrid

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

Health, dental, and vision coverage
401(k) plan
Generous parental leave
Commuter benefits
Tuition reimbursement

Job summary

Fortune Media (USA) Corporation in NYC is seeking a Senior Data Engineer to design, build and maintain production ELT pipelines that load data into our Amazon Redshift warehouse. You will integrate data from REST APIs, reports, and web portals to feed Looker analytics and support multiple Fortune teams.

You will lead data migrations, implement testing and monitoring, and optimize pipeline performance. The role requires 5+ years in data engineering, strong Python/SQL, and the ability to work 4

Qualifications

  • 5+ years of data engineering experience with ownership of production pipelines.
  • Strong Python and SQL skills.
  • Experience with cloud data warehouses, ideally Amazon Redshift (BigQuery or Snowflake also considered).
  • Experience with AWS data services such as Glue, S3, Lambda and IAM.
  • Experience pulling data from third-party sources: APIs, file drops, reports and web portals.
  • Dimensional modeling experience, including buildings tables for Looker.
  • Experience with workflow orchestration (Airflow) and version control (Git), CI/CD and code review.
  • Ability to explain technical work to people outside engineering.
  • Ability to work from our NYC office 4 days per week.

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, emailed reports, shared online documents and web portals.
  • Build aggregated analytics tables and data models for Looker.
  • Add testing, monitoring and documentation; optimize performance and cost.
  • Collaborate with business units to deliver data needs and mentor others.

Skills

Python
SQL
ELT/ETL
Data modeling
CI/CD
Git

Tools

Airflow
Git
CI/CD
Looker
dbt
Redshift
S3
Lambda

Job description

Fortune Media (USA) Corporation in NYC is seeking a Senior Data Engineer to design, build and maintain production ELT pipelines that load data into our Amazon Redshift warehouse. You will integrate data from REST APIs, reports, and web portals to feed Looker analytics and support multiple Fortune teams.

You will lead data migrations, implement testing and monitoring, and optimize pipeline performance. The role requires 5+ years in data engineering, strong Python/SQL, and the ability to work 4

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 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 - 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: 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: 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 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: Python, SQL & Pipelines (Hybrid NYC)
Senior Data Engineer: Python, SQL & Pipelines (Hybrid NYC)

khealthcareers • New York (NY)

On-site
USD 150,000 - 175,000
Stock options for every full-time
Paid parental leave
401k benefit
+2
Senior Data Engineer — Hybrid & Scalable Data Pipelines
Senior Data Engineer — Hybrid & Scalable Data Pipelines

NBCUniversal • New York (NY)

Hybrid
USD 115,000 - 145,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
Senior Data Engineer
Senior Data Engineer

FORTUNE • New York (NY)

On-site
USD 155,000 - 175,000
20 vacation days
2 personal days
11 company holidays
+2