Overview

Job Description

About the position

Wirecutter is seeking a Data Engineer to help build the infrastructure, data architecture, and pipelines that power our business.  Data Engineers operate within a distributed, agile, cross-functional squad. The data squad has an organization-wide impact by providing the data to inform the user experience, product, editorial, growth, and financial decisions at Wirecutter.  The squad is responsible for the ETL processes, architecture, storage, reliability, accuracy, monitoring, and infrastructure surrounding our internal data and analytics.

Our data engineering tech stack consists of:

  • Python and Apache Airflow for ETL pipelines

  • PostgreSQL database and S3 data lake in AWS RDS

  • BigQuery analytics data

  • Looker BI tool

Responsibilities

  • Help drive the optimization, testing, and tooling to improve data quality.

  • Write, debug, and test complex ETL processes for new or existing data pipelines.

  • Write and maintain database design and architecture documentation.

  • Maintain an understanding of Wirecutter’s data platforms as well as the data platforms of our parent company, the New York Times

  • Uncover dependencies and leverage features and tools from both the Wirecutter and New York Times

  • Collaborate with your squad leaders and stakeholders on the scoping, planning, prioritization, successful execution, and rollout of complex technical projects to provide the foundation for generating insights and address additional data for reporting needs.

  • Create new data models that are appropriately scalable, standardized, performant, and reliable.

  • Evolve our current data models from production services into readily consumable formats for all downstream data consumption.

  • Support and maintain the integrity and security of our internal data.

  • Provide insight into changing database storage and utilization requirements.

  • Recommend solutions that best align with our product and business goals, as well as the quality, reliability, and secure storage and replication of our data.

  • Improve our development workflow and infrastructure.

  • Share knowledge and problem solving with other members of your squad and the engineering team.

  • Contribute to engineering initiatives and culture as a member of Wirecutter’s engineering team.

 Qualifications

  • You have 3+ years in software or data engineering and scaling large data sets.

  • You can design & optimize queries, data sets, and data pipelines to organize, collect and standardize data that helps generate insights and addresses reporting needs.

  • You understand the challenges of reliable data replication, optimizing for a data warehouse, and maintaining the integrity of a data lake.

  • You have experience reliably integrating and handling data from multiple APIs.

  • You have experience building ETLs at scale on any major cloud provider (AWS, GCP: Cloud Composer, Kubernetes, etc.)

  • You are thoughtful, clear, and persuasive in writing and in person.

  • You have strong problem-solving skills and critical thinking abilities.

  • You have experience listening to analysts and other business users, and can translate their needs into actionable tasks.

  • You are excited to play a pivotal role in Wirecutter’s mission, innovation, and growth.

  • You are passionate and enthusiastic about what you do.

  • You have experience with version control, shell scripting, the Unix filesystem, and automating deployments.

  • Ideally, you have production experience with Python and Apache Airflow.

  • Ideally, you have experience with BI tools and managing data sets for BI tools.

  • Ideally, you have a basic understanding of statistics and sampling.

  • Ideally, you have experience working with Google Tag Manager and analytics data sets

  • Ideally, you’ve worked as a member of a distributed team.

About Wirecutter

Wirecutter helps people buy the right things for the way they want to live. The site was founded by journalists in September 2011 and was acquired by The New York Times Company in October 2016. Our recommendations are made through vigorous reporting, interviewing, and testing by teams of veteran journalists, scientists, and researchers. Consider us a best-of list for everyday things; a curated gallery filled with only interesting, useful objects; a thank-you note to the designers and engineers who create the stuff that makes our lives better; a geeky friend with next-level research skills who tests everything they buy so you don’t have to. The point is to make buying great gear quickly easier so you can get on with living your life.

We pride ourselves on following rigorous journalistic standards and ethics, and we maintain editorial independence from our business operations. Our recommendations are always made entirely by our editorial team without input from our revenue team, and our writers and editors are never made aware of any business relationships. Wirecutter is mission-driven and reader-supported; learn more about us here.

Our Company Principles

Our principles help us create a work environment that breeds trust, respect, learning, and is one that we all are excited about showing up to each day.

Seek Understanding: We are lifelong students who want to understand the world around us. We are curious to understand our readers, how we get better at our own disciplines, and how we can work better together. This means we are active listeners, information hunters, and empathetic.

Explain Why: Because we seek to understand, we value the importance of explaining our ideas and our understanding. This means we are constructively candid, sharing our perspectives and the thought process behind it. And then learning from the conversation that ensues. We are all teachers and students, helping each other grow.

Solve Things: We love to solve things, whether they are our own problems, our readers’ problems or our colleagues’ problems. While we often can solve problems on our own, we believe our best results come out when we solve them together.

Get It Done: We are passionate about getting things done. Whether it is our own individual work or teamwork, our instinct is to forge a path forward and learn as we go. This means we continually focus on how to turn work into achievable chunks, communicate those effectively to the team and efficiently execute against them.

Make It Better: We aren’t satisfied with perpetuating the status quo. We’re always looking forward. We live to change the world around us for the better, making a difference in our own lives and our readers’ lives. If we are being ambitious enough, this means that we will both fail and succeed and we take pride in owning both of those outcomes as long as we are learning.

Locations

Even with our offices in New York City and Los Angeles, Wirecutter remains a highly remote-friendly culture, and proud to employ incredible people across the country. Right now, we are eligible to hire in AZ, CA, CO, CT, FL, HI, IA, IL, IN, MA, ME, MI, MN, NH, NY, OH, OR, PA, TX, UT, WA.

Overview of Benefits at Wirecutter and The New York Times Company:

Though Wirecutter has physical locations in both NYC and LA, the company promotes and encourages a remote workforce, so that our employees can work in flexible and comfortable ways. We are committed to career development, supported by a formal mentoring program as well as tuition reimbursement. The New York Times Company offers frequent panel discussions and talks by industry leaders (Sheryl Sandberg, Melinda Gates and Ta-Nehisi Coates are a few recent examples), that we encourage our employees to attend.

We believe diversity fuels innovation and creativity, and we have a variety of employee groups and task forces across The New York Times Company and Wirecutter dedicated to fostering a diverse and inclusive workplace.

We offer a generous parental leave policy, which was recently expanded in response to employee feedback. Birth mothers receive 16 weeks fully paid, adoptive parents and birth fathers receive 10 weeks also fully paid. Similarly, we offer competitive health and dental insurance, as well as 401k matching.

#LI-AM1

The New York Times is committed to a diverse and inclusive workforce, one that reflects the varied global community we serve. Our journalism and the products we build in the service of that journalism greatly benefit from a range of perspectives, which can only come from diversity of all types, across our ranks, at all levels of the organization. Achieving true diversity and inclusion is the right thing to do. It is also the smart thing for our business. So we strongly encourage women, veterans, people with disabilities, people of color and gender nonconforming candidates to apply.

The New York Times Company is an Equal Opportunity Employer and does 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 New York Times Company will consider qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local “Fair Chance” laws.