The Trevor Project
West Hollywood, CA
51-200 employees
The world's largest suicide prevention and crisis intervention organization for LGBTQ young people.
Associate Data Engineer
Associate Data Engineer
This job is no longer open
The Trevor Project is committed to the full inclusion of all qualified individuals. As part of this commitment, we will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact accommodationrequest@thetrevorproject.org.
About Trevor
The Trevor Project is the leading 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.
Role: Associate Data Engineer
Reports to: Software Engineering Manager
Location: This role will be remote in the continental US, Alaska, or Hawaii
Hours: Full-time
Salary Range: $80,000 - $90,000
Overview of the role
The Data Engineer will work closely with the Data Engineering team and help with expanding Trevor’s core Data competencies. You will be directly involved in helping with day-to-day data defects that affect existing dashboards and reports, buildingout data integrity tests, helping with the audit of table schemas, and helping maintain various data pipelining tools.
Who You Are
- Experienced. Proven knowledge of databases and design, with an understanding of SQL and its concepts, with proficiency in at least one general purpose programming language, such as Python, JavaScript, Scala, Java, etc. Experience with main Google Cloud Platform services is preferred.
- Collaborative. Demonstrated ability to communicate ideas clearly - both written and verbal - for audiences, both internal and external. Recognized success in creating relationships with cross-functional teams from varying levels, working closely with colleagues to brainstorm ideas, discuss pros/cons, and develop ways forward.
- Communicative. Proven skill in distilling complex information into compelling, easily digestible narratives; presents information in an inspiring and persuasive way.
- Service Delivery and Adaptability. Proven focus on proactive and inclusive issue resolution and continuous improvement for all systems and processes.Demonstrated flexibility in the midst of change, being able to successfully juggle multiple deliverables, and adapting to new situations with fresh ideas or innovative approaches.
- Mission and Culture Alignment. Demonstrates awareness and support for The Trevor Project’s mission and vision: to end suicide and address mental health crises in the LGBTQ youth community, and create a world where all LGBTQ young people see a bright future for themselves.
What You'll Do
- Contribute to our critical mission of ending suicide among lesbian, gay, bisexual, transgender, queer & questioning young people, while fostering an inclusive approach to your direct work and engagement with Trevor colleagues across the organization
- Continually grow your LGBTQ competency and awareness
- Improve and expand a robust Google Cloud BigQuery schema built using Data Build Tool (DBT)
- Maintain and build data pipelines to provide growth and analytics team with cleaned data
- Expand existing health alerts and tests for data pipelines to prevent invalid data being ingested into data warehouse
- Work with a small but growing data team in providing the best data insights possible to Trevor stakeholders
- Communicate technical problems to teammates (including product managers, quality assurance analysts, and software engineers) in clear and insightful ways
- Other relevant tasks, duties, or special projects as assigned
Why Trevor?
- A career that truly makes a difference in the lives of LGBTQ young people–every single day
- Comprehensive health insurance, including plan coverage for various gender affirmation care (and we pay 100% of your employee contribution premiums for medical, dental, vision, AND basic life insurance)
- Flexible Spending Accounts
- Employee Assistance Program to help with confidential emotional support, work life solutions, financial solutions, legal assistance, or online support
- Generous vacation and 12 paid holidays (one of our holidays is Harvey Milk Day!) plus two floating holidays , and three half-day Fridays during the summer
- Pet insurance
- Remote work from the continental US, Alaska, or Hawaii (we provide the technology, a monthly internet reimbursement, and a reimbursement to outfit your work-from-home space!)
- Professional and Learning Development Trainings/Education: including a professional subscription to LinkedIn Learning, providing access to more than 13,000 high quality on-demand courses.
- Online Subscription to Headspace, a digital mindfulness and meditation platform
$80,000 - $90,000 a year
The Trevor Project provides equal employment opportunities (EEO) to all employees and qualified applicants for employment without regard to race, color, religion, gender, gender identity or expression, ancestry, sexual orientation, national origin, age, handicap, disability, marital status, or status as a veteran. The Trevor Project complies with all applicable laws.
This job is no longer open