About Trevor:The Trevor Project is the leading suicide prevention and crisis intervention organization for LGBTQ+ young people. Trevor offers 24/7 crisis services, connecting highly trained counselors with LGBTQ+ young people whenever they need support. To drive prevention efforts, The Trevor Project also operates robust research, advocacy, education, and peer support programs. We’ve been saving lives every day for over 25 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.RoleBusiness Intelligence (BI) DeveloperLocationThis role will be remote in the continental United States, Alaska, HawaiiReports toDirector of Software Engineering & QAClassificationExempt Full TimeUnion Role? NoStarting Salary Range$90-$105KSummaryThe Business Intelligence (BI) Developer is a critical role responsible for transforming clean data from the central data warehouse into actionable and trustworthy insights for stakeholders across The Trevor Project (currently including Strategy, Crisis Services, and Advancement - but not inclusive of future data sources). This role will be the technical owner for the organization’s production data visualization and reporting platform, in alignment with the organization’s data analytics strategy and Center of Excellence (led by the Strategy & Innovation team, within the Office of the CEO). The BI Developer will focus on architecting, developing, and maintaining scalable dashboards and the Semantic Layer (e.g., LookerML, dbt) to ensure metric consistency and data integrity across all public and internal reporting. Responsibilities include full lifecycle development of dashboards, performance tuning, and pipeline system health.Roles and Responsibilities:Design, implement, and maintain the organization's Semantic Layer (e.g., LookerML, dbt), ensuring that core business metrics are defined consistently and accurately across all reportsArchitect, develop, and maintain high-impact, scalable, and secure production dashboards and reports for internal operations and external impact reportingManage the user access, security, and governance standards within the primary Business Intelligence and Data SaaS platform (e.g., Looker, BigQuery, FiveTran, AirByte), ensuring compliance with organizational security and privacy policiesWork closely with the Strategy & Innovation team, Data team members, and organizational stakeholders to enforce standardized metric definitions and ensure data quality is maintained from the warehouse to the final reportAccountable for implementing and executing on the overall organizational Data & BI Strategy and adhering to the Strategy team’s Data Strategy & Analytics Product Owner standards, practices, and processesOptimize the performance of complex dashboards and reports by refining underlying SQL queries and utilizing BI tool best practicesServe as the technical reporting expert, collaborating with Strategy, Crisis Services, and Fundraising teams to translate complex business questions and requirements into technical dashboard specifications, including relating to executive-level data and strategic projects, organizational performance, and performance managementIdentify and troubleshoot data integrity issues or data pipeline defects that affect reporting accuracyEfficiently manage and execute diverse ad-hoc data requests from various organizational stakeholders (e.g., Communications, People, Finance), ensuring rapid but accurate data delivery without disrupting core engineering prioritiesAct as a key steward of data governance, prioritizing security and integrity in all activities, ensuring data access and usage comply with organizational policies and privacy standardsFully participate in all Agile Scrum events, including daily standups, sprint planning, sprint reviews, and retrospectives, ensuring data priorities and progress are transparent to the wider Technology teamDocument all final dashboard logic, data sources, and metric definitions clearly and concisely for stakeholder understanding and future maintenanceHandle confidential and sensitive strategic data and information with the utmost discretion and integrityDemonstrate fair, ethical, and equitable business practicesLearn eagerly, share knowledge appropriately, and improve continuouslyDemonstrate successful planning and problem-solving skills, including multitasking and working well within tight timelinesWork, communicate, and collaborate effectively with othersDemonstrate attention to detail and accuracy in all workDemonstrate a commitment to fostering and maintaining an environment of belongingOther relevant duties and responsibilities as assignedMinimum Qualifications:3+ years of professional experience in a blended role such as BI Developer, Analytics Engineer, or Data Engineer with a visualization focusProficiency in SQL: Demonstrated ability to write complex, performant, and well-structured SQL for data querying and transformationProficiency in Data Modeling: Strong understanding of data warehousing concepts and experience building analytical data modelsBI Tool Proficiency: Deep, professional experience with at least one major enterprise BI platform (e.g., Looker/LookerML, Tableau, Power BI)ETL/ELT Experience: Direct experience maintaining, troubleshooting, or contributing code to data pipelines (preferred experience with Python/Airflow/dbt or similar tools)Proven ability to translate business requirements into clear, efficient data visualizationsProficiency in spoken and written EnglishSalary Range$90,000 - $105,000 a yearWhy Trevor?Join a mission-driven organization where your work makes a real impact on the lives of LGBTQ+ young people—every single day.Outstanding benefits, including:Comprehensive health coverage, including plans that support various gender affirmation care needsMental health resources, with access to virtual care and a variety of in and out of network options for support403(b) retirement plan with a 3% employer match, vesting over three yearsGenerous paid time off and company holidays to rest and rechargeEmployee Assistance Program (EAP) offering confidential emotional support, work-life solutions, financial and legal guidance, and online resourcesRemote work flexibility from anywhere in the continental U.S., Alaska, or Hawaii- with provided technology, a home office setup reimbursement, and a monthly internet reimbursementThe 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.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.Apply for this job
