The Trevor Project
Data Warehouse Administrator
What's your preference?
Job Description
- Req#: ba279954-13e1-49e4-832f-8d55edd78b7c
- 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
- 2 or more years of combined education, work, and/or certification experience with demonstrated expertise in Data Lifecycle Management and ETL pipelines.
- Proficiency in:
- Preferred experience with Google Cloud, with Contact Center environments and associated data and/or other cloud infrastructure providers
- Proficiency in spoken and written English
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.
\n
Roles and Responsibilities:
Minimum Qualifications:○ 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
\n$90,000 - $105,000 a year\nWhy 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.
About the company
The Trevor Project is an American non-profit organization founded in 1998 focused on suicide prevention efforts among lesbian, gay, bisexual, transgender, queer, and questioning youth.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.