Senior Analytics Platform Engineer
Posted Updated
Description
- Ingestion & Pipelines
- Build and operate reliable pipelines that land data from production databases (CDC), SaaS tools, and third-party APIs into Snowflake
- Orchestrate batch and incremental workloads in Airflow, choosing the right load pattern (full, incremental, CDC) for each source
- Onboard new sources quickly and repeatably, with clear contracts for schema, freshness, and ownership
- Modeling & Serving
- Design and own the core dbt models (merchants, orders, payments, revenue, and product usage) that downstream teams build on
- Unify data across platforms and product lines (e.g., legacy and next-generation POS) into consistent, well-documented models so users never have to reason about where the data came from
- Build curated, analysis-ready marts for finance and product analytics, and enable self-serve for power users through clean semantics and documentation
- Write reusable macros and conventions that keep a growing dbt project consistent and maintainable
- Data Quality, Monitoring & Job Health
- Define and enforce data tests (uniqueness, nulls, referential integrity, metric reconciliation) as a first-class part of every model
- Own monitoring and alerting for pipeline health, freshness, and volume anomalies; respond to incidents, run root-cause analysis, and fix the underlying problem
- Reconcile financial data (processing volume, fees, revenue, billing) against source systems so finance can trust the numbers
- Performance & Cost
- Tune Snowflake and dbt workloads, incremental strategies, clustering, materialization choices, and warehouse sizing to keep models fast and costs predictable
- Monitor platform spend and usage and recommend changes that pay for themselves
- Partnership & Leadership
- Partner with analysts, finance, product, and engineering teams to translate ambiguous business questions into durable data products
- Raise the bar on SQL, modeling, and testing practices through code review, documentation, and mentorship
- Use AI-assisted development tools thoughtfully to move faster, while reviewing their output with the same rigor you’d apply to anyone else’s code
- What Success Looks Like
- First 90 days: You own a slice of the pipeline end to end, have shipped improvements to core models, and are a trusted responder when jobs fail
- First 6-12 months: Core models are better tested and faster, data incidents are caught before stakeholders notice, and Finance and Product teams self-serve on models you designed
Benefits
- Medical, Dental and Vision Insurance
- Paid vacation, 11 company holidays, sick time, and volunteer time off
- 401k with company match
- Stock Options
- Subscription to Linkedin Learning to expand your knowledge on all kinds of fun topics
- Employee Resource Groups for Diversity and Inclusion, Women, LGBTQIA+, and other communities
- Monthly cell phone and internet stipend
- Desk, Chair and Monitor needed for your home office? We got you
- Tuition reimbursement for up to 2k per calendar year to assist with classes of your choice
- Headspace membership for guided meditation and stress relieving tools through the Sequoia App
- Unlimited access to virtual audio and visual workouts through the Sequoia App
- Expert SQL: complex joins, window functions, incremental logic, and query performance tuning
- Experience supporting product analytics (event data, funnels, adoption, retention) and/or financial analytics (revenue, payments, reconciliation)
- Deep hands-on experience with dbt (models, tests, macros, incremental materializations, documentation) and Snowflake (or a comparable cloud warehouse)
- Strong data modeling fundamentals: dimensional modeling, grain, slowly changing dimensions, and designing models for many downstream consumers
- A testing mindset: you build data quality checks in from the start and know when a number is right and when it needs a second look
- 5+ years of experience in data engineering, analytics engineering, or a closely related role
- Experience building and operating production pipelines with orchestration (Airflow or similar), including monitoring, alerting, and on-call ownership
- Strong Python for pipeline development, automation, and tooling
- Clear communication with both technical and non-technical stakeholders
- Experience in payments, fintech, POS, or SaaS businesses
- CDC and streaming ingestion (e.g., Debezium, Kafka, Streamkap) or modern ingestion frameworks (e.g., dlt, Fivetran)
- Unifying data across platform migrations or multiple product backends
- Snowflake administration: RBAC, cost governance, warehouse management
- Data observability tools, CI/CD for dbt, and infrastructure as code
- Experience enabling BI and semantic layers (e.g., Metabase, Looker, dbt Semantic Layer) or AI/agent access to warehouse data
Skills
Sign in to read and join the discussion.