Lead Data Analyst, Operations, Quality
hims & hers
BigQuerySQL
Senior Data Analyst
Galileo
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $150,000 - $160,000 per year
Job Level
Senior
Tech Stack
ETLSQLTableau
About the role
- 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
Requirements
- 7+ years of SQL experience with complex datasets, including multi-table joins and query optimization
- 5+ years collaborating with stakeholders across Marketing, Operations, Product, and Customer Service functions
- 5+ years of digital product analytics experience with subscription/SaaS business models
- 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
Benefits
- Medical / Dental / Vision insurance
- Flexible Spending Account
- Health Savings Account + match
- Company paid STD/LTD, AD&D, and Life insurance
- Paid Family Leave
- 401K + match
- Paid Time Off
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdbtdata transformationquery optimizationdigital product analyticssubscription business modelsETLdata analysisbehavioral analyticsdata quality standards
Soft skills
collaborationstakeholder engagementcommunicationanalytical thinkingproblem-solvingattention to detailuser journey analysisfunnel analysisoptimization mindsetstrategic thinking
