Obsidian Security

Lead Analytics Engineer

Obsidian Security$219K — $240K *
Enterprise Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of experience in production analytics or data engineering systems, with substantial dbt ownership experience.
  • Strong B2B SaaS business understanding, particularly in relation to GTM, billing, and customer lifecycle metrics.
  • Ability to translate finance and RevOps questions into appropriate data models, starting with process understanding.
  • Expertise in SQL and dimensional modeling, with strong opinions on modeling decisions.
  • Experience with cloud data warehouses, especially BigQuery, and managed ELT platforms like Fivetran.
  • Daily practical use of AI coding tools for production work, showcasing real delivery impact.
  • Excellent verbal and written communication skills, able to articulate technical decisions to diverse audiences.

Responsibilities

  • Lead the complete dbt project, focusing on architecture, modeling standards, and documentation.
  • Develop dimensional models tailored for both human consumption and AI systems.
  • Establish CI/CD workflows to enhance dbt project's testing and deployment processes.
  • Oversee Fivetran data ingestion from multiple operational sources.
  • Create and manage reverse-ETL pipelines to integrate analytics back into core systems.
  • Migrate legacy reports to BigQuery seamlessly, ensuring business continuity.
  • Integrate AI tools into regular workflows to enhance analytics and reporting capabilities.

Benefits

  • Competitive compensation with equity and 401k options.
  • Comprehensive healthcare plans including dental and vision coverage.
  • Flexible paid time off along with paid holidays.
  • 12 weeks of new parent or family leave for employees.
  • Resources for personal and professional development.
Full Job Description
About the Role

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.
What You'll Bring

Requirements
  • 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.


Employee Benefits

Our competitive benefits packages are designed to support our employees' well-being, both at work and at home. Our US based employees enjoy:
  • Competitive compensation with equity and 401k
  • Comprehensive healthcare with dental and vision coverage
  • Flexible paid time off and paid holiday time off
  • 12 weeks of new parent or family leave
  • Personal and professional development resources

For more details on our US benefits, or for information on our international benefits, please see here.

Pay Transparancy

Please note that the base pay range is a guideline and for candidates who receive an offer, the base pay will vary based on factors such as work location, as well as the knowledge, skills and experience of the candidate. In addition to a competitive base salary, this position is eligible for equity awards and may be eligible for sales commission or incentive compensation based on the role or function within the company.

Base Salary Range

$219,000-$240,000 USD

About Obsidian Security

Obsidian Security is a cybersecurity company that provides cloud detection and response solutions. The company's platform uses machine learning and behavioral analytics to detect and respond to threats in real-time. Obsidian Security's solutions are used by companies in industries such as finance, healthcare, and technology to protect their cloud environments. The company was founded in 2017 and is headquartered in San Francisco, California.
Learn more about Obsidian Security
Size
100 employees
Industry
Founded
2017

Similar Jobs

More Jobs at Obsidian Security

More Enterprise Technology Jobs

Find similar Lead Analytics Engineer jobs: