Senior Analytics Engineer, People Data and Insights

The posting, as The New York Times wrote it

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

The New York Times is rebuilding how we use people data. Instead of one-off reports and ad hoc pulls, we are building governed, reusable data tools that HR leaders, HR partners, and their counterparts use to make decisions. You will help build this layer. People data at The Times lives in several systems, each with its own definitions and history. You will turn that into a modeled, tested, documented foundation that products can be built on repeatedly. You will lead the models, transformations, and data quality behind every product this team ships. You will report to the Senior Director, People Data and Insights. You will work out of the New York office on a hybrid schedule.

Responsibilities

• You will design, build, and maintain the data models and databases that our products run on.
• You will oversee the transformation layer from source systems into governed, tested, documented models.
• You will turn metric definitions from the data dictionary into executable logic, so that a definition and the number it produces cannot drift apart.
• You will build data quality into the pipeline: tests, validation, and reconciliation across sources that surface problems before team members do.
• You will work with the Program Manager to translate product requirements into models, and push back when a requirement and the underlying data do not agree.
• You will handle effective-dated and historical data correctly, so that point-in-time questions get point-in-time answers.
• You will implement and maintain access controls appropriate to compensation, demographic, and other sensitive data.
• You will document models and lineage so that all can understand why something was built the way it was.
• You will demonstrate support and understanding of our value of journalistic independence and a strong commitment to our mission to seek the truth and help people understand the world

Basic Qualifications

• 5+ years of experience in analytics engineering, data engineering, or an equivalent role building production data models.
• You are a SQL expert
• Strong dimensional modeling skills, and the judgment to know when to normalize and when not to.
• 5+ years of experience with a transformation framework such as dbt, and with version control and code review as part of normal practice.
• 5+ years of experience handling slowly changing dimensions, dated records, and point-in-time reporting.

Preferred Qualifications

[…]
ation. 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 reasonable.accommodations@nytimes.com. 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 NYTapplicants@nytimes.com. You can also file a report with the Federal Trade Commission or your state attorney general .