Data Warehouse Administrator

The Trevor Project; United States; Remote; USD 90,000 - 105,000; Full time

Job summary

An established industry player is seeking a Data Warehouse Administrator to enhance their data infrastructure and support critical operations. This remote role involves managing data pipelines, ensuring data integrity, and collaborating with various teams to drive data analytics and business intelligence initiatives. With a commitment to making a difference in the lives of LGBTQ+ youth, this organization offers a supportive work environment and comprehensive benefits. Join a passionate team dedicated to impactful work and continuous learning, where your contributions will directly influence the organization's mission.

Benefits

Comprehensive health insurance

403(b) retirement plan with 3% match

Generous vacation and paid holidays

Employee Assistance Program

Remote work support

Professional development trainings

Online subscription to Headspace

Qualifications

• 2+ years of experience in Data Lifecycle Management and ETL pipelines.
• Proficient in SQL, BI tools, and ETL technologies.

Responsibilities

• Partner with teams to understand data infrastructure needs.
• Design and maintain ETL data pipelines and data warehouse.

Skills

SQL

ETL Pipelines

Data Lifecycle Management

Technical Documentation

BI Visualization Tools

BigQuery

Server-side Scripting

Education

Bachelor's Degree or equivalent experience

Tools

Looker Studio

PowerBI

FiveTran

Airbyte

AWS Glue

Google Cloud

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 requesthere. 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.