Data Engineer, Analytics Data Products

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. About the Role:At The New York Times, data powers decisions across the entire company. The Analytics Data Products team builds the foundational data products and pipelines that make that possible, and we're looking for a Data Engineer to help us build them. You'll own and enhance the data pipelines and core, reusable data products that partner teams across the company depend on to unlock analytics for their most important questions. You'll work hands-on across our hybrid cloud architecture (AWS and GCP) and contribute to the platform that delivers trusted data products company-wide spanning multiple business domains. You'll join a collaborative team that invests in your growth. Reporting to the Senior Engineering Manager of Analytics Data Products, you'll take ownership of pipelines and products, learn from experienced engineers, and grow your impact across the company.This is a hybrid role in our New York City headquarters.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 computeresources (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.Basic Qualifications2+ years of full-time professional, hands-on experience with Software Engineering in a data context or equivalent experienceStrong proficiency in Python for scripting and data manipulationStrong 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 SDLCHands-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)Preferred QualificationsExperience operating in a dual-cloud environment (GCP/AWS)Experience with Infrastructure-as-Code (IaC) tools like TerraformKnowledge of PySpark or other Spark APIsExperience with advanced Lakehouse file formats like Iceberg or Delta LakeFamiliarity ensuring data product SLAs and quality standards, integrating advanced testing, quality checks, and monitoring into the CI/CD pipelineREQ-019488#LI-hybridAdditional Compensation and Benefits: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. Benefits may include medical, dental and vision benefits, Flexible Spending Accounts (F.S.A.s), a company-matching 401(k) plan, employee stock purchase plan, paid vacation, paid sick days, paid parental leave, tuition reimbursement and professional development programs. For roles outside of the U.S., information on benefits will be provided during the interview process.The annual base pay range for this role is between:$110,000—$130,000 USDCandidate Use of GenAI Tools:We’re excited to learn more about you and your experience. To keep our hiring process as fair and authentic as possible, we ask that you submit your own work and not use GenAI tools to generate substantive content during the application and interview process.If you’re an engineering candidate, we’ll let you know what specific GenAI tools you are permitted to use for your technical assessment.The New York Times Company is committed to being the world’s best source of independent, reliable and quality journalism. To do so, we embrace a diverse workforce that has a broad range of backgrounds and experiences across our ranks, at all levels of the organization. We encourage people from all backgrounds to apply.We are an Equal Opportunity Employer and do not discriminate on the basis of an individual's sex, age, race, color, creed, national origin, alienage, religion, marital status, pregnancy, sexual orientation or affectional preference, gender identity and expression, disability, genetic trait or predisposition, carrier status, citizenship, veteran or military status and other personal characteristics protected by law. All applications will receive consideration for employment without regard to legally protected characteristics. The U.S. Equal Employment Opportunity Commission (EEOC)’s Know Your Rights Poster is available here. The New York Times Company will provide reasonable accommodations as required by applicable federal, state, and/or local laws. Individuals seeking an accommodation for the application or interview process should email View email address on click.appcast.io. Emails sent for unrelated issues, such as following up on an application, will not receive a response.For information about The New York Times' privacy practices for job applicants, click here.Please beware of fraudulent job postings. Scammers may post fraudulent job opportunities, and they may even make fraudulent employment offers. This is done by bad actors to collect personal information and money from victims. All legitimate job opportunities from The New York Times will be accessible through The New York Times careers site. The New York Times will not ask job applicants for financial information or for payment, and will not refer you to a third party to do so. You should never send money to anyone who suggests they can provide employment with The New York Times.If you see a fake or fraudulent job posting, or if you suspect you have received a fraudulent offer, you can report it to The New York Times at View email address on click.appcast.io. You can also file a report with the Federal Trade Commission or your state attorney general.