Business Intelligence Lead
Trellis is a profitable, fast-growing Series A startup backed by General Catalyst, QED, NYCA, and Amex Ventures. We’re reimagining how people shop for home and auto insurance, using smart technology to make something historically painful feel refreshingly easy.
Every day, we help people save time, money, and unnecessary headaches. Behind the scenes, our fully remote team moves fast, owns their craft, and builds products that genuinely make life better.
Led by a three-time fintech founder with a proven track record of going big, we’re building something special, and we’re just getting started.
If you’re hungry to make an impact and love solving complex problems with a scrappy crew, you’ll love it 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.
Why Trellis? Because life’s too short for boring jobs.
We’re a team of builders, dreamers, and doers reshaping an industry that touches every household in America. At Trellis, you’ll have real ownership, meaningful impact, and the chance to grow alongside a company that’s scaling fast.
Here’s what makes Trellis an incredible place to build your career:
-
✨ A flat, transparent culture where your voice actually matters
-
🚀 Ground-floor opportunity with room to stretch and grow
-
💰 Compensation at the 75th+ percentile
-
🏡 100% remote... work from wherever you do your best thinking (In the US or Canada, that is)
-
🎉 Quarterly team events that keep our fully remote culture connected and fun
And yes, the perks are pretty great too:
-
🌴 Flexible vacation (seriously, we want you to take it)
-
🩺 100% employer-paid health insurance for employees (65% for dependents)
-
💻 Home office budget to set up your perfect workspace
- 🧘🏼♂️ Wellness events throughout the year, because we believe in investing in the full human, not just the employee
-
💸 Automatic 401(k) contribution, FSAs, bonuses, and equity opportunities to invest in your future
- 🐣 Paid parental leave
👉 If you’re looking for a place where you can do the best work of your career, while building something that actually matters, we’d love to meet you.
Create a Job Alert
Interested in building your career at Trellis? Get future opportunities sent straight to your email.
Apply for this job
*
indicates a required field