Business Intelligence Lead

Trellis; Myrtle Point (OR); Remote; USD 195,000 - 205,000; Full time

Job summary

A fast-growing fintech startup is seeking a Business Intelligence (BI) Lead to oversee analytics efforts and enhance decision-making through data insights. This fully remote role offers a salary range of $195,000 to $205,000 annually, along with benefits like unlimited vacation and comprehensive health insurance.

Benefits

Unlimited vacation time

100% employer-paid health insurance

Fun team bonding events

Budget for home office equipment

Qualifications

• 7+ years in BI or analytics roles; 2+ years in a leadership position preferred.
• Strong SQL skills and experience with modern data warehouses.
• Hands-on experience with dbt for data modeling and transformation.

Responsibilities

• Lead the BI function, mentoring the team and establishing best practices.
• Build and oversee dashboards and reporting for campaign performance monitoring.
• Provide strategic insights on advertising campaign effectiveness.

Skills

SQL skills

Communication skills

Digital advertising knowledge

Data modeling with dbt

Experience with BI tools

Tools

Looker

BigQuery

Tableau

Job description

Overview

Trellis is a profitable, fast-growing Series A startup backed by top investors like General Catalyst, QED, NYCA, and Amex Ventures.

Our mission: make shopping for home and auto insurance faster, smarter, and easier for everyday Americans. Powered by ML and GenAI, we help people find better insurance — saving them time, money, and stress.

We’re fully remote, built for speed, and led by a third-time fintech founder with a track record of building public companies.

If you move fast, take ownership, and care about your craft, you’ll thrive here.

Position Overview

Trellis is hiring a Business Intelligence (BI) Lead to lead our analytics efforts across real-time bidding and advertising campaign performance. You will own the full BI stack including dashboarding and reporting (Looker, LookML) and fluent in the modern data stack (DBT, BigQuery) - while managing a growing BI function. In this role, you’ll both build and oversee high-impact analytics, and partner with executives to ensure our teams have the insights needed to optimize ROI and scale intelligently.

This is a fully remote position, based in the US or Canada, reporting directly to the Head of Real Time Bidding, Thomas Boquet.

We believe in paying competitively for great work. As a remote team, we set our salaries at the 75th percentile of national market data in our industry. You can count on your pay being in line with (or above) the market. For this role, the base salary range is $195,000 – $205,000. We review compensation twice a year to make sure we’re staying competitive and rewarding our team’s contributions.

Who You Are

• Meticulous: You pay attention to detail and take pride in what you deliver
• Articulate: You succinctly and effectively communicate verbal and written technical and non-technical ideas and topics
• Kind, not (just) nice: You provide tough feedback in a clear and concise manner that does not diminish or belittle the recipient
• Opinionated: You bring strong opinions to discussions but are willing to change your mind when presented with new or better information
• Product-minded: You focus on the “why” just as much as the “what” or “how”
• Collaborative: You work within your team and cross-functionally to build consensus and achieve results
• Autonomous: You are self-motivated, able to hold yourself accountable, and can generate high-value work with little direct supervision

What You’ll Do

• Lead the BI function, mentoring the team and establishing best practices in data modeling, transformation, and visualization.
• Help on the development and maintenance of BI models using DBT and SQL, ensuring accuracy and scalability.
• Build and oversee dashboards and reporting in Looker (LookML) or Tableau for campaign performance monitoring.
• Partner with engineering and ML teams to define datasets and metrics optimized for analytics.
• Provide strategic insights to leadership on advertising campaign effectiveness and RTB system performance.
• Champion self-serve analytics by building intuitive and scalable BI tools for stakeholders.

What You’ll Need

While you don’t need all of these to be successful in this role, we think you’ll be more successful the more you have

• 7+ years of experience in BI or analytics roles, with a preference for 2+ years in a management or lead position.
• Strong SQL skills and experience with BigQuery or other modern data warehouses.
• Proficiency with BI tools: Looker (LookML), Tableau, or similar.
• Hands-on experience with dbt for data modeling and transformation.
• Background in digital advertising, performance marketing, or related domains strongly preferred.
• Excellent communication and storytelling skills, with a track record of influencing business decisions through data.

Compensation and Benefits

Trellis is a fantastic place to work

Join a talented, passionate team:

• Flat, collaborative, transparent culture; get in at the ground floor and be a true business partner
• Opportunities for growth and development within your role and all areas of the organization
• 75th-percentile (competitive!) compensation
• 100% remote work environment
• Quarterly, fun team bonding events

Trellis additionally offers competitive benefits:

• Unlimited vacation time
• 100% employer-paid Platinum-tier health insurance for employee, 65% for dependents
• Flexible Spending Accounts (FSAs)
• 401(k) retirement savings plan
• Bonuses and equity opportunities
• Budget for home office equipment