Note: The job is a remote job and is open to candidates in USA. Trellis is a technology company focused on improving the insurance shopping experience through its insurance marketplace and licensed agency. The Principal Product Analyst will own product and provider analytics, analyze the full user funnel, build trusted self-service reporting, investigate data issues, and strengthen the analytics layer for internal teams and external partners.
Responsibilities
- Drive & Democratize Product Analytics: Analyze user behavior across the full marketplace funnel, from traffic acquisition and quoting through carrier placement and retention, to identify opportunities and quantify the impact of product changes. Create reusable analysis frameworks that will allow colleagues to perform their own analyses
- Own Provider Analytics: Partner with our Provider Engineering team to successfully launch new monetization partners (i.e., insurance companies that pay us for generating policies for them). Serve as the trusted expert and owner of provider data, including revenue, policy retention, and compensation structures
- Build Trusted, Self-Serve Reporting: Develop and maintain Looker dashboards and partner-facing reporting that executives and external partners rely on
- Investigate Data Questions End-to-End: Root-cause anomalies and reconcile discrepancies anywhere from raw event data to the modeled analytics layer and communicate findings crisply to technical and non-technical audiences
- Strengthen the Analytics Layer: Contribute well-tested SQL, metric definitions, and documentation back into our analytics codebase (LookML) so insights become durable assets rather than one-off answers
Skills
- 5+ years of analytics experience, including 3+ years in product or marketplace analytics, with a track record of proactive analysis that delivered measurable impact
- Expert-level SQL skills, including the ability to write efficient, production-grade queries against large cloud data warehouses
- Strong BI and dashboarding experience, with a track record of building reporting used by executives and external partners
- Demonstrated ability to operate autonomously, take ownership of unowned problems, and follow through in a fast-paced environment
- Clear, concise, and professional written and verbal communication skills, with the ability to drive internal alignment and manage external partner relationships
- Experience with BigQuery, Looker, or dbt
- Experience in marketplace, ad tech, or insurtech environments
- Experience incorporating AI tools into analytics workflows
Benefits
- Fully remote across the US & Canada
- Quarterly virtual and/or in-person events that keep us connected
- Flexible vacation (yes, actually flexible)
- Health insurance starts day one
- Wellness programming
- 401(k) and HSA contributions
- FSAs
- Bonuses
- Equity opportunities
- Paid parental leave
Company Overview
Company H1B Sponsorship