ABOUT THE ROLE

TED stages conferences and produces media that it brings to millions of people around the world through web, mobile, and other platforms. We're looking for a Data Engineer with extensive experience in building data pipelines, ETL scripts, and data warehouses in a modern cloud environment. As a Data Engineer in a fast-paced team, you will work on a variety of exciting, high-visibility products building the future of TED’s data environment. In this role you will not only have the chance to deeply explore the data but will also be influential in what to do with it (partnering with product, marketing, ops, sales, and other key stakeholders). This is an excellent opportunity to 'do good' while having a high level of impact at a large-scale event and media company.

RESPONSIBILITIES

• Build custom integrations with 3rd party APIs
• Build ETLs to move and transform data
• Put together an end-to-end data pipeline using cutting edge tools and techniques
• Design data warehouses and data lakes
• Use your knowledge and experience to make recommendations and help shape new processes

ABOUT YOU

• Extensive database experience (Snowflake a plus)
• Expert in SQL
• R and/or DBT experience a plus
• Ad serving implementation a plus
• Independently organized; self-starter; ability to work with minimal direction
• Enjoy learning new tools to better solve new challenges
• Attention to detail and ability to ask the right questions
• Good communication and partnership skills
• Can switch between simultaneous projects easily

WHY WORK FOR US

TED is a global community, welcoming people from every discipline and culture who seek a deeper understanding of the world. We believe passionately in the power of ideas to change attitudes, lives and, ultimately, the world. TED began in 1984 as a conference where Technology, Entertainment and Design converged, and today covers almost all topics — from science to business to global issues — in more than 100 languages. Everything we do is driven by this goal: How can we best spread great ideas?

In addition to driving forward TED’s mission and joining our dynamic Digital Products team, we’re proud to provide strong employee benefits, including:

• Full health benefits (medical, dental, vision) 100% paid by TED for employees
• Work-life balance encouraged (TED closes for a 2-week summer break and 1-week winter break plus you're eligible for additional paid time off)
• Free OneMedical and SpringHealth membership for you and your dependents to address physical and mental well-being 
• Paid family leave
• 401(k) with match