Founding Product Analyst (all)

XO Life

15d•Remote

About The Position

We are looking for a Founding Product Analyst to help build a true self-serve analytics layer on top of our rich data lake. This role involves pulling numbers, validating changes, reconciling conflicting logic, and explaining metric discrepancies across reports. As our Product Analytics Lead, you will be the dedicated owner building this foundation, working across Snowflake, Superset, Python, APIs, and Google Sheets to make product data more accessible, trustworthy, and usable. This includes improving the underlying processing layer and maintaining critical reporting for products, investors, clients, and internal use. This is a hands-on individual contributor role, balancing day-to-day requests, recurring reporting, tracking design, and infrastructure work to move towards a more scalable and trusted analytics setup.

Requirements

5+ years of experience in product analytics, data analytics, or a similar hands-on role.
Strong working knowledge of SQL and Snowflake or a similar cloud warehouse environment.
Experience building intermediate processing tables, reusable data models, or data marts for downstream analytics.
Strong BI experience, ideally with Superset, and/or tools such as Tableau, Looker, or Power BI.
Comfortable with basic scripting in Python for analytics tasks, including pandas, JSON handling, simple scripts, and API-based data pulls.
Experience designing and maintaining product tracking for features, events, properties, funnels, and retention metrics.
Ability to debug broken reporting logic when schemas, instrumentation, or source systems change.
Experience handling recurring reporting and keeping important reporting streams operational under imperfect conditions.
Comfort using Google Sheets as a stakeholder-facing output surface when needed, even if it is not the ideal long-term solution.
Strong understanding of product metrics such as feature usage, engagement, drop-off, funnels, cohorts, and retention.
Strong communication and judgment: you can clarify ambiguous requests, align on definitions, and explain trade-offs clearly.
Comfortable as a solo IC in a startup environment, including being a temporary bottleneck for important reporting while building better structure.
Must have the legal right to live and work in the European Union (EU).

Nice To Haves

Experience with Amplitude, Mixpanel, PostHog, or similar product analytics tools.
Experience with version-controlling reporting queries and scripts in Git or a similar workflow.
Familiarity with data ingestion flows, pipeline monitoring, or being able to inspect how data gets into the warehouse when something breaks.
Experience in GDPR-sensitive or regulated environments, ideally health-related.
Experience automating client-facing or external reporting across repeated reporting cycles.

Responsibilities

Own product analytics infrastructure across the current stack: Snowflake, Superset, lightweight Python workflows, APIs, and Google Sheets.
Build and extend the processing layer in Snowflake so downstream reporting and analysis become simpler, more reusable, and less fragile.
Create self-serve analytics for Product and business stakeholders despite imperfect tooling, especially in Superset.
Design tracking for new features by defining events, properties, and measurement requirements together with Product and Engineering.
Maintain and update tracking and downstream reporting when product changes, schemas shift, or old logic breaks.
Reconcile conflicting numbers across tools, reports, and source logic and create clearer metric definitions that stakeholders can trust.
Own recurring reporting flows including product reporting, internal reporting, investor reporting, and client-facing reports/dashboards.
Automate manual reporting work wherever possible, while being pragmatic about stakeholder needs, including outputs in Google Sheets or other non-standard formats.
Run ad-hoc investigations and special analyses when dashboards are not enough, including pulling data from alternative sources or APIs when needed.
Document the existing analytics and reporting setup so knowledge is not trapped in one person’s head.
Identify tracking, schema, and instrumentation gaps proactively and work with Engineering to reduce reporting breakage over time.
Help shape the next generation of the stack, including evaluating and leading the rollout of a modern product analytics platform such as Amplitude.