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