Data Engineer, Analytics Data Products

About the role

The mission of The New York Times is to seek the truth and help people understand the world. That means independent journalism is at the heart of all we do as a company. It’s why we have a world-renowned newsroom that sends journalists to report on the ground from nearly 160 countries. It’s why we focus deeply on how our readers will experience our journalism, from print to audio to a world-class digital and app destination. And it’s why our business strategy centers on making journalism so good that it’s worth paying for.

Responsibilities

• Design, model, and implement complex data pipelines for the cleansed and curated data layers in the medallion architecture, taking full ownership of the data product's structure, partitioning, documentation, and performance characteristics.
• Develop advanced data transformations using dbt (data build tool) for relational data modeling and PySpark for complex data processing within the Lakehouse, ensuring outputs meet strict SLAs and quality standards.
• Collaborate with Data Analysts and other consumers to define requirements and translate them into scalable data models suitable for analytic use cases.
• Manage physical data storage across both GCP (GCS, BigQuery, Cloud Composer) and AWS (S3, Glue, Athena, EMR).
• Choose optimal file formats such as Parquet and Iceberg, and design efficient partitioning and clustering strategies.
• Administer and tune Spark compute resources (e.g., Dataproc, EMR, or managed services) to optimize job execution time and cost.
• Optimize user queries and access patterns to maintain platform performance and cost efficiency.
• Implement centralized data quality checks and observability mechanisms within the data pipeline to proactively identify and resolve data issues.
• Contribute to the implementation of metadata management, data lineage, and role-based access control (RBAC) programs across the Lakehouse environment.

Qualifications

• 2+ years of full-time professional, hands-on experience with Software Engineering in a data context or equivalent experience
• Strong proficiency in Python for scripting and data manipulation
• Strong proficiency in SQL and demonstrable experience with complex, production-level data modeling (preferably dimensional modeling, Kimball, OBT, or Data Vault)
• Demonstrated experience owning data pipelines and products end-to-end through the full SDLC
• Hands-on experience with a Cloud Data Warehouse (BigQuery, Snowflake, DataBricks)
• Familiarity with foundational cloud services and data storage components in at least one major cloud provider (GCP or AWS)
• Experience with workflow orchestration tools (e.g., Airflow, Cloud Composer, or Prefect) and version control systems (Git)

Benefits

• The annual base pay range for this role is between $110,000 - $130,000 USD
• Benefits may include medical, dental and vision benefits, Flexible Spending Accounts (F.S.A.s), a company-matching 401(k) plan, paid vacation, paid sick days, paid parental leave, tuition reimbursement and professional development programs.

Pay & Schedule

• The annual base pay range for this role is between $110,000 - $130,000 USD
• For roles in the U.S., dependent on your role, you may be eligible for variable pay, such as an annual bonus and restricted stock.
• For roles outside of the U.S., information on benefits will be provided during the interview process.