Job description
About Trevor:
The Trevor Project is the leading suicide prevention and crisis intervention organization for LGBTQ+ young people. Our non-profit 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.
Every day, and in every role, our staff contribute to our critical mission of ending suicide among lesbian, gay, bisexual, transgender, queer & questioning young people by embodying our values:
Heart–We care deeply and commit to do what matters
Integrity–We build trust through our words and actions
Community-Together, we are an unstoppable force for good
Belonging-We serve as allies to the mission, and to each other
Progress-We continually move onward and upward
Applicants and staff must be authorized to work for any employer in the United States. The Trevor Project will not sponsor an employment visa for this position.
Role: Data Warehouse Administrator
Location: This role will be remote in the continental United States, Alaska, or Hawaii
Reports to: Director, IT & Security
Classification: Exempt Full Time
Union Role? Yes
Salary Range: $90 - 105K
Summary:
This role will provide crucial data related to crisis services, fundraising, operations, and more, to teams
across Trevor. Serving as the technical administrator of all data infrastructure at The Trevor Project,
this role will connect our source systems (including Salesforce, Genesys, Okta, Mailchimp, Google
Analytics, SAP Litmos, Amplitude, and others) to our BigQuery data warehouse using ETL
technologies. This role will work closely with our in-house teams, particularly the Data Analytics team,
to provide the resources needed for Data Analytics and Business Intelligence processes.
Roles and Responsibilities:
- Strategically partner with teams across the organization to understand data infrastructure needs
- Implement requirements (data models, views, etc. in the data warehouse) for data analytics and BI needs as directed and prioritized by the Data Analytics team
- Design, Implement, Maintain, and Monitor ETL data pipelines and optimize pipeline to achieve the appropriate balance of performance and cost
- Design, Implement, Maintain, and Monitor The Trevor Project Data Warehouse including the creation of views and models, and the provisioning of data set access for various business users and needs
- Ensure that data design standards are optimized to enable various business intelligence and visualization platforms as required by business stakeholders
- Ensure data integrity and data privacy
- Demonstrate fair, ethical, and equitable business practices
- Learn eagerly, share knowledge appropriately, and improve continuously
- Demonstrate successful planning and problem-solving skills, including multitasking and working well within tight timelines
- Work, communicate, and collaborate effectively with others
- Demonstrate attention to detail and accuracy in all work
- Demonstrate a commitment to fostering and maintaining an environment of belonging
- Other relevant duties and responsibilities as assigned
Minimum Qualifications:
- 2 or more years of combined education, work, and/or certification experience with demonstrated expertise in Data Lifecycle Management and ETL pipelines.
- Proficiency in:
○ SQL (specifically aggregation and analytical functions)
○ Technical documentation
○ BI Visualization Tools (e.g. Looker Studio, PowerBI, etc)
○ ETL Pipelines (e.g. FiveTran, Airbyte, AWS Glue, etc)
○ BigQuery and other relational and nonrelational databases
○ Server-side scripting and programming languages that support the above work
- Preferred experience with Google Cloud, with Contact Center environments and associated data and/or other cloud infrastructure providers
- Proficiency in spoken and written English
$90,000 - $105,000 a year
Why Trevor?
A career that truly makes a difference in the lives of LGBTQ young people–every single day
Outstanding benefits, including:
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)
403(b) retirement plan with 3% match
Generous vacation and 13 paid holidays (one of our holidays is Harvey Milk Day!) plus two floating holidays and three half-day Fridays during the summer
Employee Assistance Program to help with confidential emotional support, work-life solutions, financial solutions, legal assistance, or online support
In-network mental health office and virtual visits are covered at 100%, and out-of-network visits are covered at an enhanced level.
Remote work from the continental US, Alaska, or Hawaii (we provide the technology, a monthly internet reimbursement, and 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
The Trevor Project provides equal employment opportunities (EEO) to all employees and qualified applicants for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, age, disability, genetic information, veteran status, or any other status protected by applicable law or policy. The Trevor Project complies with all applicable laws regarding equal opportunity in employment.
This is a union position. The Trevor Project recently voluntarily recognized The Communications Workers of America (CWA) as the representative of certain employees for collective bargaining purposes, and this position is in the bargaining unit. The Trevor Project is currently negotiating the first collective bargaining agreement with the union that will cover the terms and conditions of employment for this position.
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 a reasonable accommodation is needed to participate in the job application or interview process, please submit a request here. Please do not disclose medical information in this form–this information will be viewed only by our benefits team and will remain secure. This form is only for those requiring a reasonable accommodation to participate in the job application or interview process. This form is not an application - you must still apply through The Trevor Project careers website.
