Data Engineer, Media Innovations

About the role:

The Media Innovations Team (MIT) is a cross-functional partnership between product engineering, data science, and marketing. We think about advertising differently here - with a focus on first-party data only, our ad team centers the priorities of our users, our advertisers, and our newsroom through ad experiences that respect user privacy.

We are looking to add a Senior Data Engineer to the MIT team that will own and shape the marketing data domain area and move forward business goals. Our ideal candidate is excited about data, motivated to learn new technologies, and comfortable collaborating with engineers from other teams, product owners, business teams, and data analysts and data scientists. In this role, you will devise data solutions to new marketing technology challenges and how they would integrate with our existing marketing technology stack, and then take them to production. This is a high-impact role, and your contributions will make a difference in the way The New York Times builds great relationships with passionate newsreaders.

This role will report to the Engineering Manager, Media Innovations. The work location will be flexible to both remote or hybrid working models.

Responsibilities:

• Build and maintain new data pipelines to enable Marketing analytics and operations use cases
• Modernize and simplify existing marketing data pipelines and datasets by using SQL modeling in dbt
• Automate tasks such as end-to-end testing and report generation
• Build transformation pipelines with tools such as BigQuery, dbt, Airflow, FiveTran, Mode and other services in Google Cloud Platform using languages such as Python, Go & SQL

Basic Qualifications:

• 2+ years of full-time software engineering experience or equivalent
• Experience building and supporting large-scale data pipelines and warehousing solutions
• 1+ years experience with backend systems and software engineering. Programming experience in a relevant language, e.g. Python, Java
• 1+ years experience working with SQL and strong understanding of Data Modeling
• 1+ years experience working with cloud platforms like GCP or AWS

Preferred Qualifications:

• Experience with data transformation utilizing frameworks such as dbt
• Experience designing, maintaining, and monitoring an enterprise-wide data platform
• Experience with distributed systems and event-driven architectures
• Knowledge of different databases and storage technologies, like relational DBMSs, columnar storage, and key-value stores.
• Experience with data extraction and load tools such as FiveTran