Data Warehouse Administrator - The Trevor Project
View Company Profile- Job Title
- Data Warehouse Administrator
- Job Location
- Remote - United States
- 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 mattersIntegrity–We build trust through our words and actionsCommunity-Together, we are an unstoppable force for goodBelonging-We serve as allies to the mission, and to each otherProgress-We continually move onward and upwardApplicants 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 AdministratorLocation: This role will be remote in the continental United States, Alaska, or HawaiiReports to: Director, IT & SecurityClassification: Exempt Full TimeUnion Role? YesSalary Range: $90 - 105KSummary:This role will provide crucial data related to crisis services, fundraising, operations, and more, to teamsacross 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, GoogleAnalytics, SAP Litmos, Amplitude, and others) to our BigQuery data warehouse using ETLtechnologies. 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
Everything You Need, One Platform.
From job listings to startups, investors to funding rounds, and everything in between, Employbl puts the power in your hands. Why wait?
Start your free trial today!Stay Ahead of the Curve
Sign up for our newsletter to stay informed about the latest startups and trends in the tech market. Let Employbl be your guide to success.
The Trevor Project Company Size
Between 200 - 1,000 employees
The Trevor Project Founded Year
1998