Senior Data Engineer
Backend Developer
Senior
3d Design Tools
Amazon Web Services
Analytics
Analytics Engineer
Apache Airflow
Application Support
AWS
Aws Data Engineer
Aws Data Warehouse
Aws Glue
Business Systems
Cloud
Cloud Computing
Cloud Data Engineering
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
CRM
Crm Analytics
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Lake
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Transforms
Data Warehouse
Data Warehousing
Database
Databases
Digital Marketing
ETL
Google Cloud Bigquery
Informatica
IT Services
Marketing Technology
Redshift
Rendering Engines
Reporting and Analytics
REST APIs
Salesforce
Salesforce Crm
Snowflake
Software Development
SQL
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.