Business Intelligence Lead
Top Benefits
About the role
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
- 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
What the job involves
- 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
- Reporting directly to the Head of Real Time Bidding, Thomas Boquet
- 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
Benefits
- Bonuses and equity opportunities
- Unlimited vacation time
- 100% employer-paid insurance for employee, 60% for dependents
- 401K plan
- Annual in-person retreats
About Trellis
Trellis Company is a mission-driven, nonprofit 501(c)(3) corporation that connects people to education-to-employment pathways that transform their lives. Our purpose is to develop and advance initiatives that grow individual economic mobility and expand community prosperity.
At Trellis, we actively promote diversity, equality, and belonging both at Trellis and throughout our family of companies. That extends to the relationships and interactions we have with our partners, our customers, and our community.
More About Trellis For more than 42 years, we have delivered positive outcomes for college students and higher ed institutions. We are now extending our commitment to the social good to reach a greater number of people and the communities where they live. Through our nationally recognized research services, specialized employee financial wellness programs, and workforce development collaboratives, we aim to increase individual economic mobility and expand community prosperity.
We build each other up to bring out the best in all of us.
Our Core Values • We do well by doing good • Our culture celebrates diversity, equity, and inclusion • We encourage exploration, experimentation, and innovation • Our work gives us fulfillment and purpose • We foster a sense of trust, servant leadership, and integrity • We succeed because we work together
Business Intelligence Lead
Top Benefits
About the role
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
- 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
What the job involves
- 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
- Reporting directly to the Head of Real Time Bidding, Thomas Boquet
- 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
Benefits
- Bonuses and equity opportunities
- Unlimited vacation time
- 100% employer-paid insurance for employee, 60% for dependents
- 401K plan
- Annual in-person retreats
About Trellis
Trellis Company is a mission-driven, nonprofit 501(c)(3) corporation that connects people to education-to-employment pathways that transform their lives. Our purpose is to develop and advance initiatives that grow individual economic mobility and expand community prosperity.
At Trellis, we actively promote diversity, equality, and belonging both at Trellis and throughout our family of companies. That extends to the relationships and interactions we have with our partners, our customers, and our community.
More About Trellis For more than 42 years, we have delivered positive outcomes for college students and higher ed institutions. We are now extending our commitment to the social good to reach a greater number of people and the communities where they live. Through our nationally recognized research services, specialized employee financial wellness programs, and workforce development collaboratives, we aim to increase individual economic mobility and expand community prosperity.
We build each other up to bring out the best in all of us.
Our Core Values • We do well by doing good • Our culture celebrates diversity, equity, and inclusion • We encourage exploration, experimentation, and innovation • Our work gives us fulfillment and purpose • We foster a sense of trust, servant leadership, and integrity • We succeed because we work together