Senior Data Engineer

Fortune

New York (NY)

On-site

USD 155,000 - 175,000

Full time

11 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

20 vacation days
Health, dental, and vision coverage
401(k) plan
Parental leave
Tuition reimbursement

Job summary

Fortune is seeking a Senior Data Engineer to design, build, and run ELT pipelines that populate Fortune’s Amazon Redshift data warehouse. You will integrate data from multiple sources and shape analytics tables used across advertising, subscriptions, and memberships teams.

You will mentor engineers, optimize performance, and collaborate with marketing, sales, product and editorial to deliver needed data. A NYC office presence is required four days a week.

Qualifications

  • 5+ years of data engineering experience with ownership of production pipelines.
  • Strong Python and SQL skills.
  • Hands-on experience with a cloud data warehouse, ideally Amazon Redshift.
  • Experience with AWS data services such as Glue, S3, Lambda and IAM.
  • Experience pulling data from third-party sources: APIs, file drops, portals.
  • Experience leading data migrations between systems (CRM, event, subscription).
  • Dimensional modeling experience, including Looker data models.
  • Experience with workflow orchestration (Airflow) and version control (Git), CI/CD and code reviews.
  • Able to explain technical work to non-engineering stakeholders.

Responsibilities

  • Design, build and maintain production ELT pipelines in Python that load data into Redshift.
  • Ingest data from REST APIs, emailed reports, portals, and hourly event streams (AWS Glue).
  • Own pipelines for platforms like BigQuery, Google Ad Manager, Search Console, YouTube, LinkedIn, Piano, affiliate partners.
  • Migrate data between systems (Salesforce, Cvent, Recurly) with mapping, cleaning and deduplication.
  • Design and maintain analytics tables and models powering Looker reports.
  • Add testing, monitoring and docs to reduce outages and accelerate fixes.
  • Optimize Redshift performance and cost (distribution/sort keys, WLM, query tuning).
  • Collaborate with marketing, sales, product and editorial to deliver data they need.
  • Mentor engineers and analysts through reviews and pairing.

Skills

Python
SQL
Communication
Data modeling

Tools

Amazon Redshift
BigQuery
Snowflake
AWS Glue
S3
Lambda
IAM
Airflow
Git
CI/CD

Job description

The role

Fortune is hiring a Senior Data Engineer to build and run the ELT pipelines that load data into our Amazon Redshift warehouse. You'll bring in data from first- and third-party sources, build the analytics tables our teams report from, and lead projects for the advertising, subscription and memberships businesses. This role will report into the SVP of Product & Technology.

The role

Fortune is hiring a Senior Data Engineer to build and run the ELT pipelines that load data into our Amazon Redshift warehouse. You'll bring in data from first- and third-party sources, build the analytics tables our teams report from, and lead projects for the advertising, subscription and memberships businesses. This role will report into the SVP of Product & Technology.

What You'll Do
  • Design, build and maintain production ELT pipelines, primarily in Python, that ingest, clean and upsert data into Fortune's Redshift warehouse.
  • Pull data from REST APIs, emailed reports, shared online documents, third-party web portals (via browser automation) and large hourly event streams (via AWS Glue).
  • Own pipelines for key platforms including BigQuery, Google Ad Manager, Google Search Console, Apple News, LinkedIn, YouTube, Piano and affiliate marketing partners.
  • Own data migrations between business systems similar to: moving data into Salesforce Sales Cloud and Cvent, and subscriber data from Piano into Recurly. This includes mapping, cleaning, deduplicating and validating records so they arrive accurate and usable.
  • Design and maintain aggregated analytics tables and data models that power reporting in Looker.
  • Add testing, monitoring and documentation so pipelines break less often and get fixed faster when they do.
  • Optimize Redshift performance and cost (distribution and sort keys, workload management, query tuning).
  • Work with business units (marketing, sales, product, editorial, finance and others) to understand what data they need and deliver it.
  • Mentor other engineers and analysts through code reviews, design reviews and pairing.
What You'll Bring
  • 5+ years of data engineering experience, including ownership of production pipelines.
  • Strong Python and SQL.
  • Hands-on experience with a cloud data warehouse, 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: paginated and rate-limited APIs, file drops, emailed reports and web portals.
  • Experience leading data migrations between business systems (e.g., CRM, event and subscription platforms), including data mapping, cleaning, deduplication and validation.
  • Dimensional modeling experience, including building tables for Looker.
  • Experience with workflow orchestration (e.g., Airflow) and version control (Git), CI/CD and code review.
  • Able to explain technical work to people outside engineering.
  • Ability to work from our NYC office 4 days per week.
Nice to have
  • Experience in digital media or publishing: audience, ad revenue, subscription or syndication data.
  • Familiarity with Google Ad Manager, Search Console, Apple News, YouTube, LinkedIn or Piano data.
  • Browser automation experience (e.g., Playwright or Selenium).
  • dbt or similar transformation frameworks.
  • Experience migrating or rebuilding legacy databases.
  • Experience designing engagement or scoring metrics.
Salary Range:

$155,000-$175,000 base salary, plus eligibility for a discretionary variable annual bonus. This range is a good faith estimate and may ultimately vary based on a number of relevant factors.

Location:

NYC; 4 days in office.

A Few Of Fortune's Perks And Benefits
  • 20 vacation days and 2 personal days on top of 11 company holidays and an honor-based sick leave policy.
  • Health, dental, and vision coverage (90% paid for individuals and families), along with flexible spending accounts where Fortune contributes to your HSA.
  • 401(k) plan.
  • Generous parental leave.
  • Dependent care, commuter, and cell phone benefits.
  • Tuition reimbursement program.
  • A commitment to an open, inclusive, and diverse work culture.
About Fortune:

At Fortune Media, our mission is to change the world by making business better. We achieve that by providing trusted information, great storytelling, rigorous benchmarking and world-class community building. And our key values are humility, ownership, and transparency.

The policy of Fortune Media is to provide equal employment opportunities to all applicants and employees without regard to race, color, caste, creed, religion, sex, sexual orientation, gender identity or expression, marital status, citizenship status, age, national origin, ancestry, disability, or any other characteristic protected by applicable law. Fortune Media affirmatively seeks to advance the principles of equal employment opportunity and values diversity and inclusion.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

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
Tech Lead / Engineering Manager
Tech Lead / Engineering Manager

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

Hybrid
USD 115,000 - 199,000
Vacation days 22
Paid holidays 11
Sick leave policy (honor-based)
+6
Tech Lead / Engineering Manager
Tech Lead / Engineering Manager

FORTUNE • New York (NY)

Hybrid
USD 115,000 - 199,000
Vacation days included
Paid holidays
Health, dental, and vision coverage
+5
Full Stack Software Engineer Next.js
Full Stack Software Engineer Next.js

Fortune • New York (NY)

On-site
USD 68,000 - 106,000
Vacation days
Healthcare coverage
401(k) plan
+4
Senior Director- Consumer Revenue
Senior Director- Consumer Revenue

Fortune • New York (NY)

On-site
USD 202,500 - 247,500
20 vacation days and 2 personal days
Health, dental, and vision coverage
Generous parental leave
+1
Program Manager, Fortune Live Media
Program Manager, Fortune Live Media

confidential • United States

On-site
USD 100,000 - 110,000
Vacation days
Health/Dental/Vision
401(k)
+4
Program Manager, Fortune Live Media
Program Manager, Fortune Live Media

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

On-site
USD 100,000 - 110,000
Vacation and personal days
Health, dental, and vision coverage
401(k) plan
+4
Director, Audience Recruitment
Director, Audience Recruitment

Fortune Fortune • New York (NY)

Hybrid
USD 160,000 - 175,000
Health insurance
401(k) plan
Generous parental leave
+3
Senior Producer
Senior Producer

Fortune • New York (NY)

On-site
USD 100,000 - 120,000
Health coverage
Dental & Vision
401(k) plan
+5
Senior Digital Account Manager
Senior Digital Account Manager

Fortune • New York (NY)

Hybrid
USD 85,000 - 95,000
20 vacation days
Health, dental, and vision coverage
401(k) plan
+4