← Back to all jobs

TTP

The Trevor Project

Senior Data Engineer

Remote / Full Time

September 28

Role: Senior Data Engineer

Reports to: Machine Learning Engineering Manager

Location: Remote

Hours: Full-time

Term: Permanent


About Trevor

The Trevor Project is the world’s largest suicide prevention and crisis intervention organization for LGBTQ young people. We are a non-profit that provides 24/7 life-saving support via phone, text, and chat. We also operate the world’s largest safe space social networking site for LGBTQ youth and run innovative research, education, and advocacy programs. We’ve been saving lives every day for over 20 years.


Overview of the role

As The Trevor Project’s very first Senior Data Engineer on a growing team, you will play an integral role in providing crucial data related to crisis services, fundraising, operations, and more, to teams across Trevor. To do so, you will serve as the technical owner of all data infrastructure at The Trevor Project, connecting our source systems (including Salesforce, Okta, Mailchimp, Google Analytics, Humanity, SAP Litmos, and Amplitude) to our BigQuery data warehouse via Fivetran. You will also work closely with our in-house Machine Learning Team, Data Analyst Team (which has expertise in SQL, DBT, and Looker), and our data pipeline consulting vendor, Brooklyn Data Co, in the development and execution of strategic plans for future solutions. Through your technical expertise and leadership, our teams will be able to make informed, data-backed decisions that will have a direct impact on The Trevor Project’s mission to end suicide for LGBTQ young people!

 

Who you are

  • Experienced. You have strong experience creating and/or maintaining infrastructure needed to orchestrate data pipelines and store data with different performance requirements and computation goals. Experience with tools we use today, like Google Analytics/Google CloudRun, Google CloudFunctions, BigQuery, DBT, and FiveTran is preferred, but not required.
  • Pipeline Wiz. You have a proven track record of working with data pipelines and connecting new and existing systems to relational databases and/or warehouses.
  • Data Specialist. You have a strong background managing a backlog of data quality maintenance issues, working with ETL pipelines and connecting APIs, and creating system designs. 
  • Coding Expert. You are a strong programmer, specifically  in Python and SQL. While not required, you may also have coding skills in Javascript/Typescript. 
  • Project Leader. You are a strategic technical leader who is able to take a technical project vision and translate it into actionable steps and goals. 
  • Goal-oriented. You set aggressive, yet achievable, goals and then focus on exceeding them.
  • Collaborative. You understand that the best way to meet and exceed goals is through outstanding teamwork, and you have a strong background developing authentic relationships with a variety of stakeholders to accomplish said goals.
  • Flexible. You are comfortable navigating ambiguity and working through competing priorities.
  • Passionate. You care about LGBTQ youth. You care about saving lives. You want to come to work and feel inspired every day. You want to change the world.
  • Fun. The work we do is very serious, but that doesn’t mean we don’t have fun. We know how to have a good time and you should too.


What you’ll do

  • Strategically partner with teams across the organization to understand data infrastructure needs
  • Lead tech projects from to end to end utilizing a variety of technical programs and skills including, but not limited to: 
  • Advanced skills required: Python, Git, SQL (with an emphasis on aggregate/analytical functions), and writing and maintaining technical documentation (in English)
  • Intermediate skills required: Looker (LookML)
  • Technology to be learned on the job: Fivetran, Apache Beam, DBT, Google CloudRun and CloudFunctions, BigQuery, and Server-Side JavaScript/TypeScript
  • Own data pipelines to ensure accuracy, utility, and upkeep of information and provide updates and recommendations on usage when necessary
  • Route new data pipelines to integrate with new and existing systems
  • Ensuring data integrity and data privacy for constituents
  • Maintaining and creating ETL processes for data ingestion
  • Other tasks, duties, or special projects as assigned

 

Benefits

  • Generous vacation and holidays (like a full day off to celebrate Harvey Milk Day!)
  • Comprehensive health insurance, including coverage for various gender affirmation surgeries (and we pay 100% of your premiums for medical, dental, and life)
  • Flexibility to work from anywhere in the U.S. (we provide the technology, a monthly amount for internet and office supplies, and a reimbursement to outfit your work-from-home space!)
  • Fun virtual office environment and passionate team 
  • Online Subscription to Headspace, a digital meditation platform
  • Meaningful work at an organization that is saving the lives of LGBTQ young people across America every day
  • The Trevor Project is an equal opportunity employer


Your application

We’re excited to hear from you! To join Team Trevor, please upload a resume and cover letter. Applications without cover letters will not be considered. Use this as an opportunity to convey why you want to be the next Senior Data Engineer at The Trevor Project!

Made by Hyperplane