Data Warehouse Administrator

Summary

Join The Trevor Project as a Data Warehouse Administrator and play a crucial role in providing data-driven insights to various teams. This remote position, based in the continental US, Alaska, or Hawaii, involves managing the organization's data infrastructure, connecting source systems to the BigQuery data warehouse using ETL technologies. Collaborate closely with the Data Analytics team to support their processes and ensure data integrity and privacy. The ideal candidate will have experience with data lifecycle management, ETL pipelines, SQL, BI visualization tools, and BigQuery. This is a full-time, exempt union position offering a competitive salary and excellent benefits.

Requirements

• 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)
• Proficiency in: Technical documentation
• Proficiency in: BI Visualization Tools (e.g. Looker Studio, PowerBI, etc)
• Proficiency in: ETL Pipelines (e.g. FiveTran, Airbyte, AWS Glue, etc)
• Proficiency in: BigQuery and other relational and nonrelational databases
• Proficiency in: Server-side scripting and programming languages that support the above work
• Proficiency in spoken and written English

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

Preferred Qualifications

Preferred experience with Google Cloud, with Contact Center environments and associated data and/or other cloud infrastructure providers

Benefits

• 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