Lead Analytics Engineer

Obsidian Security, Inc.
Palo Alto, CA, United States
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours

Tech stack

Sql Data Warehouse Artificial Intelligence Data Analysis Automation of Tests Backup Devices BigQuery Continuous Integration Customer Data Management Information Engineering Extract Transform Load (ETL) Data Warehousing Dimensional Modeling
+5 more
BIG-IP Global Traffic Manager (GTM) SQL Databases Data Streaming Data Ingestion Delivery Pipeline

Job description

Experteer Overview In this role you lead the analytics foundation as the senior owner of Obsidian’s data warehouse and DBT-driven analytics. You will own the dbt project, warehouse architecture, and semantic layer that power executive dashboards, GTM workflows, and internal AI agents. You’ll drive AI-enabled development to ship models, workflows, and reporting pipelines at a pace a small team could not achieve alone. Your work shapes mart design, documentation, and data flows from systems of record into business reports, with close collaboration across Product, Sales, Finance, Marketing, and Security. Compensation / Benefits * Own the end-to-end dbt project: mart architecture, modeling conventions, materialization patterns, testing, lineage, and documentation * Design dimensional models serving dashboards and AI agents with rigor * Establish CI/CD for dbt: PR reviews, automated testing, and deployment workflows * Manage data ingestion with Fivetran across GTM, finance, HR, and operations * Design and operate reverse-ETL to move trusted data back to systems of record * Migrate legacy reports to the new BigQuery foundation without disrupting continuity * Apply AI tools in daily workflows and define standards for AI-augmented analytics engineering * Create schemas, documentation, and semantic conventions optimized for downstream AI agents * Build automated workflows on the warehouse for cost aggregation, executive reporting, and CRM data updates * Set technical standards, mentor teammates, and establish scalable conventions Tasks * 8+ years in production analytics or data engineering with hands-on dbt ownership * Strong business fluency in B2B SaaS and understanding of GTM, billing, customer lifecycle workflows (ARR, NRR, churn, CAC, gross margin, pipeline) * Ability to translate finance/RevOps questions into data models, understanding upstream processes * Expert SQL and dimensional modeling with opinions on incremental materialization * Production experience with a cloud data warehouse (BigQuery preferred) and a managed ELT (Fivetran preferred) * Demonstrated daily use of AI coding tools to deliver production output * Strong written and verbal communication skills Key requirements *

Requirements

and * Design and operate reverse-ETL to move trusted data back to systems of record * Migrate legacy reports to the new BigQuery foundation without disrupting continuity * Apply AI tools in daily workflows and define standards for AI-augmented analytics engineering * Create schemas, documentation, and semantic conventions optimized for downstream AI agents * Build automated workflows on the warehouse for cost aggregation, executive reporting, and CRM data updates * Set technical standards, mentor teammates, and establish scalable conventions Tasks * 8+ years in production analytics or data engineering with hands-on dbt ownership * Strong business fluency in B2B SaaS and understanding of GTM, billing, customer lifecycle workflows (ARR, NRR, churn, CAC, gross margin, pipeline) * Ability to translate finance/RevOps questions into data models, understanding upstream processes * Expert SQL and dimensional modeling with opinions on incremental materialization * Production experience with a aaa to data warehouse (BigQuery preferred) and a managed ELT (Fivetran preferred) * Demonstrated daily use of AI coding tools to deliver production output * Strong written and verbal communication skills Key requirements *

Apply for this position

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

Apply on us.experteer.com

Good distractions

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

3:27 min

Explaining query execution overhead and caching limitations in BigQuery

Adnan Rahic Ā· JS Congress

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella Ā· WWC 2023

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu Ā· WWC 2024

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou Ā· Coffee With Developers

2:30 min

Leveraging BigQuery ML for scalable SQL-based segmentation experiments

Julian Joseph Ā· LIVE

1:36 min

Evolution from key-value stores to distributed SQL

Wei Hu Wei Hu Ā· WWC 2025

Videos

See all

Related articles

See all