Lead Business Intelligence Analyst, Rover

• 6+ years of experience in Analytics or Analytics Engineering, with a specific focus on Marketing or Growth data
• Expert-level SQL proficiency. You don't just write queries; you write performant, readable code for complex data modeling, window functions, and heavy calculations within BI tools
• Deep understanding of Marketing Attribution logic. You have experience building, interpreting, or maintaining models that track user journeys across multiple touchpoints (Acquisition vs. Retention/Repeat)
• Experience with Data Modeling and creating "Gold Layer" datasets that allow other analysts and stakeholders to self-serve easily
• Strong knowledge of experimentation logic. You understand how to set up data structures to track control vs. variant groups and check for sample ratio mismatches
• Proven ability to manage technical projects from end-to-end, such as migrating reports between tools or auditing tracking setups
• Communication skills that allow you to translate complex data engineering concepts into benefits for non-technical marketing stakeholders

Desirable

• We're looking for a technically-minded Lead Analyst who loves the intersection of Data Modeling and Marketing Strategy
• You are someone who isn't satisfied with just "pulling numbers"—you want to understand and architect the underlying logic that makes those numbers true
• In this role, you will be the technical backbone of the Marketing Analytics team
• You will take ownership of our reporting infrastructure, driving the transition from legacy reports to clean, automated insights
• You will act as the bridge between raw data and advanced Data Science, ensuring our data models are robust enough to support rigorous analytics and experimentation
• You will also serve as the subject matter expert for one of our most complex domains: Attribution
• You will navigate our datasets to refine and maintain our logic—helping us distinguish between actions that lead to account creation versus those that drive repeat bookings—ensuring our Lifecycle and Acquisition stakeholders have a reliable view of their impact
• Own Marketing Attribution: Serve as the custodian of our attribution logic. You will maintain and refine our models to ensure the business understands how provider and owner strategies compound to drive New and Repeat bookings, constantly looking for ways to improve our measurement accuracy
• Architect the Reporting Suite: Tackle technical debt head-on by modernizing our reporting infrastructure. You will own the migration of critical business reports to our BI tools, designing clean, SQL-heavy calculations that serve as the "single source of truth" for Lifecycle Marketing and leadership
• Scale Experimentation Operations: Unblock the team on testing by operationalizing our experimentation framework. You will manage the transition to new tools (like Statsig), create SQL templates for test analysis, and conduct code reviews to ensure statistical rigor across the team
• Enable Advanced Analytics: Partner with our Data Scientists to perform Exploratory Data Analysis (EDA) and build robust data models. By ensuring our data foundation is solid, you will free up the team to focus on high-impact predictive modeling (LTV, Churn) and strategic deep dives