Pendo

Sr. Analytics Engineer II

Pendo
Apply
5 hours ago
Raleigh, NC, USASenior
H1B sponsor

Responsibilities

  • Own end-to-end architecture for production analytics or AI data products, including data models, semantic layers, and service boundaries.
  • Architect and maintain the dbt semantic layer supporting BI dashboards, internal applications, and AI agents, while consolidating cross-team metrics.
  • Design and operate ELT/ETL pipelines using batch, incremental, and change data capture patterns across SaaS applications, production databases, and event streams.
  • Build and optimize layered warehouse or lakehouse models, including staging, intermediate, and mart layers, dimensional or medallion patterns, partitioning, and clustering.
  • Own orchestration, scheduling, upstream data contracts, observability, incident diagnosis, and reliability improvements.
  • Review authentication models, pull requests, and service architectures for security exposure and minimize attack surfaces.
  • Mentor teammates and engineers outside the data organization, improve AI-assisted engineering practices, and participate in recruiting.
  • Define technical approaches, break complex work into milestones, explain impacts to stakeholders, and lead cross-functional initiatives through delivery.

Requirements

  • 5–8 years of experience in analytics engineering, data engineering, or software engineering, including end-to-end ownership of production data products.
  • Expert-level SQL skills, including window functions, complex joins and aggregations, and query performance tuning on large datasets.
  • Hands-on experience with cloud data warehouses or lakehouses such as BigQuery, Snowflake, or Databricks, including managed ELT tools, batch and incremental loads, and CDC.
  • Proficiency in Python and a workflow orchestrator such as Airflow or Dagster for production data pipelines.
  • Deep data modeling and semantic-layer architecture experience, including dimensional modeling, dbt, and metric consolidation across teams.
  • Experience owning production analytics or AI product architecture beyond pipelines that feed dashboards.
  • Working knowledge of cloud authentication models, secure-by-design architecture, and code review for security exposure.
  • Experience adding observability to data and AI products and diagnosing incorrect AI-agent output.
  • Strong communication, mentoring, cross-functional leadership, and active use of AI-assisted engineering tools.

Benefits

  • Hybrid work arrangement with three in-office days per week unless designated remote.
  • Equal opportunity employer with accessibility accommodations available throughout the recruitment process.

Tech Stack

Apache AirflowDatabricksdbtGoogle BigQueryPythonSnowflakeSQL

Categories

Data Engineering
Pendo

About Pendo

501-1,000 employees

Pendo builds a product experience platform that combines product analytics, in‑app guides and messaging, surveys, and feedback to help software companies onboard users and drive adoption. It sells subscriptions to product, growth, and customer-success teams, with options for employee software enablement and AI-assisted support workflows. Founded in 2013 and headquartered in Raleigh, North Carolina, Pendo is privately held and operates globally, including stewardship of the Mind the Product community acquired in 2022.

Contact me