Data Warehouse Administrator

This role provides 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. 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.