Staff Analytics Engineer

New
M
Modern HealthMental health benefits
Location: Remote - US, US based team members who live outside the Pacific time zone are expected to work at least six hours between 8 am and 5 pm Pacific time each workday.Full-TimeStaff
Salary136,595 - 189,000 USD per year
Apply NowOpens the employer's application page

Job Details

Experience
8+ years in analytics engineering, product analytics, or data engineering roles with substantial hands-on modeling experience.
Required Skills
SQLGitSnowflakeData modelingdbtLooker

Requirements

  • Have 8+ years of experience in analytics engineering, product analytics, or data engineering, including substantial hands-on modeling.
  • Bring expert SQL skills and production dbt experience, including incremental models, tests, documentation, CI, and performance at Snowflake-scale event volume.
  • Have hands-on experience designing product event instrumentation using Mixpanel, Amplitude, Segment, or an equivalent.
  • Have experience modeling data through a backend service or schema migration while maintaining continuous downstream reporting.
  • Have semantic-layer modeling experience with Snowflake Semantic Views, LookML, dbt Semantic Layer, or similar.
  • Be able to shape feature measurement in product syncs and explain tradeoffs to product managers and engineers.
  • Be comfortable learning unfamiliar business areas and delivering without close direction.
  • Have experience with Git-based workflows and code review, and be comfortable reading application code to understand source data.
  • Have experience mentoring analysts or engineers.

Responsibilities

  • Build and review dbt models, tests, documentation, legacy-table deprecation, and Looker Explores; establish modeling conventions.
  • Lead analytics work for backend service migrations by reviewing schemas and RFCs, defining Snowflake data needs, planning models, and maintaining reporting through cutover.
  • Maintain the Mixpanel event lexicon, write tracking requirements, quality-check shipped events, and build dbt models integrating Mixpanel and Iterable data into governed Looker reporting.
  • Partner with Product and Engineering to shape measurement and tracking before development and deliver launch reporting on governed marts.
  • Maintain certified metric definitions in the semantic layer, complete dbt documentation, and generated documentation and context for agents and Glean.
  • Drive the staging layer, data quality tests, and CI enforcement in the dbt repository, partnering with Data Engineering on ingestion and platform work.
  • Build and formalize AI-assisted development workflows and use them as the team's default approach.
  • Share ad-hoc intake and on-call duties and handle analysis and reporting requests beyond modeling.
  • Mentor the team on data modeling and SQL.
View Full Description & ApplyYou'll be redirected to the employer's site
136,595 - 189,000 USD per year
Apply Now