Senior People Data Analytics Engineer

The New York Times Company; New York (NY); Hybrid; USD 160,000 - 185,000; Full time

Benefits offered by this job

Annual bonus

Restricted stock

Medical benefits

Dental & vision

401(k) plan

Paid vacation

Paid sick days

Parental leave

Tuition assistance

Professional development

Job summary

The New York Times Company is rebuilding how we use people data. You will design, build, and govern production data models and the transformation layer, enabling reliable point-in-time analytics across HR products.

You will lead data quality, lineage, and access controls while collaborating with product teams and the HR function from our New York office on a hybrid schedule. Qualified candidates bring 5+ years in analytics/data engineering, strong SQL, dbt experience, and expertise in

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.

Responsibilities

• Design, build, and maintain the data models and databases that our products run on.
• Oversee the transformation layer from source systems into governed, tested, documented models.
• Turn metric definitions from the data dictionary into executable logic, so that a definition and the number it produces cannot drift apart.
• Build data quality into the pipeline: tests, validation, and reconciliation across sources that surface problems before team members do.
• Translate product requirements into models with the Program Manager, and push back when needed.
• Handle effective-dated and historical data correctly for point-in-time accuracy.
• Implement and maintain access controls for sensitive data.
• Document models and lineage for transparency.
• Support journalistic independence and our mission.

Skills

SQL expert

Analytics engineering

Dimensional modeling

dbt

Version control

SCD / slowly changing dimensions

Tools

Workday

Greenhouse

One Model

Python

AWS data services

Hex

Tableau

Looker

Job description

The New York Times Company is rebuilding how we use people data. You will design, build, and govern production data models and the transformation layer, enabling reliable point-in-time analytics across HR products.

You will lead data quality, lineage, and access controls while collaborating with product teams and the HR function from our New York office on a hybrid schedule. Qualified candidates bring 5+ years in analytics/data engineering, strong SQL, dbt experience, and expertise in