Apply on Employer Site

The Trevor Project · 14 hours ago

Business Intelligence (BI) Developer

United States

Full-time

Remote

Mid Level

$90K/yr - $105K/yr

3+ years exp

The Trevor Project is the leading suicide prevention and crisis intervention organization for LGBTQ+ young people. The Business Intelligence (BI) Developer is responsible for transforming data into actionable insights and managing the organization's data visualization and reporting platform.

LGBTNon ProfitWellness

No H1B

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 reports

Architect, develop, and maintain high-impact, scalable, and secure production dashboards and reports for internal operations and external impact reporting

Manage 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 policies

Work 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 report

Accountable 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 processes

Optimize the performance of complex dashboards and reports by refining underlying SQL queries and utilizing BI tool best practices

Serve 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 management

Identify and troubleshoot data integrity issues or data pipeline defects that affect reporting accuracy

Efficiently 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 priorities

Act 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 standards

Fully 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 team

Document all final dashboard logic, data sources, and metric definitions clearly and concisely for stakeholder understanding and future maintenance

Handle confidential and sensitive strategic data and information with the utmost discretion and integrity

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

Qualification

SQLData ModelingBI Tool ProficiencyETL/ELT ExperienceData VisualizationEnglish ProficiencyProblem-SolvingAttention to DetailCollaboration

Required

3+ years of professional experience in a blended role such as BI Developer, Analytics Engineer, or Data Engineer with a visualization focus

Proficiency in SQL: Demonstrated ability to write complex, performant, and well-structured SQL for data querying and transformation

Proficiency in Data Modeling: Strong understanding of data warehousing concepts and experience building analytical data models

BI 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 visualizations

Proficiency in spoken and written English

Benefits

Comprehensive health coverage, including plans that support various gender affirmation care needs

Mental health resources, with access to virtual care and a variety of in and out of network options for support

403(b) retirement plan with a 3% employer match, vesting over three years

Generous paid time off and company holidays to rest and recharge

Employee Assistance Program (EAP) offering confidential emotional support, work-life solutions, financial and legal guidance, and online resources

Remote work flexibility from anywhere in the continental U.S., Alaska, or Hawaii- with provided technology, a home office setup reimbursement, and a monthly internet reimbursement