Lead Analytics Engineer

Obsidian Security, Inc.
Palo Alto, CA, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Compensation
$219,000.0 - $240,000.0
Working hours
Regular working hours
Job source

Tech stack

Sql Data Warehouse Legacy Database Application Programming Interfaces (APIs) Artificial Intelligence Airflow Data Analysis Automation of Tests BigQuery Business Systems Continuous Integration Information Engineering Extract Transform Load (ETL)
+12 more
Data Warehousing Cursor (Graphical User Interface Elements) Dimensional Modeling Python (Programming Language) Salesforce.Com SQL Databases Data Streaming Snowflake Zapier Marketo Virtual Agents Databricks

Job description

We’re hiring a Lead Analytics Engineer to be the senior technical owner of Obsidian’s data warehouse and analytics foundation. You will own the DBT project, the warehouse architecture, and the semantic layer that every executive dashboard, GTM workflow, and internal AI agent will rely on. You will also help lead our use of AI in how we build, using modern AI coding tools to ship dbt models, automated workflows, and reporting pipelines at a pace a small team alone could not.

We are looking for a Senior Technical owner to set the bar for mart design, documentation, AI-augmented development, and for how data flows from our systems of record into the reports and workflows that run the business.

You will report directly to the VP of Business Systems, Data & IT. You will partner closely with Product, Sales, CS, Finance, Marketing, and Security, and you will collaborate with teammates across the Business Systems, Data & IT function.

What You’ll Do

Own the analytics foundation

  • Build and own the dbt project end-to-end - mart architecture, modeling conventions, materialization patterns, testing, lineage, documentation.
  • Design dimensional models that serve both human dashboards and downstream AI agents with equal rigor.
  • Stand up CI/CD discipline on the dbt project, including PR review, automated testing, and deployment workflows.

Build the pipelines and the warehouse

  • Own Fivetran ingestion across our GTM, finance, HR, and operational sources.
  • Design and operate reverse-ETL pipelines that move trusted data from the warehouse back into systems of record.
  • Migrate existing reports from our legacy database onto the new BigQuery foundation without breaking continuity.

Use AI to ship more, faster

  • Build with AI coding tools (Claude, Cursor, Codex, and similar) as part of your daily workflow, and set the team standard for AI-augmented analytics engineering.
  • Design schemas, documentation, and semantic conventions specifically with downstream AI agents in mind - context-rich, well-named, unambiguously documented.
  • Build automated workflows on top of the warehouse: cost aggregation across vendor APIs, automated executive reporting deliveries, automatic field updates from call intelligence into CRM, and similar.

Raise the bar across the team

  • Set technical standards for the data function, mentor and uplevel teammates, and establish conventions that scale beyond your own hands.

Requirements

Do you have experience in Schema design?, * 8+ years building analytics or data engineering systems in production, with deep, hands-on dbt experience. You have owned a DBT project, not just contributed to one.

  • Strong business fluency in B2B SaaS, and an instinct to start from the process, not the metric. You understand the upstream GTM, billing, and customer-lifecycle workflows that generate ARR, NRR, churn, CAC, gross margin, pipeline conversion, and deal velocity.
  • You can take a finance or RevOps question, walk the process it lives in, and translate it into the right data model. You know that the upstream process matters at least as much as the model that reports on it.
  • Expert SQL and dimensional modeling. You can defend a modeling decision in a paragraph, and you have opinions about incremental materialization.
  • Production experience with a cloud data warehouse (BigQuery preferred; Snowflake, Redshift, or Databricks transferable) and a managed ELT platform (Fivetran preferred).
  • Demonstrated daily use of AI coding tools to ship real work - not as a curiosity, but as a tool you have used to deliver production output.
  • Strong written and verbal communication. You can explain a data model decision to an engineer and a stakeholder with equal clarity.

Preferred

  • Python for ingestion, automation, and integration work.
  • Workflow automation experience on Workato, Airflow, or a similar platform.
  • Reverse-ETL experience on Census, Hightouch, or equivalent.
  • Hands-on familiarity with the GTM data stack (Salesforce, Marketo, Gong, or similar).
  • Experience in standing up an analytics warehouse from a greenfield state.
  • Experience working on a Business Systems, Revenue Operations, or similar internal ops team, with direct exposure to the processes that generate the data.
  • Experience operationalizing customer-data separation in a warehouse (mart access policies, anonymization pathways, privacy-aligned PII handling).
  • B2B SaaS or cybersecurity domain background.

About the company

Founded in 2017, Obsidian Security was created to close a critical gap: securing the SaaS applications where modern business happens-platforms like Microsoft 365, Salesforce, and hundreds more. Backed by top investors including Greylock, Norwest Venture Partners, and IVP, we’ve built a complete SaaS security platform to reduce risk, detect and respond to threats, and prevent breaches at the source. Our team includes leaders who helped define the categories of endpoint and identity security at CrowdStrike, Okta, Cylance, and Carbon Black. Now, we’re transforming how SaaS is secured-in the era of agentic AI. Today, Obsidian is trusted by global enterprises like Snowflake, T-Mobile, and Pure Storage. We protect more than 200 organizations across North America, Europe, the Middle East, Southeast Asia, Australia, and New Zealand-including many of the world’s largest Fortune 1000 and Global 2000 companies. With strong global momentum, a growing partner ecosystem including SentinelOne, Databricks, and Google Cloud, and a major fundraise on the horizon, we’re scaling quickly toward long-term growth and IPO readiness. Join us as we define the future of SaaS security!

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:15 min

Empowering domain teams with an open data platform

Sandhya Menon Sandhya Menon · WWC Europe 2026

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:20 min

Drawing inspiration from Zapier for programmatic SEO

Dino Lozina · WWC 2022

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

5:36 min

Connecting workflows with spreadsheets and API integrations

José Kadlec José Kadlec · WWC 2025

3:05 min

Audience questions on AI agents and pipeline vectorization

Joy Joy · WWC 2024

Videos

See all

Related articles

See all