Senior Data Analyst

Envoy; San Francisco (CA); On-site; USD 150,000 - 210,000; Full time

Job summary

Envoy is seeking a senior Analytics Engineer to own the marketing data platform on AWS, building end-to-end data products that power pipeline and revenue decisions. You will work closely with Marketing, RevOps and Data teams to ship production-grade pipelines and robust attribution models.

The role emphasizes hands-on SQL, dbt, Python and reverse ETL, with on-site work at the San Francisco HQ. You will influence decision-making through rigorous analysis and clear storytelling.

Qualifications

• 5+ years in analytics with 2+ focused on marketing analytics at a B2B SaaS company.
• Expert SQL: window functions, CTEs, performance on columnar warehouses.
• Production dbt: layered models, tests, CI/CD.
• Fluency in Python for analysis (pandas, statsmodels).
• Deep familiarity with Salesforce, Marketo/HubSpot, Segment or similar.
• Attribution knowledge and funnel analysis familiarity.
• Git, PRs, and command line proficiency.
• Ability to explain model assumptions to non-technical stakeholders.

Responsibilities

• Own the marketing data platform on AWS and run pipelines across Redshift, S3, Glue, Lambda and Iceberg with Terraform and GitHub Actions.
• Model the funnel in dbt and ship staged models for leads to opportunities and revenue.
• Build multi-touch attribution across channels and expose results via APIs.
• Develop internal apps and lightweight tools for marketing teams with AWS Amplify and API Gateway.
• Establish data quality with tests, CI, and monitoring to prevent broken pipelines.

Skills

5+ years analytics

Expert SQL

dbt production

Python for analysis

Marketing data fluency

Attribution methods

Git & CLI

Influence decisions

Tools

Redshift

S3

AWS

Airflow

Job description

Envoy protects the places the world relies on most by unifying people, spaces, and communications in one secure, integrated workplace management platform and ecosystem. More than 16,000 workplaces around the world trust Envoy to run secure, compliant, and connected operations across every location.

From manufacturing sites and data centers to pharmaceutical labs, healthcare facilities, and corporate headquarters, Envoy makes safety, security and associated regulatory compliance something our customers can be proud of. The industry is littered with box-checking and arcane manual processes as the standard and we see our role as the company to bring experience, efficiency and simplicity everywhere. Great experiences bring great security – it's a requirement. We hope this problem space excites you and we hope you're ready to come sweat the details with us – we have a lot of customers counting on us! And it certainly won't be easy.

Learn more at envoy.com

About the role

Marketing at Envoy runs on a mix of product-led signups, inbound demand and outbound motions across several products. You'll be the person who tells us which of those actually create pipeline and revenue — and you'll build the data foundation that makes the answer trustworthy.

This is a hands-on, technical role. You'll write production SQL and dbt models, not just query tables someone else built. You'll sit with Marketing and RevOps leadership as their analytical partner, and with the Data team as a builder who ships to the warehouse.

This is an onsite position that requires at least 5 days a week (Monday - Friday) in our San Francisco HQ office.

You will

You’ll work like a forward-deployed engineer embedded in Marketing: sit with the team, find the problem, and ship the data product that solves it — on AWS, in production, end to end.

• Own the marketing data platform on AWS. Build and run marketing pipelines across Redshift, S3, Glue, Lambda and Iceberg tables, with infrastructure defined in Terraform and deployed through GitHub Actions.

• Model the funnel in dbt. Ship tested staging, intermediate and mart models for lead → MQL → SQL → opportunity → closed-won, plus semantic models others self-serve from.

• Build attribution as a product. Design multi-touch attribution across web, paid, events, email and outbound, run it as scheduled jobs in Airflow, and expose it through governed tables and APIs.

• Ship internal apps, not just dashboards. Build lightweight tools Marketing uses daily — campaign ROI explorers, lead-routing consoles, self-serve query apps — on AWS Amplify, Lambda and API Gateway with Cognito/Okta auth.

• Build serverless data APIs. Expose warehouse metrics to apps, Slack and AI agents through Lambda-backed endpoints and MCP servers, with least-privilege IAM.

• Close the loop with reverse ETL. Sync scores, segments and product signals from the warehouse back into Salesforce, Marketo and Outreach so Sales and Marketing act on them.

• Engineer the event lake. Join Segment product events in S3/Iceberg to CRM records to measure product-qualified leads and PLG conversion at scale.

• Build lead scoring and intent models. Turn product usage, firmographic and job-change signals into scores in Python or Databricks, then deploy and monitor them in production.

• Run experiments and measure spend. Design A/B and holdout tests, and report CAC, payback and channel ROI with Finance.

• Use AI to move faster. Build with Claude Code and LLM tooling to prototype apps, generate models and automate analysis, with the rigor to verify the output.

• Keep it reliable. Own source freshness, data tests, CI checks, cost and monitoring so a broken pipeline never reaches a board deck.

You have

• 5+ years in analytics, with at least 2 focused on marketing, growth or go-to-market analytics at a B2B SaaS company.

• Expert SQL: window functions, CTE-first style, query performance on a columnar warehouse (Redshift, Snowflake or BigQuery), and the judgment to spot a fan-out join before it reaches a dashboard.

• Production dbt experience: you've built layered models, written tests, and shipped through code review and CI.

• Fluency in Python for analysis and statistics (pandas, statsmodels or similar), including experiment design and causal inference basics.

• Deep familiarity with marketing and sales data: Salesforce objects (leads, contacts, campaigns, opportunities), marketing automation (Marketo or HubSpot), web and product event tracking (Segment or similar).

• Working knowledge of attribution approaches and their trade-offs, plus funnel and cohort analysis.

• Comfort with Git, pull requests and the command line.

• A track record of influencing decisions: you can explain a model's assumptions to a CMO in two sentences and defend them under questioning.

Nice to have

• Experience with Airflow or another orchestrator, and with ingestion tools such as Fivetran or Estuary.

• Semantic layer or metrics-layer experience (dbt Semantic Layer, Omni, Looker).

• Data lake experience: Iceberg, Spectrum, Athena or Spark.

• Lead scoring, propensity or marketing-mix modeling.

• Exposure to sales engagement and revenue intelligence data (Outreach, Gong) or job-change signals.

• Experience using LLMs and AI tools to speed up analytics work, with the rigor to check their output.