Business Intelligence Lead

Trellis Company

full-time

Posted on: 9/29/2025

Location Type: Remote

Location: Remote • 🇺🇸 United States

✨ AI Apply

💰 $195,000 - $205,000 per year

Senior

BigQuerySQLTableau

About the role

Lead the BI function, mentoring the team and establishing best practices in data modeling, transformation, and visualization
Own the full BI stack across real-time bidding and advertising campaign performance
Develop and maintain 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
Report to the Head of Real Time Bidding and collaborate with executives to optimize ROI and scale

7+ years of experience in BI or analytics roles (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 or performance marketing preferred
Excellent communication and storytelling skills with a track record of influencing business decisions
Based in the US or Canada (fully remote position)

Benefits

75th-percentile (competitive!) compensation
100% remote work environment
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
Quarterly team bonding events
Opportunities for growth and development