DeveloperJobs.io
← Back to all jobs

Job Description

Fortune is seeking a Senior Data Engineer to design, build, and operate ELT pipelines that move data into an Amazon Redshift warehouse. You will work across multiple ingestion paths, own platform-level pipelines and migrations, and help ensure reporting data is dependable for teams using Looker.

This role is based in New York, NY with onsite expectations of 4 days per week. The base salary range is USD 155,000 to 175,000 per year, with eligibility for a discretionary variable annual bonus.

What you’ll do

  • Design, build, and maintain production ELT pipelines, primarily in Python, to ingest, clean, and upsert data into Fortune’s Amazon Redshift warehouse.
  • Ingest data from REST APIs, emailed reports, shared online documents, third-party web portals (using 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, including workflows similar to moving data into Salesforce Sales Cloud and Cvent, and migrating subscriber data from Piano into Recurly; include mapping, cleaning, deduplication, and validation so records land accurate and usable.
  • Design and maintain aggregated analytics tables and data models that support Looker reporting.
  • Add testing, monitoring, and documentation to reduce pipeline failures and speed up fixes when issues occur.
  • Optimize Redshift performance and cost using distribution and sort keys, workload management, and query tuning.
  • Partner with business units including marketing, sales, product, editorial, finance, and others to understand data needs and deliver the right datasets.
  • Mentor engineers and analysts through code reviews, design reviews, and pairing.

Requirements

  • 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 (or BigQuery / Snowflake).
  • Experience with AWS data services such as Glue, S3, Lambda, and IAM.
  • Experience pulling from third-party sources, including paginated and rate-limited APIs, file drops, emailed reports, and web portals.
  • Experience leading data migrations between business systems (for example CRM, event, and subscription platforms), including mapping, cleaning, deduplication, and validation.
  • Dimensional modeling experience, including building tables for Looker.
  • Experience with orchestration (for example Airflow) and version control (Git), plus CI/CD and code review.
  • Ability to explain technical work to people outside engineering.
  • Ability to work from the NYC office 4 days per week.

Technologies you’ll work with

  • Python, SQL
  • Amazon Redshift, BigQuery, Snowflake
  • REST APIs, AWS Glue, AWS S3, AWS Lambda, AWS IAM
  • Salesforce Sales Cloud, Cvent, Recurly
  • Looker
  • Airflow, Git, CI/CD
  • Google Ad Manager, Google Search Console, Apple News, LinkedIn, YouTube, Piano
  • Browser automation (including Playwright and Selenium)
  • dbt
  • Amazon Redshift distribution and sort keys, workload management, query tuning

Benefits

  • 20 vacation days and 2 personal days, plus 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.
  • Eligibility for a discretionary variable annual bonus.

Nice to have

  • Experience in digital media or publishing, including audience, ad revenue, subscription, or syndication data.
  • Familiarity with Google Ad Manager, Search Console, Apple News, YouTube, LinkedIn, or Piano data.
  • Browser automation experience (such as Playwright or Selenium).
  • dbt or similar transformation frameworks.
  • Experience migrating or rebuilding legacy databases.
  • Experience designing engagement or scoring metrics.

Similar Jobs