EngineerJobs.io
← Back to all jobs

Job Description

Fortune is hiring a Senior Data Engineer in New York, NY (onsite) to build and operate ELT pipelines that reliably load and transform data into an Amazon Redshift warehouse. This role supports reporting in Looker and partners closely with business teams to deliver the datasets they need. Enjoy a structured benefits package, flexible time off, and a role that combines platform ownership with mentoring and performance optimization.

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.
  • Ingest data from a range of sources, including REST APIs, emailed reports, shared online documents, third-party web portals (via browser automation), and large hourly event streams using AWS Glue.
  • Own key platform pipelines for BigQuery, Google Ad Manager, Google Search Console, Apple News, LinkedIn, YouTube, Piano, and affiliate marketing partners.
  • Lead data migrations between business systems (for example: moving data into Salesforce Sales Cloud and Cvent, and migrating subscriber data from Piano into Recurly), including mapping, cleaning, deduplicating, and validating records.
  • Design and maintain aggregated analytics tables and data models that enable Looker reporting.
  • Add testing, monitoring, and documentation to reduce pipeline breakage and speed up recovery.
  • Optimize Redshift performance and cost using distribution and sort keys, workload management, and query tuning.
  • Partner with teams across marketing, sales, product, editorial, finance, and others to understand data needs and deliver usable datasets.
  • Mentor other engineers and analysts through code reviews, design reviews, and pairing.

What you bring

  • 5+ years of data engineering experience, including ownership of production pipelines.
  • Strong Python and SQL skills.
  • Hands-on experience with a cloud data warehouse, ideally Amazon Redshift (with BigQuery or Snowflake also considered).
  • Experience with AWS data services including Glue, S3, Lambda, and IAM.
  • Experience pulling data from third-party sources such as paginated and rate-limited APIs, file drops, emailed reports, and web portals.
  • Experience leading data migrations between business systems, including mapping, cleaning, deduplication, and validation.
  • Dimensional modeling experience, including building tables for Looker.
  • Experience with workflow orchestration (for example Airflow), and version control (Git), including CI/CD and code review.
  • Ability to explain technical work to people outside of engineering.
  • Ability to work from the NYC office 4 days per week.

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), plus 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 (audience, ad revenue, subscription, or syndication data).
  • Familiarity with Google Ad Manager, Search Console, Apple News, YouTube, LinkedIn, or Piano data.
  • Browser automation experience (for example 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.

Similar Jobs