Galileo is looking to improve the quality and affordability of health care by leveraging data-driven decision-making across its product ecosystem. The Senior Data Analyst will build the analytical infrastructure to provide insights for various teams, directly impacting user understanding and healthcare journey improvement.
Requirements
- 7+ years of SQL experience with complex datasets, including multi-table joins and query optimization
- Proven expertise with dbt for building and maintaining data transformation pipelines
- Hands-on experience with Looker, Tableau, or similar BI platforms
- Track record of partnering with engineering teams and understanding technical documentation (PRDs, TDDs)
- Experience with ETL tools like Fivetran and modern data stack technologies
- 5+ years of digital product analytics experience with subscription/SaaS business models
Responsibilities
- Build and maintain dbt data marts that transform raw user data into actionable utilization profiles and behavioral segments
- Create and optimize Looker dashboards that become the daily source of truth for 20+ stakeholders across 4+ departments
- Partner with Product Engineering teams to implement comprehensive event tracking and behavioral analytics
- Deliver subscription and retention analyses that directly inform product strategy and revenue forecasting
- Reduce dashboard load times and query performance by 20%+ through systematic optimization
- Conduct deep-dive user journey and funnel analyses that identify friction points and improvement opportunities
- Maintain impeccable data quality standards while building self-service analytics capabilities for non-technical users
Other
- 5+ years collaborating with stakeholders across Marketing, Operations, Product, and Customer Service functions
