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 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.